def test__update_meeiro_cpf_already_saved_for_another__expected_ok(self):
connection = Connection('postgres', 'root', '127.0.0.1:5432',
'planting_manager_teste')
meeiro_id = create_meeiro(name='tadeu',
cpf='55584447213',
rg='50658045x')
create_meeiro(name='another', cpf='1111111111', rg='2222222222')
connection.session().expunge_all()
connection.session().close_all()
with self.assertRaises(DuplicatedValue):
Meeiro.update(connection.session(),
new_cpf='1111111111',
new_rg='new_rg',
new_name='new_name',
id_=meeiro_id)
def update(self, id_: int, cpf: str, rg: str, name: str):
try:
updated = Meeiro.update(self.db_connection,
new_cpf=cpf,
new_rg=rg,
new_name=name,
id_=id_)
if updated:
return True, 'Alterado com sucesso!'
else:
return False, 'Erro inesperado. Tente novamente.'
except DuplicatedValue as error:
return False, error
def test__update_meeiro__expected_ok(self):
connection = Connection('postgres', 'root', '127.0.0.1:5432',
'planting_manager_teste')
meeiro_id = create_meeiro(name='tadeu',
cpf='55584447213',
rg='50658045x')
connection.session().expunge_all()
connection.session().close_all()
result_set = Meeiro.update(connection.session(), 'new_cpf', 'new_rg',
'new_name', meeiro_id)
self.assertTrue(result_set)
connection.session().expunge_all()
connection.session().close_all()
altered_obj = connection.session().query(MeeiroMapping).filter(
MeeiroMapping.id == meeiro_id).one()
self.assertEqual(altered_obj.name, 'new_name')
self.assertEqual(altered_obj.rg, 'new_rg')
self.assertEqual(altered_obj.cpf, 'new_cpf')