Differential D7984 Diff 27312 web/database/queries/db-queries.js

Changeset View

Standalone View

Show All 32 Lines	CREATE TABLE IF NOT EXISTS metadata (
name TEXT UNIQUE PRIMARY KEY NOT NULL,		name TEXT UNIQUE PRIMARY KEY NOT NULL,
data TEXT NOT NULL		data TEXT NOT NULL
);		);

CREATE TABLE IF NOT EXISTS persist_storage (		CREATE TABLE IF NOT EXISTS persist_storage (
key TEXT UNIQUE PRIMARY KEY NOT NULL,		key TEXT UNIQUE PRIMARY KEY NOT NULL,
item TEXT NOT NULL		item TEXT NOT NULL
);		);

		CREATE TABLE IF NOT EXISTS reports (
		id TEXT UNIQUE PRIMARY KEY NOT NULL,
		report TEXT NOT NULL
		);
`);		`);
const migrationKeys = migrations.size ? migrations.keys() : [0];		const migrationKeys = migrations.size ? migrations.keys() : [0];
const newDatabaseVersion = Math.max(...migrationKeys);		const newDatabaseVersion = Math.max(...migrationKeys);
setSQLiteDBVersion(db, newDatabaseVersion);		setSQLiteDBVersion(db, newDatabaseVersion);
}		}

function migrate(sqliteDb: SqliteDatabase): boolean {		function migrate(sqliteDb: SqliteDatabase): boolean {
const dbVersion = getSQLiteDBVersion(sqliteDb);		const dbVersion = getSQLiteDBVersion(sqliteDb);
Show All 21 Lines