javascriptnode.jspostgresqlkoakoa-router

how to use async and await in koa?


I have a created a simple login api but i'm getting 404 error. How i can solve this issue? My ctx body is not working. When i hit on postman it throws not found.

router.post('/login', async (ctx, next) => {

    var phone= ctx.request.body.phone;
    var password = ctx.request.body.password;


        await ctx.app.pool.query("SELECT * FROM users WHERE phone= $1",
            [`${phone}`],
            async (err, result) => {
               if (result) {
                   await bcrypt.compare(password, result.rows[0].password).then(function (res) {

                        if (res === true) {
                            ctx.body = {
                                status: 200,
                                message: "login successfully",
                                data: result.rows[0],
                            };
                        }else{
                            ctx.body = {
                                status: 400,
                                message: "Incorrect password! Try again.",
                            }
                        }
                    });
                }else{
                    ctx.body = {
                        status: 400,
                        message: "Invalid phone",
                    }
                }
            });
});

Solution

  • First don't mix async with callbacks & then

    Use const res = await somepromise()

    You used a callback for the query and a then for bcrypt.compare instead of awaiting it

    router.post('/login', async (ctx, next) => {
      const phone= ctx.request.body.phone;
      const password = ctx.request.body.password;
      const result =  await ctx.app.pool.query("SELECT * FROM users WHERE phone= $1",  [`${phone}`])
    
      if (result) {
         const pwCorrect = await bcrypt.compare(password, result.rows[0].password)
         if (pwCorrect === true) {
            ctx.body = {
               status: 200,
               message: "login successfully",
               data: result.rows[0],
            };
         }else{
             ctx.body = {
               status: 400,
               message: "Incorrect password! Try again.",
             }
         }
      } else{
          ctx.body = {
            status: 400,
            message: "Invalid phone",
          }
    
    });