-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathindex.js
executable file
·59 lines (50 loc) · 1.71 KB
/
index.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
var express = require('express');
var app = express();
var mysql = require('mysql');
var bodyParser = require("body-parser");
var con= mysql.createConnection({
host: "appinfo.mysql.database.azure.com",
user: "appinfo@appinfo",
password: "Plkj@1234",
database: "appinfo"
});
con.connect(function(err) {
if (err) throw err;
console.log("Connected!");
});
app.use(bodyParser.urlencoded({ extended: false }));
app.get('/', function (req, res) {
// res.send('<html><body><h1>Hello World</h1></body></html>');
res.sendFile(__dirname + '/index.html');
});
app.get('/login', function (req, res) {
// res.send('<html><body><h1>Hello World</h1></body></html>');
res.sendFile(__dirname + '/index.html');
});
app.get('/getdata', function (req, res) {
var URL="";
var sql = "select * from appinfo where bundleId="+req.query.appId+" order by primy_key desc";
con.query(sql,function (result,fields,URL) {
URL="{\"appId\":\""+fields[0].bundleId+"\",\"url\":\""+fields[0].address +"\",\"status\":\""+fields[0].status+"\"}";
res.send(URL);
});
});
app.post('/submit-data', function (req, res) {
var status=req.body.status;
var URL= req.body.url;
var bundle= req.body.bundle;
var sql = "INSERT INTO appinfo (status,address,bundleId) VALUES ('"+status+"','"+URL+"','"+bundle+"')";
con.query(sql, function (err, result) {
if (err) throw err; console.log("1 record inserted");
});
res.send('Your request has been completed successfully');
});
app.put('/update-data', function (req, res) {
res.send('PUT Request');
});
app.delete('/delete-data', function (req, res) {
res.send('DELETE Request');
});
var server = app.listen(8080, function () {
console.log('Node server is running..');
});