Missing output from sqlite query

Question

I'm working with node and sqlite using the sqlite3 npm package. I'm trying to run the following query in node:

 SELECT PropertyId FROM 'myData' WHERE Code IS NULL LIMIT 5

You can see that this works manually in the screenshot. In node I have

async function select_Rs_from_table(db,tablename, limit) {

// SELECT PropertyId FROM 'myData' WHERE Code IS NULL;

let out  
try {
 const sql = `SELECT PropertyId FROM '${tablename}' WHERE Code IS NULL LIMIT ${limit}`;
console.log(sql);
out =  await db.run(sql);
 
} catch (error) {
 console.log(error); 
}
return out;

}

When I run this with

const sqlite3 = require('sqlite3').verbose();
 // open the database
const db = new sqlite3.Database('./test.db', 
sqlite3.OPEN_READWRITE, (err) => {
  if (err) {
    console.error(err.message);
  }
  console.log('Connected to the database.');
});
console.log('here');

select_Rs_from_table(db, 'myData', 5).then(x => console.log(x));

I see:

Debugger attached.
SELECT PropertyId FROM 'myData' WHERE StateCode IS NULL LIMIT 5
Database {}
Connected to the database.
Waiting for the debugger to disconnect...

Where is the result? How to I access the expected output?

Which Sqlite package are you using? Also return await foo() is the same as return foo() in this case (if you had it in a try..catch then return await would have value). — user5774952
– user5774952, Commented Jan 10, 2021 at 21:46

user5774952 · Accepted Answer · 2021-01-10 22:21:23Z

There are a couple issues: you're using Promise-based calls with the sqlite3 package, but that package uses callbacks. You're also using db.run rather than db.get for a select statement. To use Promises (async/await) you need the sqlite package using sqlite3.Database as a driver. Please try this fixed example:

const sqlite3 = require('sqlite3').verbose()
const sqlite = require('sqlite')

;(async () => {
  const db = await sqlite.open({
    filename: './test.db',
    driver: sqlite3.Database
  })
  console.log('connected!')

  async function select_Rs_from_table(tablename, limit) {
    try {
      const sql = `SELECT PropertyId FROM '${tablename}' WHERE Code IS NULL LIMIT ${limit}`
      return await db.get(sql)
    } catch (error) {
      console.error(error)
    }
  }

  select_Rs_from_table('myData', 5).then(console.log)
})()

Collectives™ on Stack Overflow

Missing output from sqlite query

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