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])