import psycopg2 class BaseDatos(): def __init__(self): self.HOST = "192.168.10.59" self.PORT = 5432 self.USER = "administrador" self.PASS = "administrador" self.DB = "isvareporte" self.SELECT = "" def __conectarr__(self): self.conn = psycopg2.connect(host=self.HOST, port=self.PORT, database=self.DB, user=self.USER, password=self.PASS) self.cur = self.conn.cursor() self.resultado = "" def __desconectar__(self): self.conn.close() self.cur.close() def __leer__(self): self.cur.execute(self.SELECT) self.resultado = self.cur.fetchall() def __ValidarComando__(self): return(True) def Leer(self): if self.__ValidarComando__(): self.__conectarr__() self.__leer__() self.__desconectar__()