The Google Cloud SQL Admin API is built on HTTP and JSON, so any standard HTTP client can send requests to it and parse the responses. However, instead of creating HTTP requests and parsing responses manually, you may want to use the Google APIs client libraries. The client libraries provide better language integration, improved security, and support for making calls that require user authorization.
Contents
Accessing the service
Depending on the Google Cloud SQL Admin API client library you use,
you may need to configure how the library
discovers the default service path. For client libraries that use the Google APIs Discovery
Service, use the API name sqladmin to build a client. This includes libraries for
Python and JavaScript.
The following code snippets, show how to create a client and list Cloud SQL instances in a project.
Go
Using the Go-MySQL-Driver, an example
connection to INSTANCE_NAME and database DATABASE_NAME is:
db, err := sql.Open("mysql", "root@cloudsql(INSTANCE_NAME)/DATABASE_NAME")
For the MyMySQL driver, you can connect as
root user with:
db, err := sql.Open("mymysql", "cloudsql:INSTANCE_NAME:DATABASE_NAME*/root/")
Java
For the Client Library for Java, you can optionally specify the service path directly.
// set up global SQLAdmin instance
client = new SQLAdmin.Builder(httpTransport, JSON_FACTORY, credential)
.setServicePath("sql/v1beta4/")
.setApplicationName(APPLICATION_NAME).build();
InstancesListResponse resp = client.instances().list("PROJECT_ID").execute();
List<DatabaseInstance> list = resp.getItems();
for (DatabaseInstance d : list) {
System.out.println(d.getName());
}
JavaScript
For the Client Library for JavaScript,
specify sqladmin to build a client.
gapi.client.load('sqladmin', 'v1beta4', function() { console.log('loaded');});
gapi.client.sql.instances.list({'project': PROJECT_ID}).execute(showResult);
function showResult(result) {
// Process the result.
};
Python
For the Client Library for Python,
specify sqladmin to build a client.
# Construct the service object for the interacting with the Cloud SQL Administration API.
service = discovery.build('sqladmin', 'v1beta4', http=http)
req = service.instances().list(project="PROJECT_ID")
resp = req.execute()
print json.dumps(resp, indent=2)
The service object queries the discovery document and use the correct
service path, in this case, "sql/v1beta4/projects/".
List of libraries and samples
In the tables below, the first column shows each library's stage of development (note that some are in early stages), and links to documentation for the library. The second column links to available samples for each library.
These early-stage libraries are also available: