import type { PageServerLoad } from "./$types";

import type { ImageItem } from "$lib";

// R2 public URL - update this after enabling public access on your bucket

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

const PAGE_SIZE = 15;

export const load: PageServerLoad = async ({ platform }) => {

	const db = platform?.env?.DB;

	const result = await db

		.prepare("SELECT * FROM photos ORDER BY date DESC LIMIT ?")

		.bind(PAGE_SIZE)

		.all();

	const countResult = await db

		.prepare("SELECT COUNT(*) as total FROM photos")

		.first();

	const total = (countResult?.total as number) || 0;

	const photos: ImageItem[] = result.results.map(

		(row: Record<string, unknown>) => ({

			slug: row.slug,

			title: row.title,

			date: row.date,

			image: `${R2_BASE_URL}/${row.image_key}`,

			thumb: `${R2_BASE_URL}/${row.thumb_key}`,

			type: row.type,

			camera: row.camera,

			lens: row.lens,

			aperture: row.aperture,

			exposure: row.exposure,

			focalLength: row.focal_length,

			iso: row.iso,

			make: row.make,

			blurData: row.blur_data as string,

		}),

	);

	return { photos, total, pageSize: PAGE_SIZE };

};