/
seed.py
108 lines (69 loc) · 2.52 KB
/
seed.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
"""Seed rideshare database from user and address data in seed_data/"""
from sqlalchemy import func
from model import User
from model import Address
from model import UserAddress
from model import RideType
from model import Estimate
from model import connect_to_db, db
from server import app
from datetime import datetime
import geocoder
def load_users():
"""Load users from u.user into database."""
print "Users"
User.query.delete()
for row in open("seed_data/u.user"):
row = row.strip()
user_id, email, password = row.split("|")
password = password.strip()
user = User(user_id=user_id.strip(), email=email.strip(),
password=str(hash(password)))
db.session.add(user)
db.session.commit()
def load_addresses():
"""Load addresses from u.address into database."""
print "Addresses"
Address.query.delete()
for row in open("seed_data/u.address"):
row = row.strip()
address_id, address = row.split("|")
g = geocoder.google(address)
address = Address(address_id=address_id.strip(), latitude=g.latlng[0],
longitude=g.latlng[1], address=g.address, name=g.address)
db.session.add(address)
db.session.commit()
def load_user_addresses():
"""Load user addresses from u.user_address into database."""
print "Addresses"
UserAddress.query.delete()
for row in open("seed_data/u.user_address"):
row = row.strip()
user_id, address_id, label = row.split("|")
user_address = UserAddress(user_id=user_id.strip(), address_id=address_id.strip(), label=label.strip())
db.session.add(user_address)
db.session.commit()
def load_ridetypes():
"""Load ride types from u.ridetype into database."""
print "Ride Types"
RideType.query.delete()
for row in open("seed_data/u.ridetype"):
row = row.rstrip()
ride_service, ride_type = row.split("|")
ridetype = RideType(ride_service=ride_service, ride_type=ride_type)
db.session.add(ridetype)
db.session.commit()
def set_val_add_id():
"""Set value for next address_id."""
result = db.session.query(func.max(Address.address_id)).one()
max_id = int(result[0])
query = "SELECT setval('addresses_address_id_seq', :new_id)"
db.session.execute(query, {"new_id": max_id + 1})
db.session.commit()
if __name__ == "__main__":
connect_to_db(app)
db.create_all()
load_users()
load_addresses()
load_ridetypes()
# set_val_add_id()