Reading object returned from "SELECT COUNT(*) FROM table"

Question

let rows = db.prepare("SELECT COUNT(*) FROM table").get();

Returns the object

{ 'COUNT(*)': 2 }

I am not sure how to read that as

console.log(rows.COUNT(*));

Returns

SyntaxError: Unexpected token *

Not intentionally unless there is some implemented in the better-sqlite3 library — Aidan, Apr 15 '19 at 00:38

score 1 · Accepted Answer · answered Apr 15 '19 at 03:40

1

{ 'COUNT(*)': 2 }

Since COUNT(*) is a key. You can access it directly by using Bracket notation

console.log('No of rows ', row['COUNT(*)']); //logs 2

answered Apr 15 '19 at 03:40

Sridhar

Thank you, I am actually really surprised I have never seen this before. – Aidan Apr 15 '19 at 03:53

score 0 · Answer 2 · answered Apr 15 '19 at 03:25

0

I found the solution is

Object.values(rows);

It will return a length 1 array with just the number

answered Apr 15 '19 at 03:25

Aidan

This is a worse solution that Sridhar's because it is an array instead of just the count – Aidan Apr 15 '19 at 04:09

2 Answers2