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()