FusionRunner Data Dumper

fusionrunnerdump.py

#!/usr/bin/python
""" FusionRunner

Queries Google Fusion Tables for MyTracks data.
"""
__author__ = 'hardware.hank@gmail.com (Erik Gregg)'
import sys, getpass
sys.path.append("./fusion-tables-client-python-read-only/src/")
from authorization.oauth import OAuth
from sql.sqlbuilder import SQL
import ftclient
import pprint
pp = pprint.PrettyPrinter(indent=4)

if __name__ == "__main__":
  consumer_key = "207320244638.apps.googleusercontent.com"
  f = open('secret')
  try:
    consumer_secret = f.readline().rstrip()
  finally:
    f.close()
  
  url, token, secret = OAuth().generateAuthorizationURL(consumer_key, consumer_secret, consumer_key)
  print "Visit this URL in a browser: "
  print url
  raw_input("Hit enter after authorization")
  
  token, secret = OAuth().authorize(consumer_key, consumer_secret, token, secret)
  oauth_client = ftclient.OAuthFTClient(consumer_key, consumer_secret, token, secret)

  # show tables
  results = [ x.split(",") for x in oauth_client.query(SQL().showTables()).split("\n")[1:-1] ]
  pp.pprint(results)

  for table in results:
    print oauth_client.query(SQL().select(int(table[0]), None, None))