/
seed.py
130 lines (99 loc) · 4.73 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
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
# import requests
# import json
# from pprint import pprint
from model import connect_to_db, db, User, Like, Restaurant, Category, RestaurantCategory, Message, Image
from server import app
from werkzeug.security import generate_password_hash
from datetime import datetime
from datacollector import open_json_file, get_categories, get_restaurants
# Category
def add_category_to_db():
"""Add categories to the database."""
for category in categories:
cat_id = categories[category]['cat_id']
cat_title = categories[category]['cat_title']
cat = Category(cat_id=cat_id, cat_title=cat_title)
db.session.add(cat)
db.session.commit()
# RestaurantCategory
def add_rest_cat_to_db():
"""Add the restaurant id and category id to the database."""
categories = Category.query.all()
for category in categories:
for restaurant in rest:
for item in restaurant['categories']:
cat_id = category.cat_id
if cat_id in item.values():
rest_cat = RestaurantCategory(rest_id=restaurant['id'],
cat_id=category.cat_id)
print rest_cat
db.session.add(rest_cat)
db.session.commit()
# Restaurant
def add_rest_to_db():
"""Add all restaurants and info to the database."""
for restaurant in restaurants:
info = restaurants[restaurant]
address = ', '.join(info['address'])
category = Restaurant(rest_id=info['rest_id'],
rest_title=info['rest_title'],
rest_alias=info['rest_alias'],
rating=info['rating'],
num_reviews=info['num_reviews'],
address=address,
phone=info['phone']
)
db.session.add(category)
db.session.commit()
# User
def add_user_to_db(email, password, fname, lname, birthday):
"""Add fake users to database."""
birthday = datetime.strptime(birthday, '%Y-%m-%d')
password = generate_password_hash(password)
user = User(email=email, password=password, fname=fname, lname=lname, birthday=birthday)
db.session.add(user)
db.session.commit()
# Message
def add_messages_to_db(from_user_id, to_user_id, messaged_on, message):
"""Add fake messages to database."""
message = Message(from_user_id=from_user_id, to_user_id=to_user_id,
messaged_on=messaged_on, message=message)
db.session.add(message)
db.session.commit()
def add_image_to_db(image_url):
"""Add images from static folder to the database."""
image = Image(image_url=image_url)
db.session.add(image)
db.session.commit()
# Match
if __name__ == "__main__":
connect_to_db(app)
# categories = get_categories('restaurants.json')
# restaurants = get_restaurants('restaurants.json')
# rest = open_json_file('restaurants.json')
# add_image_to_db('static/profile-picture/bacon.png')
# add_image_to_db('static/profile-picture/beer.png')
# add_image_to_db('static/profile-picture/chopsticks.png')
# add_image_to_db('static/profile-picture/icecream.png')
# add_image_to_db('static/profile-picture/pancake.png')
# add_image_to_db('static/profile-picture/pizza.png')
# add_image_to_db('static/profile-picture/salad.png')
# add_image_to_db('static/profile-picture/sushi.png')
# add_image_to_db('static/profile-picture/taco.png')
# add_image_to_db('static/profile-picture/wine.png')
# add_user_to_db('marry@yahoo.com', '123', 'Mary', 'Poppins', '1965-08-25')
# add_user_to_db('james@hotmail.com', '123', 'James', 'Corden', '1965-05-09')
# add_user_to_db('hannah@gmail.com', '123', 'Hannah', 'Baker', '1945-02-05')
# add_user_to_db('chris@gmail.com', '123', 'Chris', 'Hemsworth', '1989-06-15')
# add_user_to_db('marian@gmail.com', '123', 'Marian', 'Cabrera', '1990-09-11')
# add_user_to_db('josh@gmail.com', '123', 'Josh', 'Cabrera', '1989-06-27')
# add_user_to_db('dianne@gmail.com', '123', 'Dianne', 'Noche', '1996-12-07')
# add_user_to_db('tin@gmail.com', '123', 'Tin', 'Noche', '1999-11-15')
# add_user_to_db('rem@gmail.com', '123', 'Rem', 'Noche', '2000-04-14')
# add_user_to_db('abiel@gmail.com', '123', 'Abiel', 'Noche', '2000-08-14')
# add_messages_to_db(1, 3, '2018-05-12', 'Hello, would you be down to eat some korean food?')
# add_messages_to_db(3, 2, '2018-05-12', 'Yeah, that sounds really great. Do you have a restaurant in mind?')
# add_messages_to_db(3, 4, '2018-05-12', 'Hi Man, saw you like ethipian food. WOuld you wanna grab sometime this week?')
# add_rest_to_db()
# add_category_to_db()
# add_rest_cat_to_db()