def backgroundjob():
all_user = User.select()
for user in all_user:
print(user.username)
if user:
current_day = date.today()
previous_day = Activity.select().where(
(Activity.completion_date < current_day)).order_by(
Activity.completion_date.desc()).limit(1)
for p in previous_day:
print(p.completion_date)
yesterday = p.completion_date
if yesterday:
from models.dailyrecord import DailyRecord
is_completed = Activity.select().where(
Activity.is_completed == 1,
Activity.completion_date == yesterday,
Activity.user == user.id).count()
print(is_completed)
task = Activity.select().where(
Activity.completion_date == yesterday,
Activity.user == user.id).count()
if task == 0:
print(user.id)
print(task)
completion_rate = 0
title = yesterday
relationship = DailyRecord(title=title,
completion_rate=completion_rate,
user=user.id)
else:
print(user.id)
print(task)
completion_rate = is_completed / task * 100
title = yesterday
relationship = DailyRecord(title=title,
completion_rate=completion_rate,
user=user.id)
if relationship.save():
print('Successfully saved')
else:
print('Something wrong in the code')
else:
print('Query Problem')
else:
print('No such user')
print("done")
def new():
activity = Activity.select()
activity_data = []
for act in activity:
info = {
'name': act.activity,
'calories': act.calories
}
activity_data.append(info)
return jsonify(activity_data)
def show(username):
user_id = get_jwt_identity()
user = User.get_or_none(User.id == user_id)
if user:
from models.activity import Activity
activities = Activity.select().where(Activity.user == user.id)
if activities:
return jsonify({
"user_id": user.id,
"username": user.username,
"email": user.email,
"profileImage": user.full_image_path,
"activity": [{
"activity_id": activity.id,
"tasks": activity.task,
"completion_date": activity.completion_date,
"is_completed": activity.is_completed
} for activity in activities]})
else:
return jsonify({"messages" : "User does not have any activities yet"})
else:
return abort(404)
