Page MenuHomePhorge

D7123.1765050656.diff
No OneTemporary

Size
993 B
Referenced Files
None
Subscribers
None

D7123.1765050656.diff

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 };

File Metadata

Mime Type
text/plain
Expires
Sat, Dec 6, 7:50 PM (14 h, 47 m)
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
5840500
Default Alt Text
D7123.1765050656.diff (993 B)

Event Timeline