def update_mysql(all_tag):
conn = Getconf.getdb_con()
for tag in all_tag:
update_sql = "update tag_merge set is_delete=1 where tag_name='%s'" % tag
cursor = conn.cursor(cursor=pymysql.cursors.DictCursor)
cursor.execute(update_sql)
conn.commit()
conn.close()
def last_deal(the_bool, tag_name):
conn = Getconf.getdb_con()
cursor = conn.cursor(cursor=pymysql.cursors.DictCursor)
if the_bool:
# 更改状态为执行完毕
update_sql = "UPDATE tag_merge SET the_status=1 WHERE tag_name='%s'" % tag_name
cursor.execute(update_sql)
conn.commit()
else:
# 更改状态为执行完毕，删除键为是
update_sql = "UPDATE tag_merge SET the_status=1,is_delete=1 WHERE tag_name='%s'" % tag_name
cursor.execute(update_sql)
conn.commit()
conn.close()
def get_excute_info():
name_status = " 'the_status': 0 "
info = []
get_sql = 'select tag_name,the_status from tag_merge where is_delete=0 order by update_time desc'
while name_status.find("'the_status': 0") != -1:
conn = Getconf.getdb_con()
cursor = conn.cursor(cursor=pymysql.cursors.DictCursor)
cursor.execute(get_sql)
info = cursor.fetchall()
name_status = str(info)
time.sleep(10)
conn.close()
tag_list = []
for name in info:
tag_list.append(name['tag_name'])
return tag_list
def first_deal(tag_name):
# 连接mysql,0为正在执行，否
# 判断，有则更改状态为正在执行，删除键为否
# 不管是否执行成功，更改状态为执行完毕
# 无则插入正在执行，删除键为否
# 不管是否执行成功，更改状态为执行完毕，删除键为是
conn = Getconf.getdb_con()
cursor = conn.cursor(cursor=pymysql.cursors.DictCursor)
sql = "select tag_name from tag_merge where tag_name='%s'" % tag_name
count = cursor.execute(sql)
the_bool = False if count == 0 else True
if the_bool:
# 更改状态为正在执行，删除键为否
update_sql = "UPDATE tag_merge SET the_status=0,is_delete=0 WHERE tag_name='%s'" % tag_name
cursor.execute(update_sql)
conn.commit()
else:
# 插入正在执行，删除键为否
insert_sql = "INSERT INTO tag_merge(tag_name,the_status,is_delete) VALUES('%s',0,0)" % tag_name
cursor.execute(insert_sql)
conn.commit()
conn.close()
return the_bool