-
Notifications
You must be signed in to change notification settings - Fork 0
/
express.js
66 lines (52 loc) · 2.09 KB
/
express.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
var express=require('express'),
mysql=require('mysql'),
credentials=require('./credentials.json'),
app = express(),
port = process.env.PORT || 1337;
credentials.host='ids.morris.umn.edu'; //setup database credentials
var connection = mysql.createConnection(credentials); // setup the connection
connection.connect(function(err){if(err){console.log(error)}});
app.use(express.static(__dirname + '/public'));
app.get("/buttons",function(req,res){
var sql = 'SELECT * FROM ironman.till_buttons';
connection.query(sql,(function(res){return function(err,rows,fields){
if(err){console.log("We have an error:");
console.log(err);}
for(var index in rows) {
button = rows[index];
button.left = button.left_position;
delete button.left_position;
}
res.send(rows);
}})(res));
});
app.get("/list",function(req,res){
var sql = 'SELECT * FROM ironman.current_transaction where amount > 0';
connection.query(sql,(function(res){return function(err,rows,fields){
if(err){console.log("We have an error:");
console.log(err);}
res.send(rows);
}})(res));
});
app.get("/click",function(req,res){
var id = req.query['id'];
var sql = 'update ironman.current_transaction set amount = amount + 1, cost = cost + price where ID = ' + id;
//console.log("Attempting sql ->"+sql+"<-");
connection.query(sql,(function(res){return function(err,rows,fields){
if(err){console.log("We have an insertion error:");
console.log(err);}
res.send(err); // Let the upstream guy know how it went
}})(res));
});
// Your other API handlers go here!
app.get("/deleteRow",function (req,res) {
var id = req.query['id'];
var sql = 'update ironman.current_transaction set amount = 0, cost = 0 where ID = ' +id;
//console.log("Attempting sql ->"+sql+"<-");
connection.query(sql,(function(res){return function(err,rows,fields){
if(err){console.log("We have a deletion error:");
console.log(err);}
res.send(err); // Let the upstream guy know how it went
}})(res));
});
app.listen(port);