import { json } from "@sveltejs/kit";
import type { RequestHandler } from "./$types";
import type { ImageItem } from "$lib";

const R2_BASE_URL = "https://r2.steve.photo";
const PAGE_SIZE = 15;

export const GET: RequestHandler = async ({ url, platform }) => {
	const db = platform?.env?.DB;
	const offset = parseInt(url.searchParams.get("offset") || "0", 10);

	const result = await db
		.prepare("SELECT * FROM photos ORDER BY date DESC LIMIT ? OFFSET ?")
		.bind(PAGE_SIZE, offset)
		.all();

	const photos: ImageItem[] = result.results.map(
		(row: Record<string, unknown>) => ({
			slug: row.slug as string,
			title: row.title as string,
			date: row.date as string,
			image: `${R2_BASE_URL}/${row.image_key}`,
			thumb: `${R2_BASE_URL}/${row.thumb_key}`,
			type: row.type as string,
			camera: row.camera as string,
			lens: row.lens as string,
			aperture: row.aperture as string,
			exposure: row.exposure as string,
			focalLength: row.focal_length as string,
			iso: row.iso as string,
			make: row.make as string,
			blurData: row.blur_data as string,
		}),
	);

	return json({ photos });
};