Repository navigation
Expand file tree
/
Copy patharticleController.js
More file actions
66 lines (52 loc) · 1.47 KB
/
Copy patharticleController.js
File metadata and controls
66 lines (52 loc) · 1.47 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
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
import express from 'express';
import connections from '../database/connections.js';
const connection = connections()
class ArticleController{
index = async(req, res)=>{
await connection.query(`USE noticiasblog`);
await connection.query(`
SELECT * FROM noticias
`, (error, result, fields)=>{
console.log(result);
console.log(fields);
if(error) throw error;
res.json(result);
})
}
create = async (req, res)=>{
const {
id,
title,
body
} = req.body;
console.log(req.body)
await connection.query(`USE noticiasblog`);
await connection.query(`
INSERT INTO noticias(
id,
title,
body,
posted
)VALUES(
default, '${title}', '${body}', default
)
`,(error, result, fields)=>{
if(error) throw error
console.log('Dados cadastrados com sucesso: '+ result);
console.log(fields);
res.send().status()
})
};
remove = async (req, res)=>{
const {id} = req.query;
await connection.query(`
DELETE FROM noticias WHERE id = ${id}
`,(err)=>{
if(err){
console.log(err)
}
res.send().status();
})
}
}
export default ArticleController;