Beispiel #1
0
def getData(table_name, task):
    query_string = "SELECT key, FgL, FgR FROM [data.{0}] WHERE task = '{1}'".format(table_name, task)
    rows = queryGoogle(query_string)
    data = defaultdict(list)
    
    for row in rows['rows']:
        key = row['f'][0]['v']
        fgl = row['f'][1]['v']
        fgr = row['f'][2]['v']
        data[key].append([fgl, fgr])
    return data
def getTasks(table_name):
    tasks = queryGoogle("SELECT task from data.{0} GROUP BY task".format(table_name))