-
Notifications
You must be signed in to change notification settings - Fork 0
/
server.js
123 lines (101 loc) · 3.44 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
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
import express from "express"
import sql from "mysql"
import "dotenv/config"
function getSeason() { // remember .getMonth() ranges from 0-11, not 1-12
let now = new Date()
if (now.getMonth() > 9 && now.getMonth() < 3) { // determine Winter
return 0
}else if (now.getMonth() > 8 && now.getMonth() < 10) { // determine Fall
return 1
}else if (now.getMonth() > 3 && now.getMonth() < 6) { // determine Spring
return 2
}else if (now.getMonth() >= 6 && now.getMonth() < 8) { // determine Summer
return 3
}
}
const con = sql.createConnection({
host: process.env.DB_HOST,
user: "will",
password: process.env.DB_PASSWORD,
database: "hive"
})
con.connect()
const app = express()
app.set("view engine", "hbs")
app.use(express.static("views"))
app.use(express.json())
app.get("/hive/", (req, res) => {
if (!req.query.temperature || !req.query.humidity || !req.query.weight) {
res.send("Invalid request")
}else {
let stmt = "INSERT INTO `data` (`temperature`, `humidity`, `weight`, `date`, `time`) VALUES (?, ?, ?, ?, ?)"
let current = new Date()
console.log(req.query.weight)
let date = current.getMonth() + 1 + "/" + current.getDate() + "/" + current.getFullYear()
if (current.getMinutes() < 10) {
let time = current.getHours() + ":0" + current.getMinutes()
con.query(stmt, [req.query.temperature, req.query.humidity, req.query.weight, date, time], (err) => {
if (err) {
console.log(err)
}else {
res.send("Success.")
}
})
}else {
let time = current.getHours() + ":" + current.getMinutes()
con.query(stmt, [req.query.temperature, req.query.humidity, req.query.weight, date, time], (err) => {
if (err) {
console.log(err)
}else {
res.send("Success.")
}
})
}
}
})
app.get("/dashboard", (req, res) => {
con.query("SELECT `temperature`, `humidity`, `weight`, `time` FROM `data` ORDER BY `id` DESC LIMIT 24", (err, result) => {
let temperatures = []
for (let i = 0; i < result.length; i++) {
temperatures.push(result[i])
}
temperatures = temperatures.reverse()
if (getSeason() == 0) { // these temp minimums are very much subject to change
if (temperatures[temperatures.length - 1].temperature > 32) { // fetch last temp reading
var tempstatus = true
}else {
var tempstatus = false
}
}
if (getSeason() == 1) {
if (temperatures[temperatures.length - 1].temperature > 50) {
var tempstatus = true
}else {
var tempstatus = false
}
}
if (getSeason() == 2) {
if (temperatures[temperatures.length - 1].temperature >= 90 && temperatures[temperatures.length - 1].temperature < 100) {
var tempstatus = true
}else {
var tempstatus = false
}
}
if (getSeason() == 3) {
if (temperatures[temperatures.length - 1].temperature >= 90 && temperatures[temperatures.length - 1].temperature < 100) {
var tempstatus = true
}else {
var tempstatus = false
}
}
if (temperatures[temperatures.length - 1].humidity >= 50 && temperatures[temperatures.length - 1].humidity <= 60) {
var humiditystatus = true
}else {
var humiditystatus = false
}
res.render("dashboard", {temperatures: temperatures, tempstatus: tempstatus, humiditystatus: humiditystatus})
})
})
app.listen(3000, () => {
console.log("Server is Running!");
})