Cloud Databases: Sample Code & Bindings
Cloud Databases Code Samples
Bindings: The Rackspace Cloud Databases API is a RESTful API, with support for the binding listed below:
Code Samples - PHP
· Test Connection from Rackspace Cloud Sites to Rackspace Cloud Databases
Code Samples - XML
· Create Database Instance Request
· Create Database Instance Response
Code Samples – JSON
· Create Database Instance Request
· Create Database Instance Response
List of API Operations
o API Versions
§ List Versions
§ List Version Details
o Database Instances
§ Create Database Instance
§ List All Database Instances
§ List Database Instance Status and Details
§ Delete Database Instance
§ Enable Root User
§ List Root-Enabled Status
o Database Instance Actions
§ Restart Instance
§ Resize the Instance
§ Resize the Instance Volume
o Databases
§ Create Database
§ List Databases for Instance
§ Delete Database
o Users
§ Create User
§ List Users in Database Instance
§ Delete User
o Flavors
§ List Flavors
§ List Flavor By ID
Code Sample: Create Database Instance Response (XML)
HTTP/1.1 200 OK
Content-Type: application/xml
Content-Length: 748
Date: Wed, 25 Jan 2012 21:53:23 GMT
<?xml version="1.0" ?>
<instance created="2012-01-25T21:53:18Z" hostname="e09ad9a3f73309469cf1f43d11e79549caf9acf2.rackspaceclouddb.com" id="692d8418-7a8f-47f1-8060-59846c6e024f" name="xml_rack_instance" status="BUILD" updated="2012-01-25T21:53:22Z" xmlns="http://docs.openstack.org/database/api/v1.0">
<links>
<link href="https://ord.databases.api.rackspacecloud.com/v1.0/1234/instances/692d8418-7a8f-47f1-8060-59846c6e024f" rel="self"/>
<link href="https://ord.databases.api.rackspacecloud.com/instances/692d8418-7a8f-47f1-8060-59846c6e024f" rel="bookmark"/>
</links>
<volume size="2"/>
<flavor id="1">
<links>
<link href="https://ord.databases.api.rackspacecloud.com/v1.0/1234/flavors/1" rel="self"/>
<link href="https://ord.databases.api.rackspacecloud.com/flavors/1" rel="bookmark"/>
</links>
</flavor>
</instance>
Code Sample: Create Database Request (XML)
POST /v1.0/1234/instances/692d8418-7a8f-47f1-8060-59846c6e024f/databases HTTP/1.1
User-Agent: python-example-client
Host: ord.databases.api.rackspacecloud.com
X-Auth-Token: 87c6033c-9ff6-405f-943e-2deb73f278b7
Accept: application/xml
Content-Type: application/xml
<?xml version="1.0" ?>
<databases xmlns="http://docs.openstack.org/database/api/v1.0">
<database name="exampledb" character_set="utf8" collate="utf8_general_ci" />
<database name="anotherexampledb" />
<database name="oneMoreExampledb" />
</databases>
Code Sample: Create Database Response (XML)
HTTP/1.1 202 Accepted
Content-Type: application/xml
Content-Length: 0
Date: Wed, 27 Jun 2012 23:11:18 GMT
Code Sample: Create User Request (XML)
POST /v1.0/1234/instances/1f19ee9e-6124-46b3-a6c6-fc46a5756814/users HTTP/1.1
User-Agent: python-example-client
Host: ord.databases.api.rackspacecloud.com
X-Auth-Token: bb64d788-2dec-4a6b-a670-7151d108cacf
Accept: application/xml
Content-Type: application/xml
<?xml version="1.0" ?>
<users xmlns="http://docs.openstack.org/database/api/v1.0">
<user name="testuser" password="password">
<databases>
<database name="databaseC"/>
</databases>
</user>
<user name="userwith2dbs" password="password">
<databases>
<database name="databaseA"/>
<database name="databaseB"/>
</databases>
</user>
</users>
Code Sample: Create User Response (XML)
HTTP/1.1 202 Accepted
Content-Type: application/xml
Content-Length: 0
Date: Wed, 27 Jun 2012 23:11:19 GMT
Code Sample: Create Database Instance Request (JSON)
POST /v1.0/1234/instances HTTP/1.1
User-Agent: python-example-client
Host: ord.databases.api.rackspacecloud.com
X-Auth-Token: d6cafa5b-e0c7-4ab8-948e-7c95f2acd031
Accept: application/json
Content-Type: application/json
{
"instance": {
"databases": [
{
"character_set": "utf8",
"collate": "utf8_general_ci",
"name": "sampledb"
},
{
"name": "nextround"
}
],
"flavorRef": "https://ord.databases.api.rackspacecloud.com/v1.0/1234/flavors/1",
"name": "json_rack_instance",
"users": [
{
"databases": [
{
"name": "sampledb"
}
],
"name": "demouser",
"password": "demopassword"
}
],
"volume": {
"size": 2
}
}
}
Code Sample: Create Database Instance Response (JSON)
HTTP/1.1 200 OK
Content-Type: application/json
Content-Length: 636
Date: Wed, 25 Jan 2012 21:53:10 GMT
{
"instance": {
"created": "2012-01-25T21:53:09Z",
"flavor": {
"id": "1",
"links": [
{
"href": "https://ord.databases.api.rackspacecloud.com/v1.0/1234/flavors/1",
"rel": "self"
},
{
"href": "https://ord.databases.api.rackspacecloud.com/flavors/1",
"rel": "bookmark"
}
]
},
"hostname": "e09ad9a3f73309469cf1f43d11e79549caf9acf2.rackspaceclouddb.com",
"id": "dea5a2f7-3ec7-4496-adab-0abb5a42d635",
"links": [
{
"href": "https://ord.databases.api.rackspacecloud.com/v1.0/1234/instances/dea5a2f7-3ec7-4496-adab-0abb5a42d635",
"rel": "self"
},
{
"href": "https://ord.databases.api.rackspacecloud.com/instances/dea5a2f7-3ec7-4496-adab-0abb5a42d635",
"rel": "bookmark"
}
],
"name": "json_rack_instance",
"status": "BUILD",
"updated": "2012-01-25T21:53:10Z",
"volume": {
"size": 2
}
}
}
Code Sample: Create Database Request (JSON)
POST /v1.0/1234/instances/692d8418-7a8f-47f1-8060-59846c6e024f/databases HTTP/1.1
User-Agent: python-example-client
Host: ord.databases.api.rackspacecloud.com
X-Auth-Token: 87c6033c-9ff6-405f-943e-2deb73f278b7
Accept: application/json
Content-Type: application/json
{
"databases": [
{
"character_set": "utf8",
"collate": "utf8_general_ci",
"name": "testingdb"
},
{
"name": "sampledb"
}
]
}
Code Sample: Create Database Response (JSON)
HTTP/1.1 202 Accepted
Content-Type: application/json
Content-Length: 0
Date: Wed, 27 Jun 2012 23:11:18 GMT
Code Sample: Create User Request (JSON)
POST /v1.0/1234/instances/1c59bdb8-03b6-4079-a7db-ba92d23a98b3/users HTTP/1.1
User-Agent: python-example-client
Host: ord.databases.api.rackspacecloud.com
X-Auth-Token: bb64d788-2dec-4a6b-a670-7151d108cacf
Accept: application/json
Content-Type: application/json
{
"users": [
{
"databases": [
{
"name": "databaseA"
}
],
"name": "dbuser3",
"password": "password"
},
{
"databases": [
{
"name": "databaseB"
},
{
"name": "databaseC"
}
],
"name": "dbuser4",
"password": "password"
}
]
}
Code Sample: Create User Response (JSON)
HTTP/1.1 202 Accepted
Content-Type: application/json
Content-Length: 0
Date: Wed, 27 Jun 2012 23:11:18 GMT
Legal Disclaimer
This information is intended for software developers who want to develop applications by using Rackspace Cloud Databases application programming interface (API). The information is for informational purposes only and is provided “as is.”
Rackspace makes no representations or warranties of any kind, express or implied, as to the accuracy or completeness of the contents of this information and reserves the right to make changes to specifications and product/services description at any time without notice. Rackspace services offerings are subject to change without notice. Users must take full responsibility for application of any services mentioned herein. Except as set forth in Rackspace general terms and conditions and/or cloud terms of service, Rackspace assumes no liability whatsoever, and disclaims any express or implied warranty, relating to its services including, but not limited to, the implied warranty of merchantability, fitness for a particular purpose, and noninfringement.
© 2011-2013 Rackspace US, Inc.
Except where otherwise noted, content on this site is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License
See license specifics and DISCLAIMER
0 Comments
Add new comment