BQ: JSON on query output, even when paging

hraban · hraban · commit ad6ebb3ac9bf · 2016-02-16T18:29:42.000Z
For composability with JSON capable tools in a unix pipeline. See GoogleCloudPlatform#184
diff --git a/bigquery/api/sync_query.py b/bigquery/api/sync_query.py
@@ -60,17 +60,21 @@ def main(project_id, query, timeout, num_retries):
 
     # [START paging]
     # Page through the result set and print all results.
+    results = []
     page_token = None
+
     while True:
         page = bigquery.jobs().getQueryResults(
             pageToken=page_token,
             **query_job['jobReference']).execute(num_retries=2)
 
-        print(json.dumps(page.get('rows', [])))
+        results.extend(page.get('rows', []))
 
         page_token = page.get('pageToken')
         if not page_token:
             break
+
+    print(json.dumps(results))
     # [END paging]
 # [END run]
 
