def persist(available_ip_list): insert_sql = "INSERT IGNORE INTO ZHIHU_PROXY (PROXY_IP) \ VALUES (%s)" print "insert sql:%s" % insert_sql tm = TransactionManager() tm.execute_many_sql(insert_sql, available_ip_list) tm.close_connection()
def empty_table(): truncate_sql = "truncate TABLE ZHIHU_PROXY" tm = TransactionManager() tm.execute_sql(truncate_sql) tm.close_connection()