How to assign a variable to the output of a sqlite query in node js

user_14827372 0
Viewed 473

What I am doing right now is:

db.get(`SELECT * FROM '${message.guild.id}'`,(err, row) => {
    console.log(row.channel);
});

What I basically want to do is, something like this:

let xyz = db.get(`SELECT * FROM '${message.guild.id}'`,(err, row) => {
    return row.channel;
});
console.log(xyz);
node.js sqlite
1 Answers

Your db function uses a callback. A callback is run async to your code so JS will not wait for it and will continue to execute the code below. That means you won't be able to assign a variable like you suggested.

What you could do is create an async function you can await in your code:

async function getChannelFromID(db, id) {
    return new Promise((resolve, reject) => {
        db.get(`SELECT * FROM '${id}'`,(err, row) => {
            if (err) reject(err); // I assume this is how an error is thrown with your db callback
            resolve(row.channel);
        });
    });
}

// Now you can use the function like this
// (make sure you mark the function you call this in as async)
const xyz = await getChannelFromID(db, message.guild.id);
user_10432310
Related