Electron, Javascript: How to select an array within an array returned by the database

Question

I want to foreach an array to show on the screen. This array is the data from a database table.

The code to get this data:

const { getConnection } = require('./database');

async function getUsers() {
   const conn = getConnection();
   var usuarios = (await conn).query('SELECT * FROM user');
   console.log(usuarios)
}

But this variable comes this way:

And I'm not able to select that array (_rejectionHandler0)

Unmitigated · Accepted Answer · 2021-01-04 19:34:34Z

4

Since .query also returns a Promise, you need to await it.

var usuarios = await (await conn).query('SELECT * FROM user');

await conn waits for the connection to be obtained and the outer await waits for the query to finish.

Alternatively, you can await each one separately:

const conn = await getConnection();
var usuarios = await conn.query('SELECT * FROM user');

answered Jan 4, 2021 at 19:34

Unmitigated

91.4k12 gold badges102 silver badges109 bronze badges

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

Collectives™ on Stack Overflow

Electron, Javascript: How to select an array within an array returned by the database

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