google_cloud_spanner_quickstart_connect_and_execute_sql_query.py

1# Imports the Google Cloud Client Library
2from google.cloud import spanner
3
4def run_quickstart():
5    # Instantiate a client.
6    spanner_client = spanner.Client()
7
8    # Your Cloud Spanner instance ID.
9    instance_id = "my-instance"
10
11    # Your Cloud Spanner database ID.
12    database_id = "my-database"
13
14    # Get a Cloud Spanner instance by ID.
15    instance = spanner_client.instance(instance_id)
16
17    # Get a Cloud Spanner database by ID.
18    database = instance.database(database_id)
19
20    # Execute a simple SQL statement.
21    with database.snapshot() as snapshot:
22        results = snapshot.execute_sql("SELECT 1")
23
24        for row in results:
25            print(row)
26
27if __name__ == "__main__":
28    run_quickstart()