执行signUp函数时出现未定义的情况。

huangapple
go评论139阅读模式
英文:

Getting undefined when executing signUp function

问题

以下是您要翻译的代码部分：

  1. async function signUp(info) {
  2.     const {
  3.         firstName,
  4.         lastName,
  5.         address,
  6.         email,
  7.         phoneNumber,
  8.         password,
  9.         city,
  10.         postal_code,
  11.     } = info;
  13.     console.log("only info: ", phoneNumber);
  15.     const queryInsertNewUser = `INSERT INTO public."Users"(
  16.         "First_Name", "Email", "Mobile", "Address", "User_Type", "Last_Name", "password", "city","postal_code")
  17.         VALUES ('${firstName}', '${email}', '${phoneNumber}', '${address}', 'Customer', '${lastName}', '${password}','${city}','${postal_code}')
  18.         RETURNING user_id;`;
  20.     client.query(queryInsertNewUser, (err, result) => {
  21.         if (!err) {
  22.             if (result.rowCount == 1) {
  23.                 console.log("User registered.");
  24.                 return {
  25.                     status: "Success",
  26.                     msg: "User Registered Successfully",
  27.                     user_id: result.rows[0].user_id,
  28.                 };
  29.             } else {
  30.                 console.log("Not Registered.");
  31.                 return {
  32.                     status: "Error",
  33.                     msg: "Could not register user. Call Developer.",
  34.                 };
  35.             }
  36.         } else {
  37.             console.log(err);
  38.         }
  39.     });
  40. }
  42. app.post("/signup", async(req, res) => {
  43.     const { email } = req.body;
  44.     const data = await signUp(req.body);
  45.     console.log(data);
  46. });

请注意，由于JavaScript的异步性质，client.query的回调函数中的return语句不会直接返回值给signUp函数的调用者。您可能需要重构代码以处理回调函数的方式来处理异步操作，或者考虑使用await来等待client.query的结果。这是解决问题的一种方式。

英文:

I am trying to return a particular response when a data is inserted in postgresql. The query works perfectly, Inserts data into DB but before returning a response it prints undefined. Kindly check the code below.

  1. async function signUp(info) {
  2.     const {
  3.         firstName,
  4.         lastName,
  5.         address,
  6.         email,
  7.         phoneNumber,
  8.         password,
  9.         city,
  10.         postal_code,
  11.     } = info;
  13.     console.log("only info: ", phoneNumber);
  15.     const queryInsertNewUser = `INSERT INTO public."Users"(
  16.         "First_Name", "Email", "Mobile", "Address", "User_Type", "Last_Name", "password", "city","postal_code")
  17.         VALUES ('${firstName}', '${email}', '${phoneNumber}', '${address}', 'Customer', '${lastName}', '${password}','${city}','${postal_code}')
  18.         RETURNING user_id;`;
  22.     client.query(queryInsertNewUser, (err, result) => {
  23.         if (!err) {
  24.             if (result.rowCount == 1) {
  25.                 console.log("User registered.");
  26.                 return {
  27.                     status: "Success",
  28.                     msg: "User Registered Successfully",
  29.                     user_id: result.rows[0].user_id,
  30.                 };
  31.             } else {
  32.                 console.log("Not Registered.");
  33.                 return {
  34.                     status: "Error",
  35.                     msg: "Could not register user. Call Developer.",
  36.                 };
  37.             }
  38.         } else {
  39.             console.log(err);
  40.         }
  41.     });
  42. }
  45. app.post("/signup", async(req, res) => {
  46.     const { email } = req.body;
  47.     const data = await signUp(req.body);
  48.     console.log(data);
  49. });

I tried shortening the code, tried async/await still does not work. If I remove the client.query part of signUp method and replace it with return " hello". the Console.log prints hello.

答案1

得分: 0

尝试以下代码，看看是否有帮助。

  1. async function signUp(info) {
  2.     try {
  3.         const {
  4.             firstName,
  5.             lastName,
  6.             address,
  7.             email,
  8.             phoneNumber,
  9.             password,
  10.             city,
  11.             postal_code,
  12.         } = info;
  13.     
  14.         console.log("only info: ", phoneNumber);
  15.     
  16.         const queryInsertNewUser = `INSERT INTO public.Users(
  17.     First_Name, Email, Mobile, Address, User_Type, Last_Name, password, city,postal_code)
  18.     VALUES ($1, $2, $3, $4, 'Customer', $5, $6, $7, $8)
  19.     RETURNING user_id;`;
  20.     
  21.         const params = [firstName, email, phoneNumber, address, lastName, password, city, postal_code]
  22.     
  23.         const result = await client.query(queryInsertNewUser, params);
  24.         console.log("Result here", result)
  25.         if (result) { // OR (result && result.rowCount)
  26.             return {
  27.                 status: "Success",
  28.                 msg: "User Registered Successfully",
  29.                 user_id: result.rows[0].user_id,
  30.             }
  31.         }
  32.         console.log("Not Registered.");
  33.         return {
  34.             status: "Error",
  35.             msg: "Could not register user. Call Developer.",
  36.         }
  37.     } catch (error) {
  38.         console.error("Error", error)
  39.         return {
  40.             status: false
  41.         }
  42.     }
  43. }

如果要使用回调进行查询，尝试将其更改如下，但我建议将其改为Promise。

  1. client.query(queryInsertNewUser, (err, result) => {
  2.     if (err) {
  3.         console.log(err);
  4.         return {
  5.             status: false
  6.         }
  7.     }
  8.     if (result && result.rowCount) {
  9.         console.log("User registered.");
  10.         return {
  11.             status: "Success",
  12.             msg: "User Registered Successfully",
  13.             user_id: result.rows[0].user_id,
  14.         };
  15.     } else {
  16.         console.log("Not Registered.");
  17.         return {
  18.             status: "Error",
  19.             msg: "Could not register user. Call Developer.",
  20.         };
  21.     }
  22. });
英文:

Try below code, see if it helps.

  1. async function signUp(info) {
  2.     try {
  3.         const {
  4.             firstName,
  5.             lastName,
  6.             address,
  7.             email,
  8.             phoneNumber,
  9.             password,
  10.             city,
  11.             postal_code,
  12.         } = info;
  13.     
  14.         console.log("only info: ", phoneNumber);
  15.     
  16.         const queryInsertNewUser = `INSERT INTO public.Users(
  17.     First_Name, Email, Mobile, Address, User_Type, Last_Name, password, city,postal_code)
  18.     VALUES ($1, $2, $3, $4, 'Customer', $5, $6, $7, $8)
  19.     RETURNING user_id;`;
  20.     
  21.         const params = [firstName, email, phoneNumber, address, lastName, password, city, postal_code]
  22.     
  23.         const result = await client.query(queryInsertNewUser, params);
  24.         console.log("Result here", result)
  25.         if (result) { // OR (result && result.rowCount)
  26.             return {
  27.                 status: "Success",
  28.                 msg: "User Registered Successfully",
  29.                 user_id: result.rows[0].user_id,
  30.             }
  31.         }
  32.         console.log("Not Registered.");
  33.         return {
  34.             status: "Error",
  35.             msg: "Could not register user. Call Developer.",
  36.         }
  37.     } catch (error) {
  38.         console.error("Error", error)
  39.         return {
  40.             status: false
  41.         }
  42.     }
  43. }

If you want to use callback for query then try changing it like below, but I'll suggest to move it to Promise

  1. client.query(queryInsertNewUser, (err, result) => {
  2.     if (err) {
  3.         console.log(err);
  4.         return {
  5.             status: false
  6.         }
  7.     }
  8.     if (result && result.rowCount) {
  9.         console.log("User registered.");
  10.         return {
  11.             status: "Success",
  12.             msg: "User Registered Successfully",
  13.             user_id: result.rows[0].user_id,
  14.         };
  15.     } else {
  16.         console.log("Not Registered.");
  17.         return {
  18.             status: "Error",
  19.             msg: "Could not register user. Call Developer.",
  20.         };
  21.     }
  22. });

huangapple
  • 本文由 发表于 2023年1月11日 03:09:24
  • 转载请务必保留本文链接：https://go.coder-hub.com/75074734.html
  • async-await
  • javascript
  • node.js
  • postgresql
  • rest
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定