def initial_write(verbose=False):
dbs = get_db_list()
for db in dbs:
cur = pgconn(db)[1]
cur.execute("SELECT %s, schemaname, relname, n_tup_ins, n_tup_upd, n_tup_del FROM pg_stat_user_tables", (db,))
for row in cur:
lite_write(row, verbose)
def table_sync():
existing = get_existing_db_stats()
pg_existing = []
dbs = get_db_list()
modified = []
for db in dbs:
cur = pgconn(db)[1]
cur.execute("SELECT %s, schemaname, relname, n_tup_ins, n_tup_upd, n_tup_del FROM pg_stat_user_tables", (db,))
for row in cur:
pg_existing.append(row)
for row in pg_existing:
for ex in existing:
if row[0] == ex[2] and row[1] == ex[3] and row[2] == ex[4]:
if row[3] != ex[5] or row[4] != ex[6] or row[5] != ex[7]:
dump_db('/home/cory/cityscan/dbdump', row[0], row[1], row[2])
