database_creation_capabilities

Creates, updates, deletes, gets or lists a database_creation_capabilities resource.

Overview

Name	database_creation_capabilities
Type	Resource
Id	ovh.hosting_web.database_creation_capabilities

Fields

The following fields are returned by SELECT queries:

list

Struct which describs quota and available for a specific type of database

Name	Datatype	Description
available	integer	Number of database left for creation
engines	array	Database software available on this platform
isolation	string	Technology use to isolate differents webhosting accounts (dedicated, local, shared)
quota	object	Size of data can be used
type	string	Database offer name (extraSqlPerso, local, privateDatabase, sqlLocal, sqlPerso, sqlPro)

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
list	select	service_name		Get database creation capabilities. Returns, for each database offer of the hosting, the engines, the quota and the number of databases left to create.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
api_host	string	The OVHcloud API host. Selected by OVH_ENDPOINT (ovh-eu, ovh-ca or ovh-us; default ovh-eu). (default: api.eu.ovhcloud.com, x-stackQL-envVarSelector: {"envVar":"OVH_ENDPOINT","default":"ovh-eu","values":{"ovh-eu":"api.eu.ovhcloud.com","ovh-ca":"api.ca.ovhcloud.com","ovh-us":"api.us.ovhcloud.com"}})
service_name	string	The internal name of your hosting (wire: serviceName)

SELECT examples

list

Get database creation capabilities. Returns, for each database offer of the hosting, the engines, the quota and the number of databases left to create.

SELECT
available,
engines,
isolation,
quota,
type
FROM ovh.hosting_web.database_creation_capabilities
WHERE service_name = '{{ service_name }}' -- required
;