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