-
Notifications
You must be signed in to change notification settings - Fork 0
/
index.js
55 lines (47 loc) · 2.02 KB
/
index.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
'use strict';
var express = require('express');
var router = express.Router();
require('dotenv').config();
var findResult = new Array;
var genreSet = new Set();
var genres = new Array();
var languageSet = new Set();
var languages = new Array();
const populateChoices = async () => {
console.log("Connecting to ", process.env.DB_NAME);
const { MongoClient } = require('mongodb');
const uri = "mongodb+srv://" +
`${process.env.DB_USER}` +
":" +
`${process.env.DB_PASS}` +
"@" +
`${process.env.DB_NAME}` +
"/imdb?authMechanism=SCRAM-SHA-1&keepAlive=true&socketTimeoutMS=360000&connectTimeoutMS=360000";
const client = await MongoClient.connect(uri, {
useNewUrlParser: true,
useUnifiedTopology: true
});
console.log("Connected");
try {
const collection = client.db("imdb").collection("movies");
var genreList = await collection.aggregate([{ $group: { _id: '$genre' } }]).toArray();
var languageList = await collection.aggregate([{ $match: { language: { $exists: true } } },{ $group: { _id: '$language' } }]).toArray();
genreList.forEach(doc => doc["_id"].split(",").forEach(dic => genreSet.add(dic.trim())));
languageList.forEach(doc => doc["_id"].split(",").forEach(dic => languageSet.add(dic.trim())));
genres = Array.from(genreSet).sort();
languages = Array.from(languageSet).sort();
module.exports.genresExported = genres;
module.exports.languagesExported = languages;
} catch (e) {
console.error(e);
}
finally {
await client.close();
}
};
/* GET home page. */
router.get('/', async function (req, res) {
await populateChoices();
res.render('index', { pagetitle: 'iMovieDB', movies: findResult, genres: genres, genreSelected: req.body.genre, languages: languages, languageSelected: req.body.language, title: req.body.title, year: parseInt(req.body.year), duration: parseInt(req.body.duration), rating: Number(req.body.rating) });
});
module.exports = router;