forked from pavansolapure/opencodez-samples
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathproducts.js
More file actions
72 lines (59 loc) · 1.83 KB
/
products.js
File metadata and controls
72 lines (59 loc) · 1.83 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
67
68
69
70
71
72
import express from "express";
import db from "../db/database";
import Product from "../domain/product";
const router = express.Router();
router.get("/", (req, res, next) => {
db.query(Product.getAllProductSQL(), (err, data)=> {
if(!err) {
res.status(200).json({
message:"Products listed.",
productId:data
});
}
});
});
router.post("/add", (req, res, next) => {
//read product information from request
let product = new Product(req.body.prd_name, req.body.prd_price);
db.query(product.getAddProductSQL(), (err, data)=> {
res.status(200).json({
message:"Product added.",
productId: data.insertId
});
});
});
router.get("/:productId", (req, res, next) => {
let pid = req.params.productId;
db.query(Product.getProductByIdSQL(pid), (err, data)=> {
if(!err) {
if(data && data.length > 0) {
res.status(200).json({
message:"Product found.",
product: data
});
} else {
res.status(200).json({
message:"Product Not found."
});
}
}
});
});
router.post("/delete", (req, res, next) => {
var pid = req.body.productId;
db.query(Product.deleteProductByIdSQL(pid), (err, data)=> {
if(!err) {
if(data && data.affectedRows > 0) {
res.status(200).json({
message:`Product deleted with id = ${pid}.`,
affectedRows: data.affectedRows
});
} else {
res.status(200).json({
message:"Product Not found."
});
}
}
});
});
module.exports = router;