def getHospital(MinScale, typeList):
s = "SELECT * FROM tbHospitals WHERE scale >= " + str(
MinScale) + " and ( type like '%%%%%s%%%%'" % typeList[0]
for x in typeList:
s += " or type LIKE '%%%%%s%%%%'" % x
s += ')'
return tool_mysql.select_sql(s)
def f():
print('start')
import tool_mysql
from snownlp import SnowNLP
df_com=tool_mysql.select_sql('select id,txt from tbComments where sentiRate is null or sentiRate=\'\'') #读取评论文本 返回<class 'pandas.core.frame.DataFrame'>
for n in range(df_com.__len__()):
dt_com=[i for i in df_com.ix[n]]
if(len(dt_com[1])>0):
senti=SnowNLP(dt_com[1]).sentiments
tool_mysql.update('tbComments','sentiRate',senti,'id',str(dt_com[0]))
print(n,dt_com[1])
print(senti)
print('done')
def getAnswer(name, s_choice):
df = tool_mysql.select_sql(
'''SELECT question,choice FROM tbSickSymp WHERE name = '{}';'''.format(
name))
if (df.__len__() == 0):
return '警告：数据错误，未查到症状' + name
else:
s = df.ix[0][0]
if (type(df.ix[0][1]) == type('1') and len(df.ix[0][1]) > 0): #存在候选项
choice = eval(df.ix[0][1])
for i in choice:
if (i[0] == s_choice):
return i[1]
return '警告：未查到该快捷回复'
def getQuestion(txt):
df = tool_mysql.select_sql(
'''SELECT question,choice FROM tbSickSymp WHERE name = '{}';'''.format(
txt))
if (df.__len__() == 0):
return '警告：数据错误，未查到症状' + txt
else:
s = df.ix[0][0]
if (type(df.ix[0][1]) == type('1') and len(df.ix[0][1]) > 0): #存在候选项
choice = eval(df.ix[0][1])
n = 1
for i in choice:
s = s + "\n" + '''<a href="weixin://bizmsgmenu?msgmenucontent=''' + i[
0] + '''&msgmenuid=''' + str(n) + '''">''' + str(
n) + "." + i[0] + '''</a>'''
n += 1
return s
def getActionByWcid(wcid):
return tool_mysql.select_sql(
'''select level from tbUserAction WHERE wcid = '{}';'''.format(wcid))
def getUserBySymp(list):
str = "SELECT * FROM tbUser WHERE characteristics LIKE '%%%%%s%%%%'" % list[
0]
for x in list:
str += " or characteristics LIKE '%%%%%s%%%%'" % x
return tool_mysql.select_sql(str)
def getUser(FromUserName):
return tool_mysql.select_sql(
'''select * from tbUser WHERE wcid = '{}';'''.format(FromUserName))
def getSicknessByName(name):
return tool_mysql.select_sql(
"SELECT * FROM tbSickness WHERE sickName LIKE '%%%%%s%%%%'" % name)
def getSickness(txt):
return tool_mysql.select_sql(
"SELECT * FROM tbSickness WHERE symptomCha LIKE '%%%%%s%%%%'" % txt)
def getUserLocation(FromUserName):
df = tool_mysql.select_sql(
'''select * from tbUser WHERE wcid = '{}';'''.format(FromUserName))
return [df.ix[0][1], df.ix[0][2]]