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
|
const express = require("express");
const cors = require("cors");
const cookieParser = require("cookie-parser");
const flash = require("connect-flash");
const expressSession = require("express-session");
const mysql = require("mysql2");
const app = express();
const port = process.env.PORT || 3000;
const connectionURL = process.env.DATABASE_URL;
const cron = require("node-cron");
const wildcardSubdomains = require("wildcard-subdomains");
const subdomain = require("express-subdomain");
require("dotenv").config();
// Middleware
app.use(cors());
app.use(express.json());
app.use(cookieParser());
app.use(express.urlencoded({ extended: true }));
app.use(
expressSession({
cookie: { maxAge: 30 * 24 * 60 * 60 * 1000 },
secret: process.env.AUTHORIZATION_STRING,
})
);
app.use(flash());
app.use(
wildcardSubdomains({
namespace: "_profile",
whitelist: ["www", "api"],
})
);
app.use(subdomain("screenshot.api", require("./routes/api/public/screenshot.js")));
app.use(subdomain("api", require("./routes/api")));
// Set Template Engine
app.set("view engine", "ejs");
// Set public folder
app.use(express.static(__dirname + "/public"));
// set views folder
app.set("views", __dirname + "/views");
// Routes
app.use("/", require("./routes"));
// Run a cron job every 6 days to connect to the database - so that the database does not sleep
cron.schedule("0 0 */6 * *", () => {
console.log("Cron job running");
const connection = mysql.createConnection(connectionURL);
connection.connect();
connection.query("SELECT 1", (err, results, fields) => {
if (err) {
console.log(err);
} else {
console.log("Database connected");
}
});
connection.end();
});
// Start server
app.listen(port, () => {
console.log(`Server started on port ${port}`);
});
|
