Returned with object from db call

Question

I execute the following code;

 var array = await Promise.all([
    database.query("SELECT COUNT(amount) FROM transactions WHERE date >= now() - INTERVAL 1 DAY;"), 
    database.query("SELECT COUNT(amount) FROM transactions WHERE date >= now() - INTERVAL 7 DAY;"), 
    database.query("SELECT COUNT(amount) FROM transactions"), 
  ]);

I expect an array like so [1,2,3];

Instead what I get is;

[ [ RowDataPacket { 'COUNT(amount)': 6 } ],
  [ RowDataPacket { 'COUNT(amount)': 7 } ],
  [ RowDataPacket { 'COUNT(amount)': 7 } ] ]

What did I miss?

CalculatingKraken · Accepted Answer · 2019-01-06 02:53:33Z

1

As per https://github.com/mysqljs/mysql/issues/1330, it is because it is a low level library.

You can still access the array with [0]['COUNT(amount)'] and so on. If you just want the numbers you may have too add more logic.

answered Jan 6, 2019 at 2:53

CalculatingKraken

8311 gold badge10 silver badges20 bronze badges

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

2 Comments

Borda Over a year ago

Shame. It really annoys me.

Evert Over a year ago

@Borda it shouldn't, because it takes 2 seconds to write a re-usable function that wraps query and returns a single value. If your library of choice would supply this feature it would also just be this exact same function. This is a learning opportunity.

Collectives™ on Stack Overflow

Returned with object from db call

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related