Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import os,sys
- import subprocess
- import glob
- from os import path
- from google.cloud.spanner_v1.streamed import StreamedResultSet
- def run_quickstart():
- # [START spanner_quickstart]
- # Imports the Google Cloud Client Library.
- from google.cloud import spanner
- # Instantiate a client.
- spanner_client = spanner.Client.from_service_account_json('<stripped Auth Key>')
- # Your Cloud Spanner instance ID.
- instance_id = 'spannereval'
- # Get a Cloud Spanner instance by ID.
- instance = spanner_client.instance(instance_id)
- # Your Cloud Spanner database ID.
- database_id = 'ias-ei-test'
- # Get a Cloud Spanner database by ID.
- database = instance.database(database_id)
- # Execute a simple SQL statement.
- with database.snapshot() as snapshot:
- results = snapshot.execute_sql('SELECT * from product_inventory_status')
- for row in results:
- print(row)
- # [END spanner_quickstart]
Add Comment
Please, Sign In to add comment