def displaydata_toxl_instock():
con = con_postgres()
call_sql(con, 'REFRESH MATERIALIZED VIEW io."In_Stock"', [],
"executeNoReturn")
con.close()
sql_to_xl('io.In_Stock', wkbk=xw.Book.caller(), sh='In Stock')
def displaydata_toxl_enroute():
con = con_postgres()
call_sql(con, 'REFRESH MATERIALIZED VIEW io."Enroute"', [],
'executeNoReturn')
con.close()
sql_to_xl('io.Enroute', wkbk=xw.Book.caller(), sh='Enroute')
def displaydata_toxl_already():
con = con_postgres()
call_sql(con, 'REFRESH MATERIALIZED VIEW public."Already"', [],
'executeNoReturn')
con.close()
sql_to_xl('Already', wkbk=xw.Book.caller(), sh='Already')
def taxoeditor_toxl():
"""
Writes WmTaxo_Updated to taxo_editor.xlsm
"""
sql_to_xl('wm.WmTaxo_Updated', wkbk=xw.Book.caller(), sh='Taxo')
def displaydata_toxl_manual():
"""
Writes the postgres view public.Display1 to "Display Data.xlsm"
"""
sql_to_xl('Display1', wkbk=xw.Book.caller(), sh='Manual')