<commit_before>from datetime import date, datetime

from database import (Friendship, PopularPath, Route, Session,
                      SQLAlchemySession, User, Waypoint)

db = SQLAlchemySession()

# Add some users
colin = User(name='<NAME>')
ben = User(name='<NAME>')
ron = User(name='<NAME>')
mitt = User(name='<NAME>')
al = User(name='<NAME>')
john = User(name='<NAME>')
db.add_all([colin, ben, ron, mitt, al, john])
db.commit()

# Add some friendships
colin_ben = Friendship(friender_id=colin.id, friendee_id=ben.id)
colin_ron = Friendship(friender_id=colin.id, friendee_id=ron.id)
colin_mitt = Friendship(friender_id=colin.id, friendee_id=mitt.id)
colin_al = Friendship(friender_id=colin.id, friendee_id=al.id)
colin_john = Friendship(friender_id=colin.id, friendee_id=john.id)
ben_colin = Friendship(friender_id=ben.id, friendee_id=colin.id)
ron_colin = Friendship(friender_id=ron.id, friendee_id=colin.id)
al_colin = Friendship(friender_id=al.id, friendee_id=colin.id)
db.add_all([colin_ben, colin_ron, colin_mitt, colin_al, colin_john, ben_colin,
            ron_colin, al_colin])
db.commit()

# Add some routes
colin_r1 = Route(user_id=colin.id, distance=11, efficiency=81, time=201)
colin_r2 = Route(user_id=colin.id, distance=31, efficiency=91, time=2201)
colin_r3 = Route(user_id=colin.id, distance=553, efficiency=31, time=10201)
db.add_all([colin_r1, colin_r2, colin_r3])
db.commit()

# Add some waypoints
w1 = Waypoint(route_id=colin_r1.id, accuracy=20,
              latitude=29.648158, longitude=-82.344515)
w2 = Waypoint(route_id=colin_r1.id, accuracy=20,
              latitude=29.647691, longitude=-82.344617)
w3 = Waypoint(route_id=colin_r1.id, accuracy=20,
              latitude=29.647939, longitude=-82.345347)
w4 = Waypoint(route_id=colin_r1.id, accuracy=20,
              latitude=29.64723, longitude=-82.345502)
w5 = Waypoint(route_id=colin_r1.id, accuracy=20,
              latitude=29.646745, longitude=-82.346334)
w6 = Waypoint(route_id=colin_r1.id, accuracy=20,
              latitude=29.646582, longitude=-82.346977)
w7 = Waypoint(route_id=colin_r1.id, accuracy=20,
              latitude=29.646414, longitude=-82.347508)
db.add_all([w1, w2, w3, w4, w5, w6, w7])
db.commit()

db.close()<commit_msg>Added a few realistic waypoints for each route<commit_after>from datetime import date, datetime

from database import (Friendship, PopularPath, Route, Session,
                      SQLAlchemySession, User, Waypoint)

db = SQLAlchemySession()

# Add some users
colin = User(name='<NAME>')
ben = User(name='<NAME>')
ron = User(name='<NAME>')
mitt = User(name='<NAME>')
al = User(name='<NAME>')
john = User(name='<NAME>')
db.add_all([colin, ben, ron, mitt, al, john])
db.commit()

# Add some friendships
colin_ben = Friendship(friender_id=colin.id, friendee_id=ben.id)
colin_ron = Friendship(friender_id=colin.id, friendee_id=ron.id)
colin_mitt = Friendship(friender_id=colin.id, friendee_id=mitt.id)
colin_al = Friendship(friender_id=colin.id, friendee_id=al.id)
colin_john = Friendship(friender_id=colin.id, friendee_id=john.id)
ben_colin = Friendship(friender_id=ben.id, friendee_id=colin.id)
ron_colin = Friendship(friender_id=ron.id, friendee_id=colin.id)
al_colin = Friendship(friender_id=al.id, friendee_id=colin.id)
db.add_all([colin_ben, colin_ron, colin_mitt, colin_al, colin_john, ben_colin,
            ron_colin, al_colin])
db.commit()

# Add some routes
colin_r1 = Route(user_id=colin.id, distance=11, efficiency=81, time=201)
colin_r2 = Route(user_id=colin.id, distance=31, efficiency=91, time=2201)
colin_r3 = Route(user_id=colin.id, distance=553, efficiency=31, time=10201)
db.add_all([colin_r1, colin_r2, colin_r3])
db.commit()

# Add some waypoints
# CISE -> Reitz
w1 = Waypoint(route_id=colin_r1.id, accuracy=20,
              latitude=29.648158, longitude=-82.344515)
w2 = Waypoint(route_id=colin_r1.id, accuracy=20,
              latitude=29.647691, longitude=-82.344617)
w3 = Waypoint(route_id=colin_r1.id, accuracy=20,
              latitude=29.647939, longitude=-82.345347)
w4 = Waypoint(route_id=colin_r1.id, accuracy=20,
              latitude=29.64723, longitude=-82.345502)
w5 = Waypoint(route_id=colin_r1.id, accuracy=20,
              latitude=29.646745, longitude=-82.346334)
w6 = Waypoint(route_id=colin_r1.id, accuracy=20,
              latitude=29.646582, longitude=-82.346977)
w7 = Waypoint(route_id=colin_r1.id, accuracy=20,
              latitude=29.646414, longitude=-82.347508)
db.add_all([w1, w2, w3, w4, w5, w6, w7])
# CISE -> Library West
w8 = Waypoint(route_id=colin_r2.id, accuracy=33,
              latitude=29.64823, longitude=-82.34439)
w9 = Waypoint(route_id=colin_r2.id, accuracy=12,
              latitude=29.64904, longitude=-82.34364)
w10 = Waypoint(route_id=colin_r2.id, accuracy=5,
              latitude=29.65035, longitude=-82.34293)
w11 = Waypoint(route_id=colin_r2.id,  accuracy=21,
              latitude=29.65111, longitude=-82.34285)
db.add_all([w8, w9, w10, w11])
# CISE -> Little Hall
w12 = Waypoint(route_id=colin_r3.id, accuracy=17,
              latitude=29.64823, longitude=-82.34439)
w13 = Waypoint(route_id=colin_r3.id, accuracy=30,
              latitude=29.64858, longitude=-82.3433)
w14 = Waypoint(route_id=colin_r3.id, accuracy=23,
               latitude=29.64854, longitude=-82.34206)
w15 = Waypoint(route_id=colin_r3.id, accuracy=11,
               latitude=29.64875, longitude=-82.34102)
db.add_all([w12, w13, w14, w15])
db.commit()

db.close()
{'fraction_non_alphanumeric': 0.1414419372592185, 'fraction_numerical': 0.09466152999449642, 'mean_word_length': 4.655601659751038, 'pattern_counts': {'":': 0, '<': 15, '<?xml version=': 0, '>': 18, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 2, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '2036292', 'n_tokens_mistral': 2472, 'n_tokens_neox': 2199, 'n_words': 350}