-
Notifications
You must be signed in to change notification settings - Fork 0
/
index.js
73 lines (65 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
60
61
62
63
64
65
66
67
68
69
70
71
72
73
const mysql = require('mysql');
const express = require('express');
var app = express();
const bodyparser = require('body-parser');
app.use(bodyparser.json())
var mysqlConnection = mysql.createConnection({
host: 'localhost',
port: 3306,
user: 'root',
password: 'GrantS',
database: 'cowDB',
multipleStatements: true
});
mysqlConnection.connect((err) => {
if (!err) {
console.log('DB connection succeeded')
} else {
console.log('DB connection failed error: ' + JSON.stringify(err));
}
});
app.listen(3000,()=>console.log('Express server is running at port 3000'));
//get all cows
app.get('/cows', (req, res)=> {
mysqlConnection.query('SELECT * FROM cows', (err, rows, fields) => {
if(!err) {
console.log(rows);
res.send(rows)
} else {
console.log(err);
}
})
})
//get cow by name
app.get('/cows/:name', (req, res)=> {
mysqlConnection.query('SELECT * FROM cows WHERE name = ?', [req.params.name], (err, rows, fields) => {
if(!err) {
console.log(rows);
res.send(rows)
} else {
console.log(err);
}
})
})
app.delete('/cows/:name', (req, res)=> {
mysqlConnection.query('DELETE FROM cows WHERE name = ?', [req.params.name], (err, rows, fields) => {
if(!err) {
console.log(rows);
res.send('Deleted successfully');
} else {
console.log(err);
}
})
})
app.post('/cows', (req, res)=> {
let cow = req.body;
var sql = "SET @cowID = ?; SET @name = ?; SET @description = ?; CALL new_cow(@cowID, @name, @description);";
mysqlConnection.query(sql,[cow.cowID, cow.name, cow.description], (err, rows, fields) => {
if(!err) {
console.log(rows);
res.send(rows);
} else {
console.log(err);
}
})
})