-
Notifications
You must be signed in to change notification settings - Fork 0
/
seed.js
84 lines (81 loc) · 9.61 KB
/
seed.js
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
// This file should contain all the record creation needed to seed the database with its default values.
// The data can then be loaded with the node seed.js
var Promise = require('bluebird');
var { db, Place, Hotel, Restaurant, Activity } = require('./db');
var data = {
hotels: [
{name: "Andaz Wall Street", place: {address: "75 Wall St", city: "New York", state: "NY", phone: "123-456-7890", location: [40.705137, -74.007624]}, num_stars: 4, amenities: "Pool, Free Wi-Fi" },
{name: "Hotel Mulberry", place: {address: "52 Mulberry St", city: "New York", state: "NY", phone: "123-456-7890", location: [40.715317, -73.999542]}, num_stars: 4.5, amenities: "Free Wi-Fi" },
{name: "The Ritz-Carlton New York, Battery Park", place: {address: "Two West Street", city: "New York", state: "NY", phone: "123-456-7890", location: [40.705417, -74.017241]}, num_stars: 4.5, amenities: "24 hour Gym, Paid Wi-Fi" },
{name: "Wall Street Inn", place: {address: "9 S William St", city: "New York", state: "NY", phone: "123-456-7890", location: [40.704581, -74.010273]}, num_stars: 4, amenities: "Free Wi-Fi" },
{name: "Smyth TriBeCa", place: {address: "85 West Broadway", city: "New York", state: "NY", phone: "123-456-7890", location: [40.715076, -74.009301]}, num_stars: 3.5, amenities: "24 hour Gym" },
{name: "Double Tree", place: {address: "8 Stone St", city: "New York", state: "NY", phone: "123-456-7890", location: [40.703961, -74.012350]}, num_stars: 3.5, amenities: "24 hour Gym" },
{name: "Hotel 91", place: {address: "91 E Broadway", city: "New York", state: "NY", phone: "123-456-7890", location: [40.713427, -73.993624]}, num_stars: 3.5, amenities: "Free Wi-Fi" },
{name: "Conrad New York Hotel", place: {address: "102 N End Ave", city: "New York", state: "NY", phone: "123-456-7890", location: [40.714985, -74.015841]}, num_stars: 3.5, amenities: "Paid Wi-Fi, Dogs Allowed" },
{name: "Millenium Hilton Hotel", place: {address: "55 Church St", city: "New York", state: "NY", phone: "123-456-7890", location: [40.711597, -74.010392]}, num_stars: 3.5, amenities: "Paid Wi-Fi" },
{name: "US Pacific Hotel", place: {address: "106 Bowery", city: "New York", state: "NY", phone: "123-456-7890", location: [40.717873, -73.995231]}, num_stars: 2, amenities: "Accepts Credit Cards" },
{name: "Gild Hall, a Thompson Hotel", place: {address: "15 Gold Street", city: "New York", state: "NY", phone: "123-456-7890", location: [40.707894, -74.007108]}, num_stars: 4, amenities: "Paid Wi-Fi" },
{name: "W New York", place: {address: "123 Washington Street", city: "New York", state: "NY", phone: "123-456-7890", location: [40.709102, -74.013997]}, num_stars: 3.5, amenities: "Pool, 24 hour Gym, Paid Wi-Fi" },
{name: "New York Marriott Downtown", place: {address: "85 W St at Albany St", city: "New York", state: "NY", phone: "123-456-7890", location: [40.731131, -73.989568]}, num_stars: 3.5, amenities: "24 hour Gym, Paid Wi-Fi" },
{name: "Cosmopolitan Hotel", place: {address: "95 W Broadway", city: "New York", state: "NY", phone: "123-456-7890", location: [40.715681, -74.008922]}, num_stars: 3.5, amenities: "Free Wif-Fi" },
{name: "Club Quarters", place: {address: "140 Washington St", city: "New York", state: "NY", phone: "123-456-7890", location: [40.709630, -74.013940]}, num_stars: 4, amenities: "Free Wif-Fi" }
],
restaurants: [
{name: "Bouley", place: {address: "75 Wall St", city: "New York", state: "NY", phone: "123-456-7890", location: [40.705137, -74.013940]}, cuisine: "French", price: 4},
{name: "Marc Forgione", place: {address: "134 Reade St", city: "New York", state: "NY", phone: "123-456-7890", location: [40.716526, -74.009567]}, cuisine: "Seafood", price: 3},
{name: "Tamarind", place: {address: "99 Hudson St", city: "New York", state: "NY", phone: "123-456-7890", location: [40.718977, -74.008929]}, cuisine: "Indian", price: 3},
{name: "Hop Lee Restaurant", place: {address: "16 Mott St", city: "New York", state: "NY", phone: "123-456-7890", location: [40.714230, -73.998509]}, cuisine: "Chinese", price: 2},
{name: "Jungsik", place: {address: "2 Harrison St", city: "New York", state: "NY", phone: "123-456-7890", location: [40.718679, -74.008900]}, cuisine: "Korean", price: 4},
{name: "The Capital Grille", place: {address: "120 Broadway", city: "New York", state: "NY", phone: "123-456-7890", location: [40.708475, -74.010846]}, cuisine: "Steakhouses, American", price: 4},
{name: "Pylos", place: {address: "128 E 7th St", city: "New York", state: "NY", phone: "123-456-7890", location: [40.726096, -73.984152]}, cuisine: "Greek", price: 3},
{name: "Joe's Shanghai", place: {address: "9 Pell St", city: "New York", state: "NY", phone: "123-456-7890", location: [40.714601, -73.997761]}, cuisine: "Shanghainese, Dim Sum", price: 2},
{name: "Cafe Katja", place: {address: "79 Orchard St", city: "New York", state: "NY", phone: "123-456-7890", location: [40.717719, -73.990565]}, cuisine: "German, Austrian", price: 2},
{name: "Rosanjin", place: {address: "141 Duane St", city: "New York", state: "NY", phone: "123-456-7890", location: [40.716403, -74.007724]}, cuisine: "Japanese", price: 3},
{name: "Kittichai", place: {address: "60 Thompson St", city: "New York", state: "NY", phone: "123-456-7890", location: [40.724014, -74.003242]}, cuisine: "Thai", price: 4},
{name: "Bianca Restaurant", place: {address: "5 Bleecker St", city: "New York", state: "NY", phone: "123-456-7890", location: [40.725495, -73.992662]}, cuisine: "Italian", price: 2},
{name: "Rayuela", place: {address: "165 Allen St", city: "New York", state: "NY", phone: "123-456-7890", location: [40.721266, -73.989756]}, cuisine: "Spanish, Latin American", price: 3},
{name: "Mas Farmhouse", place: {address: "39 Downing St", city: "New York", state: "NY", phone: "123-456-7890", location: [40.729269, -74.003875]}, cuisine: "New American, French", price: 4},
{name: "Xe Lua", place: {address: "86 Mulberry St", city: "New York", state: "NY", phone: "123-456-7890", location: [40.716544, -73.998626]}, cuisine: "Vietnamese", price: 1}
],
activities: [
{name: "Mahayana Temple Buddhist Association", place: {address: "133 Canal St", city: "New York", state: "NY", phone: "123-456-7890", location: [40.716291, -73.995315]}, age_range: "All" },
{name: "South Street Seaport", place: {address: "19 Fulton St", city: "New York", state: "NY", phone: "123-456-7890", location: [40.707119, -74.003602]}, age_range: "All" },
{name: "Ground Zero", place: {address: "1 Liberty Plz Lbby 2", city: "New York", state: "NY", phone: "123-456-7890", location: [40.709329, -74.013120]}, age_range: "All" },
{name: "National September 11th Memorial & Museum", place: {address: "1 Albany St", city: "New York", state: "NY", phone: "123-456-7890", location: [40.709189, -74.013157]}, age_range: "All" },
{name: "Battery Park", place: {address: "State St & Battery Pl", city: "New York", state: "NY", phone: "123-456-7890", location: [40.704531, -74.014334]}, age_range: "All" },
{name: "Staten Island Ferry Whitehall Terminal", place: {address: "4 S St", city: "New York", state: "NY", phone: "123-456-7890", location: [40.729125, -73.989650]}, age_range: "All" },
{name: "Chinatown Ice Cream Factory", place: {address: "65 Bayard St", city: "New York", state: "NY", phone: "123-456-7890", location: [40.715323, -73.998190]}, age_range: "All" },
{name: "Blue Man Group", place: {address: "434 Lafayette St", city: "New York", state: "NY", phone: "123-456-7890", location: [40.729373, -73.992104]}, age_range: "All" },
{name: "Scott's Pizza Tours", place: {address: "244 5th Ave", city: "New York", state: "NY", phone: "123-456-7890", location: [40.744610, -73.987708]}, age_range: "All" },
{name: "Apple Store", place: {address: "103 Prince St", city: "New York", state: "NY", phone: "123-456-7890", location: [40.724918, -73.999144]}, age_range: "All" },
{name: "Brooklyn Bridge Park", place: {address: "Pier 1", city: "New York", state: "NY", phone: "123-456-7890", location: [40.702225, -73.996563]}, age_range: "All" },
{name: "Ellis Island Immigration Museum", place: {address: "Ellis Island", city: "New York", state: "NY", phone: "123-456-7890", location: [40.699297, -74.040317]}, age_range: "All" },
{name: "Washington Square Park", place: {address: "1 Washington Sq E", city: "New York", state: "NY", phone: "123-456-7890", location: [40.732204, -73.998649]}, age_range: "All" },
{name: "Union Square Holiday Market", place: {address: "Union Sq & W 14th St", city: "New York", state: "NY", phone: "123-456-7890", location: [40.733615, -73.987995]}, age_range: "All" },
{name: "Strand Bookstore", place: {address: "828 Broadway", city: "New York", state: "NY", phone: "123-456-7890", location: [40.733274, -73.990870]}, age_range: "All" }
]
};
db.sync({force: true})
.then(function () {
console.log("Dropped old data, now inserting data");
const creatingHotels = Promise.map(data.hotels, function (hotel) {
return Hotel.create(hotel, { include: [Place] });
});
const creatingRestaurants = Promise.map(data.restaurants, function (restaurant) {
return Restaurant.create(restaurant, { include: [Place] });
});
const creatingActivities = Promise.map(data.activities, function (activity) {
return Activity.create(activity, { include: [Place] });
});
return Promise.all([creatingHotels, creatingRestaurants, creatingActivities]);
})
.then(function () {
console.log('Finished inserting data');
})
.catch(function (err) {
console.error('There was totally a problem', err, err.stack);
})
.finally(function () {
db.close(); // creates but does not return a promise
return null; // stops bluebird from complaining about un-returned promise
});