Stored Procedure for node.js
User.createuser = (req, result) => {
sql.query("INSERT INTO Users SET ?", req, (err, res) => {
if (err) {
console.log("error: ", err);
result(err, null);
return;
}
// if (await User.findOne({ where: { username: req.body.username } })) {
// throw 'Username "' + req.body.username + '" is already taken';
// }
console.log("created User: ", { id: res.insertId, ...req });
result(null, { id: res.insertId, ...req });
});
};
Example json object for api create route (post method)
{
"username": "seve",
"user_name": "sev123",
"user_surname": "avcı",
"email": "sevre@gmail.com",
"user_type": "user",
"password": "123456"
}
The "I...
![How To [Pii_pn_17ae00974a128627] Error Code 2021?](https://howtodownload.cc/wp-content/uploads/2021/06/Ways-To-Fix-pii_email_f471d3ee8613f77bd6e2-Error.jpg)