def test_insert_duplicate_uid_and_rid_experience_entry(self):
'''
Tests inserting an entry into the experience table while an entry with
the same uid and same rid already exists in the table. Expect an error message and data in database remains the same.
'''
experience = Experience(uid=1, rid=12, experience=10)
db.session.add(experience)
errmsg = experiencehelper.insert_experience(1, 12)
self.assertEqual(errmsg, [
"Experience entry already exists for given user at this restaurant."
])
experience = Experience.query.filter_by(uid=1, rid=12)
self.assertEqual(experience.count(), 1)
self.assertEqual(experience.first().uid, 1)
self.assertEqual(experience.first().rid, 12)
self.assertEqual(experience.first().experience, 10)
def test_insert_duplicate_rid_experience_entry(self):
'''
Tests inserting an entry into the experience table while an entry with
the same rid and a different uid already exists in the table. Expect output to match correct data.
'''
experience = Experience(uid=1, rid=12, experience=10)
db.session.add(experience)
errmsg = experiencehelper.insert_experience(2, 12)
self.assertEqual(errmsg, None)
experience = Experience.query.filter_by(rid=12)
self.assertEqual(experience.count(), 2)
experience = Experience.query.filter_by(uid=1, rid=12).first()
self.assertNotEqual(experience, None)
self.assertEqual(experience.uid, 1)
self.assertEqual(experience.rid, 12)
self.assertEqual(experience.experience, 10)
experience = Experience.query.filter_by(uid=2, rid=12).first()
self.assertNotEqual(experience, None)
self.assertEqual(experience.uid, 2)
self.assertEqual(experience.rid, 12)
self.assertEqual(experience.experience, 0)