-
Notifications
You must be signed in to change notification settings - Fork 0
/
server.js
101 lines (88 loc) · 2.72 KB
/
server.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
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
// server.js
"use strict";
// init project (using Express)
const express = require("express");
const apiRoutes = require("./routes/api.js");
const bodyParser = require("body-parser");
// init Sass compiler.
const compileSass = require("express-compile-sass");
// add more packages
const fs = require("fs");
const moment = require("moment");
const mdq = require("mongo-date-query");
const json2csv = require("json2csv").parse;
const path = require("path");
const fields = ["datapoints"];
// MongoDB conecttion using Mongoose
const mongoose = require("mongoose");
const mongo = require("mongodb");
const config = {
useNewUrlParser: true,
useFindAndModify: false,
useCreateIndex: true
};
// Room Schema
const Room = require("./models/Room");
// iinit App and it's bodyParse
const app = express();
app.use(bodyParser.json());
app.use(bodyParser.urlencoded({ extended: true }));
// serve all .sass and .scss files in /public as CSS
app.use(
compileSass({
root: "public", // directory containing files to compile
sourceMap: true, // includes base64 encoded source maps in output css
sourceComments: true, // includes source comments in output css
watchFiles: true, // watch sass files and update mtime on main files for each change
logToConsole: true // whether or not to log errors to the console
})
);
// serve from public
app.use("/public", express.static(process.cwd() + "/public"));
// serve index page
app.get("/", (request, response) => {
response.sendFile(__dirname + "/views/index.html");
});
//404 Not Found Middleware
app.use(function(req, res, next) {
res.status(404).sendFile(__dirname + "/views/404.html");
});
// Routing of the app
apiRoutes(app);
// Download info from the api
app.post("/api/download/BjpgUJTT", function(req, res) {
Room.find({ _id: "BjpgUJTT" }, function(err, room) {
if (err) {
return res.status(500).json({ err });
} else {
let csv;
try {
csv = json2csv(room, { fields });
} catch (err) {
return res.status(500).json({ err });
}
const dateTime = moment().format("YYYYMMDDhhmmss");
const filePath = path.join(
__dirname,
"..",
"public",
"exports",
"csv-" + dateTime + ".csv"
);
fs.writeFile(filePath, csv, function(err) {
if (err) {
return res.json(err).status(500);
} else {
setTimeout(function() {
fs.unlinkSync(filePath); // delete this file after 30 seconds
}, 30000);
return res.json("/exports/csv-" + dateTime + ".csv");
}
});
}
});
});
// listen for requests
const listener = app.listen(process.env.PORT, () => {
console.log(`Your app is listening on port ${listener.address().port}`);
});