src = cfg[args.src]
print("")
print("------------------------------------------------------------------------------------")
print("Source: " + str(args.src))
print("------------------------------------------------------------------------------------")
srcdb = DB(dbname=src["db"], host=src["host"], port=int(src["port"]), user=src["user"], passwd=src["password"])
for srv in args.dst:
item = cfg[srv]
print("")
print("------------------------------------------------------------------------------------")
print("Destination: " + str(srv))
print("------------------------------------------------------------------------------------")
dstdb = DB(dbname=item["db"], host=item["host"], port=int(item["port"]), user=item["user"], passwd=item["password"])
for table in tables:
dstdb.start()
rows = srcdb.query('SELECT * FROM %s' % table).getresult()
dstdb.query('CREATE TEMPORARY TABLE newvals ON COMMIT DROP AS TABLE %s WITH NO DATA' % table)
dstdb.inserttable('newvals', rows)
dstdb.query('LOCK TABLE %s IN EXCLUSIVE MODE' % table)
print(upd.get(table))
dstdb.query(upd.get(table))
print(insert.get(table))
dstdb.query(insert.get(table))
dstdb.commit()
for srv in args.dst:
item = cfg[srv]
print("")
print(
"------------------------------------------------------------------------------------"
)
print("Destination: " + str(srv))
print(
"------------------------------------------------------------------------------------"
)
dstdb = DB(dbname=item["db"],
host=item["host"],
port=int(item["port"]),
user=item["user"],
passwd=item["password"])
for table in tables:
dstdb.start()
rows = srcdb.query('SELECT * FROM %s' % table).getresult()
dstdb.query(
'CREATE TEMPORARY TABLE newvals ON COMMIT DROP AS TABLE %s WITH NO DATA'
% table)
dstdb.inserttable('newvals', rows)
dstdb.query('LOCK TABLE %s IN EXCLUSIVE MODE' % table)
print(upd.get(table))
dstdb.query(upd.get(table))
print(insert.get(table))
dstdb.query(insert.get(table))
dstdb.commit()
