nodejs express nested sequelize async await

Question

I could not get the a nested logic to work. I need to combined data from 2 table and return it to the request. I do not want a join table as I need to return an individual record from tableA first then combine with tableB record before it is returned. Below is my simplified code

exports.get_caution_reasons = async (req, res) => {
   let return_data = [];
   await db.sequelize.query("SELECT TableA xxxxx",{
                type: QueryTypes.SELECT
            }).then(recordA => {
                for (let index = 0; index < recordA.length; index++) {
                    return_data.push({recordA[index].xxx, recordA[index].yyy})
                    db.sequelize.query("SELECT TableB xxxxx WHERE zzz=recordA.zzz",{
                       type: QueryTypes.SELECT
                    }).then(recordB => {
                        for (let index = 0; index < recordB.length; index++) {
                            return_data.push({recordB[index].xxx, recordB[index].yyy}) 
                        }   
                    })
                }
                res.status(200).json({data: return_data});
            })
};

It only return the record for TableA only. I tried various async and await to get the recordB in there but without success. Any help is useful.

Anastazy · Accepted Answer · 2021-06-08 08:53:49Z

1

Probably something like that should work:

exports.get_caution_reasons = async (req, res, next) => {
    try {
        let options = { type: QueryTypes.SELECT }
        let data = []
        let result_a = await db.sequelize.query("SELECT TableA xxxxx", options)
        for (let index = 0; index < result_a.length; index++) {
            data.push({ /* whatever you need... */ })
            let result_b = await db.sequelize.query("SELECT TableB xxxxx WHERE zzz=recordA.zzz", options)
            for (let index = 0; index < result_b.length; index++) {
                data.push({ /* ... */ })
            }
        }
        res.json({ data })
    } catch (err) {
        next(err)
    }
}

edited Jun 8, 2021 at 8:53

answered Jun 7, 2021 at 14:12

Anastazy

4,7962 gold badges16 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

nodejs express nested sequelize async await

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related