-
Notifications
You must be signed in to change notification settings - Fork 29
/
storage-engine-queries.js
60 lines (50 loc) · 1.16 KB
/
storage-engine-queries.js
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
52
53
54
55
56
57
58
59
60
// @flow
import { SqliteDatabase } from 'sql.js';
import { parseMultiStatementSQLiteResult } from '../utils/db-utils.js';
type Entry = {
key: string,
item: string,
};
function setPersistStorageItem(db: SqliteDatabase, key: string, item: string) {
const query = `
INSERT OR REPLACE INTO persist_storage (key, item)
VALUES ($key, $item)
`;
const params = {
$key: key,
$item: item,
};
db.exec(query, params);
}
function getPersistStorageItem(db: SqliteDatabase, key: string): string {
const query = `
SELECT *
FROM persist_storage
WHERE key = $key
`;
const params = {
$key: key,
};
const rawResult = db.exec(query, params);
const result = parseMultiStatementSQLiteResult<Entry>(rawResult);
if (result.length === 0 || result[0].length === 0) {
return '';
}
const [entry] = result[0];
return entry.item;
}
function removePersistStorageItem(db: SqliteDatabase, key: string) {
const query = `
DELETE FROM persist_storage
WHERE key = $key
`;
const params = {
$key: key,
};
db.exec(query, params);
}
export {
setPersistStorageItem,
getPersistStorageItem,
removePersistStorageItem,
};