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)