API tools faq
paste
Advertisement
noburudesu

add_data.js

noburudesu
Jul 23rd, 2023
78
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 13.40 KB | None | 0 0
raw download clone embed print report
  1. /*
  2. This script creates the database and inserts 5 users (all of which are owners to exactly one establishment), 5 reviews, 5 establishments
  3. */
  4.  
  5. // import module `database` from `../models/db.js`
  6. const db = require('./models/db.js');
  7.  
  8. /* import all the collections */
  9. const User = require('./models/UserModel.js');
  10. const Establishment = require('./models/EstablishmentModel.js');
  11. const Review = require('./models/ReviewModel.js');
  12. const EstablishmentOwner = require('./models/EstablishmentOwnerModel.js');
  13. const OwnerResponse = require('./models/OwnerResponseModel.js');
  14.  
  15. async function insertUser(user) {
  16. await db.insertOne(User, user);
  17. }
  18.  
  19. async function insertEstablishmentOwner(establishmentOwner) {
  20. await db.insertOne(EstablishmentOwner, establishmentOwner);
  21. };
  22.  
  23. async function insertEstablishment(establishment) {
  24. await db.insertOne(Establishment, establishment);
  25. }
  26.  
  27. async function insertReview(review) {
  28. await db.insertOne(Review, review);
  29. }
  30.  
  31. /* insert 7 users - 5 owners 2 visitors */
  32. /* the owner accounts */
  33. var user = {
  34. username: "kenshinfetalvero",
  35. password: "123",
  36. first_name: "Kenshin",
  37. last_name: "Fetalvero",
  38. description: "CEO of Jollibee",
  39. avatarImagePath: "../images/default-user-images/default-avatar.png",
  40. bannerImagePath: "../images/default-user-images/default-banner.jpg",
  41. location: "Philippines",
  42. joined: "2023-07-19T00:00:00.000Z"
  43. };
  44.  
  45. insertUser(user);
  46.  
  47. var user = {
  48. username: "briangabini",
  49. password: "123",
  50. first_name: "Brian",
  51. last_name: "Gabini",
  52. description: "CEO of Jus and Jerry's",
  53. avatarImagePath: "../images/default-user-images/default-avatar.png",
  54. bannerImagePath: "../images/default-user-images/default-banner.jpg",
  55. location: "Philippines",
  56. joined: "2023-07-19T00:00:00.000Z"
  57. };
  58.  
  59. insertUser(user);
  60.  
  61. var user = {
  62. username: "shawnetumalad",
  63. password: "123",
  64. first_name: "Shawne",
  65. last_name: "Tumalad",
  66. description: "CEO of Burger King",
  67. avatarImagePath: "../images/default-user-images/default-avatar.png",
  68. bannerImagePath: "../images/default-user-images/default-banner.jpg",
  69. location: "Philippines",
  70. joined: "2023-07-19T00:00:00.000Z"
  71. };
  72.  
  73. insertUser(user);
  74.  
  75. var user = {
  76. username: "johndolon",
  77. password: "123",
  78. first_name: "John",
  79. last_name: "Dolon",
  80. description: "CEO of 24 Chicken",
  81. avatarImagePath: "../images/default-user-images/default-avatar.png",
  82. bannerImagePath: "../images/default-user-images/default-banner.jpg",
  83. location: "Philippines",
  84. joined: "2023-07-19T00:00:00.000Z"
  85. };
  86.  
  87. insertUser(user);
  88.  
  89. var user = {
  90. username: "jmdolon",
  91. password: "123",
  92. first_name: "John",
  93. last_name: "Dolon",
  94. description: "CEO of BonChon",
  95. avatarImagePath: "../images/default-user-images/default-avatar.png",
  96. bannerImagePath: "../images/default-user-images/default-banner.jpg",
  97. location: "Philippines",
  98. joined: "2023-07-19T00:00:00.000Z"
  99. };
  100.  
  101. insertUser(user);
  102.  
  103. /* the other 2 visitor accounts */
  104. var user = {
  105. username: "randomuser1",
  106. password: "123",
  107. first_name: "Alfredo",
  108. last_name: "Cruz",
  109. description: "I like burgers!",
  110. avatarImagePath: "../images/default-user-images/default-avatar.png",
  111. bannerImagePath: "../images/default-user-images/default-banner.jpg",
  112. location: "Philippines",
  113. joined: "2023-07-19T00:00:00.000Z"
  114. };
  115.  
  116. insertUser(user);
  117.  
  118. var user = {
  119. username: "randomuser2",
  120. password: "123",
  121. first_name: "Pepito",
  122. last_name: "Manaloto",
  123. description: "I like chicken!",
  124. avatarImagePath: "../images/default-user-images/default-avatar.png",
  125. bannerImagePath: "../images/default-user-images/default-banner.jpg",
  126. location: "Philippines",
  127. joined: "2023-07-19T00:00:00.000Z"
  128. };
  129.  
  130. insertUser(user);
  131.  
  132. /* map it to the EstablishmentOwner */
  133. var establishmentOwner = {
  134. username: "kenshinfetalvero",
  135. establishment_id: 0
  136. };
  137.  
  138. insertEstablishmentOwner(establishmentOwner);
  139.  
  140. var establishmentOwner = {
  141. username: "briangabini",
  142. establishment_id: 1
  143. };
  144.  
  145. insertEstablishmentOwner(establishmentOwner);
  146.  
  147. var establishmentOwner = {
  148. username: "shawnetumalad",
  149. establishment_id: 2
  150. };
  151.  
  152. insertEstablishmentOwner(establishmentOwner);
  153.  
  154. var establishmentOwner = {
  155. username: "johndolon",
  156. establishment_id: 3
  157. };
  158.  
  159. insertEstablishmentOwner(establishmentOwner);
  160.  
  161. var establishmentOwner = {
  162. username: "jmdolon",
  163. establishment_id: 4
  164. };
  165.  
  166. insertEstablishmentOwner(establishmentOwner);
  167.  
  168. /* insert 5 establishments */
  169. var establishment = {
  170. establishment_id: 0,
  171. name: "Jollibee",
  172. description: "Jollibee's fried chicken - Chickenjoy, spaghetti & burgers made it one of the fastest growing restaurants in the world with 1400+ branches globally. People also ask",
  173. contact: "09293939191",
  174. address: "10/F Jollibee Plaza Building, Emerald Ave., Ortigas Center, Pasig City",
  175. overall_rating: 5,
  176. total_reviews: 1,
  177. imagePaths: {
  178. establishmentPfpPath: "../images/Establishments/Jollibee/jollibee_pfp.png",
  179. establishmentMapPath: "../images/Establishments/Jollibee/jollibee_map.png",
  180. establishmentHeaderPath: "../images/Establishments/Jollibee/jollibee_header.jpg",
  181. establishmentMenuPhotos: [
  182. "../images/Establishments/Jollibee/photos/jollibee_menu1.png"
  183. ],
  184. establishmentFoodPhotos: [
  185. "../images/Establishments/Jollibee/photos/jollibee_img1.jpg"
  186. ]
  187. },
  188. establishmentTime: {
  189. Monday: "7:00 AM - 9:00 PM",
  190. Tuesday: "7:00 AM - 9:00 PM",
  191. Wednesday: "7:00 AM - 9:00 PM",
  192. Thursday: "7:00 AM - 9:00 PM",
  193. Friday: "7:00 AM - 9:00 PM",
  194. Saturday: "7:00 AM - 9:00 PM",
  195. Sunday: "7:00 AM - 9:00 PM"
  196. }
  197. }
  198.  
  199. insertEstablishment(establishment);
  200.  
  201. var establishment = {
  202. establishment_id: 1,
  203. name: "Jus and Jerry's",
  204. description: "Jus & Jerry’s Food Corp. was founded by identical twin brothers Justin and Jeremy as a small cafeteria-style back in 2010. Their first store was located along Tolentino St., Manila near UST. A year later, they moved to a bigger location in Taft Ave., Manila to cater to more patrons.",
  205. contact: "0923458521",
  206. address: "EGI TAFT TOWER, Unit 112 G/F, 2339 Taft Ave, Malate, Manila, 1004 Metro Manila",
  207. overall_rating: 5,
  208. total_reviews: 1,
  209. imagePaths: {
  210. establishmentPfpPath: "../images/Establishments/Jus and Jerry's/jus-and-jerrys_pfp.png",
  211. establishmentMapPath: "../images/Establishments/Jus and Jerry's/jus-and-jerrys_map.png",
  212. establishmentHeaderPath: "../images/Establishments/Jus and Jerry's/jus-and-jerrys_header.jpg",
  213. establishmentMenuPhotos: [
  214. "../images/Establishments/Jus and Jerry's/photos/jus-and-jerrys_menu1.png"
  215. ],
  216. establishmentFoodPhotos: [
  217. "../images/Establishments/Jollibee/photos/jollibee_img1.jpg"
  218. ]
  219. },
  220. establishmentTime: {
  221. Monday: "10:30 AM - 7:00 PM",
  222. Tuesday: "10:30 AM - 7:00 PM",
  223. Wednesday: "10:30 AM - 7:00 PM",
  224. Thursday: "10:30 AM - 7:00 PM",
  225. Friday: "10:30 AM - 7:00 PM",
  226. Saturday: "10:30 AM - 7:00 PM",
  227. Sunday: "10:30 AM - 7:00 PM"
  228. }
  229. }
  230.  
  231. insertEstablishment(establishment);
  232.  
  233. var establishment = {
  234. establishment_id: 2,
  235. name: "Burger King",
  236. description: "Founded in 1954, Burger King is the second largest fast food hamburger chain in the world. The original Home of the Whopper, our commitment to premium ingredients, signature recipes, and family-friendly dining experiences is what has defined our brand for more than 50 successful years.",
  237. contact: "0948574892",
  238. address: "2/F, Burger King Building, 275, E. Rodriguez Sr. Avenue, Quezon City",
  239. overall_rating: 5,
  240. total_reviews: 1,
  241. imagePaths: {
  242. establishmentPfpPath: "../images/Establishments/Burger King/burger-king_pfp.png",
  243. establishmentMapPath: "../images/Establishments/Burger King/burger-king_map.png",
  244. establishmentHeaderPath: "../images/Establishments/Burger King/burger-king_header.jpg",
  245. establishmentMenuPhotos: [
  246. "../images/Establishments/Burger King/photos/burger-king_menu1.jpg"
  247. ],
  248. establishmentFoodPhotos: [
  249. "../images/Establishments/Burger King/photos/burger-king_img1.png"
  250. ]
  251. },
  252. establishmentTime: {
  253. Monday: "Open 24 Hours",
  254. Tuesday: "Open 24 Hours",
  255. Wednesday: "Open 24 Hours",
  256. Thursday: "Open 24 Hours",
  257. Friday: "Open 24 Hours",
  258. Saturday: "Open 24 Hours",
  259. Sunday: "Open 24 Hours"
  260. }
  261. }
  262.  
  263. insertEstablishment(establishment);
  264.  
  265. var establishment = {
  266. establishment_id: 3,
  267. name: "24 Chicken",
  268. description: "At 24 Chicken, we are obsessed with serving the best possible fried chicken. Serving happiness at a budget friendly price since 2017.",
  269. contact: "09234567964",
  270. address: "24 Chicken P.Noval- Dapitan UST",
  271. overall_rating: 5,
  272. total_reviews: 1,
  273. imagePaths: {
  274. establishmentPfpPath: "../images/Establishments/24 Chicken/24-chicken_pfp.jpg",
  275. establishmentMapPath: "../images/Establishments/24 Chicken/24-chicken_map.png",
  276. establishmentHeaderPath: "../images/Establishments/24 Chicken/24-chicken_header.jpg",
  277. establishmentMenuPhotos: [
  278. "../images/Establishments/24 Chicken/photos/24-chicken_menu1.jpg"
  279. ],
  280. establishmentFoodPhotos: [
  281. "../images/Establishments/24 Chicken/photos/24-chicken_img1.jpg"
  282. ]
  283. },
  284. establishmentTime: {
  285. Monday: "10:00 AM - 9:00 PM",
  286. Tuesday: "10:00 AM - 9:00 PM",
  287. Wednesday: "10:00 AM - 9:00 PM",
  288. Thursday: "10:00 AM - 9:00 PM",
  289. Friday: "10:00 AM - 9:00 PM",
  290. Saturday: "10:00 AM - 9:00 PM",
  291. Sunday: "10:00 AM - 9:00 PM"
  292. }
  293. }
  294.  
  295. insertEstablishment(establishment);
  296.  
  297. var establishment = {
  298. establishment_id: 4,
  299. name: "BonChon",
  300. description: "Crunch out loud! We set out to share the joy of hand-battered, double-fried, crazy crispy Korean Fried Chicken around the world.",
  301. contact: "09294588561",
  302. address: "Alabang Town Center, Muntinlupa",
  303. overall_rating: 5,
  304. total_reviews: 1,
  305. imagePaths: {
  306. establishmentPfpPath: "../images/Establishments/Bonchon/bonchon_pfp.png",
  307. establishmentMapPath: "../images/Establishments/Bonchon/bonchon_map.png",
  308. establishmentHeaderPath: "../images/Establishments/Bonchon/bonchon_header.jpg",
  309. establishmentMenuPhotos: [
  310. "../images/Establishments/Bonchon/photos/bonchon_menu1.jpg"
  311. ],
  312. establishmentFoodPhotos: [
  313. "../images/Establishments/Bonchon/photos/bonchon_img1.jpg"
  314. ]
  315. },
  316. establishmentTime: {
  317. Monday: "11:00 AM - 9:00 PM",
  318. Tuesday: "11:00 AM - 9:00 PM",
  319. Wednesday: "11:00 AM - 9:00 PM",
  320. Thursday: "11:00 AM - 9:00 PM",
  321. Friday: "11:00 AM - 9:00 PM",
  322. Saturday: "10:00 AM - 10:00 PM",
  323. Sunday: "10:00 AM - 9:00 PM"
  324. }
  325. }
  326.  
  327. insertEstablishment(establishment);
  328.  
  329. /* insert 5 reviews */
  330. /* for the demo there would be 1 review each coming from the visitor accounts */
  331. var review = {
  332. review_id: 0,
  333. username: "randomuser1",
  334. establishment_id: 0,
  335. title: "BURGER STEAK IS THE BEST!",
  336. body_desc: "I really like the burger steak in this restaurant ever since I was a kid.",
  337. date: "2017-10-05",
  338. edited: false,
  339. rating: 5,
  340. votes: {
  341. numVotes: 0,
  342. numDownVotes: 0,
  343. upvotes: [],
  344. downvotes: []
  345. },
  346. };
  347.  
  348. insertReview(review);
  349.  
  350. var review = {
  351. review_id: 1,
  352. username: "randomuser1",
  353. establishment_id: 1,
  354. title: "Chicken Chops are the best!",
  355. body_desc: "I really like the chicken chops with the garlicky soy garlic flavor 5 out 5 would recommend!",
  356. date: "2017-10-27",
  357. edited: false,
  358. rating: 0,
  359. votes: {
  360. numVotes: 0,
  361. numDownVotes: 0,
  362. upvotes: [],
  363. downvotes: []
  364. },
  365. };
  366.  
  367. insertReview(review);
  368.  
  369. var review = {
  370. review_id: 2,
  371. username: "randomuser2",
  372. establishment_id: 2,
  373. title: "WHOPPER IS THE BEST!",
  374. body_desc: "I really like ordering from this restaurant when I'm craving for a good burger.",
  375. date: "2017-10-11",
  376. edited: false,
  377. rating: 0,
  378. votes: {
  379. numVotes: 0,
  380. numDownVotes: 0,
  381. upvotes: [],
  382. downvotes: []
  383. },
  384. };
  385.  
  386. insertReview(review);
  387.  
  388. var review = {
  389. review_id: 3,
  390. username: "randomuser2",
  391. establishment_id: 3,
  392. title: "Sulit na masarap pa",
  393. body_desc: "Nagustuhan ko yung chicken nila kasi malaki yung serving tapos masarap pa yung lasa.",
  394. date: "2017-10-23",
  395. edited: false,
  396. rating: 0,
  397. votes: {
  398. numVotes: 0,
  399. numDownVotes: 0,
  400. upvotes: [],
  401. downvotes: []
  402. },
  403. };
  404.  
  405. insertReview(review);
  406.  
  407. var review = {
  408. review_id: 4,
  409. username: "randomuser2",
  410. establishment_id: 4,
  411. title: "Bulgogi is good",
  412. body_desc: "I tried the bulgogi once as well as the korean chicken, it was really good and I would recommend it to anyone!",
  413. date: "2017-10-04",
  414. edited: false,
  415. rating: 0,
  416. votes: {
  417. numVotes: 0,
  418. numDownVotes: 0,
  419. upvotes: [],
  420. downvotes: []
  421. },
  422. };
  423.  
  424. insertReview(review);
  425.  
  426.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!