/* * Copyright (C) 2023 Yomitan Authors * Copyright (C) 2020-2022 Yomichan Authors * * This program is free software: you can redistribute it and/or modify * it under the terms of the GNU General Public License as published by * the Free Software Foundation, either version 3 of the License, or * (at your option) any later version. * * This program is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * GNU General Public License for more details. * * You should have received a copy of the GNU General Public License * along with this program. If not, see <https://www.gnu.org/licenses/>. */ /** * @template {string} TObjectStoreName */ export class Database { constructor() { /** @type {?IDBDatabase} */ this._db = null; /** @type {boolean} */ this._isOpening = false; } /** * @param {string} databaseName * @param {number} version * @param {import('database').StructureDefinition<TObjectStoreName>[]} structure */ async open(databaseName, version, structure) { if (this._db !== null) { throw new Error('Database already open'); } if (this._isOpening) { throw new Error('Already opening'); } try { this._isOpening = true; this._db = await this._open(databaseName, version, (db, transaction, oldVersion) => { this._upgrade(db, transaction, oldVersion, structure); }); } finally { this._isOpening = false; } } /** * @throws {Error} */ close() { if (this._db === null) { throw new Error('Database is not open'); } this._db.close(); this._db = null; } /** * @returns {boolean} */ isOpening() { return this._isOpening; } /** * @returns {boolean} */ isOpen() { return this._db !== null; } /** * @param {string[]} storeNames * @param {IDBTransactionMode} mode * @returns {IDBTransaction} * @throws {Error} */ transaction(storeNames, mode) { if (this._db === null) { throw new Error(this._isOpening ? 'Database not ready' : 'Database not open'); } return this._db.transaction(storeNames, mode); } /** * @param {TObjectStoreName} objectStoreName * @param {unknown[]} items * @param {number} start * @param {number} count * @returns {Promise<void>} */ bulkAdd(objectStoreName, items, start, count) { return new Promise((resolve, reject) => { if (start + count > items.length) { count = items.length - start; } if (count <= 0) { resolve(); return; } const transaction = this._readWriteTransaction([objectStoreName], resolve, reject); const objectStore = transaction.objectStore(objectStoreName); for (let i = start, ii = start + count; i < ii; ++i) { objectStore.add(items[i]); } transaction.commit(); }); } /** * @template [TData=unknown] * @template [TResult=unknown] * @param {IDBObjectStore|IDBIndex} objectStoreOrIndex * @param {?IDBValidKey|IDBKeyRange} query * @param {(results: TResult[], data: TData) => void} onSuccess * @param {(reason: unknown, data: TData) => void} onError * @param {TData} data */ getAll(objectStoreOrIndex, query, onSuccess, onError, data) { if (typeof objectStoreOrIndex.getAll === 'function') { this._getAllFast(objectStoreOrIndex, query, onSuccess, onError, data); } else { this._getAllUsingCursor(objectStoreOrIndex, query, onSuccess, onError, data); } } /** * @param {IDBObjectStore|IDBIndex} objectStoreOrIndex * @param {IDBValidKey|IDBKeyRange} query * @param {(value: IDBValidKey[]) => void} onSuccess * @param {(reason?: unknown) => void} onError */ getAllKeys(objectStoreOrIndex, query, onSuccess, onError) { if (typeof objectStoreOrIndex.getAllKeys === 'function') { this._getAllKeysFast(objectStoreOrIndex, query, onSuccess, onError); } else { this._getAllKeysUsingCursor(objectStoreOrIndex, query, onSuccess, onError); } } /** * @template TPredicateArg * @template [TResult=unknown] * @template [TResultDefault=unknown] * @param {TObjectStoreName} objectStoreName * @param {?string} indexName * @param {?IDBValidKey|IDBKeyRange} query * @param {?((value: TResult|TResultDefault, predicateArg: TPredicateArg) => boolean)} predicate * @param {TPredicateArg} predicateArg * @param {TResultDefault} defaultValue * @returns {Promise<TResult|TResultDefault>} */ find(objectStoreName, indexName, query, predicate, predicateArg, defaultValue) { return new Promise((resolve, reject) => { const transaction = this.transaction([objectStoreName], 'readonly'); const objectStore = transaction.objectStore(objectStoreName); const objectStoreOrIndex = indexName !== null ? objectStore.index(indexName) : objectStore; this.findFirst(objectStoreOrIndex, query, resolve, reject, null, predicate, predicateArg, defaultValue); }); } /** * @template TData * @template TPredicateArg * @template [TResult=unknown] * @template [TResultDefault=unknown] * @param {IDBObjectStore|IDBIndex} objectStoreOrIndex * @param {?IDBValidKey|IDBKeyRange} query * @param {(value: TResult|TResultDefault, data: TData) => void} resolve * @param {(reason: unknown, data: TData) => void} reject * @param {TData} data * @param {?((value: TResult, predicateArg: TPredicateArg) => boolean)} predicate * @param {TPredicateArg} predicateArg * @param {TResultDefault} defaultValue */ findFirst(objectStoreOrIndex, query, resolve, reject, data, predicate, predicateArg, defaultValue) { const noPredicate = (typeof predicate !== 'function'); const request = objectStoreOrIndex.openCursor(query, 'next'); request.onerror = (e) => reject(/** @type {IDBRequest<?IDBCursorWithValue>} */ (e.target).error, data); request.onsuccess = (e) => { const cursor = /** @type {IDBRequest<?IDBCursorWithValue>} */ (e.target).result; if (cursor) { const {value} = cursor; if (noPredicate || predicate(value, predicateArg)) { resolve(value, data); } else { cursor.continue(); } } else { resolve(defaultValue, data); } }; } /** * @param {import('database').CountTarget[]} targets * @param {(results: number[]) => void} resolve * @param {(reason?: unknown) => void} reject */ bulkCount(targets, resolve, reject) { const targetCount = targets.length; if (targetCount <= 0) { resolve([]); return; } let completedCount = 0; /** @type {number[]} */ const results = new Array(targetCount).fill(null); /** * @param {Event} e * @returns {void} */ const onError = (e) => reject(/** @type {IDBRequest<number>} */ (e.target).error); /** * @param {Event} e * @param {number} index */ const onSuccess = (e, index) => { const count = /** @type {IDBRequest<number>} */ (e.target).result; results[index] = count; if (++completedCount >= targetCount) { resolve(results); } }; for (let i = 0; i < targetCount; ++i) { const index = i; const [objectStoreOrIndex, query] = targets[i]; const request = objectStoreOrIndex.count(query); request.onerror = onError; request.onsuccess = (e) => onSuccess(e, index); } } /** * @param {TObjectStoreName} objectStoreName * @param {IDBValidKey|IDBKeyRange} key * @returns {Promise<void>} */ delete(objectStoreName, key) { return new Promise((resolve, reject) => { const transaction = this._readWriteTransaction([objectStoreName], resolve, reject); const objectStore = transaction.objectStore(objectStoreName); objectStore.delete(key); transaction.commit(); }); } /** * @param {TObjectStoreName} objectStoreName * @param {?string} indexName * @param {IDBKeyRange} query * @param {?(keys: IDBValidKey[]) => IDBValidKey[]} filterKeys * @param {?(completedCount: number, totalCount: number) => void} onProgress * @returns {Promise<void>} */ bulkDelete(objectStoreName, indexName, query, filterKeys=null, onProgress=null) { return new Promise((resolve, reject) => { const transaction = this._readWriteTransaction([objectStoreName], resolve, reject); const objectStore = transaction.objectStore(objectStoreName); const objectStoreOrIndex = indexName !== null ? objectStore.index(indexName) : objectStore; /** * @param {IDBValidKey[]} keys */ const onGetKeys = (keys) => { try { if (typeof filterKeys === 'function') { keys = filterKeys(keys); } this._bulkDeleteInternal(objectStore, keys, onProgress); transaction.commit(); } catch (e) { reject(e); } }; this.getAllKeys(objectStoreOrIndex, query, onGetKeys, reject); }); } /** * @param {string} databaseName * @returns {Promise<void>} */ static deleteDatabase(databaseName) { return new Promise((resolve, reject) => { const request = indexedDB.deleteDatabase(databaseName); request.onerror = (e) => reject(/** @type {IDBRequest} */ (e.target).error); request.onsuccess = () => resolve(); request.onblocked = () => reject(new Error('Database deletion blocked')); }); } // Private /** * @param {string} name * @param {number} version * @param {import('database').UpdateFunction} onUpgradeNeeded * @returns {Promise<IDBDatabase>} */ _open(name, version, onUpgradeNeeded) { return new Promise((resolve, reject) => { const request = indexedDB.open(name, version); request.onupgradeneeded = (event) => { try { const transaction = /** @type {IDBTransaction} */ (request.transaction); transaction.onerror = (e) => reject(/** @type {IDBRequest} */ (e.target).error); onUpgradeNeeded(request.result, transaction, event.oldVersion, event.newVersion); } catch (e) { reject(e); } }; request.onerror = (e) => reject(/** @type {IDBRequest} */ (e.target).error); request.onsuccess = () => resolve(request.result); }); } /** * @param {IDBDatabase} db * @param {IDBTransaction} transaction * @param {number} oldVersion * @param {import('database').StructureDefinition<TObjectStoreName>[]} upgrades */ _upgrade(db, transaction, oldVersion, upgrades) { for (const {version, stores} of upgrades) { if (oldVersion >= version) { continue; } for (const [objectStoreName, {primaryKey, indices}] of Object.entries(stores)) { const existingObjectStoreNames = transaction.objectStoreNames || db.objectStoreNames; const objectStore = ( this._listContains(existingObjectStoreNames, objectStoreName) ? transaction.objectStore(objectStoreName) : db.createObjectStore(objectStoreName, primaryKey) ); const existingIndexNames = objectStore.indexNames; for (const indexName of indices) { if (this._listContains(existingIndexNames, indexName)) { continue; } objectStore.createIndex(indexName, indexName, {}); } } } } /** * @param {DOMStringList} list * @param {string} value * @returns {boolean} */ _listContains(list, value) { for (let i = 0, ii = list.length; i < ii; ++i) { if (list[i] === value) { return true; } } return false; } /** * @template [TData=unknown] * @template [TResult=unknown] * @param {IDBObjectStore|IDBIndex} objectStoreOrIndex * @param {?IDBValidKey|IDBKeyRange} query * @param {(results: TResult[], data: TData) => void} onSuccess * @param {(reason: unknown, data: TData) => void} onReject * @param {TData} data */ _getAllFast(objectStoreOrIndex, query, onSuccess, onReject, data) { const request = objectStoreOrIndex.getAll(query); request.onerror = (e) => onReject(/** @type {IDBRequest<import('core').SafeAny[]>} */ (e.target).error, data); request.onsuccess = (e) => onSuccess(/** @type {IDBRequest<import('core').SafeAny[]>} */ (e.target).result, data); } /** * @template [TData=unknown] * @template [TResult=unknown] * @param {IDBObjectStore|IDBIndex} objectStoreOrIndex * @param {?IDBValidKey|IDBKeyRange} query * @param {(results: TResult[], data: TData) => void} onSuccess * @param {(reason: unknown, data: TData) => void} onReject * @param {TData} data */ _getAllUsingCursor(objectStoreOrIndex, query, onSuccess, onReject, data) { /** @type {TResult[]} */ const results = []; const request = objectStoreOrIndex.openCursor(query, 'next'); request.onerror = (e) => onReject(/** @type {IDBRequest<?IDBCursorWithValue>} */ (e.target).error, data); request.onsuccess = (e) => { const cursor = /** @type {IDBRequest<?IDBCursorWithValue>} */ (e.target).result; if (cursor) { results.push(cursor.value); cursor.continue(); } else { onSuccess(results, data); } }; } /** * @param {IDBObjectStore|IDBIndex} objectStoreOrIndex * @param {IDBValidKey|IDBKeyRange} query * @param {(value: IDBValidKey[]) => void} onSuccess * @param {(reason?: unknown) => void} onError */ _getAllKeysFast(objectStoreOrIndex, query, onSuccess, onError) { const request = objectStoreOrIndex.getAllKeys(query); request.onerror = (e) => onError(/** @type {IDBRequest<IDBValidKey[]>} */ (e.target).error); request.onsuccess = (e) => onSuccess(/** @type {IDBRequest<IDBValidKey[]>} */ (e.target).result); } /** * @param {IDBObjectStore|IDBIndex} objectStoreOrIndex * @param {IDBValidKey|IDBKeyRange} query * @param {(value: IDBValidKey[]) => void} onSuccess * @param {(reason?: unknown) => void} onError */ _getAllKeysUsingCursor(objectStoreOrIndex, query, onSuccess, onError) { /** @type {IDBValidKey[]} */ const results = []; const request = objectStoreOrIndex.openKeyCursor(query, 'next'); request.onerror = (e) => onError(/** @type {IDBRequest<?IDBCursor>} */ (e.target).error); request.onsuccess = (e) => { const cursor = /** @type {IDBRequest<?IDBCursor>} */ (e.target).result; if (cursor) { results.push(cursor.primaryKey); cursor.continue(); } else { onSuccess(results); } }; } /** * @param {IDBObjectStore} objectStore * @param {IDBValidKey[]} keys * @param {?(completedCount: number, totalCount: number) => void} onProgress */ _bulkDeleteInternal(objectStore, keys, onProgress) { const count = keys.length; if (count === 0) { return; } let completedCount = 0; const onSuccess = () => { ++completedCount; try { /** @type {(completedCount: number, totalCount: number) => void}} */ (onProgress)(completedCount, count); } catch (e) { // NOP } }; const hasProgress = (typeof onProgress === 'function'); for (const key of keys) { const request = objectStore.delete(key); if (hasProgress) { request.onsuccess = onSuccess; } } } /** * @param {string[]} storeNames * @param {() => void} resolve * @param {(reason?: unknown) => void} reject * @returns {IDBTransaction} */ _readWriteTransaction(storeNames, resolve, reject) { const transaction = this.transaction(storeNames, 'readwrite'); transaction.onerror = (e) => reject(/** @type {IDBTransaction} */ (e.target).error); transaction.onabort = () => reject(new Error('Transaction aborted')); transaction.oncomplete = () => resolve(); return transaction; } }