-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathapp.js
More file actions
39 lines (33 loc) · 1.04 KB
/
app.js
File metadata and controls
39 lines (33 loc) · 1.04 KB
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
const fastify = require('fastify')
const mysql = require('mysql')
const app = fastify({ logger: true });
app.register(require('fastify-cors'), {})
app.register(require('fastify-xml-body-parser'), {})
const conn = mysql.createConnection({
host: 'localhost',
port: '6033',
user: 'root',
password: 'my_secret_password',
database: 'mydb'
})
conn.connect(err => {
if (err) {
return console.error("Ошибка: " + err.message);;
} else {
console.log("Подключение к серверу MySQL успешно установлено");
}
})
app.listen(8000, () => { console.log('app str...'); })
let dbData;
conn.query('SELECT * FROM ToDoList', (err, result, field) => {
dbData = result
})
app.get('/', (req, res) => {
res.send(dbData)
})
app.post('/', (req, res) => {
let data = [req.body.id, req.body.task, req.body.isDone]
conn.query('INSERT INTO `ToDoList`(`id`, `task`, `isDone`) VALUES (?,?,?)', data, (err, results, fields) => {
!err ? res.json(results) : res.json(err)
})
})