import type { ImageItem } from "$lib/types";

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

export async function getPhotos(
	platform: App.Platform | undefined,
): Promise<ImageItem[]> {
	const db = platform?.env?.DB;

	if (!db) {
		return [];
	}

	const result = await db
		.prepare("SELECT * FROM photos ORDER BY date DESC")
		.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,
			tags: [],
			blurData: row.blur_data as string,
		}),
	);

	return photos;
}