def llamadaajaxdatosupdate(): datosbd = pg.executequery( "select datname,tup_returned from pg_stat_database where datname not like 'template%' and tup_fetched<>0") for values in datosbd: query = "insert into log_values values (%s,'Select', now(),%d)" % ("'" + values[0] + "'", values[1]) pg.executupdateequery(query) return dict(datosbd)
def llamadaajaxpeso(): datosbd = pg.executequery( "SELECT distinct datname,round(((pg_database_size(datname)/1024)/1024::numeric),2)::real from pg_database where datname not like 'template%' ") for values in datosbd: query = "insert into log_values values (%s,'Weigth', now(),%d)" % ("'" + values[0] + "'", values[1]) pg.executupdateequery(query) return dict(datosbd)
def llamadaajaxdatosupdate(): datosbd = pg.executequery( "select datname,tup_returned from pg_stat_database where datname not like 'template%' and tup_fetched<>0" ) for values in datosbd: query = "insert into log_values values (%s,'Select', now(),%d)" % ( "'" + values[0] + "'", values[1]) pg.executupdateequery(query) return dict(datosbd)
def llamadaajaxpeso(): datosbd = pg.executequery( "SELECT distinct datname,round(((pg_database_size(datname)/1024)/1024::numeric),2)::real from pg_database where datname not like 'template%' " ) for values in datosbd: query = "insert into log_values values (%s,'Weigth', now(),%d)" % ( "'" + values[0] + "'", values[1]) pg.executupdateequery(query) return dict(datosbd)
def llamadaajaxdatosconeccion(): datosbd = pg.executequery( "select datname,numbackends from pg_stat_database where datname not like 'template%' and numbackends<>0 ") for values in datosbd: query = "insert into log_values values (%s,'Conection', now(),%d)" % ("'" + values[0] + "'", values[1]) pg.executupdateequery(query) var = dict(datosbd) var[""] = 0.0001 return var
def llamadaajaxdatosconeccion(): datosbd = pg.executequery( "select datname,numbackends from pg_stat_database where datname not like 'template%' and numbackends<>0 " ) for values in datosbd: query = "insert into log_values values (%s,'Conection', now(),%d)" % ( "'" + values[0] + "'", values[1]) pg.executupdateequery(query) var = dict(datosbd) var[""] = 0.0001 return var
def llamadaajaxdatosmemoria(): datosbd = pg.executequery("select text,value from get_resource()") return dict(datosbd)
def llamadaajaxdatosfechahora(): datosbd = pg.executequery( "select 'fecha y Hora',current_date::text||' , '||to_char(current_timestamp,'HH24:MI:SS')" ) return dict(datosbd)
def llamadaajaxdatosmemoria(): datosbd = pg.executequery("select text,value from get_resource()") return dict(datosbd)
def llamadaajaxdatosfechahora(): datosbd = pg.executequery( "select 'fecha y Hora',current_date::text||' , '||to_char(current_timestamp,'HH24:MI:SS')") return dict(datosbd)