You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
84 lines
1.6 KiB
84 lines
1.6 KiB
import { TaskManager } from "./task_manager.mjs"; |
|
import { Transaction } from "./transaction.mjs"; |
|
import { Result } from "./result.mjs"; |
|
import { query } from "./query.mjs"; |
|
|
|
|
|
export class Database { |
|
constructor(dbName, adapter) { |
|
this.dbName = dbName; |
|
this.adapter = adapter; |
|
this.version = null; |
|
this.path = null; |
|
|
|
this.taskManager = new TaskManager(); |
|
} |
|
|
|
async open() { |
|
let response = await this.adapter.open(this.dbName); |
|
|
|
if (response) { |
|
if (response.hasOwnProperty('version')) { |
|
this.version = response.version; |
|
} |
|
if (response.hasOwnProperty('path')) { |
|
this.path = response.path; |
|
} |
|
} |
|
|
|
// Allow chaining |
|
return this; |
|
} |
|
|
|
close() { |
|
return this.adapter.close(this.dbName); |
|
} |
|
|
|
transaction() { |
|
return new Transaction( |
|
this.dbName, |
|
this.adapter, |
|
this.taskManager.enqueue.bind(this.taskManager) |
|
); |
|
} |
|
|
|
async autoTransaction(cb, inheritTx) { |
|
let tx = inheritTx || this.transaction(); |
|
let result; |
|
|
|
try { |
|
result = await cb(tx); |
|
} catch (e) { |
|
if (!inheritTx) { |
|
await tx.rollback(); |
|
} |
|
throw e; |
|
} |
|
|
|
if (!inheritTx) { |
|
await tx.commit(); |
|
} |
|
|
|
return result; |
|
} |
|
|
|
|
|
// Execute a single SQL statement |
|
async sql(sql, ...args) { |
|
const completeCb = await this.taskManager.enqueue(); |
|
|
|
let result; |
|
let error; |
|
try { |
|
result = await this.adapter.sql(this.dbName, ...query(sql, ...args)); |
|
} catch (e) { |
|
error = e; |
|
} |
|
completeCb(); |
|
|
|
if (error) { |
|
throw error; |
|
} |
|
return new Result(result); |
|
} |
|
} |