v2/models/deliveries.js - Code Metrics - Inspection of "Finished with mega migration to version handling o..." - emilfolino/order_api - Measure and Improve Code Quality continuously with Scrutinizer

Test Failed

Push — master ( 853a48...344ee9 )

by Emil

created 2019-02-22 14:48 UTC

v2/models/deliveries.js A

↳ Parent: Project

Complexity

Total Complexity	13
Complexity/F	1.63

Size

Lines of Code	104
Function Count	8

Duplication

Duplicated Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
cc	0
eloc	68
nc	1
dl	0
loc	104
rs	10
c	0
b	0
f	0
wmc	13
mnd	2
bc	14
fnc	8
bpm	1.75
cpm	1.625
noi	4

4 Functions

Rating	Name	Size	Complexity
A	deliveries.addDelivery	25	1
A	deliveries.getDeliveries	16	1
A	deliveries.deleteDelivery	30	2
A	deliveries.getDelivery	20	1

const db = require("../db/database.js");

const deliveries = {
    sql: "SELECT ROWID as id, productId as product_id, amount," +
                    " deliveryDate as delivery_date, comment" +
                    " FROM deliveries WHERE apiKey = ?",

    getDeliveries: function(res, apiKey) {
        db.all(deliveries.sql, apiKey, (err, rows) => {
            if (err) {
                return res.status(500).json({
                    errors: {
                        status: 500,
                        source: "/deliveries",
                        title: "Database error",
                        detail: err.message
                    }
                });
            }

            res.json({ data: rows });

        });
    },

    getDelivery: function(res, deliveryId, apiKey, status=200) {
        db.get(
            deliveries.sql + " AND ROWID = ?",
            apiKey,
            deliveryId,
            function(err, row) {
                if (err) {
                    return res.status(500).json({
                        errors: {
                            status: 500,
                            source: "/deliveries",
                            title: "Database error",
                            detail: err.message
                        }
                    });
                }

                res.status(status).json({ data: row });

            });
    },

    addDelivery: function(res, body) {
        const sql = "INSERT INTO deliveries (productId, amount, deliveryDate," +
                        " comment, apiKey) VALUES (?, ?, ?, ?, ?)";

        db.run(sql,
            body.product_id,
            body.amount,
            body.delivery_date,
            body.comment,
            body.api_key,
            function(err) {
                if (err) {
                    return res.status(500).json({
                        errors: {
                            status: 500,
                            source: "/delivery",
                            title: "Database error",
                            detail: err.message
                        }
                    });
                }

                deliveries.getDelivery(res, this.lastID, body.api_key, 201);

            });
    },

    deleteDelivery: function(res, body) {
        if (Number.isInteger(parseInt(body.id))) {
            const sql = "DELETE FROM deliveries WHERE apiKey = ? AND ROWID = ?";

            db.run(sql,
                body.api_key,
                body.id, (err) => {
                    if (err) {
                        return res.status(500).json({
                            errors: {
                                status: 500,
                                source: "/orders",
                                title: "Database error",
                                detail: err.message
                            }
                        });
                    }

                    res.status(204).send();

                });
        } else {
            res.status(400).json({
                errors: {
                    status: 400,
                    detail: "Required attribute delivery id (id)" +
                        " was not included in the request."
                }
            });
        }
    }
};

module.exports = deliveries;


1			const db = require("../db/database.js");
2
3			const deliveries = {
4			sql: "SELECT ROWID as id, productId as product_id, amount," +
5			" deliveryDate as delivery_date, comment" +
6			" FROM deliveries WHERE apiKey = ?",
7
8			getDeliveries: function(res, apiKey) {
9			db.all(deliveries.sql, apiKey, (err, rows) => {
10			if (err) {
11			return res.status(500).json({
12			errors: {
13			status: 500,
14			source: "/deliveries",
15			title: "Database error",
16			detail: err.message
17			}
18			});
19			}
20
21			res.json({ data: rows });
			0 ignored issues – show Best Practice introduced 2019-02-22 14:50 UTC by Report Bug Copy Issue Report There is no `return` statement in this branch, but you do return something in other branches. Did you maybe miss it? If you do not want to return anything, consider adding `return undefined;` explicitly. Loading history...
22			});
23			},
24
25			getDelivery: function(res, deliveryId, apiKey, status=200) {
26			db.get(
27			deliveries.sql + " AND ROWID = ?",
28			apiKey,
29			deliveryId,
30			function(err, row) {
31			if (err) {
32			return res.status(500).json({
33			errors: {
34			status: 500,
35			source: "/deliveries",
36			title: "Database error",
37			detail: err.message
38			}
39			});
40			}
41
42			res.status(status).json({ data: row });
			0 ignored issues – show Best Practice introduced 2019-02-22 14:50 UTC by Report Bug Copy Issue Report There is no `return` statement in this branch, but you do return something in other branches. Did you maybe miss it? If you do not want to return anything, consider adding `return undefined;` explicitly. Loading history...
43			});
44			},
45
46			addDelivery: function(res, body) {
47			const sql = "INSERT INTO deliveries (productId, amount, deliveryDate," +
48			" comment, apiKey) VALUES (?, ?, ?, ?, ?)";
49
50			db.run(sql,
51			body.product_id,
52			body.amount,
53			body.delivery_date,
54			body.comment,
55			body.api_key,
56			function(err) {
57			if (err) {
58			return res.status(500).json({
59			errors: {
60			status: 500,
61			source: "/delivery",
62			title: "Database error",
63			detail: err.message
64			}
65			});
66			}
67
68			deliveries.getDelivery(res, this.lastID, body.api_key, 201);
			0 ignored issues – show Best Practice introduced 2019-02-13 09:10 UTC by Report Bug Copy Issue Report There is no `return` statement in this branch, but you do return something in other branches. Did you maybe miss it? If you do not want to return anything, consider adding `return undefined;` explicitly. Loading history...
69			});
70			},
71
72			deleteDelivery: function(res, body) {
73			if (Number.isInteger(parseInt(body.id))) {
74			const sql = "DELETE FROM deliveries WHERE apiKey = ? AND ROWID = ?";
75
76			db.run(sql,
77			body.api_key,
78			body.id, (err) => {
79			if (err) {
80			return res.status(500).json({
81			errors: {
82			status: 500,
83			source: "/orders",
84			title: "Database error",
85			detail: err.message
86			}
87			});
88			}
89
90			res.status(204).send();
			0 ignored issues – show Best Practice introduced 2019-02-13 09:10 UTC by Report Bug Copy Issue Report There is no `return` statement in this branch, but you do return something in other branches. Did you maybe miss it? If you do not want to return anything, consider adding `return undefined;` explicitly. Loading history...
91			});
92			} else {
93			res.status(400).json({
94			errors: {
95			status: 400,
96			detail: "Required attribute delivery id (id)" +
97			" was not included in the request."
98			}
99			});
100			}
101			}
102			};
103
104			module.exports = deliveries;
105

emilfolino / order_api

Push — master ( 853a48...344ee9 )

v2/models/deliveries.js A

Complexity

Size

Duplication

Importance

4 Functions

Duplication Side-by-Side

Filter issues like