import { applyGlobalScopes } from '../scope/apply-global-scopes'
import { applyWithAggregates } from '../aggregate/apply-with-aggregates'
import { applyOrderByAggregates } from '../aggregate/apply-order-by-aggregates'
import { loadRelations } from '../relation/load-relations'



export async function getFirst(query: any) {
  applyGlobalScopes(query)
  applyWithAggregates(query)
  applyOrderByAggregates(query)

  const rows = await query.limit(1)
  let result = query.$model.hydrate(rows)

  if (query._withTree && Object.keys(query._withTree).length) {
    await loadRelations(result, query.$model, query._withTree)
  }

  if (!result.at(0)) return null

  result.at(0).__expandedAttributes = Object.keys(query._withTree || {}).filter(k => query._withTree[k]?.__attribute)

  if (query._formatter) {
    result = result.map(query._formatter).at(0)
  }

  return result.at(0)
}