Sequelize raw queries TextRow and getting data out of it

Question

Given this query here,

        let output = [];
        const sql = `select * from coredb.account LIMIT ${offset},${limit}`;
        let data = await sequelize.query(sql, null, {raw: true, type: sequelize.QueryTypes.SELECT});
        data.forEach((item) => {
            console.log(item['id'], item.id); // <-- output says "undefined, undefined"
        });

the data variable is indeed hydrated with the right row data when using console.log to inspect it.

But, when I try to access the individual properties, they only ever come back as undefined. This TextRow object that Sequelize seems to return the result in doesn't seem to want to let me access then explicit rows.

Just curious what i'm missing here, am I missing an option?

@Ellebkey even with raw set to false, I get the same result and can't access the individual fields — RedactedProfile, Jun 11 '19 at 14:34

score 3 · Answer 1 · answered Mar 06 '20 at 22:23

3

I agree, Sequalize raw queries are not intuitive. You don't need the null or raw: true flag. Something like this should work:

let data = await sequelize.query(sql, {type: sequelize.QueryTypes.SELECT});

answered Mar 06 '20 at 22:23

ow3n

5,974
4
53
51

3

LOL I just tried to vote for this answer 8 months later w/o realizing it was my own. – ow3n Nov 25 '20 at 15:28

KenOn10 · Answer 2 · 2019-06-11T19:39:30.577

2

When I tried this, "data" was an array of two objects, each being the query result. So, the properties can be accessed by using index [0].... e.g.

data[0].forEach((item) => {
   console.log(item['id'], item.id); // <-- output says "undefined, undefined"
});

Not yet sure WHY this occurs!

EDIT - it's because .query() should have only two arguments. Changing the call to: sequelize.query(sql, {raw: true, type: sequelize.QueryTypes.SELECT}) resulted in data being a single array (as expected).

edited Jun 11 '19 at 19:39

answered Jun 11 '19 at 19:29

KenOn10

1,743
1
9
10

If you console.log the 'data' object you can see the anatomy of what sequelize returns – Michael Nelles Dec 11 '19 at 14:04

score 0 · Answer 3 · answered Apr 07 '20 at 16:58

Finally I was able to find the solution for it. You just need to make a new array and push data into it by finding bases on key name like this: suppose we have data in students object:

    let finalArray = new Array();
    for (var k in students ) {
      finalArray.push(students[k])
    }

 console.log(finalArray) // Normal JSON array object :)

Saul Euan · Answer 4 · 2022-07-30T03:25:15.403

0

 m.sequelize.query(sql, {
          model,
          mapToModel: true
        })
          .then(model => res.status(200).send(model))
          .catch(error => res.status(400).send(error.toString())
        })

edited Jul 30 '22 at 03:25

answered Jul 30 '22 at 03:23

Saul Euan

11
3

Sequelize raw queries TextRow and getting data out of it

4 Answers4