In [1]:

    

from senpy.pgsql.transportation.gtfs.circ import name_circulations


    

In [4]:

    

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

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


GTFS_SCHEMA = {
    "TNAME"     : "stop_times",
    "TRIP"      : "trip_id",
    "STOP"      : "stop_id",
    "SEQUENCE"  : "stop_sequence",
    "DEPARTURE" : "departure_time"
}

serviceSchema = {
    "TRIPS" : {
        "TNAME"   : "trips",
        "TRIP"    : "trip_id",
        "SERVICE" : "service_id"
    },
    "CALENDAR" : {
        "TNAME"   : "calendar_dates",
        "SERVICE" : "service_id",
        "DATE"    : "date",
        "FILTER"  : ''
    }
}

OTHER_SCHEMA = {
    "TNAME"    : "percursos_geom_v2",
    "ROUTE"    : "fid_percurso",
    "SEQUENCE" : "ordem",
    "STOP"     : "paragem"
}


    

In [5]:

    

name_circulations(conGTFS_DB, GTFS_SCHEMA, OTHER_SCHEMA, 'trip_and_route', conOther_DB=conOTHER_DB)


    

    
Out[5]:





'trip_and_route'

In [ ]: