import { db } from "@/lib/db";
import { youtubeVideos, users } from "@/lib/db/schema";
import { eq } from "drizzle-orm";
import { NextResponse } from "next/server";

export async function GET(request: Request) {
    const { searchParams } = new URL(request.url);
    const videoId = searchParams.get('id');
    const deleteId = searchParams.get('deleteId');

    if (deleteId) {
        await db.delete(youtubeVideos).where(eq(youtubeVideos.id, deleteId));
        return NextResponse.json({ success: true, deleted: deleteId });
    }

    if (!videoId) return NextResponse.json({ error: "Missing id" }, { status: 400 });

    const videos = await db.select().from(youtubeVideos).where(eq(youtubeVideos.videoId, videoId));

    const usersList = await db.query.users.findMany();

    return NextResponse.json({ videos, users: usersList });
}