def get_yg(self):
sql = 'SELECT id,lon,lat FROM stations ;'
self.cursor.execute(sql)
result = self.cursor.fetchall()
for dict in result:
print(dict)
print(dict['lat'], dict['lon'])
lat, lon = conversion.get_lonlat(dict['lat'], dict['lon'])
print(lat, lon)
geocode = encode(lat, lon)
a, b = decode(geocode)
print(a, b)
sql = 'UPDATE stations SET geohash = "%s" WHERE id = %d ;' % (
geocode, dict['id']) # 更新下一站信息
print(sql)
self.cursor.execute(sql)
self.db.commit()
print(result)
def insert_nodes(self, info, stype='subways'):
info = direction_check(info, self.single_uids)
for l in info: # 每条路线
# 1.线路信息
line = l['name']
stations = l['stations']
start_station = stations[0]['name']
end_station = stations[-1]['name']
wait_time = l['headway']
endtime = l['endTime']
self.dbm.line_feature(
[start_station, end_station, wait_time, endtime, line], stype)
for j in range(len(stations)): # 每个站
# 2.站点信息
name = stations[j]['name']
lon = stations[j]['geo'][2:13]
lat = stations[j]['geo'][14:24]
lon, lat = conversion.get_lonlat(float(lon), float(lat))
self.dbm.stations([name, lon, lat,
line]) #1.存储站点信息; 注意：若单独调用，需要检查id信息