Skip to content

Email for professionals and teams

1.4 KB
Raw Blame
/**
 * Whether any error in the chain has a message matching `pattern`. Drizzle
 * wraps driver errors as "Failed query: …" and keeps the driver message on
 * `cause`, so checking only the outer message misses it. The patterns cover
 * SQLite/D1, PostgreSQL and MySQL wording.
 */
function errorChainMatches(error: unknown, pattern: RegExp): boolean {
	let current: unknown = error;
	const visited = new Set<unknown>();
	while (current && !visited.has(current)) {
		visited.add(current);
		if (pattern.test(current instanceof Error ? current.message : String(current))) return true;
		if (typeof current !== "object" || !("cause" in current)) break;
		current = (current as { cause?: unknown }).cause;
	}
	return false;
}

/** The table does not exist yet, for features whose migration may not be applied. */
export function isMissingTableError(error: unknown): boolean {
	return errorChainMatches(error, /no such table|relation "[^"]+" does not exist|table '[^']+' doesn't exist/i);
}

/** A column added by a migration that may not be applied yet. */
export function isMissingColumnError(error: unknown): boolean {
	return errorChainMatches(error, /no such column|has no column named|column "[^"]+" (of relation "[^"]+" )?does not exist|unknown column/i);
}

export function isUniqueConstraintError(error: unknown): boolean {
	return errorChainMatches(error, /UNIQUE constraint failed|duplicate key value violates unique constraint|duplicate entry/i);
}