/
app.js
53 lines (43 loc) · 1.32 KB
/
app.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
/**
* Tableau Write Back Extension // MSSQL
*
* @version 1.0
* @author Andre de Vries, https://github.com/andre347/
* @link https://theinformationlab.co.uk
*
*/
// set up server
const express = require("express");
const app = express();
const bodyParser = require("body-parser");
const sql = require("mssql");
const port = 3000;
let pool;
//get helper files
let helpersPost = require("./helpers/indexPost");
let helpersGet = require("./helpers/indexGet");
//set up middleware
app.use(bodyParser.urlencoded({ extended: true }));
app.use(express.static(__dirname + "/public"));
app.use(express.static(__dirname + "/views"));
app.engine("html", require("ejs").renderFile);
app.use(bodyParser.json());
//first route to notify user to go to login page
app.get("/", helpersGet.root);
//extension
app.get("/extension", helpersGet.extension);
//about page
app.get("/about", helpersGet.about);
// get and post login page
app.get("/login", helpersGet.login);
//tableau data
app.get("/tableau", helpersGet.tableauData);
app.post("/tableau", helpersPost.tableauData);
//get write back form and post data
app.get("/writeData", helpersGet.renderData);
app.post("/writeData", helpersPost.writeData);
app.post("/getData", helpersPost.getData);
//start the server
app.listen(port, function() {
console.log("Our server is running on " + port);
});