Skip to content

armgit / Cap

Public Imported from GitHub
0

Open source Loom alternative. Beautiful, shareable screen recordings.

2.0 KB
Raw Blame
import "server-only";

import { db } from "@cap/database";
import { videos } from "@cap/database/schema";
import { type User, Video } from "@cap/web-domain";
import { and, count, eq, gte, lt, or } from "drizzle-orm";

const monthStartUtc = (reference: Date) =>
	new Date(Date.UTC(reference.getUTCFullYear(), reference.getUTCMonth(), 1));

const quotaWindowStart = (reference: Date) => {
	const start = monthStartUtc(reference);
	return start > Video.SHAREABLE_LINK_LIMIT_ENFORCED_FROM
		? start
		: Video.SHAREABLE_LINK_LIMIT_ENFORCED_FROM;
};

/**
 * A video is over quota when 25 or more of the owner's videos were created
 * earlier in the same calendar month (UTC). The flag is derived from creation
 * order, so it sticks to the video across month boundaries, disappears the
 * moment the owner upgrades (callers skip the check for Pro owners), and
 * frees up if earlier videos from that month are deleted.
 */
export async function isVideoOverShareableLinkLimit(video: {
	id: Video.VideoId;
	ownerId: User.UserId;
	createdAt: Date;
	isScreenshot: boolean;
}): Promise<boolean> {
	if (video.isScreenshot) return false;
	if (video.createdAt < Video.SHAREABLE_LINK_LIMIT_ENFORCED_FROM) return false;

	const [row] = await db()
		.select({ earlier: count() })
		.from(videos)
		.where(
			and(
				eq(videos.ownerId, video.ownerId),
				eq(videos.isScreenshot, false),
				gte(videos.createdAt, quotaWindowStart(video.createdAt)),
				or(
					lt(videos.createdAt, video.createdAt),
					and(eq(videos.createdAt, video.createdAt), lt(videos.id, video.id)),
				),
			),
		);

	return (row?.earlier ?? 0) >= Video.FREE_PLAN_SHAREABLE_LINKS_PER_MONTH;
}

export async function getShareableLinkUsage(userId: User.UserId): Promise<{
	used: number;
	limit: number;
}> {
	const [row] = await db()
		.select({ used: count() })
		.from(videos)
		.where(
			and(
				eq(videos.ownerId, userId),
				eq(videos.isScreenshot, false),
				gte(videos.createdAt, quotaWindowStart(new Date())),
			),
		);

	return {
		used: row?.used ?? 0,
		limit: Video.FREE_PLAN_SHAREABLE_LINKS_PER_MONTH,
	};
}