"""
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
"""
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 migrate_db_dict, ads_offline_db_dict
# 迁移数据库
model = DBConnection(**migrate_db_dict)
# model.table_name = "UnionKeyWord"
# 广告线下数据库
model_v2 = DBConnection(**ads_offline_db_dict)
# model_v2.table_name = "UnionKeyWord"
# 显示所有数据表
result = model.show_tables()
print "检测数据库中表......."
print model.kwargs["host"] + " 数据库中有如下表:"
for table in result:
print table
"""
# 同步两个库中的表结构