def mysql_l(self):
"""
连接行业表获取行业数据
:param cmpShortName:
:return:
"""
if self.companyName:
conn = PymysqlPool('industry')
sql = "SELECT A.compName, A.categoryCode, B.constValueDesc, B.constCode FROM(SELECT * FROM seeyii_assets_database.sy_cd_ms_ind_comp_gm WHERE compName = '{}') AS A INNER JOIN ( SELECT * FROM seeyii_assets_database.sy_cd_mt_sys_const WHERE constCode IN ( 3, 4, 5 ) ) AS B ON A.categoryCode = B.cValue".format(
self.companyName)
counts, infos = conn.getAll(sql)
return infos
else:
return ""
def mysql_client(self):
return PymysqlPool('129')
def mysql_client_125():
return PymysqlPool('125')
def mysql_125(self):
return PymysqlPool('125')
def mysql_180(self):
return PymysqlPool('180')