How to loop data in RowDataPacket

Question

How to loop data in RowDataPacket.

This problem happen because in addonis QueryBuild not return same value

as lucid models

If I use lucid models every work fine

const emp =  await EMP.all();
for(let i in emp.rows) {
      const data = emp.rows[i]

}

After I using querybuilder I do something like this

const emp =  await Database
                    .table('emp');



for(let i in emp.RowDataPacket) {
      console.log('s')
      const data = emp.RowDataPacket[i]
      const emp =  await emp_sell.query()
                                  .where('emp_id',data.id);
    }

It's not even display 's'

@guijob it's same . The data return RowDataPacket . but I don't know how to fecth data in controller — TryHard, Mar 22 '19 at 05:06
oh ok, so I think you ended up with a RowDataPacket[] witch is not iterable. As a workaround you could `JSON.parse(JSON.stringify(emp)` to transform into js array then iterate over it — guijob, Mar 22 '19 at 05:18
thanks, Now I can use emp.forEach(function(data) { console.log(data.id); }); — TryHard, Mar 22 '19 at 05:27

score 4 · Accepted Answer · answered Mar 22 '19 at 05:36

4

When making this query await Database.table('emp');, you ended with an RowDataPacket objects, which is an object not iterable, as a workaround you could parse it to an array as:

JSON.parse(JSON.stringify(emp))

How to loop data in RowDataPacket

1 Answers1