Differential D6714 Diff 22560 keyserver/src/database/migration-config.js

Changeset View

Standalone View

keyserver/src/database/migration-config.js

Show First 20 Lines • Show All 141 Lines • ▼ Show 20 Lines	const migrations: $ReadOnlyMap<number, () => Promise<void>> = new Map([
[		[
14,		14,
async () => {		async () => {
await dbQuery(SQL`		await dbQuery(SQL`
ALTER TABLE cookies MODIFY COLUMN social_proof mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL;		ALTER TABLE cookies MODIFY COLUMN social_proof mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL;
`);		`);
},		},
],		],
		[
		15,
		async () => {
		await dbQuery(
		SQL`
		ALTER TABLE cookies
		DROP INDEX device_token,
		DROP INDEX user_device_token;

		ALTER TABLE cookies
		MODIFY device_token mediumtext
		CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
		ADD UNIQUE KEY device_token (device_token(512)),
		ADD KEY user_device_token (user,device_token(512));
		`,
		{ multipleStatements: true },
		);
		},
		],
]);		]);
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