Guest User

Untitled

a guest
Jun 19th, 2018
75
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.93 KB | None | 0 0
  1. import os,sys
  2. import subprocess
  3. import glob
  4. from os import path
  5. from google.cloud.spanner_v1.streamed import StreamedResultSet
  6. def run_quickstart():
  7. # [START spanner_quickstart]
  8. # Imports the Google Cloud Client Library.
  9. from google.cloud import spanner
  10.  
  11. # Instantiate a client.
  12. spanner_client = spanner.Client.from_service_account_json('<stripped Auth Key>')
  13.  
  14. # Your Cloud Spanner instance ID.
  15. instance_id = 'spannereval'
  16.  
  17. # Get a Cloud Spanner instance by ID.
  18. instance = spanner_client.instance(instance_id)
  19.  
  20. # Your Cloud Spanner database ID.
  21. database_id = 'ias-ei-test'
  22.  
  23. # Get a Cloud Spanner database by ID.
  24. database = instance.database(database_id)
  25.  
  26. # Execute a simple SQL statement.
  27. with database.snapshot() as snapshot:
  28. results = snapshot.execute_sql('SELECT * from product_inventory_status')
  29. for row in results:
  30. print(row)
  31. # [END spanner_quickstart]
Add Comment
Please, Sign In to add comment