Since REPLACE INTO inserts when the ID passed in does not exist, there's no need to have separate INSERT INTO functions
Every controller-model pair should combine PUT & POST verbs into one function.
Process
Delete INSERT INTO function in each model, renaming REPLACE INTO function
Do something like this: const { id = null } = req.params in order to get the id out, giving it a default value of null if req.params.id does not exist (which will happen when someone is POSTing)
Hook up PUT & POST routes to newly combined controller functions
[x] computers
[x] customers
[x] payment options
[x] training programs
[x] employees
[x] products
[x] orders
[x] departments
[x] product types
Take a look at routes/products/productTypes.js, controllers/products/productTypesCtrl.js & models/products/ProductTypesModel.js
Context
REPLACE INTOinserts when theIDpassed in does not exist, there's no need to have separateINSERT INTOfunctionsPUT&POSTverbs into one function.Process
INSERT INTOfunction in each model, renamingREPLACE INTOfunctionconst { id = null } = req.paramsin order to get the id out, giving it a default value ofnullifreq.params.iddoes not exist (which will happen when someone isPOSTing)PUT&POSTroutes to newly combined controller functionsTake a look at
routes/products/productTypes.js,controllers/products/productTypesCtrl.js&models/products/ProductTypesModel.jsExpected Result
PUT&POSTshould continue to work as expected