if __name__ == "__main__":
# model = Model()
# model.select(select_param=["id", "name", "gender"], where_param={"name = ": "jack", "gender = ": "M"})
# model.order_by(["name desc", "gender desc"])
# model.limit(1, 4)
# result = model.execute()
# print result
# model.insert(result)
# 配置
print finance_dict
# 迁移数据库
model = DBConnection(**finance_dict)
# 要迁移的数据库表 CpcFinanceDetail
model.table_name = "CpcFinanceDetail"
model_v2 = DBConnection(**finance_dict)
# 迁移的数据迁移到 CpcFinanceDetail1
model_v2.table_name = "CpcFinanceDetail1"
# 从线下库中找到上次同步的id
model_v2.select(select_param=["max(id) as max_id"])
mid = model_v2.execute()
max_id = mid[0]["max_id"]
if max_id is None:
max_id = 0
# 同步操作
status = True
# while status:
model.select(select_param=["*"], where_param={"id > ": max_id})
table_info = model.show_create_table()
model_v2.table_name = table
table_info_v2 = model_v2.show_create_table()
if table_info_v2 is None:
print model_v2.kwargs["host"] + "数据库" + model_v2.db + "中" + table + "不存在"
print "创建" + table + "中......."
model_v2.create_table(table_info)
print "创建成功!!!"
else:
print table + "已存在！！！"
"""
# result = ["UnionActivityPlan"]
# 同步表数据
for table in result:
model_v2.table_name = table
# 从线下库中找到上次同步的id
model_v2.select(select_param=["max(id) as max_id"])
mid = model_v2.execute()
max_id = mid[0]["max_id"]
if max_id is None:
max_id = 0
# 同步操作
status = True
while status:
model.table_name = table
model.select(select_param=["*"], where_param={"id > ": max_id})
model.limit(0, 1000)
item_list = model.execute()
if not item_list:
status = False
