Differential D7199 Diff 24993 keyserver/src/database/migration-config.js

Changeset View

Standalone View

Show First 20 Lines • Show All 303 Lines • ▼ Show 20 Lines	async () => {
await dbQuery(SQL`		await dbQuery(SQL`
ALTER TABLE messages		ALTER TABLE messages
ADD COLUMN IF NOT EXISTS pinned tinyint(1) UNSIGNED NOT NULL DEFAULT 0,		ADD COLUMN IF NOT EXISTS pinned tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
ADD COLUMN IF NOT EXISTS pin_time bigint(20) DEFAULT NULL,		ADD COLUMN IF NOT EXISTS pin_time bigint(20) DEFAULT NULL,
ADD INDEX IF NOT EXISTS thread_pinned (thread, pinned);		ADD INDEX IF NOT EXISTS thread_pinned (thread, pinned);
`);		`);
},		},
],		],
		[
		28,
		async () => {
		await dbQuery(SQL`
		ALTER TABLE threads
		ADD COLUMN IF NOT EXISTS pinned_count int UNSIGNED NOT NULL DEFAULT 0;
		`);
		},
		],
]);		]);
const newDatabaseVersion: number = Math.max(...migrations.keys());		const newDatabaseVersion: number = Math.max(...migrations.keys());

async function writeJSONToFile(data: any, filePath: string): Promise<void> {		async function writeJSONToFile(data: any, filePath: string): Promise<void> {
console.warn(`updating ${filePath} to ${JSON.stringify(data)}`);		console.warn(`updating ${filePath} to ${JSON.stringify(data)}`);
const fileHandle = await fs.promises.open(filePath, 'w');		const fileHandle = await fs.promises.open(filePath, 'w');
await fileHandle.writeFile(JSON.stringify(data, null, ' '), 'utf8');		await fileHandle.writeFile(JSON.stringify(data, null, ' '), 'utf8');
await fileHandle.close();		await fileHandle.close();
▲ Show 20 Lines • Show All 89 Lines • Show Last 20 Lines