37,722
社区成员
发帖
与我相关
我的任务
分享
try:
mysql_cursor.execute(mysql_sql)
results = mysql_cursor.fetchall()
print "query all mysql records..."
param = []
for row in results:
id = row[0]
serial_number = row[1].encode('utf8')
#param.append(id,serial_number)
oracle_sql = 'insert into t_v_user_info(id,serial_number) values(:1,:2)'
oracle_cursor.execute(oracle_sql,(id,serial_number))
oracle_db.commit()
except Exception, err:
print err
mysql_db.rollback()
oracle_db.rollback()
print "database synchronization error"
exit(0)