import { asc } from 'drizzle-orm';
import { invites } from '~~/drizzle/schema';
import { db } from '~~/server/lib/db';

export default defineEventHandler(async (event) => {
    await protectAdminRoute(event);

    await deleteDeadInvites();

    return await db
        .select({
            id: invites.id,
            token: invites.token,
            maxUses: invites.maxUses,
            uses: invites.uses,
            expiresAt: invites.expiresAt,
            createdAt: invites.createdAt,
        })
        .from(invites)
        .orderBy(asc(invites.createdAt));
});