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

Question

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);

Dominik · Accepted Answer · 2020-12-26 07:55:12Z

5

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);

edited Dec 26, 2020 at 7:55

answered Dec 26, 2020 at 7:49

Dominik

6,3239 gold badges44 silver badges63 bronze badges

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

2 Comments

ad1tya2 Over a year ago

Thanks a lot for the help this works for me right now, But is there any way to do what i was trying to do without async?

Dominik Over a year ago

Only by adding all your code inside the callback function... otherwise... nope ;)

Collectives™ on Stack Overflow

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

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related