Skip to content

Node.js based forum software built for the modern web

2.7 KB
Raw Blame
'use strict';

const helpers = module.exports;

helpers.valueToString = function (value) {
	return String(value);
};

helpers.removeDuplicateValues = function (values, ...others) {
	for (let i = 0; i < values.length; i++) {
		if (values.lastIndexOf(values[i]) !== i) {
			values.splice(i, 1);
			for (let j = 0; j < others.length; j++) {
				others[j].splice(i, 1);
			}
			i -= 1;
		}
	}
};

helpers.ensureLegacyObjectType = async function (db, key, type) {
	await db.query({
		name: 'ensureLegacyObjectTypeBefore',
		text: `
DELETE FROM "legacy_object"
 WHERE "expireAt" IS NOT NULL
   AND "expireAt" <= CURRENT_TIMESTAMP`,
	});

	const res = await tryUpsert(db, {
		name: 'ensureLegacyObjectType_upsert',
		text: `
			INSERT INTO "legacy_object" ("_key", "type")
			VALUES ($1::TEXT, $2::TEXT::LEGACY_OBJECT_TYPE)
			ON CONFLICT ("_key")
			DO UPDATE SET "type" = "legacy_object"."type"
			RETURNING "type"`,
		values: [key, type],
	});

	if (res.rows[0].type !== type) {
		throw new Error(`database: cannot insert ${JSON.stringify(key)} as ${type} because it already exists as ${res.rows[0].type}`);
	}
};

helpers.ensureLegacyObjectsType = async function (db, keys, type) {
	keys = [...new Set(keys)];
	if (!keys.length) {
		return;
	}
	await db.query({
		name: 'ensureLegacyObjectTypeBefore',
		text: `
DELETE FROM "legacy_object"
 WHERE "expireAt" IS NOT NULL
   AND "expireAt" <= CURRENT_TIMESTAMP`,
	});

	const res = await tryUpsert(db, {
		name: 'ensureLegacyObjectsType_upsert',
		text: `
INSERT INTO "legacy_object" ("_key", "type")
SELECT k, $2::TEXT::LEGACY_OBJECT_TYPE
FROM UNNEST($1::TEXT[]) k
	ON CONFLICT ("_key")
	DO UPDATE SET "type" = "legacy_object"."type"
	RETURNING "_key", "type"`,
		values: [keys, type],
	});

	const invalid = res.rows.filter(r => r.type !== type);

	if (invalid.length) {
		const parts = invalid.map(r => `${JSON.stringify(r._key)} is ${r.type}`);
		throw new Error(`database: cannot insert multiple objects as ${type} because they already exist: ${parts.join(', ')}`);
	}
};

async function tryUpsert(db, queryConfig) {
	let res;
	const savepoint = `upsert_${Math.random().toString(36).substring(7)}`;
	try {
		await db.query(`SAVEPOINT ${savepoint}`);
		res = await db.query(queryConfig);
		await db.query(`RELEASE SAVEPOINT ${savepoint}`);
	} catch (err) {
		if (err.code === '23505') { // retry if failed due to error: unique constraint
			// Roll back to the savepoint to prevent
			// error: current transaction is aborted, commands ignored until end of transaction block
			await db.query(`ROLLBACK TO SAVEPOINT ${savepoint}`);
			res = await db.query(queryConfig);
			await db.query(`RELEASE SAVEPOINT ${savepoint}`);
		} else {
			throw err;
		}
	}
	return res;
}

helpers.noop = function () {};