DB errors

[bingxueshuang]

Please check for database errors on edge cases and general cases. Errors are not at all handled, so please comment with error name and url, values inserted etcetra or a screenshot.

[bingxueshuang]

This is an example error what I'm getting for inserting to inventory something that already exists.

App is listening on port 8080
/home/node_modules/mysql2/promise.js:341
    const localErr = new Error();
                     ^

Error: Duplicate entry '102-new med' for key 'Inventory.PRIMARY'
    at PromisePool.query (/home/node_modules/mysql2/promise.js:341:22)
    at Object.add (file:///home/models/inventory.model.js:55:14)
    at file:///home/routes/inventory.js:86:21
    at Layer.handle [as handle_request] (/home/node_modules/express/lib/router/layer.js:95:5)
    at next (/home/node_modules/express/lib/router/route.js:144:13)
    at file:///home/middlewares/validators/util.js:89:3
    at Layer.handle [as handle_request] (/home/node_modules/express/lib/router/layer.js:95:5)
    at next (/home/node_modules/express/lib/router/route.js:144:13)
    at middleware (/home/node_modules/express-validator/src/middlewares/check.js:16:13) {
  code: 'ER_DUP_ENTRY',
  errno: 1062,
  sql: "INSERT INTO Inventory VALUES ('102', 'new med', '23', '42')",
  sqlState: '23000',
  sqlMessage: "Duplicate entry '102-new med' for key 'Inventory.PRIMARY'"
}