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