52 lines
1012 B
JavaScript
52 lines
1012 B
JavaScript
|
'use strict'
|
||
|
|
|
||
|
|
const fs = require('fs')
|
||
|
|
const os = require('os')
|
||
|
|
const path = require('path')
|
||
|
|
const sqlite3 = require('sqlite3').verbose()
|
||
|
|
const squel = require('squel')
|
||
|
|
|
||
|
|
const DB_FILE = path.join(os.homedir(), '.intval3.db')
|
||
|
|
const db = new sqlite3.Database(DB_FILE)
|
||
|
|
|
||
|
|
class DB {
|
||
|
|
constructor () {
|
||
|
|
this._table = 'frames'
|
||
|
|
this.createTable()
|
||
|
|
}
|
||
|
|
createTable () {
|
||
|
|
const query = `CREATE TABLE
|
||
|
|
IF NOT EXISTS ${this._table} (
|
||
|
|
dir INTEGER,
|
||
|
|
exposure INTEGER,
|
||
|
|
start INTEGER,
|
||
|
|
stop INTEGER,
|
||
|
|
len INTEGER,
|
||
|
|
counter INTEGER,
|
||
|
|
sequence INTEGER
|
||
|
|
);`
|
||
|
|
db.run(query)
|
||
|
|
}
|
||
|
|
insert (obj) {
|
||
|
|
const query = squel.insert()
|
||
|
|
.into(this._table)
|
||
|
|
.setFields(obj) //dir, exposure, start, stop, len, counter
|
||
|
|
.toString()
|
||
|
|
db.run(query)
|
||
|
|
}
|
||
|
|
find (where, cb) {
|
||
|
|
const query = squel.select()
|
||
|
|
.from(this._table)
|
||
|
|
.where(where)
|
||
|
|
.toString()
|
||
|
|
db.all(query, cb)
|
||
|
|
}
|
||
|
|
list (cb) {
|
||
|
|
const query = squel.select()
|
||
|
|
.from(this._table)
|
||
|
|
.toString()
|
||
|
|
db.all(query, cb)
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
module.exports = new DB()
|