def get(self, identifier=None): sql = inout.get_queries_file() if identifier: return PgSqlDal.execute_query(sql['Address']['getOneOrMore'], CMD_TYPE_TEXT, (identifier,)) else: return PgSqlDal.execute_query(sql['Address']['getAll'], CMD_TYPE_TEXT)
def get(self, zip_number=None): """ Return a list of tuples with the data of registers """ sql = inout.get_queries_file() if zip_number: return PgSqlDal.execute_query(sql['ZipCodes']['getOneOrMore'], CMD_TYPE_TEXT, (zip_number,)) else: return PgSqlDal.execute_query(sql['Zipcodes']['getAll'], CMD_TYPE_TEXT)
def test_exec_query_func(self): """<TestPgSqlDal> A chamada à função "insert_in_tbltests" deve ocorrer sem erros e ter algum retorno se o SGDB estiver alcançável""" ret = PgSqlDal.execute_query(self.sql['TblTests']['callFunction'], CMD_TYPE_FUNCTION, ('Matheus Saraiva', ), must_commit=False, is_test=True) self.assertIsNotNone(ret, 'Não houve um retorno')
def test_exec_query_text_n_par(self): """<TestPgSqlDal> A consulta sem parâmetros deve ocorrer sem erros e ter algum retorno""" ret = PgSqlDal.execute_query( self.sql['TblTests']['selectWithoutParameter'], CMD_TYPE_TEXT, must_commit=False, is_test=True) self.assertIsNotNone(ret, 'Não houve um retorno')
def insert(self, address): """ Insert a Address object in data base and return the current ID """ sql = inout.get_queries_file() return PgSqlDal.execute_query(sql['Address']['insert'], CMD_TYPE_FUNCTION, ( address.zip_code, address.number, address.complement ) )
def insert(self, dependent): sql = inout.get_queries_file() return PgSqlDal.execute_query(sql['Dependents']['insert'], CMD_TYPE_FUNCTION, ( dependent.person.name, dependent.person.telephone, dependent.person.email, dependent.person.address, dependent.person.photo, dependent.person.login, dependent.person.password, dependent.person.is_authorized, dependent.guarantor, ) )