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()
