import { getSurrealDB } from '$lib/server/db';
import { serializeRecords } from '$lib/server/serialize';
import type { PageServerLoad } from './$types';

export const load: PageServerLoad = async () => {
  const db = await getSurrealDB();
  
  const [ads] = await db.query<[any[]]>(`
    SELECT 
      id,
      name,
      status,
      format,
      content,
      duration_seconds,
      user.id AS user_id,
      user.email AS user_email,
      user.first_name AS user_first_name,
      user.last_name AS user_last_name,
      company.id AS company_id,
      company.name AS company_name,
      is_active,
      created_at,
      updated_at
    FROM ad
    ORDER BY created_at DESC
  `);
  
  return {
    ads: serializeRecords(ads || [])
  };
};