1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
import * as sqliteConnApi from "native";
export class SqliteConn {
#conn;
constructor(conn) {
this.#conn = conn;
}
/**
*
* @param sql {string}
* @param params {*[]}
* @returns {Promise<number>}
*/
async execute(sql, params= []) {
return await sqliteConnApi.execute(this.#conn, sql, params);
}
/**
*
* @param sql {string}
* @param params {*[]}
* @returns {Promise<Object[]>}
*/
async query(sql, params = []) {
const [columnNames, rows] = await sqliteConnApi.query(this.#conn, sql, params);
return rows.map(it => {
const map = {};
for (let i = 0; i < columnNames.length; i++) {
map[columnNames[i]] = it[i];
}
return map;
});
}
}
export class Sqlite {
/**
*
* @param path {string}
* @returns {Promise<SqliteConn>}
*/
static async open(path) {
const conn = sqliteConnApi.create();
await sqliteConnApi.open(conn, path);
return new SqliteConn(conn);
}
}