...
export * from './apis/getAircraftWithinRadius';
 

import { ConsumptionApi } from "@514labs/moose-lib";
import { tags } from "typia";
 
/**
 * Parameters for the getAircraftWithinRadius API
 */
interface AircraftRadiusParams {
  /** Latitude of the center point */
  center_lat: number;
  
  /** Longitude of the center point */
  center_lon: number;
  
  /** Radius in miles from the center point */
  radius_miles: number;
  
  /** Maximum number of results to return (optional) */
  limit?: number & tags.Type<"int64"> & tags.Minimum<1> & tags.Maximum<1000>;
}
 
/**
 * API to retrieve aircraft within a specified radius from given coordinates
 * Uses ClickHouse's geoDistance function to calculate great circle distance
 */
export const getAircraftWithinRadius = new ConsumptionApi<AircraftRadiusParams>(
  "getAircraftWithinRadius",
  async (params, { client, sql }) => {
    // Execute the query with proper parameter handling
    const result = await client.query.execute(sql`
      SELECT 
        hex,
        flight,
        aircraft_type,
        lat,
        lon,
        alt_baro,
        gs,
        track,
        timestamp,
        round(geoDistance(lon, lat, ${params.center_lon}, ${params.center_lat}) * 0.000621371, 2) as distance_miles
      FROM AircraftTrackingProcessed 
      WHERE geoDistance(lon, lat, ${params.center_lon}, ${params.center_lat}) * 0.000621371 <= ${params.radius_miles}
      ORDER BY distance_miles ASC
      LIMIT ${params.limit || 100}
    `);
    
    return result;
  },
  {
    metadata: {
      description: "Returns all aircraft within a specified distance (in miles) from given coordinates"
    }
  }
);