def test_session_query_daily_eat_assert_equal_true(self):
session = orm.session
rows = session.query(DailyEat).filter_by(user_id="test",
food="test",
year=1,
month=1,
date=1).all()
result = orm.as_list_dict(rows)
self.assertEqual(result[0]["user_id"], "test")
self.assertEqual(result[0]["food"], "test")
self.assertEqual(result[0]["year"], 1)
self.assertEqual(result[0]["month"], 1)
self.assertEqual(result[0]["date"], 1)
def get_user_bodys_by_user_id(user_id):
bodys = session.query(UserBody).filter_by(user_id=user_id).all()
list_bodys = orm.as_list_dict(bodys)
return jsonify(user_bodys=list_bodys)
def all():
bodys = session.query(UserBody).all()
list_bodys = orm.as_list_dict(bodys)
print(list_bodys)
return jsonify(user_bodys=list_bodys)
def get_daily_eat_by_user_id(user_id):
daily_eats = session.query(DailyEat).filter_by(user_id=user_id).all()
list_daily_eats = orm.as_list_dict(daily_eats)
return jsonify(daily_eats=list_daily_eats)
def all():
daily_eats = session.query(DailyEat).all()
list_daily_eats = orm.as_list_dict(daily_eats)
return jsonify(daily_eats=list_daily_eats)
def get_user_by_id(id):
users = session.query(User).filter_by(id=id).all()
list_users = orm.as_list_dict(users)
return jsonify(users=list_users)
def all():
users = session.query(User).all()
list_users = orm.as_list_dict(users)
print(list_users)
return jsonify(users=list_users)
def test_session_query_user_assert_equal_true(self):
session = orm.session
rows = session.query(User).filter_by(id="test").all()
result = orm.as_list_dict(rows)
self.assertEqual(result[0]["id"], "test")
self.assertEqual(result[0]["password"], "test")
def get_food_by_name(name):
foods = session.query(Food).filter_by(name=name).all()
list_foods = orm.as_list_dict(foods)
return jsonify(foods=list_foods)
def all():
foods = session.query(Food).all()
list_foods = orm.as_list_dict(foods)
return jsonify(foods=list_foods)
