def add_test_user(self):
User.query.delete()
user = User('test_name', 'test_surname', 'test_role', 'test_email',
'test_password', 1)
user.id = 1
dB.add(user)
dB.commit()
def add_test_field(self):
Field.query.delete()
field = Field('test_name', 'test_description', 'test_descriptor',
'test_website')
field.id = 1
dB.add(field)
dB.commit()
def add_test_user(self):
#Delete users and add one in the database
dbManager.delete_users()
user = User('test_name', 'test_surname', 'test_role', 'test_email',
'test_password', 1)
user.id = 1
dB.add(user)
dB.commit()
def add_test_offer(self):
#Delete offers and add one in the database
Offer.query.delete()
self.add_test_user()
offer = Offer('test_title', 'test_content', 'test_descriptor', 1)
offer.id = 1
dB.add(offer)
dB.commit()
def test_update_offer(self):
user = User('test_name2', 'test_surname2', 'test_role2', 'test_email2',
'test_password2', 1)
user.id = 2
dB.add(user)
dB.commit()
self.add_test_offer()
self.assertEqual(
dbManager.update_offer(1, 'new_test_title', 'new_test_content',
'new_test_descriptor', 2), True)
self.assertEqual(
dbManager.get_offer_by_id(1), {
'id': 1,
'title': 'new_test_title',
'content': 'new_test_content',
'descriptor': 'new_test_descriptor',
'id_user': 2
})
self.assertEqual(
dbManager.update_offer(36, 'new_test_title', 'new_test_content',
'new_test_descriptor', 2), None)