Skip to content

Commit dc3f616

Browse files
jsesanchezjsesanchez
committed
Se da estructura
1 parent 8c1f9ef commit dc3f616

4 files changed

Lines changed: 103 additions & 93 deletions

File tree

‎DB_Connection/connection.js‎

Lines changed: 16 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,16 @@
1+
//MYSQL Config
2+
const mysql = require('mysql')
3+
4+
module.exports = () =>
5+
mysql.createConnection(
6+
{
7+
host : 'localhost',
8+
port : '3306',
9+
user : 'root',
10+
password : 'password',
11+
database : 'db'
12+
},
13+
'single'
14+
)
15+
16+

‎app.js‎

Lines changed: 5 additions & 93 deletions
Original file line numberDiff line numberDiff line change
@@ -1,105 +1,17 @@
11
const express = require('express');
2-
const mysql = require('mysql');
32
const bodyParser = require('body-parser');
43

54
const PORT = process.env.PORT || 3050;
65
const app = express();
76

87
app.use(bodyParser.json());
98

10-
//MYSQL Config
9+
//Routes
10+
app.use(require('./src/routes/index'));
1111

12-
var connection = mysql.createConnection({
13-
host : 'localhost',
14-
port : '3306',
15-
user : 'root',
16-
password : 'password',
17-
database : 'db'
18-
});
19-
20-
21-
// Route
22-
app.get('/',(req,res)=>{
23-
res.send('Welcometo my API');
24-
});
25-
26-
//Listar
27-
28-
app.get('/location',(req,res)=>{
29-
const sql = 'SELECT * FROM location';
30-
connection.query(sql,(error, results)=>{
31-
if(error) throw error;
32-
if(results.length >0) {
33-
res.json(results);
34-
}else{
35-
res.send("No Location");
36-
}
37-
});
38-
});
39-
40-
//Listar ID
41-
42-
app.get('/location/:id',(req,res)=>{
43-
const {id }=req.params;
44-
const sql = `SELECT * FROM location WHERE id = ${id}`;
45-
connection.query(sql,(error, result)=>{
46-
if(error) throw error;
47-
if(result.length >0) {
48-
res.json(result);
49-
}else{
50-
res.send("Location doesnt exist");
51-
}
52-
});
53-
});
54-
55-
//Agregar
56-
57-
app.post('/location',(req,res)=>{
58-
const sql = 'INSERT INTO location SET ?';
59-
60-
const locationObj = {
61-
name: req.body.name,
62-
area_m2: req.body.area_m2
63-
};
64-
65-
connection.query(sql,locationObj,(error,result)=>{
66-
if(error) throw error;
67-
res.send("OK");
68-
});
12+
//ErrorHandler
13+
app.use((err, req, res, next)=>{
14+
res.send({error: err.message});
6915
});
7016

71-
72-
//editar
73-
74-
app.put('/location/:id',(req,res)=>{
75-
const {id } = req.params;
76-
const{name, area_m2} = req.body;
77-
const sql =`UPDATE location SET name = '${name}', area_m2 ='${area_m2}' WHERE id='${id}'`;
78-
79-
connection.query(sql,error=>{
80-
if(error) throw error;
81-
res.send("OK UPDATE");
82-
});
83-
84-
});
85-
86-
//eliminar
87-
88-
app.delete('/location/:id',(req,res)=>{
89-
const {id }=req.params;
90-
const sql = `DELETE FROM location WHERE id = ${id}`;
91-
connection.query(sql,(error, result)=>{
92-
if(error) throw error;
93-
res.send("OK DELETE");
94-
});
95-
});
96-
97-
98-
99-
//Check conn
100-
connection.connect(error =>{
101-
if(error) throw error;
102-
console.log('DB running');
103-
});
104-
10517
app.listen(PORT, ()=>{console.log(`Server running on port ${PORT}`)});

‎src/controller/ControllerAPI.js‎

Lines changed: 70 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,70 @@
1+
const connection = require('../../DB_Connection/connection');
2+
const conn =connection();
3+
4+
5+
const controller = {};
6+
7+
controller.ListarAll = (req,res) => {
8+
const sql = 'SELECT * FROM location';
9+
conn.query(sql,(error, results)=>{
10+
if(error) throw error;
11+
if(results.length >0) {
12+
res.json(results);
13+
}else{
14+
res.send("No Location");
15+
}
16+
});
17+
}
18+
19+
20+
controller.ListarID = (req,res) => {
21+
const {id} = req.params;
22+
const sql = `SELECT * FROM location WHERE id='${id}'`;
23+
console.log(id);
24+
console.log(sql);
25+
conn.query(sql,(error, results)=>{
26+
if(error) throw error;
27+
if(results.length >0) {
28+
res.json(results);
29+
}else{
30+
res.send("No Location ID");
31+
}
32+
});
33+
}
34+
35+
controller.add = (req,res) =>{
36+
const sql = 'INSERT INTO location SET ?';
37+
const locationObj = {
38+
name: req.body.name,
39+
area_m2: req.body.area_m2
40+
};
41+
conn.query(sql,locationObj,(error,result)=>{
42+
if(error) throw error;
43+
res.send("OK");
44+
});
45+
}
46+
47+
48+
controller.update = (req,res) =>{
49+
const {id}=req.params;
50+
const{name, area_m2} = req.body;
51+
const sql =`UPDATE location SET name = '${name}', area_m2 ='${area_m2}' WHERE id='${id}'`;
52+
conn.query(sql,error=>{
53+
if(error) throw error;
54+
res.send("OK UPDATE");
55+
});
56+
}
57+
58+
controller.delete = (req,res) =>{
59+
const {id}=req.params;
60+
const sql = `DELETE FROM location WHERE id = '${id}'`;
61+
console.log(id);
62+
console.log(sql);
63+
conn.query(sql,(error, result)=>{
64+
if(error) throw error;
65+
res.send("OK DELETE");
66+
});
67+
}
68+
69+
70+
module.exports =controller;

‎src/routes/index.js‎

Lines changed: 12 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,12 @@
1+
const express = require('express');
2+
const router = express.Router();
3+
const controller = require('../controller/ControllerAPI');
4+
5+
router.get('/location',controller.ListarAll);
6+
router.post('/location',controller.add);
7+
router.put('/location/:id',controller.update);
8+
router.delete('/location/:id',controller.delete);
9+
router.get('/location/:id',controller.ListarID);
10+
11+
12+
module.exports = router;

0 commit comments

Comments
 (0)