def checkListMysqlDB(keyword_id, influencer, link):
sql = 'SELECT circle FROM Weibo_keyword WHERE id="{}"'.format(keyword_id)
circle = queryOneMysqlDB(sql)[0]
#sql = 'SELECT keyword_id, influencer, link FROM Weibo WHERE keyword_id="{}" AND influencer="{}" AND link="{}"'.format(keyword_id, influencer, link)
sql = 'SELECT r.id FROM Weibo AS r, Weibo_keyword AS k WHERE r.keyword_id=k.id AND r.influencer="{}" AND r.link="{}" AND k.circle="{}"'.format(influencer, link, circle)
if queryOneMysqlDB(sql) != None:
return True
else:
sql = 'SELECT r.id FROM Weibo_leads AS r, Weibo_keyword AS k WHERE r.keyword_id=k.id AND r.influencer="{}" AND r.link="{}" AND k.circle="{}"'.format(influencer, link, circle)
return True if queryOneMysqlDB(sql)!=None else False
def addKeywordId():
sql = "SELECT * FROM Weibo_keyword"
keywordList = queryAllMysqlDB(sql)
id = 0
while True:
sql = 'SELECT id, product_seg, circle, keyword FROM Weibo WHERE keyword_id=0 and id>"{}" LIMIT 1'.format(
id)
result = queryOneMysqlDB(sql)
if result == None:
break
id = result[0]
print("{} {} {} {}".format(result[0], result[1], result[2], result[3]))
for keyword in keywordList:
if result[1] == keyword[1] and result[2] == keyword[2] and result[
3] == keyword[3]:
sql = 'UPDATE Weibo SET keyword_id="{}" WHERE id="{}"'.format(
keyword[0], result[0])
updateMysqlDB(sql)
break
time.sleep(0.1)
def queryPageidMysqlDB():
sql = 'SELECT keyword_id, page_id FROM Weibo_page LIMIT 1'
return queryOneMysqlDB(sql)
def queryKeywordMysqlDB():
sql = 'SELECT id, keyword FROM Weibo_keyword WHERE finished != 1 LIMIT 1'
return queryOneMysqlDB(sql)
def queryCircleMysqlDB(keyword_id):
sql = 'SELECT circle FROM Weibo_keyword WHERE id="{}"'.format(keyword_id)
return queryOneMysqlDB(sql)
def queryAccountMysqlDB():
sql = 'SELECT keyword_id, link FROM Weibo WHERE share_avg=0 AND comment_avg=0 AND post_type="" AND keyword_id!=0 LIMIT 1'
return queryOneMysqlDB(sql)
def checkExistDB(product_seg, circle, keyword):
sql = 'SELECT * FROM Weibo_keyword WHERE product_seg="{}" AND circle="{}" AND keyword="{}"'.format(
product_seg, circle, keyword)
return queryOneMysqlDB(sql)