def get_datas(sids, siteCols, siteLayer, nearLayers): ds = DataSource(dbinfo) ds._connect() datas = {} for sid in sids: sitesql = getInfo(siteLayer, siteCols, sid) datas[sid] = {} datas[sid][siteLayer] = dict(zip(siteCols, *ds._run(sitesql))) for layer in nearLayers: cols = nearLayers[layer]['cols'] sql = nearest( siteLayer, layer, 1000, sid, cols ) data = ds._run(sql) if len(data) > 0: vals = data[0] else: vals = [] datas[sid][layer] = dict(zip(cols, vals)) ds._close() return datas
def get_datas(sids, siteCols, siteLayer, nearLayers): ds = DataSource(dbinfo) ds._connect() datas = {} for sid in sids: sitesql = getInfo(siteLayer, siteCols, sid) datas[sid] = {} datas[sid][siteLayer] = dict(zip(siteCols, *ds._run(sitesql))) for layer in nearLayers: cols = nearLayers[layer]["cols"] sql = nearest(siteLayer, layer, 1000, sid, cols) data = ds._run(sql) if len(data) > 0: vals = data[0] else: vals = [] datas[sid][layer] = dict(zip(cols, vals)) ds._close() return datas