google_cloud_spanner_quickstart_client_connection_select_query.py

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