def get_city_id_map_info_name_dict():
city_id_map_info_dict = {}
city_id_name_dict = {}
sql = 'select id,name,map_info from city'
for line in db_devdb.QueryBySQL(sql):
city_id_map_info_dict[line['id']] = line['map_info']
city_id_name_dict[line['id']] = line['name']
return city_id_map_info_dict, city_id_name_dict
def get_id_map_dict():
id_map_dict = {}
sql = 'select id,map_info from city'
for line in db_devdb.QueryBySQL(sql):
id_map_dict[line['id']] = line['map_info']
return id_map_dict
def get_dict():
id_dict = defaultdict(list)
sql = 'select id,name_en,map_info from city'
for line in db_devdb.QueryBySQL(sql):
id_dict[line['name_en']].append((line['map_info'], line['id']))
return id_dict
def get_city_info(city_id):
sql = 'select name,country from city where id=%s' % city_id
res = db_devdb.QueryBySQL(sql)
return res[0]['name'], res[0]['country']
def get_id_country():
id_country = []
sql = 'select id,country from city where id in (%s)' % get_city_id()
for line in db_devdb.QueryBySQL(sql):
id_country.append((line['country'], line['id']))
return id_country