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)