def init_arealist(self): ''' 初始化省市数据 :return: ''' getAreaSql = f"select Position,Province_Name,Province_Code,City_Name,City_Code from arealists" with MysqlHelper.Operator(MYSQL_HOST, MYSQL_PORT, MYSQL_USER, MYSQL_PASSWORD, MYSQL_DB) as oper: # 获取省市列表 cursor = oper.execute_sql(getAreaSql) self.areaList = oper.res_to_dict(cursor) # '省市'字去掉 self.new_areaList = list( map( lambda x: { 'Position': x['Position'], 'Province_Name': x['Province_Name'].replace('省', '').replace('市', ''), 'Province_Code': x['Province_Code'], 'City_Name': x['City_Name'].replace('省', '').replace('市', ''), 'City_Code': x['City_Code'] }, self.areaList)) oper.cursor.close()
def get_company_list(self): sql = "select company_name,qyxx_id from company_manager where status not like '新三板%' and status not like " \ "'上市%' and status not like '拟上市%'" try: com_list = MysqlHelper().get_all(sql) return com_list except Exception as err: print("MYSQL查询数据时出错了~错误内容为{}".format(str(err)))