D7123.1768429911.diff
No OneTemporary
Actions

Size

993 B

Referenced Files

None

Subscribers

None

D7123.1768429911.diff
View Options

	diff --git a/web/database/queries/draft-queries.js b/web/database/queries/draft-queries.js
	--- a/web/database/queries/draft-queries.js
	+++ b/web/database/queries/draft-queries.js
	@@ -1,6 +1,10 @@
	// @flow

	-import type { SqliteDatabase } from 'sql.js';
	+import { SqliteDatabase } from 'sql.js';
	+
	+import type { ClientDBDraftInfo } from 'lib/types/draft-types.js';
	+
	+import { parseMultiStatementSQLiteResult } from '../utils/db-utils.js';

	function removeAllDrafts(db: SqliteDatabase) {
	db.exec(`DELETE FROM drafts`);
	@@ -33,4 +37,15 @@
	db.exec(query, params);
	}

	-export { removeAllDrafts, updateDraft, moveDraft };
	+function getAllDrafts(db: SqliteDatabase): ClientDBDraftInfo[] {
	+ const rawDBResult = db.exec(`SELECT * FROM drafts`);
	+ const dbResult =
	+ parseMultiStatementSQLiteResult<ClientDBDraftInfo>(rawDBResult);
	+ if (dbResult.length === 0) {
	+ return [];
	+ }
	+
	+ return dbResult[0];
	+}
	+
	+export { removeAllDrafts, updateDraft, moveDraft, getAllDrafts };