def setUp(self):
self.conn1, self.cur1 = mysql.connect_mysql(host="10.255.254.22",
user="******",
passwd="ddbackend",
db="prodviewdb",
port=3306)
self.conn2, self.cur2 = mysql.connect_mysql(host="10.255.255.22",
user="******",
passwd="ddbackend",
db="prodinterSeachdb",
port=3306)
from common_module import mysql
import time
table_list = ["b2c_product","b2c_product_subcat","category_map","coupon_info",
"product_activity_search","product_info","product_meta","product_price",
"product_promo_info","product_stock","products_core_search","search_info",
"search_info_extra"]
source_record = {}
destination_record = {}
start_pid = 1066700124
end_pid = 1066701624
conn2,cur2 = mysql.connect_mysql(host="10.255.254.22",user="******",passwd="ddbackend",db="prodviewdb_recycle",port=3306,charset="utf8")
conn1,cur1 = mysql.connect_mysql(host="10.255.254.22",user="******",passwd="ddbackend",db="prodviewdb",port=3306,charset="utf8")
#insert into prodviewdb_recycle.recycle 10000 record
'''
for i in xrange(2000001):
if i > 600000:
cur2.execute("insert into recycle (product_id,shop_id,product_name,category_id,status,creation_date,last_modified_date) values (%d,%d,'xiaolongtest',%d,0,now(),now())" % (i,(i + 10 ),(i * 100)))
if i > 3000000:
break
conn2.commit()
'''
'''
pids = []
cur1.execute("select product_id from products_core_search where product_id >= 60209143 limit 100000")
def setUp(self):
self.conn1,self.cur1 = mysql.connect_mysql(host="10.255.254.22",user="******",passwd="ddbackend",db="prodviewdb",port=3306)
self.conn2,self.cur2 = mysql.connect_mysql(host="10.255.255.22",user="******",passwd="ddbackend",db="prodinterSeachdb",port=3306)
