Get information from sqlite db in node.js?

Question

SQLite

Hello. Such a problem. There is a sqlite database connected to the Node.js project, interacting with 'sqlite-sync'. And here is a table in the database that stores 1 row and 2 columns:
Id - Key
1 - 892
(example)
How to get this value "892" and put it into a variable using a query in Node.js?

Answer 1

This is not a problem
https://www.npmjs.com/package/sqlite-sync#usage
something like this

var sqlite = require('sqlite-sync');
sqlite.connect(':memory:');
sqlite.run("CREATE TABLE TableName(Id INTEGER PRIMARY KEY, Key INTEGER NOT NULL)");
sqlite.run("INSERT INTO TableName VALUES(1, 892)");
var result = sqlite.run("SELECT Key FROM TableName WHERE Id = 1");
console.log(result[0].Key);

OUT: 892