Open source Loom alternative. Beautiful, shareable screen recordings.
Rust appcapcossloommacnextjsnextjs15open-sourceossreactrecordrustscreen-capturescreen-recorderscreenshotsolidjstauritauri-apptypescriptvite
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 };
};