How to insert a value in a select statement with the help of JavaScript, especially when using express and postgres?
CreateUser and listAllUsers work (included below for reference). The test / capture works and satisfies the request or returns the error for those two as well.
Any help would be greatly appreciated!
When using Postman, the result I get when I send the object get (localhost: 4000 / user / id with a key value x-www-formurlencoded, user_id = 3) is…
{
"name": "error",
"length": 90,
"severity": "ERROR",
"code": "42601",
"position": "37",
"file": "scan.l",
"line": "1134",
"routine": "scanner_yyerror"
}
And in the terminal, it shows the following (trapped in my console.log).
3
QUERY: SELECT * FROM users WHERE user_id = $ {user_id}
When I loop user, he says the same thing in the terminal. Here is the command curl and putput …
curl -X GET localhost: 4000 / user / 3
{"name": "error", "length": 90, "severity": "ERROR", "code": "42601", "position": "37", "file": "scan.l", " line ":" 1134 "," routine ":" scanner_yyerror "} ww10sc2353621: ~ james.mcgregor $ curl -X localhost GET: 4000 / user / 3
In the end, the 3 that I pass as user_id is not substituted in the select statement. That's my problem. I can not understand how to do this properly. Should I even adopt this approach or should I try to pass it as a parameter in the URL?
const db = require (& # 39; ../ connectors / db.js & # 39;);
User class {
constructor (id, user_id, firstname, middle_initial, last_name, email, type) {
this.id = id;
this.first_name = firstname;
this.middle_initial = middle_initial;
this.last_name = last_name;
this.email = email;
this.type = type;
this.user_id = user_id;
}
static newUser (user_id, firstname, middle_initial, last_name, email, type) {
returns db.one (`
INSERT INTO users ("user_id", "firstname", "middle_initial", "last_name", "email", "type")
VALUES (& # 39; $ {user_id} & # 39;; & # 39; $ {firstname} & # 39; $ {middle_initial} & # 39; $ {last_name} & # 39; $ {email} & # 39;; & # 39; $ {type} & # 39;)
Return ID
`)
}
static async allUsers () {
const findAllQuery = SELECT * FROM users; & # 39 ;;
return db.query (findAllQuery)
}
static async selectUser (user_id) {
console.log (user_id);
const findOneQuery = SELECT * FROM users WHERE user_id = $ {user_id} & # 39 ;;
return db.query (findOneQuery)
}
}
module.exports = User;
const express = require (& # 39;);
const dataFunctions = require (& # 39; ./ catalog.js & # 39;);
const AppRouter = express.Router ();
AppRouter.post (& # 39; / user & # 39 ;, dataFunctions.createUser);
AppRouter.get (& # 39; / users & # 39 ;, dataFunctions.listAllUsers);
AppRouter.get (& # 39; / user /: id, dataFunctions.listUserByUserID);
AppRouter.delete (& # 39; / user /: id, dataFunctions.deleteUserByUserID);
module.exports = AppRouter;
const Users = require (& # 39; ../models/users.js & # 39;)
// Create
Async function. createUser (req, res) {
try {
console.log (req.body);
const userId = wait Users.newUser (req.body.user_id, req.body.first_name, req.body.middle_initial, req.body.last_name, req.body.email, req.body.type)
res.status (201) .send (`user ID: $ {userId.id}`);
} catch (error) {
res.status (400) .send (error);
}
}
// List All
async function listAllUsers (req, res) {
try {
const userList = wait Users.allUsers ();
console.log (userList);
res.status (200) .send (userList);
} catch (error) {
res.status (400) .send (error);
}
}
// List by ID
function async listUserByUserID (req, res) {
try {
const userList = wait Users.selectUser (req.body.user_id);
console.log (userList);
res.status (200) .send (userList);
} catch (error) {
res.status (400) .send (error);
}
}
module.exports = {
Create a user,
listAllUsers,
listUserByUserID
}
