-
Notifications
You must be signed in to change notification settings - Fork 2
/
parsing.js
52 lines (43 loc) · 1.17 KB
/
parsing.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
//Parse data from JSON POST and insert into MYSQL
var express = require('express');
var app = express();
var path = require('path');
var bodyParser = require('body-parser');
var mysql = require('mysql');
// Configure MySQL connection
var connection = mysql.createConnection({
host: 'localhost',
user: 'root',
password: 'root',
database: 'HSC_Lib'
})
//Establish MySQL connection
connection.connect(function(err) {
if (err)
throw err
else {
console.log('Connected to MySQL');
// Start the app when connection is ready
app.listen(3000);
console.log('Server listening on port 3000');
}
});
app.use(bodyParser.json())
app.get('/', function(req, res) {
res.sendFile(path.join(__dirname+ '/myfile.html'));
});
app.post('/', function(req, res) {
var jsondata = req.body;
var values = [];
for(var i=0; i< jsondata.length; i++)
values.push([jsondata[i].name,jsondata[i].age]);
//Bulk insert using nested array [ [a,b],[c,d] ] will be flattened to (a,b),(c,d)
connection.query('INSERT INTO members (name, age) VALUES ?', [values], function(err,result) {
if(err) {
res.send('Error');
}
else {
res.send('Success');
}
});
});