All URIs are relative to https://api.ionos.com/databases/postgresql
| Method | HTTP request | Description |
|---|---|---|
| users_delete | DELETE /clusters/{clusterId}/users/{username} | Delete user |
| users_get | GET /clusters/{clusterId}/users/{username} | Get user |
| users_list | GET /clusters/{clusterId}/users | List users |
| users_patch | PATCH /clusters/{clusterId}/users/{username} | Patch user |
| users_post | POST /clusters/{clusterId}/users | Create a user |
users_delete(cluster_id, username)
Delete user
Deletes a single user
- Basic Authentication (basicAuth):
- Api Key Authentication (tokenAuth):
import ionoscloud_dbaas_postgres
from ionoscloud_dbaas_postgres.rest import ApiException
from pprint import pprint
# Defining the host is optional and defaults to https://api.ionos.com/databases/postgresql
# See configuration.py for a list of all supported configuration parameters.
configuration = ionoscloud_dbaas_postgres.Configuration(
host = "https://api.ionos.com/databases/postgresql"
)
# The client must configure the authentication and authorization parameters
# in accordance with the API server security policy.
# Examples for each auth method are provided below, use the example that
# satisfies your auth use case.
# Configure HTTP basic authorization: basicAuth
configuration = ionoscloud_dbaas_postgres.Configuration(
username = os.environ["USERNAME"],
password = os.environ["PASSWORD"]
)
# Configure API key authorization: tokenAuth
configuration.api_key['tokenAuth'] = os.environ["API_KEY"]
# Uncomment below to setup prefix (e.g. Bearer) for API key, if needed
# configuration.api_key_prefix['tokenAuth'] = 'Bearer'
# Enter a context with an instance of the API client
with ionoscloud_dbaas_postgres.ApiClient(configuration) as api_client:
# Create an instance of the API class
api_instance = ionoscloud_dbaas_postgres.UsersApi(api_client)
cluster_id = '498ae72f-411f-11eb-9d07-046c59cc737e' # str | The unique ID of the cluster.
username = 'benjamin' # str | The authentication username.
try:
# Delete user
api_instance.users_delete(cluster_id, username)
except Exception as e:
print("Exception when calling UsersApi->users_delete: %s\n" % e)| Name | Type | Description | Notes |
|---|---|---|---|
| cluster_id | str | The unique ID of the cluster. | |
| username | str | The authentication username. |
void (empty response body)
- Content-Type: Not defined
- Accept: application/json
| Status code | Description | Response headers |
|---|---|---|
| 204 | Successful response | - |
| 0 | Any erroneous status code: 400 (parse error), 401 (auth error), 402 (trial access), 403 (insufficient permissions), 404 (not found), 405 (unsupported HTTP method), 415 (unsupported content type, 422 (validation error), 429 (request rate limit exceeded), 500 (server error), 503 (maintenance) | * Content-Type - application/problem+json |
[Back to top] [Back to API list] [Back to Model list] [Back to README]
UserResource users_get(cluster_id, username)
Get user
Retrieves a single user
- Basic Authentication (basicAuth):
- Api Key Authentication (tokenAuth):
import ionoscloud_dbaas_postgres
from ionoscloud_dbaas_postgres.models.user_resource import UserResource
from ionoscloud_dbaas_postgres.rest import ApiException
from pprint import pprint
# Defining the host is optional and defaults to https://api.ionos.com/databases/postgresql
# See configuration.py for a list of all supported configuration parameters.
configuration = ionoscloud_dbaas_postgres.Configuration(
host = "https://api.ionos.com/databases/postgresql"
)
# The client must configure the authentication and authorization parameters
# in accordance with the API server security policy.
# Examples for each auth method are provided below, use the example that
# satisfies your auth use case.
# Configure HTTP basic authorization: basicAuth
configuration = ionoscloud_dbaas_postgres.Configuration(
username = os.environ["USERNAME"],
password = os.environ["PASSWORD"]
)
# Configure API key authorization: tokenAuth
configuration.api_key['tokenAuth'] = os.environ["API_KEY"]
# Uncomment below to setup prefix (e.g. Bearer) for API key, if needed
# configuration.api_key_prefix['tokenAuth'] = 'Bearer'
# Enter a context with an instance of the API client
with ionoscloud_dbaas_postgres.ApiClient(configuration) as api_client:
# Create an instance of the API class
api_instance = ionoscloud_dbaas_postgres.UsersApi(api_client)
cluster_id = '498ae72f-411f-11eb-9d07-046c59cc737e' # str | The unique ID of the cluster.
username = 'benjamin' # str | The authentication username.
try:
# Get user
api_response = api_instance.users_get(cluster_id, username)
print("The response of UsersApi->users_get:\n")
pprint(api_response)
except Exception as e:
print("Exception when calling UsersApi->users_get: %s\n" % e)| Name | Type | Description | Notes |
|---|---|---|---|
| cluster_id | str | The unique ID of the cluster. | |
| username | str | The authentication username. |
- Content-Type: Not defined
- Accept: application/json
| Status code | Description | Response headers |
|---|---|---|
| 200 | Successful operation. | - |
| 0 | Any erroneous status code: 400 (parse error), 401 (auth error), 402 (trial access), 403 (insufficient permissions), 404 (not found), 405 (unsupported HTTP method), 415 (unsupported content type, 422 (validation error), 429 (request rate limit exceeded), 500 (server error), 503 (maintenance) | * Content-Type - application/problem+json |
[Back to top] [Back to API list] [Back to Model list] [Back to README]
UserList users_list(cluster_id, limit=limit, offset=offset, system=system)
List users
Retrieves a list of users
- Basic Authentication (basicAuth):
- Api Key Authentication (tokenAuth):
import ionoscloud_dbaas_postgres
from ionoscloud_dbaas_postgres.models.user_list import UserList
from ionoscloud_dbaas_postgres.rest import ApiException
from pprint import pprint
# Defining the host is optional and defaults to https://api.ionos.com/databases/postgresql
# See configuration.py for a list of all supported configuration parameters.
configuration = ionoscloud_dbaas_postgres.Configuration(
host = "https://api.ionos.com/databases/postgresql"
)
# The client must configure the authentication and authorization parameters
# in accordance with the API server security policy.
# Examples for each auth method are provided below, use the example that
# satisfies your auth use case.
# Configure HTTP basic authorization: basicAuth
configuration = ionoscloud_dbaas_postgres.Configuration(
username = os.environ["USERNAME"],
password = os.environ["PASSWORD"]
)
# Configure API key authorization: tokenAuth
configuration.api_key['tokenAuth'] = os.environ["API_KEY"]
# Uncomment below to setup prefix (e.g. Bearer) for API key, if needed
# configuration.api_key_prefix['tokenAuth'] = 'Bearer'
# Enter a context with an instance of the API client
with ionoscloud_dbaas_postgres.ApiClient(configuration) as api_client:
# Create an instance of the API class
api_instance = ionoscloud_dbaas_postgres.UsersApi(api_client)
cluster_id = '498ae72f-411f-11eb-9d07-046c59cc737e' # str | The unique ID of the cluster.
limit = 100 # int | The maximum number of elements to return. Use together with 'offset' for pagination. (optional) (default to 100)
offset = 0 # int | The first element to return. Use together with 'limit' for pagination. (optional) (default to 0)
system = True # bool | If set to 'true' all users, including system users are returned. System users cannot be deleted or updated. (optional)
try:
# List users
api_response = api_instance.users_list(cluster_id, limit=limit, offset=offset, system=system)
print("The response of UsersApi->users_list:\n")
pprint(api_response)
except Exception as e:
print("Exception when calling UsersApi->users_list: %s\n" % e)| Name | Type | Description | Notes |
|---|---|---|---|
| cluster_id | str | The unique ID of the cluster. | |
| limit | int | The maximum number of elements to return. Use together with 'offset' for pagination. | [optional] [default to 100] |
| offset | int | The first element to return. Use together with 'limit' for pagination. | [optional] [default to 0] |
| system | bool | If set to 'true' all users, including system users are returned. System users cannot be deleted or updated. | [optional] |
- Content-Type: Not defined
- Accept: application/json
| Status code | Description | Response headers |
|---|---|---|
| 200 | Successful operation. | - |
| 0 | Any erroneous status code: 400 (parse error), 401 (auth error), 402 (trial access), 403 (insufficient permissions), 404 (not found), 405 (unsupported HTTP method), 415 (unsupported content type, 422 (validation error), 429 (request rate limit exceeded), 500 (server error), 503 (maintenance) | * Content-Type - application/problem+json |
[Back to top] [Back to API list] [Back to Model list] [Back to README]
UserResource users_patch(cluster_id, username, users_patch_request)
Patch user
Patches a single user. Only changing the password is supported. System users cannot be patched.
- Basic Authentication (basicAuth):
- Api Key Authentication (tokenAuth):
import ionoscloud_dbaas_postgres
from ionoscloud_dbaas_postgres.models.user_resource import UserResource
from ionoscloud_dbaas_postgres.models.users_patch_request import UsersPatchRequest
from ionoscloud_dbaas_postgres.rest import ApiException
from pprint import pprint
# Defining the host is optional and defaults to https://api.ionos.com/databases/postgresql
# See configuration.py for a list of all supported configuration parameters.
configuration = ionoscloud_dbaas_postgres.Configuration(
host = "https://api.ionos.com/databases/postgresql"
)
# The client must configure the authentication and authorization parameters
# in accordance with the API server security policy.
# Examples for each auth method are provided below, use the example that
# satisfies your auth use case.
# Configure HTTP basic authorization: basicAuth
configuration = ionoscloud_dbaas_postgres.Configuration(
username = os.environ["USERNAME"],
password = os.environ["PASSWORD"]
)
# Configure API key authorization: tokenAuth
configuration.api_key['tokenAuth'] = os.environ["API_KEY"]
# Uncomment below to setup prefix (e.g. Bearer) for API key, if needed
# configuration.api_key_prefix['tokenAuth'] = 'Bearer'
# Enter a context with an instance of the API client
with ionoscloud_dbaas_postgres.ApiClient(configuration) as api_client:
# Create an instance of the API class
api_instance = ionoscloud_dbaas_postgres.UsersApi(api_client)
cluster_id = '498ae72f-411f-11eb-9d07-046c59cc737e' # str | The unique ID of the cluster.
username = 'benjamin' # str | The authentication username.
users_patch_request = ionoscloud_dbaas_postgres.UsersPatchRequest() # UsersPatchRequest | Patch containing all properties that should be updated
try:
# Patch user
api_response = api_instance.users_patch(cluster_id, username, users_patch_request)
print("The response of UsersApi->users_patch:\n")
pprint(api_response)
except Exception as e:
print("Exception when calling UsersApi->users_patch: %s\n" % e)| Name | Type | Description | Notes |
|---|---|---|---|
| cluster_id | str | The unique ID of the cluster. | |
| username | str | The authentication username. | |
| users_patch_request | UsersPatchRequest | Patch containing all properties that should be updated |
- Content-Type: application/json
- Accept: application/json
| Status code | Description | Response headers |
|---|---|---|
| 200 | Successful operation. | - |
| 0 | Any erroneous status code: 400 (parse error), 401 (auth error), 402 (trial access), 403 (insufficient permissions), 404 (not found), 405 (unsupported HTTP method), 415 (unsupported content type, 422 (validation error), 429 (request rate limit exceeded), 500 (server error), 503 (maintenance) | * Content-Type - application/problem+json |
[Back to top] [Back to API list] [Back to Model list] [Back to README]
UserResource users_post(cluster_id, user)
Create a user
Create a new Postgres User
- Basic Authentication (basicAuth):
- Api Key Authentication (tokenAuth):
import ionoscloud_dbaas_postgres
from ionoscloud_dbaas_postgres.models.user import User
from ionoscloud_dbaas_postgres.models.user_resource import UserResource
from ionoscloud_dbaas_postgres.rest import ApiException
from pprint import pprint
# Defining the host is optional and defaults to https://api.ionos.com/databases/postgresql
# See configuration.py for a list of all supported configuration parameters.
configuration = ionoscloud_dbaas_postgres.Configuration(
host = "https://api.ionos.com/databases/postgresql"
)
# The client must configure the authentication and authorization parameters
# in accordance with the API server security policy.
# Examples for each auth method are provided below, use the example that
# satisfies your auth use case.
# Configure HTTP basic authorization: basicAuth
configuration = ionoscloud_dbaas_postgres.Configuration(
username = os.environ["USERNAME"],
password = os.environ["PASSWORD"]
)
# Configure API key authorization: tokenAuth
configuration.api_key['tokenAuth'] = os.environ["API_KEY"]
# Uncomment below to setup prefix (e.g. Bearer) for API key, if needed
# configuration.api_key_prefix['tokenAuth'] = 'Bearer'
# Enter a context with an instance of the API client
with ionoscloud_dbaas_postgres.ApiClient(configuration) as api_client:
# Create an instance of the API class
api_instance = ionoscloud_dbaas_postgres.UsersApi(api_client)
cluster_id = '498ae72f-411f-11eb-9d07-046c59cc737e' # str | The unique ID of the cluster.
user = ionoscloud_dbaas_postgres.User() # User |
try:
# Create a user
api_response = api_instance.users_post(cluster_id, user)
print("The response of UsersApi->users_post:\n")
pprint(api_response)
except Exception as e:
print("Exception when calling UsersApi->users_post: %s\n" % e)| Name | Type | Description | Notes |
|---|---|---|---|
| cluster_id | str | The unique ID of the cluster. | |
| user | User |
- Content-Type: application/json
- Accept: application/json
| Status code | Description | Response headers |
|---|---|---|
| 200 | Successful operation. | - |
| 0 | Any erroneous status code: 400 (parse error), 401 (auth error), 402 (trial access), 403 (insufficient permissions), 404 (not found), 405 (unsupported HTTP method), 415 (unsupported content type, 422 (validation error), 429 (request rate limit exceeded), 500 (server error), 503 (maintenance) | * Content-Type - application/problem+json |
[Back to top] [Back to API list] [Back to Model list] [Back to README]