-
-
Save parzibyte/b3645b8153357f2996be73ef0101c90f to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
const conexion = require("../conexion") | |
module.exports = { | |
insertar(nombre, precio) { | |
return new Promise((resolve, reject) => { | |
conexion.query(`insert into productos | |
(nombre, precio) | |
values | |
(?, ?)`, | |
[nombre, precio], (err, resultados) => { | |
if (err) reject(err); | |
else resolve(resultados.insertId); | |
}); | |
}); | |
}, | |
obtener() { | |
return new Promise((resolve, reject) => { | |
conexion.query(`select id, nombre, precio from productos`, | |
(err, resultados) => { | |
if (err) reject(err); | |
else resolve(resultados); | |
}); | |
}); | |
}, | |
obtenerPorId(id) { | |
return new Promise((resolve, reject) => { | |
conexion.query(`select id, nombre, precio from productos where id = ?`, | |
[id], | |
(err, resultados) => { | |
console.log({resultados}); | |
if (err) reject(err); | |
else resolve(resultados[0]); | |
}); | |
}); | |
}, | |
actualizar(id, nombre, precio) { | |
return new Promise((resolve, reject) => { | |
conexion.query(`update productos | |
set nombre = ?, | |
precio = ? | |
where id = ?`, | |
[nombre, precio, id], | |
(err) => { | |
if (err) reject(err); | |
else resolve(); | |
}); | |
}); | |
}, | |
eliminar(id) { | |
return new Promise((resolve, reject) => { | |
conexion.query(`delete from productos | |
where id = ?`, | |
[id], | |
(err) => { | |
if (err) reject(err); | |
else resolve(); | |
}); | |
}); | |
}, | |
} |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment