Javascript array parsing

Question

var usersRows = [];
connection.query('SELECT * from users', function(err, rows, fields) {
    if (!err) {
        rows.forEach(function(row) {
            usersRows.push(row);
        });
        console.log(usersRows);
    }
    else {
        console.log('Error while performing Query.' + err);
    }
});

It returned to me:

var usersRows = [ [ RowDataPacket { id: 1, name: 'sall  brwon', number: '+99999999\r\n' } ] ];

I need to parse this and remove rowdatapacket; I need result like this:

userRows = { id: 1, name: 'my name is', number: '+999999\r\n' };

for some reason, my comment has been erased... so the comment was: "and what have you tried?" — Zathrus Writer
– Zathrus Writer, Commented Sep 27, 2015 at 12:20

Vadim Shvetsov · Accepted Answer · 2017-02-20 17:20:10Z

4

If you need to get rid of RowDataPacket's array and save it in yours you can also use this:

usersRows = JSON.parse(JSON.stringify(results));

answered Feb 20, 2017 at 17:20

Vadim Shvetsov

2,4463 gold badges22 silver badges28 bronze badges

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

Comments

Yokowasis · Accepted Answer · 2015-09-27 09:25:02Z

2

Have you tried

userRows = RowDataPacket;

answered Sep 27, 2015 at 9:25

Yokowasis

3632 silver badges11 bronze badges

5 Comments

sall brown Over a year ago

RowDataPacket is not defined

Yokowasis Over a year ago

how is it not defined ? from what i see on your post its value is { id: 1, name: 'sall brwon', number: '+99999999\r\n'}

Kumaresan Perumal Over a year ago

@Yokowasis: i need you, please help me.

Yokowasis Over a year ago

@KumaresanPerumal why ? can't you just pm me ?

Kumaresan Perumal Over a year ago

i got json from db with RowDataPacket. how to remove it?

William Kheng · Accepted Answer · 2016-06-23 00:56:55Z

0

You might want to try JSON.stringify(rows)

answered Jun 23, 2016 at 0:56

William Kheng

67111 silver badges16 bronze badges

1 Comment

Michael Gaskill Over a year ago

That will return a string, when the OP is looking for the object. Plus, it's pretty costly to do this, compared to the accepted answer.

Community · Accepted Answer · 2017-05-23 12:09:52Z

Was unable to understand and implement the accepted the answer. Hence, tried the long way out according the results I was getting.

Am using "mysql": "2.13.0" and saw that the this library returned array of array out of which:

Index 0 had array of RowDataPackets 
Index 1 had other mysql related information.

Please find the code below:

var userDataList = [];
//Get only the rowdatapackets array which is at position 0
var usersRows = data[0];
//Loop around the data and parse as required
for (var i = 0; i < usersRows.length; i++) {
   var userData = {};
   //Parse the data if required else just
   userData.name = userRows.firstName + userRows.lastName;
   userDataList.push(userData);
}

If no parsing is required and you just want the data as is, you could use the solution like mentioned in link How do I loop through or enumerate a JavaScript object? Have not tried it but could be tweaked and worked out.

There should be simpler way to do it but as a novice I found the above way server the purpose. Do comment in case of better solution.

Nicholas Shanks · Accepted Answer · 2019-01-09 15:03:38Z

0

RowDataPacket is the class name of the object that contains the fields.

The console.log() result [ [ RowDataPacket { id: 1, name: 'sall brwon', number: '+99999999\r\n' } ] ] should be read as "an array of one item, containing and array of one item, containing an object of class RowDataPacket with fields id, name, and number"

answered Jan 9, 2019 at 15:03

Nicholas Shanks

11k4 gold badges60 silver badges82 bronze badges

Collectives™ on Stack Overflow

Javascript array parsing

5 Answers 5

Comments

5 Comments

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

5 Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related