D7122.id24363.diff
No OneTemporary
Actions

Size

987 B

Referenced Files

None

Subscribers

None

D7122.id24363.diff
View Options

	diff --git a/web/database/queries/draft-queries.js b/web/database/queries/draft-queries.js
	new file mode 100644
	--- /dev/null
	+++ b/web/database/queries/draft-queries.js
	@@ -0,0 +1,36 @@
	+// @flow
	+
	+import type { SqliteDatabase } from 'sql.js';
	+
	+function removeAllDrafts(db: SqliteDatabase) {
	+ db.exec(`DELETE FROM drafts`);
	+}
	+
	+function updateDraft(db: SqliteDatabase, key: string, text: string) {
	+ const query = `
	+ INSERT OR REPLACE INTO drafts (key, text)
	+ VALUES ($key, $text)
	+ `;
	+ const params = {
	+ $key: key,
	+ $text: text,
	+ };
	+
	+ db.exec(query, params);
	+}
	+
	+function moveDraft(db: SqliteDatabase, oldKey: string, newKey: string) {
	+ const query = `
	+ UPDATE OR REPLACE drafts
	+ SET key = $newKey, text = (SELECT text FROM drafts WHERE key = $oldKey)
	+ WHERE key = $oldKey
	+ `;
	+ const params = {
	+ $newKey: newKey,
	+ $oldKey: oldKey,
	+ };
	+
	+ db.exec(query, params);
	+}
	+
	+export { removeAllDrafts, updateDraft, moveDraft };