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,
)
)
