import type { APIRoute } from "astro";

import { requirePerm } from "#api/authorize.js";
import { requireDb, unwrapResult } from "#api/error.js";
import { handleMediaUsageWorkList } from "#api/handlers/media-usage-work.js";
import { isParseError, parseQuery } from "#api/parse.js";
import { mediaUsageWorkListQuery } from "#api/schemas.js";

export const prerender = false;

export const GET: APIRoute = async ({ request, locals }) => {
	const { emdash, user } = locals;
	const dbErr = requireDb(emdash?.db);
	if (dbErr) return dbErr;

	const denied = requirePerm(user, "schema:manage");
	if (denied) return denied;

	const query = parseQuery(new URL(request.url), mediaUsageWorkListQuery);
	if (isParseError(query)) return query;

	return unwrapResult(await handleMediaUsageWorkList(emdash.db, query));
};