def activity_cycling_user_2(): activity = Activity(user_id=2, sport_id=1, activity_date=datetime.datetime.strptime( '23/01/2018', '%d/%m/%Y'), distance=15, duration=datetime.timedelta(seconds=3600)) activity.moving = activity.duration db.session.add(activity) db.session.commit() return activity
def activity_running_user_1(): activity = Activity(user_id=1, sport_id=2, activity_date=datetime.datetime.strptime( '01/04/2018', '%d/%m/%Y'), distance=12, duration=datetime.timedelta(seconds=6000)) activity.moving = activity.duration db.session.add(activity) db.session.commit() return activity
def activity_cycling_user_1(): activity = Activity(user_id=1, sport_id=1, activity_date=datetime.datetime.strptime( '01/01/2018', '%d/%m/%Y'), distance=10, duration=datetime.timedelta(seconds=1024)) activity.max_speed = 10 activity.ave_speed = 10 activity.moving = activity.duration db.session.add(activity) db.session.commit() return activity
def seven_activities_user_1(): activity = Activity(user_id=1, sport_id=1, activity_date=datetime.datetime.strptime( '20/03/2017', '%d/%m/%Y'), distance=5, duration=datetime.timedelta(seconds=1024)) activity.ave_speed = float(activity.distance) / (1024 / 3600) activity.moving = activity.duration db.session.add(activity) db.session.flush() activity = Activity(user_id=1, sport_id=1, activity_date=datetime.datetime.strptime( '01/06/2017', '%d/%m/%Y'), distance=10, duration=datetime.timedelta(seconds=3456)) activity.ave_speed = float(activity.distance) / (3456 / 3600) activity.moving = activity.duration db.session.add(activity) db.session.flush() activity = Activity(user_id=1, sport_id=1, activity_date=datetime.datetime.strptime( '01/01/2018', '%d/%m/%Y'), distance=10, duration=datetime.timedelta(seconds=1024)) activity.ave_speed = float(activity.distance) / (1024 / 3600) activity.moving = activity.duration db.session.add(activity) db.session.flush() activity = Activity(user_id=1, sport_id=1, activity_date=datetime.datetime.strptime( '23/02/2018', '%d/%m/%Y'), distance=1, duration=datetime.timedelta(seconds=600)) activity.ave_speed = float(activity.distance) / (600 / 3600) activity.moving = activity.duration db.session.add(activity) db.session.flush() activity = Activity(user_id=1, sport_id=1, activity_date=datetime.datetime.strptime( '23/02/2018', '%d/%m/%Y'), distance=10, duration=datetime.timedelta(seconds=1000)) activity.ave_speed = float(activity.distance) / (1000 / 3600) activity.moving = activity.duration db.session.add(activity) db.session.flush() activity = Activity(user_id=1, sport_id=1, activity_date=datetime.datetime.strptime( '01/04/2018', '%d/%m/%Y'), distance=8, duration=datetime.timedelta(seconds=6000)) activity.ave_speed = float(activity.distance) / (6000 / 3600) activity.moving = activity.duration db.session.add(activity) db.session.flush() activity = Activity(user_id=1, sport_id=1, activity_date=datetime.datetime.strptime( '09/05/2018', '%d/%m/%Y'), distance=10, duration=datetime.timedelta(seconds=3000)) activity.ave_speed = float(activity.distance) / (3000 / 3600) activity.moving = activity.duration db.session.add(activity) db.session.commit() return activity