views.py 文件源码

def save_json():
    df = pd.read_sql_table(filename, SQLALCHEMY_DATABASE_URI)
    data = {}
    for i, row in df.iterrows():
        spatial_id = str(row['spatial_id'])
        if spatial_id not in data.keys():
            data[spatial_id] = {}
        for key, value in row.iteritems():
            if key != 'spatial_id':
                data[spatial_id][key] = str(value)
    with open(DATA_FOLDER+'results/'+filename+'.json', 'w') as fp:
        json.dump(data, fp, indent=2)