diff options
author | Florian Dold <florian@dold.me> | 2023-07-11 15:41:48 +0200 |
---|---|---|
committer | Florian Dold <florian@dold.me> | 2023-08-22 08:01:13 +0200 |
commit | b2d0ad57ddf251a109d536cdc49fb6505dbdc50c (patch) | |
tree | 7eaeca3ad8ec97a9c1970c1004feda2d61c3441b /packages/idb-bridge/src/node-sqlite3-impl.ts | |
parent | 58fdf9dc091b076787a9746c405fe6a9366f5da6 (diff) | |
download | wallet-core-b2d0ad57ddf251a109d536cdc49fb6505dbdc50c.tar.xz |
sqlite3 backend for idb-bridge / wallet-core
Diffstat (limited to 'packages/idb-bridge/src/node-sqlite3-impl.ts')
-rw-r--r-- | packages/idb-bridge/src/node-sqlite3-impl.ts | 84 |
1 files changed, 84 insertions, 0 deletions
diff --git a/packages/idb-bridge/src/node-sqlite3-impl.ts b/packages/idb-bridge/src/node-sqlite3-impl.ts new file mode 100644 index 000000000..fa38d298f --- /dev/null +++ b/packages/idb-bridge/src/node-sqlite3-impl.ts @@ -0,0 +1,84 @@ +/* + This file is part of GNU Taler + (C) 2023 Taler Systems S.A. + + GNU Taler is free software; you can redistribute it and/or modify it under the + terms of the GNU General Public License as published by the Free Software + Foundation; either version 3, or (at your option) any later version. + + GNU Taler is distributed in the hope that it will be useful, but WITHOUT ANY + WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR + A PARTICULAR PURPOSE. See the GNU General Public License for more details. + + You should have received a copy of the GNU General Public License along with + GNU Taler; see the file COPYING. If not, see <http://www.gnu.org/licenses/> + */ + +// @ts-ignore: optional dependency +import type Database from "better-sqlite3"; +import { + ResultRow, + Sqlite3Interface, + Sqlite3Statement, +} from "./sqlite3-interface.js"; + +export async function createNodeSqlite3Impl(): Promise<Sqlite3Interface> { + // @ts-ignore: optional dependency + const bsq = (await import("better-sqlite3")).default; + + return { + open(filename: string) { + const internalDbHandle = bsq(filename); + return { + internalDbHandle, + close() { + internalDbHandle.close(); + }, + prepare(stmtStr): Sqlite3Statement { + const stmtHandle = internalDbHandle.prepare(stmtStr); + return { + internalStatement: stmtHandle, + getAll(params): ResultRow[] { + let res: ResultRow[]; + if (params === undefined) { + res = stmtHandle.all() as ResultRow[]; + } else { + res = stmtHandle.all(params) as ResultRow[]; + } + return res; + }, + getFirst(params): ResultRow | undefined { + let res: ResultRow | undefined; + if (params === undefined) { + res = stmtHandle.get() as ResultRow | undefined; + } else { + res = stmtHandle.get(params) as ResultRow | undefined; + } + return res; + }, + run(params) { + const myParams = []; + if (params !== undefined) { + myParams.push(params); + } + // The better-sqlite3 library doesn't like it we pass + // undefined directly. + let res: Database.RunResult; + if (params !== undefined) { + res = stmtHandle.run(params); + } else { + res = stmtHandle.run(); + } + return { + lastInsertRowid: res.lastInsertRowid, + }; + }, + }; + }, + exec(sqlStr): void { + internalDbHandle.exec(sqlStr); + }, + }; + }, + }; +} |