I have this async function called getData and it returns a datas array after db.all call. My problem here is that it doesn't wait until db.all gets done. It returns an empty array. Here's my code:
const sqlite3 = require('sqlite3').verbose()
let db = new sqlite3.Database('./datas.sqlite')
async function getData() {
let dataArray = []
await db.all("SELECT * FROM pressure_data", [], (err, rows) => {
rows.forEach(row => {
dataArray.push({ "Name": row['Name'], "Pressure": row['Pressure']/100 })
}
})
return dataArray
}