import { serverSupabaseServiceRole } from '#supabase/server'

export default defineCachedEventHandler(async (event) => {
  const supabase = serverSupabaseServiceRole(event)

  const { data, error } = await supabase
    .from('airlines')
    .select('iata, icao, name, logo_url, website, booking_url, booking_url_template')
    .order('name')

  if (error) throw createError({ statusCode: 500, message: error.message })

  return { airlines: data }
}, { maxAge: 60 * 60 * 24 }) // cache 24h