In [ ]:

    

from senpy.pgsql.tables import tables_to_table


    

In [ ]:

    

conparam = {
    "HOST" : "localhost", "PORT" : "5432", "PASSWORD" : "admin",
    "USER" : "postgres", "DATABASE" : "valcarris_v2"
}

l = [
    "val_14jan_withcirc", "val_15jan_withcirc", "val_16jan_withcirc",
    "val_17jan_withcirc", "val_18jan_withcirc", "val_19jan_withcirc",
    "val_20jan_withcirc"
]

OUTTABLE = "val_14a20Jan_withcirc"


    

In [ ]:

    

tables_to_table(conparam, l, OUTTABLE)


    

In [1]:

    

"""
Execute senpy.pgsql.tables.copy.fromdb_todb
"""

from senpy.pgsql.tables import copy_fromdb_todb2

fromDb = {
    "HOST" : "localhost", "PORT" : "5432", "PASSWORD" : "admin",
    "USER" : "postgres", "DATABASE" : "valcarris_v2"
}

toDb = {
    "HOST" : "localhost", "PORT" : "5432", "PASSWORD" : "admin",
    "USER" : "postgres", "DATABASE" : "gtfs_carris"
}

table = ["validacoes_v9"]

copy_fromdb_todb2(fromDb, toDb, table)


    

In [ ]: