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)
Advertisement
Answer
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');