import { json, type RequestHandler } from '@sveltejs/kit';
import { getSurrealDB } from '$lib/server/db';

export const POST: RequestHandler = async ({ locals }) => {
	// Vérifier que c'est un admin
	if (locals.user?.role !== 'admin') {
		return json({ error: 'Unauthorized' }, { status: 403 });
	}

	try {
		const db = await getSurrealDB();

		console.log('[reset-thumbnails] Resetting video thumbnails...');

		// Réinitialiser tous les thumbnails des vidéos
		const result = await db.query('UPDATE media SET thumbnail_url = null WHERE type = "video"');

		console.log('[reset-thumbnails] Update result:', result);

		// Vérifier les vidéos
		const videos = await db.query<[any[]]>('SELECT * FROM media WHERE type = "video"');
		console.log('[reset-thumbnails] Videos count:', videos[0]?.length || 0);

		return json({
			success: true,
			message: 'Thumbnails reset',
			videosReset: videos[0]?.length || 0
		});
	} catch (error) {
		console.error('[reset-thumbnails] Error:', error);
		return json(
			{ error: error instanceof Error ? error.message : 'Unknown error' },
			{ status: 500 }
		);
	}
};