In [ ]:

    

from senpy.topsql.pnd import xls_to_pgsql

excel = r'D:\TRENMO_JASP\CARRIS\validacoes\val_by_circ\v14a20jan_withcircgpby_v4.xlsx'

conParam = {
    'HOST':'localhost', 'USER': 'postgres', 'PASSWORD': 'admin',
    'PORT': '5432', 'DATABASE': 'gtfs_carris'
}

table = 'val_with_circ'

sheet='v14a20jan_withcircgpby_v4_0'

xls_to_pgsql(conParam, excel, table, excelSheet=sheet)


    

In [ ]:

    

from senpy.totxt import pgsql_to_txt

TABLE = 'val_14a20jan_withcirc'
CSVFI = r'D:\TRENMO_JASP\CARRIS\val_14a20jan_withcirc.csv'
conParam = {
    "HOST" : "localhost", "PORT" : "5432", "PASSWORD" : "admin",
    "USER" : "postgres", "DATABASE" : "valcarris_v2"
}

pgsql_to_txt(TABLE, CSVFI, '\t', dic_con=conParam)


    

In [1]:

    

from gasp.toxls import pgsql_to_xls

TABLE = 'nodes_wid_v2'
XLSFI = r'D:\TRENMO_JASP\CARRIS\emme\add_opp_sul_tejo\previous_nodesid.xlsx'
conParam = {
    "HOST" : "localhost", "PORT" : "5432", "PASSWORD" : "admin",
    "USER" : "postgres", "DATABASE" : "rdv_emme"
}

pgsql_to_xls(TABLE, XLSFI, dic_con=conParam)


    

    
Out[1]:





'D:\\TRENMO_JASP\\CARRIS\\emme\\add_opp_sul_tejo\\previous_nodesid.xlsx'

In [ ]:

    

from senpy.toxls import pgsql_to_xls2

QUERIES = [
    "SELECT * FROM validacoes_v9 WHERE route_id='736|0|ASC' AND dia='2018-01-15'",
    "SELECT * FROM validacoes_v9 WHERE route_id='736|3|ASC' AND dia='2018-01-15'",
    "SELECT * FROM validacoes_v9 WHERE route_id='736|4|ASC' AND dia='2018-01-15'",
    "SELECT * FROM validacoes_v9 WHERE route_id='736|0|DESC' AND dia='2018-01-15'",
    "SELECT * FROM validacoes_v9 WHERE route_id='736|3|DESC' AND dia='2018-01-15'",
    "SELECT * FROM validacoes_v9 WHERE route_id='736|4|DESC' AND dia='2018-01-15'",
    ("SELECT * FROM validacoes_v9 WHERE route_id='736|0|ASC' "
     "AND TO_TIMESTAMP(dia || ' ' || time, 'YYYY-MM-DD HH24:MI:SS') >= "
     "TO_TIMESTAMP('2018-01-15 07:30:00', 'YYYY-MM-DD HH24:MI:SS') AND "
     "TO_TIMESTAMP(dia || ' ' || time, 'YYYY-MM-DD HH24:MI:SS') <= "
     "TO_TIMESTAMP('2018-01-15 09:30:00', 'YYYY-MM-DD HH24:MI:SS')"),
    ("SELECT * FROM validacoes_v9 WHERE route_id='736|0|ASC' "
     "AND TO_TIMESTAMP(dia || ' ' || time, 'YYYY-MM-DD HH24:MI:SS') >= "
     "TO_TIMESTAMP('2018-01-15 16:30:00', 'YYYY-MM-DD HH24:MI:SS') AND "
     "TO_TIMESTAMP(dia || ' ' || time, 'YYYY-MM-DD HH24:MI:SS') <= "
     "TO_TIMESTAMP('2018-01-15 18:30:00', 'YYYY-MM-DD HH24:MI:SS')"),
    ("SELECT * FROM validacoes_v9 WHERE route_id='736|0|DESC' "
     "AND TO_TIMESTAMP(dia || ' ' || time, 'YYYY-MM-DD HH24:MI:SS') >= "
     "TO_TIMESTAMP('2018-01-15 07:30:00', 'YYYY-MM-DD HH24:MI:SS') AND "
     "TO_TIMESTAMP(dia || ' ' || time, 'YYYY-MM-DD HH24:MI:SS') <= "
     "TO_TIMESTAMP('2018-01-15 09:30:00', 'YYYY-MM-DD HH24:MI:SS')"),
    ("SELECT * FROM validacoes_v9 WHERE route_id='736|0|DESC' "
     "AND TO_TIMESTAMP(dia || ' ' || time, 'YYYY-MM-DD HH24:MI:SS') >= "
     "TO_TIMESTAMP('2018-01-15 16:30:00', 'YYYY-MM-DD HH24:MI:SS') AND "
     "TO_TIMESTAMP(dia || ' ' || time, 'YYYY-MM-DD HH24:MI:SS') <= "
     "TO_TIMESTAMP('2018-01-15 18:30:00', 'YYYY-MM-DD HH24:MI:SS')")
]

outXLS = r'D:\TRENMO_JASP\CARRIS\validacoes\porlinha\linha_736.xlsx'

sheets_names = [
    "736|0|ASC", "736|3|ASC", "736|4|ASC", 
    "736|0|DESC", "736|3|DESC", "736|4|DESC",
    "736|0|ASC_09_30", "736|0|ASC_16_30",
    "736|0|DESC_09_30", "736|0|DESC_16_30"
]

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

pgsql_to_xls2(QUERIES, outXLS, sheets_names, conParam)


    

In [ ]:

    

from senpy.totxt.pnd import psqldb_to_txt

conParam = {
    "HOST" : "localhost", "PORT" : "5432", "PASSWORD" : "admin",
    "USER" : "postgres", "DATABASE" : "matuc_db_tmp"
}

workspace = r'C:\gis\matuc'

psqldb_to_txt("\t", workspace, conParam)


    

In [ ]: