forked from project-chip/zap
-
Notifications
You must be signed in to change notification settings - Fork 0
/
query-generic.js
77 lines (73 loc) · 1.94 KB
/
query-generic.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
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
/**
*
* Copyright (c) 2020 Silicon Labs
*
* Licensed under the Apache License, Version 2.0 (the "License");
* you may not use this file except in compliance with the License.
* You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
*/
/**
* This module provides generic queries.
*
* @module DB API: generic queries against the database.
*/
const dbApi = require('./db-api.js')
/**
* Simple query that returns number of rows in a given table.
*
* @export
* @param {*} db
* @param {*} table
* @returns a promise that resolves into the count of the rows in the table.
*/
async function selectCountFrom(db, table) {
return dbApi
.dbGet(db, `SELECT COUNT(*) AS COUNT FROM ${table}`)
.then((x) => x.COUNT)
}
/**
* Writes the saved location of the file.
*
* @export
* @param {*} db
* @param {*} filePath
* @param {*} category
*/
async function insertFileLocation(db, filePath, category) {
return dbApi.dbInsert(
db,
'INSERT OR REPLACE INTO FILE_LOCATION (CATEGORY, FILE_PATH, ACCESS_TIME) VALUES (?,?,?)',
[category, filePath, Date.now()]
)
}
/**
* Retrieves the saved location from a file
*
* @export
* @param {*} db
* @param {*} category
*/
async function selectFileLocation(db, category) {
let row = await dbApi.dbGet(
db,
'SELECT FILE_PATH FROM FILE_LOCATION WHERE CATEGORY = ?',
[category]
)
if (row == null) {
return ''
} else {
return row.FILE_PATH
}
}
// exports
exports.selectCountFrom = selectCountFrom
exports.insertFileLocation = insertFileLocation
exports.selectFileLocation = selectFileLocation