def testFoodDiary(self):
'''Create food entries'''
now = datetime.datetime.now().strftime("%Y-%m-%d")
self.user = models.Users(username='******', email='*****@*****.**', password=generate_password_hash('welcome1'))
session.add(self.user)
session.commit()
rank1 = models.Ranks(rank=1, rankdesc='Good')
rank2 = models.Ranks(rank=2, rankdesc='Ok')
rank3 = models.Ranks(rank=3, rankdesc='Bad')
session.add_all([rank1, rank2, rank3])
session.commit()
food1 = models.Food(food='TEST FOOD 1', food_date=now, rank_id=1, user_id=self.user.id)
food2 = models.Food(food='TEST FOOD 1', food_date=now, rank_id=2, user_id=self.user.id)
food3 = models.Food(food='TEST FOOD 1', food_date=now, rank_id=3, user_id=self.user.id)
session.add_all([food1, food2, food3])
session.commit()
foodcount = session.query(models.Food).count()
self.assertEqual(foodcount, 3)
def testRank(self):
'''Create ranks'''
try:
self.rank1 = models.Ranks(rank=1, rankdesc='good')
self.rank2 = models.Ranks(rank=2, rankdesc='ok')
self.rank3 = models.Ranks(rank=3, rankdesc='bad')
session.add_all([self.rank1, self.rank2, self.rank3])
session.commit()
r1test = session.query(models.Ranks).filter_by(rank=1).first()
r2test = session.query(models.Ranks).filter_by(rank=2).first()
r3test = session.query(models.Ranks).filter_by(rank=3).first()
self.assertEqual(r1test.rankdesc, 'good')
self.assertEqual(r2test.rankdesc, 'ok')
self.assertEqual(r3test.rankdesc, 'bad')
except sqlalchemy.exc.DataError as error:
print(error)
def testRank(self):
'''Create ranks'''
try:
self.rank1 = models.Ranks(rank=1, rankdesc='good')
self.rank2 = models.Ranks(rank=2, rankdesc='ok')
self.rank3 = models.Ranks(rank=3, rankdesc='bad')
session.add_all([self.rank1, self.rank2, self.rank3])
session.commit()
r1test = session.query(models.Ranks).filter_by(rank=1).first()
r2test = session.query(models.Ranks).filter_by(rank=2).first()
r3test = session.query(models.Ranks).filter_by(rank=3).first()
self.assertEqual(r1test.rankdesc, 'good')
self.assertEqual(r2test.rankdesc, 'ok')
self.assertEqual(r3test.rankdesc, 'bad')
except sqlalchemy.exc.DataError as error:
print(error)
def testFoodDiary(self):
'''Create food entries'''
now = datetime.datetime.now().strftime("%Y-%m-%d")
self.user = models.Users(username='******',
email='*****@*****.**',
password=generate_password_hash('welcome1'))
session.add(self.user)
session.commit()
rank1 = models.Ranks(rank=1, rankdesc='Good')
rank2 = models.Ranks(rank=2, rankdesc='Ok')
rank3 = models.Ranks(rank=3, rankdesc='Bad')
session.add_all([rank1, rank2, rank3])
session.commit()
food1 = models.Food(food='TEST FOOD 1',
food_date=now,
rank_id=1,
user_id=self.user.id)
food2 = models.Food(food='TEST FOOD 1',
food_date=now,
rank_id=2,
user_id=self.user.id)
food3 = models.Food(food='TEST FOOD 1',
food_date=now,
rank_id=3,
user_id=self.user.id)
session.add_all([food1, food2, food3])
session.commit()
foodcount = session.query(models.Food).count()
self.assertEqual(foodcount, 3)
def setranks():
rank1 = Ranks(rank=1, rankdesc='Good')
rank2 = Ranks(rank=2, rankdesc='Ok')
rank3 = Ranks(rank=3, rankdesc='Bad')
session.add_all([rank1, rank2, rank3])
session.commit()
