Sqlite3 (node.js) returns [object Object]

Question

I am trying to use SQLITE3 to store data for my discord bot and here i need to save a number that goes up each time a command is used. Here is my code: (creating table and setting the value to 0.)

  db.run("CREATE TABLE gbanCases ( number INT )")
  db.run("INSERT INTO gbanCases (number) VALUES ($number)", {
    $number : 0
});

Trying to see what number returns:

        var caseNumber = db.run("SELECT number FROM gbanCases")
        console.log(caseNumber)

The thing is that caseNumber returns me "[object Object]" and I want it to return the 0 that was setted up earlier. Please help me if you can, i'm still very new to this.

Replace your current log with `console.log({ caseNumber })` and see what you get. — code, Aug 05 '22 at 17:46
Here is what i get: ```{caseNumber: Database} caseNumber: Database {filename: 'database.sqlite', mode: 65542} [[Prototype]]: Object``` — CryZz, Aug 05 '22 at 17:51
Don't use `db.run()` for a `SELECT` query, use `db.get()` or `db.all()` depending on whether you want 1 row or all rows. They take a callback function that receives the results. — Barmar, Aug 05 '22 at 17:54

score 1 · Accepted Answer · answered Aug 05 '22 at 17:57

1

Use db.get() to get the result of a query, not db.run(). The resulting row is passed as an argument to the callback function.

db.get("SELECT number FROM gbanCases", function(err, row) {
    if (err) {
        throw err;
    }
    console.log(row.number);
})

answered Aug 05 '22 at 17:57

Barmar

741,623
53
500
612

console.log(row.number); returns : "{}1" – CryZz Aug 05 '22 at 17:59
I suspect `{}` is coming from something else, not this. `row.number` shouldn't contain that. – Barmar Aug 05 '22 at 18:01
How can I fix it? I'm supposed to get 0. – CryZz Aug 05 '22 at 18:04
I can't think of any reason why it doesn't work. The `{}` is not coming from my code, it must be coming from something else you're doing. – Barmar Aug 05 '22 at 18:06
Maybe i didn't do this correctly : ` db.run("CREATE TABLE gbanCases ( number INT )") db.run("INSERT INTO gbanCases (number) VALUES ($number)", { $number : 0 });` – CryZz Aug 05 '22 at 18:06
That part looks fine to me. Can you view the contents of the table from a regular sqlite query tool? – Barmar Aug 05 '22 at 18:06
What do you see if you do `console.log(row)`? – Barmar Aug 05 '22 at 18:07
`console.log(row)` returns `{number: '{}1'}` – CryZz Aug 05 '22 at 18:10
That's really weird. I don't know why an `INT` column would have a string like that in the value. – Barmar Aug 05 '22 at 18:11
In the same database file (not same table) I got string columns, i'm going to create a file for this table – CryZz Aug 05 '22 at 18:12
is this code alright ? : `db2.run("UPDATE gbanCases SET number = ?", row.number + 1)` – CryZz Aug 05 '22 at 18:17
I think `row.number + 1` should be in an array. `[row.number + 1]` – Barmar Aug 05 '22 at 18:17
I managed to fix it, 0 is now returned, thank's so much for all your help! – CryZz Aug 05 '22 at 18:26
Is it possible to use row.number everywhere in my file? If yes, how so? – CryZz Aug 05 '22 at 18:38
See https://stackoverflow.com/questions/14220321/how-to-return-the-response-from-an-asynchronous-call – Barmar Aug 05 '22 at 18:39

Sqlite3 (node.js) returns [object Object]

1 Answers1