-
Notifications
You must be signed in to change notification settings - Fork 0
/
server.js
105 lines (85 loc) · 2.51 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
var express = require('express')
var mysql = require('mysql')
var bodyParser = require('body-parser')
var app = express()
app.use(bodyParser.json())
var con = mysql.createConnection({
host: "localhost",
user: "root",
password: "root",
database: "iotdb"
})
con.connect(function(err) {
if (err) throw err
console.log("Connected!")
})
app.get('/', function (req, res) {
res.send('Hello Here')
})
/*** ADD ***/
app.get('/addTemp', function (req, res) {
var query = con.query("INSERT INTO temperatures (value) VALUES ("+req.query.value+")", function(err, rows)
{
if (err)
console.log("Error inserting : %s ",err );
else
res.json({msg:"inserted successfully"})
});
})
/*** GET ALL ***/
app.get('/getAll', function (req, res) {
var query = con.query('SELECT * FROM temperatures',function(err,rows)
{
if(err)
console.log("Error Selecting : %s ",err );
else
res.json({rows})
});
})
/*** GET By Id ***/
app.get('/getById', function (req, res) {
var query = con.query('SELECT value FROM temperatures WHERE id='+req.query.id,function(err,result,rows)
{
if(err)
console.log("Error Selecting : %s ",err );
else
res.json(result[0].value)
});
})
/*** GET By Value ***/
app.get('/getByValue', function (req, res) {
var query = con.query('SELECT * FROM temperatures WHERE value='+req.query.value,function(err,result,rows)
{
if(err)
console.log("Error Selecting : %s ",err );
else
res.json({Result:rows})
});
})
/*** DELETE ***/
app.get('/delete', function (req, res) {
var query = con.query("DELETE FROM temperatures WHERE id = "+req.query.id, function(err, rows)
{
if(err)
console.log("Error deleting : %s ",err );
else
res.json({Result:"deleted"})
});
})
/*** UPDATE ***/
app.get('/update', function (req, res) {
var query = con.query("UPDATE temperatures set value="+req.query.value+" WHERE id ="+ req.query.id, function(err, rows)
{
if (err)
console.log("Error Updating : %s ",err );
else
res.json({Result:"updated"})
});
})
// Port Number
const port = 4300;
// server address
const address = '172.16.220.137';
app.listen(port, address, () => {
console.log('Server started on address '+address+' and on port '+port);
});