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