Skip to content

armgit / Cap

Public Imported from GitHub
0

Open source Loom alternative. Beautiful, shareable screen recordings.

2.4 KB
Raw Blame
import "server-only";

import { db } from "@cap/database";
import {
	mcpOAuthClients,
	mcpOAuthCodes,
	mcpOAuthRegistrationQuotas,
	mcpOAuthTokens,
} from "@cap/database/schema";
import { and, eq, gt, isNull, lt, notExists } from "drizzle-orm";

const affectedRows = (value: unknown) => {
	const result = Array.isArray(value) ? value[0] : value;
	return (result as { affectedRows?: number } | undefined)?.affectedRows ?? 0;
};

export const cleanupExpiredMcpRecords = async (now = new Date()) => {
	const database = db();
	let codes = 0;
	let tokens = 0;
	let clients = 0;
	let quotas = 0;
	for (let batch = 0; batch < 10; batch += 1) {
		const deleted = affectedRows(
			await database
				.delete(mcpOAuthCodes)
				.where(lt(mcpOAuthCodes.expiresAt, now))
				.limit(1_000),
		);
		codes += deleted;
		if (deleted < 1_000) break;
	}
	for (let batch = 0; batch < 10; batch += 1) {
		const deleted = affectedRows(
			await database
				.delete(mcpOAuthTokens)
				.where(lt(mcpOAuthTokens.refreshExpiresAt, now))
				.limit(1_000),
		);
		tokens += deleted;
		if (deleted < 1_000) break;
	}
	const unusedBefore = new Date(now.getTime() - 24 * 60 * 60_000);
	for (let batch = 0; batch < 10; batch += 1) {
		const deleted = affectedRows(
			await database
				.delete(mcpOAuthClients)
				.where(
					and(
						isNull(mcpOAuthClients.activatedAt),
						lt(mcpOAuthClients.createdAt, unusedBefore),
					),
				)
				.limit(1_000),
		);
		clients += deleted;
		if (deleted < 1_000) break;
	}
	const staleBefore = new Date(now.getTime() - 90 * 24 * 60 * 60_000);
	for (let batch = 0; batch < 10; batch += 1) {
		const deleted = affectedRows(
			await database
				.delete(mcpOAuthClients)
				.where(
					and(
						lt(mcpOAuthClients.activatedAt, staleBefore),
						notExists(
							database
								.select({ id: mcpOAuthTokens.id })
								.from(mcpOAuthTokens)
								.where(
									and(
										eq(mcpOAuthTokens.clientId, mcpOAuthClients.clientId),
										isNull(mcpOAuthTokens.revokedAt),
										gt(mcpOAuthTokens.refreshExpiresAt, now),
									),
								),
						),
					),
				)
				.limit(1_000),
		);
		clients += deleted;
		if (deleted < 1_000) break;
	}
	for (let batch = 0; batch < 10; batch += 1) {
		const deleted = affectedRows(
			await database
				.delete(mcpOAuthRegistrationQuotas)
				.where(lt(mcpOAuthRegistrationQuotas.expiresAt, now))
				.limit(1_000),
		);
		quotas += deleted;
		if (deleted < 1_000) break;
	}
	return { codes, tokens, clients, quotas };
};