StandBuddy

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_157":158,"_159":160},"routes/_app.x.$handle.$name",{"_97":96,"_32":45,"_105":87,"_27":106,"_13":14,"_107":-5,"_11":108,"_109":110,"_111":112,"_113":114,"_115":116,"_20":-5,"_117":-5,"_118":-5,"_119":25,"_120":121,"_122":123,"_124":-5,"_125":-5,"_126":127},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":-5,"_53":-5,"_18":54,"_55":-5,"_56":25,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":64,"_65":66,"_67":68,"_69":-5,"_70":71,"_72":71,"_73":74,"_75":74,"_76":74,"_77":71,"_78":71,"_79":80,"_81":82,"_83":84,"_85":25},"version",200,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","main.ts","latestPath","fileId","23a46dd0-3fa4-11f1-b5dd-42b51c65c3df","name","fileType","http","content","import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\nexport default async function (req: Request): Promise {\n const url = new URL(req.url);\n const from = url.searchParams.get(\"from\");\n const to = url.searchParams.get(\"to\");\n const deep = url.searchParams.get(\"deep\") === \"1\";\n const date = url.searchParams.get(\"date\");\n const refresh = url.searchParams.get(\"refresh\") === \"1\";\n const passedHubs = (url.searchParams.get(\"hubs\") || \"\").split(\",\").filter(\n Boolean,\n );\n\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS routes_cache (\n route_key TEXT PRIMARY KEY,\n routes_json TEXT,\n created_at INTEGER\n )`);\n\n if (!from || !to) {\n return new Response(getHTML(), {\n headers: { \"Content-Type\": \"text/html\" },\n });\n }\n\n const CACHE_TTL = 30 * 24 * 60 * 60;\n const cacheKey = deep ? `${from}-${to}-deep` : `${from}-${to}`;\n const now = Math.floor(Date.now() / 1000);\n\n if (!refresh) {\n try {\n const cached = await sqlite.execute(\n `SELECT routes_json, created_at FROM routes_cache WHERE route_key = ?`,\n [cacheKey],\n );\n if (cached.rows.length > 0) {\n const age = now - Number(cached.rows[0][1]);\n if (age < CACHE_TTL) {\n const data = JSON.parse(String(cached.rows[0][0]));\n return new Response(\n JSON.stringify({\n ...data,\n cached: true,\n age_days: Math.floor(age / 86400),\n }),\n {\n headers: {\n \"Content-Type\": \"application/json\",\n \"Access-Control-Allow-Origin\": \"*\",\n },\n },\n );\n }\n }\n } catch (e) {}\n }\n\n const API_KEY = \"0a4f417693msh720c79bda8763c0p19c96fjsn6fbc5aa01ef8\";\n const HOST = \"aerodatabox.p.rapidapi.com\";\n const MAJOR = [\n \"HKG\",\n \"SIN\",\n \"DXB\",\n \"DOH\",\n \"LHR\",\n \"CDG\",\n \"FRA\",\n \"AMS\",\n \"IST\",\n \"JFK\",\n \"LAX\",\n \"MIA\",\n \"ORD\",\n \"ATL\",\n \"IAH\",\n \"DFW\",\n \"EWR\",\n \"YYZ\",\n \"ICN\",\n \"PVG\",\n \"BKK\",\n \"KUL\",\n \"MAD\",\n \"LIS\",\n \"FCO\",\n \"EZE\",\n \"SCL\",\n \"BOG\",\n \"LIM\",\n \"PTY\",\n \"MEX\",\n \"GRU\",\n \"CGH\",\n \"GIG\",\n \"BSB\",\n \"SSA\",\n \"FOR\",\n \"REC\",\n \"MAO\",\n \"CWB\",\n \"POA\",\n ];\n\n const KNOWN_INTL: Record = {\n \"GRU\": [\n \"MIA\",\n \"JFK\",\n \"LAX\",\n \"ORD\",\n \"ATL\",\n \"IAH\",\n \"DFW\",\n \"BOS\",\n \"EWR\",\n \"YUL\",\n \"YYZ\",\n \"LHR\",\n \"CDG\",\n \"FRA\",\n \"MAD\",\n \"LIS\",\n \"FCO\",\n \"MXP\",\n \"ZRH\",\n \"MUC\",\n \"BCN\",\n \"EZE\",\n \"SCL\",\n \"BOG\",\n \"LIM\",\n \"PTY\",\n \"DXB\",\n \"DOH\",\n \"NBO\",\n \"ADD\",\n \"JNB\",\n \"CMN\",\n \"HKG\",\n \"GIG\",\n ],\n \"GIG\": [\n \"MIA\",\n \"JFK\",\n \"LHR\",\n \"CDG\",\n \"FRA\",\n \"MAD\",\n \"LIS\",\n \"EZE\",\n \"SCL\",\n \"BOG\",\n \"LIM\",\n ],\n \"BSB\": [\"MIA\", \"LIS\", \"MAD\", \"EZE\", \"SCL\", \"BOG\", \"LIM\"],\n \"FOR\": [\"LIS\", \"MAD\"],\n \"REC\": [\"LIS\", \"MAD\", \"MIA\"],\n \"SSA\": [\"LIS\", \"MAD\"],\n \"CGH\": [\"MIA\", \"EZE\", \"SCL\", \"BOG\", \"LIM\", \"PTY\"],\n };\n\n const C: Record = {\n \"GRU\": [-23.43, -46.47],\n \"GIG\": [-22.81, -43.25],\n \"SDU\": [-22.91, -43.16],\n \"BSB\": [-15.87, -47.92],\n \"CGH\": [-23.63, -46.66],\n \"SSA\": [-12.91, -38.33],\n \"FOR\": [-3.78, -38.53],\n \"REC\": [-8.13, -34.92],\n \"MAO\": [-3.04, -60.05],\n \"CWB\": [-25.53, -49.17],\n \"POA\": [-29.99, -51.17],\n \"PVH\": [-8.71, -63.90],\n \"NAT\": [-5.91, -35.25],\n \"THE\": [-5.06, -42.82],\n \"MCZ\": [-9.51, -35.79],\n \"JPA\": [-7.14, -34.95],\n \"CGR\": [-20.47, -54.67],\n \"CGB\": [-15.65, -56.12],\n \"BEL\": [-1.38, -48.48],\n \"SLZ\": [-2.59, -44.23],\n \"PMW\": [-10.29, -48.36],\n \"GYN\": [-16.63, -49.22],\n \"AJU\": [-10.98, -37.07],\n \"VIX\": [-20.26, -40.29],\n \"FLN\": [-27.67, -48.55],\n \"LDB\": [-23.33, -51.13],\n \"UDI\": [-18.88, -48.22],\n \"CNF\": [-19.62, -43.97],\n \"IGU\": [-25.60, -54.49],\n \"EZE\": [-34.82, -58.54],\n \"AEP\": [-34.56, -58.42],\n \"COR\": [-31.31, -64.21],\n \"ROS\": [-32.90, -60.79],\n \"MDZ\": [-32.83, -68.79],\n \"MVD\": [-34.82, -56.01],\n \"SCL\": [-33.39, -70.79],\n \"LIM\": [-12.02, -77.11],\n \"BOG\": [4.70, -74.15],\n \"MDE\": [6.17, -75.43],\n \"UIO\": [-0.13, -78.36],\n \"GYE\": [-2.16, -79.88],\n \"ASU\": [-25.24, -57.52],\n \"CCS\": [10.60, -66.99],\n \"LPB\": [-16.51, -68.19],\n \"VVI\": [-17.64, -63.13],\n \"PTY\": [9.07, -79.38],\n \"GUA\": [14.58, -90.53],\n \"HAV\": [22.99, -82.41],\n \"SDQ\": [18.43, -69.67],\n \"NRT\": [35.76, 140.38],\n \"HND\": [35.55, 139.78],\n \"KIX\": [34.43, 135.23],\n \"ICN\": [37.46, 126.44],\n \"PEK\": [40.08, 116.58],\n \"PVG\": [31.14, 121.80],\n \"HKG\": [22.31, 113.92],\n \"TPE\": [25.08, 121.23],\n \"MNL\": [14.51, 121.02],\n \"SIN\": [1.36, 103.99],\n \"KUL\": [2.74, 101.71],\n \"BKK\": [13.69, 100.75],\n \"CGK\": [-6.13, 106.65],\n \"DPS\": [-8.75, 115.17],\n \"SGN\": [10.82, 106.65],\n \"HAN\": [21.22, 105.81],\n \"BOM\": [19.09, 72.87],\n \"DEL\": [28.56, 77.10],\n \"DXB\": [25.25, 55.36],\n \"AUH\": [24.43, 54.65],\n \"DOH\": [25.27, 51.61],\n \"RUH\": [24.96, 46.70],\n \"JED\": [21.68, 39.16],\n \"TLV\": [31.99, 34.90],\n \"IST\": [41.27, 28.74],\n \"ATH\": [37.94, 23.94],\n \"FCO\": [41.80, 12.25],\n \"MXP\": [45.63, 8.72],\n \"MAD\": [40.47, -3.56],\n \"BCN\": [41.30, 2.08],\n \"LIS\": [38.77, -9.13],\n \"CDG\": [49.01, 2.55],\n \"LHR\": [51.48, -0.45],\n \"LGW\": [51.16, -0.18],\n \"AMS\": [52.31, 4.77],\n \"FRA\": [50.03, 8.57],\n \"MUC\": [48.35, 11.79],\n \"BER\": [52.37, 13.50],\n \"VIE\": [48.11, 16.57],\n \"ZRH\": [47.46, 8.55],\n \"OPO\": [41.24, -8.68],\n \"DUB\": [53.42, -6.27],\n \"BRU\": [50.90, 4.48],\n \"JFK\": [40.64, -73.78],\n \"EWR\": [40.69, -74.17],\n \"LAX\": [33.94, -118.41],\n \"SFO\": [37.62, -122.38],\n \"SEA\": [47.45, -122.31],\n \"DEN\": [39.86, -104.67],\n \"ORD\": [41.98, -87.90],\n \"BOS\": [42.37, -71.01],\n \"IAD\": [38.94, -77.46],\n \"ATL\": [33.64, -84.43],\n \"MIA\": [25.80, -80.29],\n \"IAH\": [29.98, -95.34],\n \"DFW\": [32.90, -97.04],\n \"DTW\": [42.21, -83.35],\n \"YYZ\": [43.68, -79.63],\n \"YVR\": [49.19, -123.18],\n \"MEX\": [19.44, -99.07],\n \"CUN\": [21.04, -86.87],\n \"CLT\": [35.21, -80.94],\n \"MCO\": [28.43, -81.31],\n \"YUL\": [45.47, -73.74],\n \"FLL\": [26.07, -80.15],\n \"MSP\": [44.88, -93.22],\n \"YYC\": [51.13, -114.01],\n \"HNL\": [21.32, -157.92],\n \"ANC\": [61.17, -149.99],\n \"PDX\": [45.58, -122.59],\n \"LAS\": [36.08, -115.15],\n \"PHX\": [33.43, -112.01],\n \"SAN\": [32.73, -117.19],\n \"SLC\": [40.78, -111.97],\n \"SYD\": [-33.95, 151.18],\n \"MEL\": [-37.67, 144.83],\n \"BNE\": [-27.38, 153.12],\n \"AKL\": [-37.01, 174.79],\n \"CAI\": [30.11, 31.40],\n \"CMN\": [33.37, -7.59],\n \"LOS\": [6.58, 3.32],\n \"NBO\": [-1.32, 36.93],\n \"ADD\": [8.98, 38.80],\n \"JNB\": [-26.13, 28.24],\n \"CPT\": [-33.96, 18.60],\n \"CTS\": [42.77, 141.69],\n \"FUK\": [33.58, 130.45],\n \"OKA\": [26.19, 127.64],\n \"PUS\": [35.18, 128.93],\n \"CJU\": [33.51, 126.49],\n \"CAN\": [23.39, 113.30],\n \"CTU\": [30.57, 103.94],\n \"KHH\": [22.57, 120.35],\n \"CEB\": [10.30, 123.97],\n \"HKT\": [8.11, 98.30],\n \"CNX\": [18.77, 98.96],\n \"SUB\": [-7.37, 112.78],\n \"DAD\": [16.04, 108.20],\n \"BLR\": [13.19, 77.70],\n \"MAA\": [12.99, 80.17],\n \"CCU\": [22.65, 88.45],\n \"HYD\": [17.23, 78.43],\n \"AMM\": [31.72, 35.99],\n \"BAH\": [26.27, 50.63],\n \"MCT\": [23.59, 58.28],\n \"KWI\": [29.24, 47.97],\n \"DAR\": [-6.88, 39.20],\n \"EBB\": [0.04, 32.44],\n \"MRU\": [-20.43, 57.68],\n \"LAD\": [-8.85, 13.23],\n \"DKR\": [14.74, -17.49],\n \"ACC\": [5.60, -0.17],\n \"GDL\": [20.52, -103.31],\n \"CUZ\": [-13.54, -71.94],\n \"ROS\": [-32.90, -60.79],\n };\n\n const CONT: Record = {\n \"GRU\": \"SA\",\n \"CGH\": \"SA\",\n \"GIG\": \"SA\",\n \"SDU\": \"SA\",\n \"BSB\": \"SA\",\n \"SSA\": \"SA\",\n \"FOR\": \"SA\",\n \"REC\": \"SA\",\n \"MAO\": \"SA\",\n \"CWB\": \"SA\",\n \"POA\": \"SA\",\n \"MVD\": \"SA\",\n \"BOG\": \"SA\",\n \"LIM\": \"SA\",\n \"SCL\": \"SA\",\n \"EZE\": \"SA\",\n \"PVH\": \"SA\",\n \"THE\": \"SA\",\n \"NAT\": \"SA\",\n \"MCZ\": \"SA\",\n \"JPA\": \"SA\",\n \"CGR\": \"SA\",\n \"CGB\": \"SA\",\n \"BEL\": \"SA\",\n \"SLZ\": \"SA\",\n \"PMW\": \"SA\",\n \"GYN\": \"SA\",\n \"AJU\": \"SA\",\n \"VIX\": \"SA\",\n \"FLN\": \"SA\",\n \"LDB\": \"SA\",\n \"UDI\": \"SA\",\n \"CNF\": \"SA\",\n \"IGU\": \"SA\",\n \"AEP\": \"SA\",\n \"ASU\": \"SA\",\n \"VVI\": \"SA\",\n \"LPB\": \"SA\",\n \"UIO\": \"SA\",\n \"GYE\": \"SA\",\n \"CCS\": \"SA\",\n \"COR\": \"SA\",\n \"ROS\": \"SA\",\n \"MDZ\": \"SA\",\n \"MDE\": \"SA\",\n \"CUZ\": \"SA\",\n \"GUA\": \"SA\",\n \"HAV\": \"SA\",\n \"SDQ\": \"SA\",\n \"PTY\": \"SA\",\n \"VCP\": \"SA\",\n \"NRT\": \"AS\",\n \"HND\": \"AS\",\n \"KIX\": \"AS\",\n \"ICN\": \"AS\",\n \"PEK\": \"AS\",\n \"PVG\": \"AS\",\n \"HKG\": \"AS\",\n \"TPE\": \"AS\",\n \"MNL\": \"AS\",\n \"SIN\": \"AS\",\n \"KUL\": \"AS\",\n \"BKK\": \"AS\",\n \"CGK\": \"AS\",\n \"DPS\": \"AS\",\n \"SGN\": \"AS\",\n \"HAN\": \"AS\",\n \"BOM\": \"AS\",\n \"DEL\": \"AS\",\n \"DXB\": \"AS\",\n \"AUH\": \"AS\",\n \"DOH\": \"AS\",\n \"RUH\": \"AS\",\n \"JED\": \"AS\",\n \"TLV\": \"AS\",\n \"CTS\": \"AS\",\n \"FUK\": \"AS\",\n \"OKA\": \"AS\",\n \"PUS\": \"AS\",\n \"CJU\": \"AS\",\n \"CAN\": \"AS\",\n \"CTU\": \"AS\",\n \"KHH\": \"AS\",\n \"CEB\": \"AS\",\n \"HKT\": \"AS\",\n \"CNX\": \"AS\",\n \"SUB\": \"AS\",\n \"DAD\": \"AS\",\n \"BLR\": \"AS\",\n \"MAA\": \"AS\",\n \"CCU\": \"AS\",\n \"HYD\": \"AS\",\n \"AMM\": \"AS\",\n \"BAH\": \"AS\",\n \"MCT\": \"AS\",\n \"KWI\": \"AS\",\n \"IST\": \"EU\",\n \"ATH\": \"EU\",\n \"FCO\": \"EU\",\n \"MXP\": \"EU\",\n \"MAD\": \"EU\",\n \"BCN\": \"EU\",\n \"LIS\": \"EU\",\n \"CDG\": \"EU\",\n \"LHR\": \"EU\",\n \"LGW\": \"EU\",\n \"AMS\": \"EU\",\n \"FRA\": \"EU\",\n \"MUC\": \"EU\",\n \"BER\": \"EU\",\n \"VIE\": \"EU\",\n \"ZRH\": \"EU\",\n \"OPO\": \"EU\",\n \"DUB\": \"EU\",\n \"BRU\": \"EU\",\n \"WAW\": \"EU\",\n \"PRG\": \"EU\",\n \"BUD\": \"EU\",\n \"ARN\": \"EU\",\n \"OSL\": \"EU\",\n \"CPH\": \"EU\",\n \"HEL\": \"EU\",\n \"JFK\": \"NA\",\n \"EWR\": \"NA\",\n \"LAX\": \"NA\",\n \"SFO\": \"NA\",\n \"SEA\": \"NA\",\n \"DEN\": \"NA\",\n \"ORD\": \"NA\",\n \"BOS\": \"NA\",\n \"IAD\": \"NA\",\n \"ATL\": \"NA\",\n \"MIA\": \"NA\",\n \"IAH\": \"NA\",\n \"DFW\": \"NA\",\n \"DTW\": \"NA\",\n \"YYZ\": \"NA\",\n \"YVR\": \"NA\",\n \"MEX\": \"NA\",\n \"CUN\": \"NA\",\n \"CLT\": \"NA\",\n \"MCO\": \"NA\",\n \"YUL\": \"NA\",\n \"FLL\": \"NA\",\n \"MSP\": \"NA\",\n \"YYC\": \"NA\",\n \"GDL\": \"NA\",\n \"HNL\": \"NA\",\n \"ANC\": \"NA\",\n \"PDX\": \"NA\",\n \"LAS\": \"NA\",\n \"PHX\": \"NA\",\n \"SAN\": \"NA\",\n \"SLC\": \"NA\",\n \"SYD\": \"OC\",\n \"MEL\": \"OC\",\n \"BNE\": \"OC\",\n \"AKL\": \"OC\",\n \"PER\": \"OC\",\n \"ADL\": \"OC\",\n \"CAI\": \"AF\",\n \"CMN\": \"AF\",\n \"LOS\": \"AF\",\n \"NBO\": \"AF\",\n \"ADD\": \"AF\",\n \"JNB\": \"AF\",\n \"CPT\": \"AF\",\n \"ACC\": \"AF\",\n \"DKR\": \"AF\",\n \"DAR\": \"AF\",\n \"EBB\": \"AF\",\n \"MRU\": \"AF\",\n \"LAD\": \"AF\",\n };\n\n function delay(ms: number) {\n return new Promise((r) => setTimeout(r, ms));\n }\n\n function hvs(a: [number, number], b: [number, number]): number {\n const R = 6371,\n dLat = (b[0] - a[0]) * Math.PI / 180,\n dLon = (b[1] - a[1]) * Math.PI / 180;\n const s = Math.sin(dLat / 2) ** 2 +\n Math.cos(a[0] * Math.PI / 180) * Math.cos(b[0] * Math.PI / 180) *\n Math.sin(dLon / 2) ** 2;\n return R * 2 * Math.atan2(Math.sqrt(s), Math.sqrt(1 - s));\n }\n\n async function fetchRoutes(iata: string): Promise> {\n const map = new Map();\n try {\n const res = await fetch(\n `https://${HOST}/airports/iata/${iata}/stats/routes/daily`,\n {\n headers: { \"x-rapidapi-key\": API_KEY, \"x-rapidapi-host\": HOST },\n },\n );\n if (!res.ok) return map;\n const data = JSON.parse(await res.text());\n if (!data?.routes) return map;\n for (const route of data.routes) {\n const dest = route?.destination?.iata;\n if (!dest) continue;\n const airlines: string[] = (route.operators || []).filter((o: any) =>\n o?.iata\n ).map((o: any) => o.iata);\n if (airlines.length) map.set(dest, airlines);\n }\n } catch (e) {}\n return map;\n }\n\n async function fetchFlights(\n iata: string,\n dest: string,\n dateStr: string,\n ): Promise {\n try {\n const h = { \"x-rapidapi-key\": API_KEY, \"x-rapidapi-host\": HOST };\n const u1 =\n `https://${HOST}/flights/airports/iata/${iata}/${dateStr}T00:00/${dateStr}T11:59?withLeg=true&direction=Departure&withCancelled=false`;\n const u2 =\n `https://${HOST}/flights/airports/iata/${iata}/${dateStr}T12:00/${dateStr}T23:59?withLeg=true&direction=Departure&withCancelled=false`;\n const r1 = await fetch(u1, { headers: h });\n const d1 = JSON.parse(await r1.text());\n await delay(1500);\n const r2 = await fetch(u2, { headers: h });\n const d2 = JSON.parse(await r2.text());\n const all = [...(d1.departures || []), ...(d2.departures || [])];\n return all.filter((f: any) => f?.arrival?.airport?.iata === dest);\n } catch (e) {\n return [];\n }\n }\n\n const results: any[] = [];\n const seen = new Set();\n\n function addLegs(path: string[], legAls: string[][]) {\n const k = path.join(\"›\");\n if (seen.has(k)) return;\n seen.add(k);\n const conts = [\n ...new Set(path.slice(1, -1).map((p) => CONT[p]).filter(Boolean)),\n ];\n const c1 = C[path[0]], c2 = C[path[path.length - 1]];\n if (c1 && c2) {\n const dd = hvs(c1, c2);\n let td = 0, ok = true;\n for (let i = 0; i < path.length - 1; i++) {\n const ca = C[path[i]], cb = C[path[i + 1]];\n if (ca && cb) td += hvs(ca, cb);\n else ok = false;\n }\n if (ok) {\n const m = dd < 500 ? 1.5 : dd < 2000 ? 2 : 3;\n if (dd > 100 && td > dd * m) return;\n }\n }\n results.push({\n path,\n airlines: [...new Set(legAls.flat())],\n legAirlines: legAls,\n stops: path.length - 2,\n continents: conts,\n });\n }\n\n const depMap = passedHubs.length && deep\n ? new Map()\n : await fetchRoutes(from);\n if (!passedHubs.length || !deep) await delay(1500);\n const arrMapRaw = await fetchRoutes(to);\n const arrMap = new Map([...arrMapRaw]);\n for (const hub of (KNOWN_INTL[to] || [])) {\n if (!arrMap.has(hub)) arrMap.set(hub, []);\n }\n\n if (depMap.has(to)) addLegs([from, to], [depMap.get(to)!]);\n for (const [h1, al1] of depMap) {\n if (h1 === to) continue;\n if (arrMap.has(h1)) addLegs([from, h1, to], [al1, arrMap.get(h1)!]);\n }\n\n if (deep) {\n const hubs = [\n ...new Set([\n ...passedHubs,\n ...[...arrMap.keys()].filter((h) => h !== from && MAJOR.includes(h)),\n ]),\n ].slice(0, 15);\n for (const h1 of hubs) {\n await delay(1500);\n const hm = await fetchRoutes(h1);\n for (const [h2, al2] of hm) {\n if (h2 === from || h2 === h1) continue;\n if (h2 === to) addLegs([from, h1, to], [al2, arrMap.get(h1) || []]);\n else if (arrMap.has(h2)) {\n addLegs([from, h1, h2, to], [\n al2,\n hm.get(h2) || [],\n arrMap.get(h2) || [],\n ]);\n } else if (arrMap.has(h1) && passedHubs.includes(h2)) {\n addLegs([from, h2, h1, to], [\n al2,\n hm.get(h1) || [],\n arrMap.get(h1) || [],\n ]);\n }\n }\n }\n for (const prev of results.filter((r) => r.stops === 2).slice(0, 3)) {\n const h2 = prev.path[2];\n if (!MAJOR.includes(h2)) continue;\n await delay(1500);\n const dm = await fetchRoutes(h2);\n for (const [h3, al3] of dm) {\n if (prev.path.includes(h3)) continue;\n if (h3 === to) {\n addLegs([from, prev.path[1], h2, to], [...prev.legAirlines, al3]);\n } else if (arrMap.has(h3)) {\n addLegs([from, prev.path[1], h2, h3, to], [\n ...prev.legAirlines,\n al3,\n arrMap.get(h3) || [],\n ]);\n }\n }\n }\n const emptyHubs = new Set(\n results.filter((r) =>\n r.legAirlines[r.legAirlines.length - 1]?.length === 0\n ).map((r) => r.path[r.path.length - 2]),\n );\n for (const hub of emptyHubs) {\n await delay(1500);\n const hm = await fetchRoutes(hub);\n const als = hm.get(to) || [];\n if (als.length) {\n arrMap.set(hub, als);\n for (const r of results) {\n if (r.path[r.path.length - 2] === hub) {\n r.legAirlines[r.legAirlines.length - 1] = als;\n r.airlines = [...new Set(r.legAirlines.flat())];\n }\n }\n }\n }\n }\n\n results.sort((a, b) => a.stops - b.stops);\n const deduped = new Set();\n const finalRoutes = results.filter((r) => {\n const k = r.path.join(\"-\");\n if (deduped.has(k)) return false;\n deduped.add(k);\n return true;\n }).slice(0, 100);\n\n let flightSchedule: any[] = [];\n if (date && !deep && finalRoutes.some((r) => r.stops === 0)) {\n flightSchedule = await fetchFlights(from, to, date);\n }\n\n const payload = { routes: finalRoutes, flights: flightSchedule };\n\n try {\n await sqlite.execute(\n `INSERT OR REPLACE INTO routes_cache (route_key, routes_json, created_at) VALUES (?, ?, ?)`,\n [cacheKey, JSON.stringify(payload), now],\n );\n } catch (e) {}\n\n return new Response(JSON.stringify({ ...payload, cached: false }), {\n headers: {\n \"Content-Type\": \"application/json\",\n \"Access-Control-Allow-Origin\": \"*\",\n },\n });\n}\n\nfunction getHTML(): string {\n return `\n\n\n\n\nStandBuddy\n\n\n\n\n\n

From

\n \n

Date

\n \n \n

Exclude airlines

\n \n

\n\n\n\n`;\n}","import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\nexport default async function (req: Request): Promise {\n const url = new URL(req.url);\n const from = url.searchParams.get(\"from\");\n const to = url.searchParams.get(\"to\");\n const deep = url.searchParams.get(\"deep\") === \"1\";\n const date = url.searchParams.get(\"date\");\n const refresh = url.searchParams.get(\"refresh\") === \"1\";\n const passedHubs = (url.searchParams.get(\"hubs\") || \"\").split(\",\").filter(\n Boolean,\n );\n\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS routes_cache (\n route_key TEXT PRIMARY KEY,\n routes_json TEXT,\n created_at INTEGER\n )`);\n\n if (!from || !to) {\n return new Response(getHTML(), {\n headers: { \"Content-Type\": \"text/html\" },\n });\n }\n\n const CACHE_TTL = 30 * 24 * 60 * 60;\n const cacheKey = deep ? `${from}-${to}-deep` : `${from}-${to}`;\n const now = Math.floor(Date.now() / 1000);\n\n if (!refresh) {\n try {\n const cached = await sqlite.execute(\n `SELECT routes_json, created_at FROM routes_cache WHERE route_key = ?`,\n [cacheKey],\n );\n if (cached.rows.length > 0) {\n const age = now - Number(cached.rows[0][1]);\n if (age < CACHE_TTL) {\n const data = JSON.parse(String(cached.rows[0][0]));\n return new Response(\n JSON.stringify({\n ...data,\n cached: true,\n age_days: Math.floor(age / 86400),\n }),\n {\n headers: {\n \"Content-Type\": \"application/json\",\n \"Access-Control-Allow-Origin\": \"*\",\n },\n },\n );\n }\n }\n } catch (e) {}\n }\n\n const API_KEY = \"0a4f417693msh720c79bda8763c0p19c96fjsn6fbc5aa01ef8\";\n const HOST = \"aerodatabox.p.rapidapi.com\";\n const MAJOR = [\n \"HKG\",\n \"SIN\",\n \"DXB\",\n \"DOH\",\n \"LHR\",\n \"CDG\",\n \"FRA\",\n \"AMS\",\n \"IST\",\n \"JFK\",\n \"LAX\",\n \"MIA\",\n \"ORD\",\n \"ATL\",\n \"IAH\",\n \"DFW\",\n \"EWR\",\n \"YYZ\",\n \"ICN\",\n \"PVG\",\n \"BKK\",\n \"KUL\",\n \"MAD\",\n \"LIS\",\n \"FCO\",\n \"EZE\",\n \"SCL\",\n \"BOG\",\n \"LIM\",\n \"PTY\",\n \"MEX\",\n \"GRU\",\n \"CGH\",\n \"GIG\",\n \"BSB\",\n \"SSA\",\n \"FOR\",\n \"REC\",\n \"MAO\",\n \"CWB\",\n \"POA\",\n ];\n\n const KNOWN_INTL: Record = {\n \"GRU\": [\n \"MIA\",\n \"JFK\",\n \"LAX\",\n \"ORD\",\n \"ATL\",\n \"IAH\",\n \"DFW\",\n \"BOS\",\n \"EWR\",\n \"YUL\",\n \"YYZ\",\n \"LHR\",\n \"CDG\",\n \"FRA\",\n \"MAD\",\n \"LIS\",\n \"FCO\",\n \"MXP\",\n \"ZRH\",\n \"MUC\",\n \"BCN\",\n \"EZE\",\n \"SCL\",\n \"BOG\",\n \"LIM\",\n \"PTY\",\n \"DXB\",\n \"DOH\",\n \"NBO\",\n \"ADD\",\n \"JNB\",\n \"CMN\",\n \"HKG\",\n \"GIG\",\n ],\n \"GIG\": [\n \"MIA\",\n \"JFK\",\n \"LHR\",\n \"CDG\",\n \"FRA\",\n \"MAD\",\n \"LIS\",\n \"EZE\",\n \"SCL\",\n \"BOG\",\n \"LIM\",\n ],\n \"BSB\": [\"MIA\", \"LIS\", \"MAD\", \"EZE\", \"SCL\", \"BOG\", \"LIM\"],\n \"FOR\": [\"LIS\", \"MAD\"],\n \"REC\": [\"LIS\", \"MAD\", \"MIA\"],\n \"SSA\": [\"LIS\", \"MAD\"],\n \"CGH\": [\"MIA\", \"EZE\", \"SCL\", \"BOG\", \"LIM\", \"PTY\"],\n };\n\n const C: Record = {\n \"GRU\": [-23.43, -46.47],\n \"GIG\": [-22.81, -43.25],\n \"SDU\": [-22.91, -43.16],\n \"BSB\": [-15.87, -47.92],\n \"CGH\": [-23.63, -46.66],\n \"SSA\": [-12.91, -38.33],\n \"FOR\": [-3.78, -38.53],\n \"REC\": [-8.13, -34.92],\n \"MAO\": [-3.04, -60.05],\n \"CWB\": [-25.53, -49.17],\n \"POA\": [-29.99, -51.17],\n \"PVH\": [-8.71, -63.90],\n \"NAT\": [-5.91, -35.25],\n \"THE\": [-5.06, -42.82],\n \"MCZ\": [-9.51, -35.79],\n \"JPA\": [-7.14, -34.95],\n \"CGR\": [-20.47, -54.67],\n \"CGB\": [-15.65, -56.12],\n \"BEL\": [-1.38, -48.48],\n \"SLZ\": [-2.59, -44.23],\n \"PMW\": [-10.29, -48.36],\n \"GYN\": [-16.63, -49.22],\n \"AJU\": [-10.98, -37.07],\n \"VIX\": [-20.26, -40.29],\n \"FLN\": [-27.67, -48.55],\n \"LDB\": [-23.33, -51.13],\n \"UDI\": [-18.88, -48.22],\n \"CNF\": [-19.62, -43.97],\n \"IGU\": [-25.60, -54.49],\n \"EZE\": [-34.82, -58.54],\n \"AEP\": [-34.56, -58.42],\n \"COR\": [-31.31, -64.21],\n \"ROS\": [-32.90, -60.79],\n \"MDZ\": [-32.83, -68.79],\n \"MVD\": [-34.82, -56.01],\n \"SCL\": [-33.39, -70.79],\n \"LIM\": [-12.02, -77.11],\n \"BOG\": [4.70, -74.15],\n \"MDE\": [6.17, -75.43],\n \"UIO\": [-0.13, -78.36],\n \"GYE\": [-2.16, -79.88],\n \"ASU\": [-25.24, -57.52],\n \"CCS\": [10.60, -66.99],\n \"LPB\": [-16.51, -68.19],\n \"VVI\": [-17.64, -63.13],\n \"PTY\": [9.07, -79.38],\n \"GUA\": [14.58, -90.53],\n \"HAV\": [22.99, -82.41],\n \"SDQ\": [18.43, -69.67],\n \"NRT\": [35.76, 140.38],\n \"HND\": [35.55, 139.78],\n \"KIX\": [34.43, 135.23],\n \"ICN\": [37.46, 126.44],\n \"PEK\": [40.08, 116.58],\n \"PVG\": [31.14, 121.80],\n \"HKG\": [22.31, 113.92],\n \"TPE\": [25.08, 121.23],\n \"MNL\": [14.51, 121.02],\n \"SIN\": [1.36, 103.99],\n \"KUL\": [2.74, 101.71],\n \"BKK\": [13.69, 100.75],\n \"CGK\": [-6.13, 106.65],\n \"DPS\": [-8.75, 115.17],\n \"SGN\": [10.82, 106.65],\n \"HAN\": [21.22, 105.81],\n \"BOM\": [19.09, 72.87],\n \"DEL\": [28.56, 77.10],\n \"DXB\": [25.25, 55.36],\n \"AUH\": [24.43, 54.65],\n \"DOH\": [25.27, 51.61],\n \"RUH\": [24.96, 46.70],\n \"JED\": [21.68, 39.16],\n \"TLV\": [31.99, 34.90],\n \"IST\": [41.27, 28.74],\n \"ATH\": [37.94, 23.94],\n \"FCO\": [41.80, 12.25],\n \"MXP\": [45.63, 8.72],\n \"MAD\": [40.47, -3.56],\n \"BCN\": [41.30, 2.08],\n \"LIS\": [38.77, -9.13],\n \"CDG\": [49.01, 2.55],\n \"LHR\": [51.48, -0.45],\n \"LGW\": [51.16, -0.18],\n \"AMS\": [52.31, 4.77],\n \"FRA\": [50.03, 8.57],\n \"MUC\": [48.35, 11.79],\n \"BER\": [52.37, 13.50],\n \"VIE\": [48.11, 16.57],\n \"ZRH\": [47.46, 8.55],\n \"OPO\": [41.24, -8.68],\n \"DUB\": [53.42, -6.27],\n \"BRU\": [50.90, 4.48],\n \"JFK\": [40.64, -73.78],\n \"EWR\": [40.69, -74.17],\n \"LAX\": [33.94, -118.41],\n \"SFO\": [37.62, -122.38],\n \"SEA\": [47.45, -122.31],\n \"DEN\": [39.86, -104.67],\n \"ORD\": [41.98, -87.90],\n \"BOS\": [42.37, -71.01],\n \"IAD\": [38.94, -77.46],\n \"ATL\": [33.64, -84.43],\n \"MIA\": [25.80, -80.29],\n \"IAH\": [29.98, -95.34],\n \"DFW\": [32.90, -97.04],\n \"DTW\": [42.21, -83.35],\n \"YYZ\": [43.68, -79.63],\n \"YVR\": [49.19, -123.18],\n \"MEX\": [19.44, -99.07],\n \"CUN\": [21.04, -86.87],\n \"CLT\": [35.21, -80.94],\n \"MCO\": [28.43, -81.31],\n \"YUL\": [45.47, -73.74],\n \"FLL\": [26.07, -80.15],\n \"MSP\": [44.88, -93.22],\n \"YYC\": [51.13, -114.01],\n \"HNL\": [21.32, -157.92],\n \"ANC\": [61.17, -149.99],\n \"PDX\": [45.58, -122.59],\n \"LAS\": [36.08, -115.15],\n \"PHX\": [33.43, -112.01],\n \"SAN\": [32.73, -117.19],\n \"SLC\": [40.78, -111.97],\n \"SYD\": [-33.95, 151.18],\n \"MEL\": [-37.67, 144.83],\n \"BNE\": [-27.38, 153.12],\n \"AKL\": [-37.01, 174.79],\n \"CAI\": [30.11, 31.40],\n \"CMN\": [33.37, -7.59],\n \"LOS\": [6.58, 3.32],\n \"NBO\": [-1.32, 36.93],\n \"ADD\": [8.98, 38.80],\n \"JNB\": [-26.13, 28.24],\n \"CPT\": [-33.96, 18.60],\n \"CTS\": [42.77, 141.69],\n \"FUK\": [33.58, 130.45],\n \"OKA\": [26.19, 127.64],\n \"PUS\": [35.18, 128.93],\n \"CJU\": [33.51, 126.49],\n \"CAN\": [23.39, 113.30],\n \"CTU\": [30.57, 103.94],\n \"KHH\": [22.57, 120.35],\n \"CEB\": [10.30, 123.97],\n \"HKT\": [8.11, 98.30],\n \"CNX\": [18.77, 98.96],\n \"SUB\": [-7.37, 112.78],\n \"DAD\": [16.04, 108.20],\n \"BLR\": [13.19, 77.70],\n \"MAA\": [12.99, 80.17],\n \"CCU\": [22.65, 88.45],\n \"HYD\": [17.23, 78.43],\n \"AMM\": [31.72, 35.99],\n \"BAH\": [26.27, 50.63],\n \"MCT\": [23.59, 58.28],\n \"KWI\": [29.24, 47.97],\n \"DAR\": [-6.88, 39.20],\n \"EBB\": [0.04, 32.44],\n \"MRU\": [-20.43, 57.68],\n \"LAD\": [-8.85, 13.23],\n \"DKR\": [14.74, -17.49],\n \"ACC\": [5.60, -0.17],\n \"GDL\": [20.52, -103.31],\n \"CUZ\": [-13.54, -71.94],\n \"ROS\": [-32.90, -60.79],\n };\n\n const CONT: Record = {\n \"GRU\": \"SA\",\n \"CGH\": \"SA\",\n \"GIG\": \"SA\",\n \"SDU\": \"SA\",\n \"BSB\": \"SA\",\n \"SSA\": \"SA\",\n \"FOR\": \"SA\",\n \"REC\": \"SA\",\n \"MAO\": \"SA\",\n \"CWB\": \"SA\",\n \"POA\": \"SA\",\n \"MVD\": \"SA\",\n \"BOG\": \"SA\",\n \"LIM\": \"SA\",\n \"SCL\": \"SA\",\n \"EZE\": \"SA\",\n \"PVH\": \"SA\",\n \"THE\": \"SA\",\n \"NAT\": \"SA\",\n \"MCZ\": \"SA\",\n \"JPA\": \"SA\",\n \"CGR\": \"SA\",\n \"CGB\": \"SA\",\n \"BEL\": \"SA\",\n \"SLZ\": \"SA\",\n \"PMW\": \"SA\",\n \"GYN\": \"SA\",\n \"AJU\": \"SA\",\n \"VIX\": \"SA\",\n \"FLN\": \"SA\",\n \"LDB\": \"SA\",\n \"UDI\": \"SA\",\n \"CNF\": \"SA\",\n \"IGU\": \"SA\",\n \"AEP\": \"SA\",\n \"ASU\": \"SA\",\n \"VVI\": \"SA\",\n \"LPB\": \"SA\",\n \"UIO\": \"SA\",\n \"GYE\": \"SA\",\n \"CCS\": \"SA\",\n \"COR\": \"SA\",\n \"ROS\": \"SA\",\n \"MDZ\": \"SA\",\n \"MDE\": \"SA\",\n \"CUZ\": \"SA\",\n \"GUA\": \"SA\",\n \"HAV\": \"SA\",\n \"SDQ\": \"SA\",\n \"PTY\": \"SA\",\n \"VCP\": \"SA\",\n \"NRT\": \"AS\",\n \"HND\": \"AS\",\n \"KIX\": \"AS\",\n \"ICN\": \"AS\",\n \"PEK\": \"AS\",\n \"PVG\": \"AS\",\n \"HKG\": \"AS\",\n \"TPE\": \"AS\",\n \"MNL\": \"AS\",\n \"SIN\": \"AS\",\n \"KUL\": \"AS\",\n \"BKK\": \"AS\",\n \"CGK\": \"AS\",\n \"DPS\": \"AS\",\n \"SGN\": \"AS\",\n \"HAN\": \"AS\",\n \"BOM\": \"AS\",\n \"DEL\": \"AS\",\n \"DXB\": \"AS\",\n \"AUH\": \"AS\",\n \"DOH\": \"AS\",\n \"RUH\": \"AS\",\n \"JED\": \"AS\",\n \"TLV\": \"AS\",\n \"CTS\": \"AS\",\n \"FUK\": \"AS\",\n \"OKA\": \"AS\",\n \"PUS\": \"AS\",\n \"CJU\": \"AS\",\n \"CAN\": \"AS\",\n \"CTU\": \"AS\",\n \"KHH\": \"AS\",\n \"CEB\": \"AS\",\n \"HKT\": \"AS\",\n \"CNX\": \"AS\",\n \"SUB\": \"AS\",\n \"DAD\": \"AS\",\n \"BLR\": \"AS\",\n \"MAA\": \"AS\",\n \"CCU\": \"AS\",\n \"HYD\": \"AS\",\n \"AMM\": \"AS\",\n \"BAH\": \"AS\",\n \"MCT\": \"AS\",\n \"KWI\": \"AS\",\n \"IST\": \"EU\",\n \"ATH\": \"EU\",\n \"FCO\": \"EU\",\n \"MXP\": \"EU\",\n \"MAD\": \"EU\",\n \"BCN\": \"EU\",\n \"LIS\": \"EU\",\n \"CDG\": \"EU\",\n \"LHR\": \"EU\",\n \"LGW\": \"EU\",\n \"AMS\": \"EU\",\n \"FRA\": \"EU\",\n \"MUC\": \"EU\",\n \"BER\": \"EU\",\n \"VIE\": \"EU\",\n \"ZRH\": \"EU\",\n \"OPO\": \"EU\",\n \"DUB\": \"EU\",\n \"BRU\": \"EU\",\n \"WAW\": \"EU\",\n \"PRG\": \"EU\",\n \"BUD\": \"EU\",\n \"ARN\": \"EU\",\n \"OSL\": \"EU\",\n \"CPH\": \"EU\",\n \"HEL\": \"EU\",\n \"JFK\": \"NA\",\n \"EWR\": \"NA\",\n \"LAX\": \"NA\",\n \"SFO\": \"NA\",\n \"SEA\": \"NA\",\n \"DEN\": \"NA\",\n \"ORD\": \"NA\",\n \"BOS\": \"NA\",\n \"IAD\": \"NA\",\n \"ATL\": \"NA\",\n \"MIA\": \"NA\",\n \"IAH\": \"NA\",\n \"DFW\": \"NA\",\n \"DTW\": \"NA\",\n \"YYZ\": \"NA\",\n \"YVR\": \"NA\",\n \"MEX\": \"NA\",\n \"CUN\": \"NA\",\n \"CLT\": \"NA\",\n \"MCO\": \"NA\",\n \"YUL\": \"NA\",\n \"FLL\": \"NA\",\n \"MSP\": \"NA\",\n \"YYC\": \"NA\",\n \"GDL\": \"NA\",\n \"HNL\": \"NA\",\n \"ANC\": \"NA\",\n \"PDX\": \"NA\",\n \"LAS\": \"NA\",\n \"PHX\": \"NA\",\n \"SAN\": \"NA\",\n \"SLC\": \"NA\",\n \"SYD\": \"OC\",\n \"MEL\": \"OC\",\n \"BNE\": \"OC\",\n \"AKL\": \"OC\",\n \"PER\": \"OC\",\n \"ADL\": \"OC\",\n \"CAI\": \"AF\",\n \"CMN\": \"AF\",\n \"LOS\": \"AF\",\n \"NBO\": \"AF\",\n \"ADD\": \"AF\",\n \"JNB\": \"AF\",\n \"CPT\": \"AF\",\n \"ACC\": \"AF\",\n \"DKR\": \"AF\",\n \"DAR\": \"AF\",\n \"EBB\": \"AF\",\n \"MRU\": \"AF\",\n \"LAD\": \"AF\",\n };\n\n function delay(ms: number) {\n return new Promise((r) => setTimeout(r, ms));\n }\n\n function hvs(a: [number, number], b: [number, number]): number {\n const R = 6371,\n dLat = (b[0] - a[0]) * Math.PI / 180,\n dLon = (b[1] - a[1]) * Math.PI / 180;\n const s = Math.sin(dLat / 2) ** 2 +\n Math.cos(a[0] * Math.PI / 180) * Math.cos(b[0] * Math.PI / 180) *\n Math.sin(dLon / 2) ** 2;\n return R * 2 * Math.atan2(Math.sqrt(s), Math.sqrt(1 - s));\n }\n\n async function fetchRoutes(iata: string): Promise> {\n const map = new Map();\n try {\n const res = await fetch(\n `https://${HOST}/airports/iata/${iata}/stats/routes/daily`,\n {\n headers: { \"x-rapidapi-key\": API_KEY, \"x-rapidapi-host\": HOST },\n },\n );\n if (!res.ok) return map;\n const data = JSON.parse(await res.text());\n if (!data?.routes) return map;\n for (const route of data.routes) {\n const dest = route?.destination?.iata;\n if (!dest) continue;\n const airlines: string[] = (route.operators || []).filter((o: any) =>\n o?.iata\n ).map((o: any) => o.iata);\n if (airlines.length) map.set(dest, airlines);\n }\n } catch (e) {}\n return map;\n }\n\n async function fetchFlights(\n iata: string,\n dest: string,\n dateStr: string,\n ): Promise {\n try {\n const h = { \"x-rapidapi-key\": API_KEY, \"x-rapidapi-host\": HOST };\n const u1 =\n `https://${HOST}/flights/airports/iata/${iata}/${dateStr}T00:00/${dateStr}T11:59?withLeg=true&direction=Departure&withCancelled=false`;\n const u2 =\n `https://${HOST}/flights/airports/iata/${iata}/${dateStr}T12:00/${dateStr}T23:59?withLeg=true&direction=Departure&withCancelled=false`;\n const r1 = await fetch(u1, { headers: h });\n const d1 = JSON.parse(await r1.text());\n await delay(1500);\n const r2 = await fetch(u2, { headers: h });\n const d2 = JSON.parse(await r2.text());\n const all = [...(d1.departures || []), ...(d2.departures || [])];\n return all.filter((f: any) => f?.arrival?.airport?.iata === dest);\n } catch (e) {\n return [];\n }\n }\n\n const results: any[] = [];\n const seen = new Set();\n\n function addLegs(path: string[], legAls: string[][]) {\n const k = path.join(\"›\");\n if (seen.has(k)) return;\n seen.add(k);\n const conts = [\n ...new Set(path.slice(1, -1).map((p) => CONT[p]).filter(Boolean)),\n ];\n const c1 = C[path[0]], c2 = C[path[path.length - 1]];\n if (c1 && c2) {\n const dd = hvs(c1, c2);\n let td = 0, ok = true;\n for (let i = 0; i < path.length - 1; i++) {\n const ca = C[path[i]], cb = C[path[i + 1]];\n if (ca && cb) td += hvs(ca, cb);\n else ok = false;\n }\n if (ok) {\n const m = dd < 500 ? 1.5 : dd < 2000 ? 2 : 3;\n if (dd > 100 && td > dd * m) return;\n }\n }\n results.push({\n path,\n airlines: [...new Set(legAls.flat())],\n legAirlines: legAls,\n stops: path.length - 2,\n continents: conts,\n });\n }\n\n const depMap = passedHubs.length && deep\n ? new Map()\n : await fetchRoutes(from);\n if (!passedHubs.length || !deep) await delay(1500);\n const arrMapRaw = await fetchRoutes(to);\n const arrMap = new Map([...arrMapRaw]);\n for (const hub of (KNOWN_INTL[to] || [])) {\n if (!arrMap.has(hub)) arrMap.set(hub, []);\n }\n\n if (depMap.has(to)) addLegs([from, to], [depMap.get(to)!]);\n for (const [h1, al1] of depMap) {\n if (h1 === to) continue;\n if (arrMap.has(h1)) addLegs([from, h1, to], [al1, arrMap.get(h1)!]);\n }\n\n if (deep) {\n const hubs = [\n ...new Set([\n ...passedHubs,\n ...[...arrMap.keys()].filter((h) => h !== from && MAJOR.includes(h)),\n ]),\n ].slice(0, 15);\n for (const h1 of hubs) {\n await delay(1500);\n const hm = await fetchRoutes(h1);\n for (const [h2, al2] of hm) {\n if (h2 === from || h2 === h1) continue;\n if (h2 === to) addLegs([from, h1, to], [al2, arrMap.get(h1) || []]);\n else if (arrMap.has(h2)) {\n addLegs([from, h1, h2, to], [\n al2,\n hm.get(h2) || [],\n arrMap.get(h2) || [],\n ]);\n } else if (arrMap.has(h1) && passedHubs.includes(h2)) {\n addLegs([from, h2, h1, to], [\n al2,\n hm.get(h1) || [],\n arrMap.get(h1) || [],\n ]);\n }\n }\n }\n for (const prev of results.filter((r) => r.stops === 2).slice(0, 3)) {\n const h2 = prev.path[2];\n if (!MAJOR.includes(h2)) continue;\n await delay(1500);\n const dm = await fetchRoutes(h2);\n for (const [h3, al3] of dm) {\n if (prev.path.includes(h3)) continue;\n if (h3 === to) {\n addLegs([from, prev.path[1], h2, to], [...prev.legAirlines, al3]);\n } else if (arrMap.has(h3)) {\n addLegs([from, prev.path[1], h2, h3, to], [\n ...prev.legAirlines,\n al3,\n arrMap.get(h3) || [],\n ]);\n }\n }\n }\n const emptyHubs = new Set(\n results.filter((r) =>\n r.legAirlines[r.legAirlines.length - 1]?.length === 0\n ).map((r) => r.path[r.path.length - 2]),\n );\n for (const hub of emptyHubs) {\n await delay(1500);\n const hm = await fetchRoutes(hub);\n const als = hm.get(to) || [];\n if (als.length) {\n arrMap.set(hub, als);\n for (const r of results) {\n if (r.path[r.path.length - 2] === hub) {\n r.legAirlines[r.legAirlines.length - 1] = als;\n r.airlines = [...new Set(r.legAirlines.flat())];\n }\n }\n }\n }\n }\n\n results.sort((a, b) => a.stops - b.stops);\n const deduped = new Set();\n const finalRoutes = results.filter((r) => {\n const k = r.path.join(\"-\");\n if (deduped.has(k)) return false;\n deduped.add(k);\n return true;\n }).slice(0, 100);\n\n let flightSchedule: any[] = [];\n if (date && !deep && finalRoutes.some((r) => r.stops === 0)) {\n flightSchedule = await fetchFlights(from, to, date);\n }\n\n const payload = { routes: finalRoutes, flights: flightSchedule };\n\n try {\n await sqlite.execute(\n `INSERT OR REPLACE INTO routes_cache (route_key, routes_json, created_at) VALUES (?, ?, ?)`,\n [cacheKey, JSON.stringify(payload), now],\n );\n } catch (e) {}\n\n return new Response(JSON.stringify({ ...payload, cached: false }), {\n headers: {\n \"Content-Type\": \"application/json\",\n \"Access-Control-Allow-Origin\": \"*\",\n },\n });\n}\n\nfunction getHTML(): string {\n return `\n\n\n\n\nStandBuddy\n\n\n\n\n\n

From

\n \n

Date

\n \n \n

Exclude airlines

\n \n

\n\n\n\n`;\n}","createdAt",["D",1777847147081],"branchVersion","branchId","23a0d670-3fa4-11f1-b5dd-42b51c65c3df","id","23a00416-3fa4-11f1-b5dd-42b51c65c3df","untitled-6356",["D",1777010963006],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","fe136906-e9b9-4b55-a280-d7b22619bd7c","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",1,"orgId","019dbd88-7002-73ba-9299-709d7c8dfa1c","tursoName","23a004163fa411f1b5dd42b51c65c3df","tursoHostname","23a004163fa411f1b5dd42b51c65c3df-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789530642963],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_97":96,"_104":100},"org",{"_97":96,"_98":-5,"_99":100,"_18":54,"_101":102,"_103":25},"branch",{"_13":86,"_32":87,"_43":42,"_88":44,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":45,"_95":96},"isOwned",219,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","marcelobrgdops","handle","displayName","avatar","https://avatars.githubusercontent.com/u/278866238?v=4","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_43":44,"_32":45,"_38":152,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":-5,"_53":-5,"_18":54,"_55":-5,"_56":25,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":64,"_65":66,"_67":153,"_69":-5,"_70":71,"_72":71,"_73":74,"_75":74,"_76":74,"_77":71,"_78":71,"_79":154,"_81":155,"_83":156,"_85":25},"tree",[147],"files",[147],"counts",{"_136":137,"_138":60,"_139":137,"_140":141,"_142":143},"contents",[128],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles",true,"grants","orgs","customDomains",{},{"_43":129,"_32":28,"_30":31,"_130":-5,"_41":42,"_40":14,"_131":25,"_38":132,"_13":133,"_33":34,"_35":37,"_24":25,"_134":-5,"_27":135},"082fd538-473f-11f1-8533-42b51c65c3df","parentId","latest",["D",1777847147081],199,"label",[28],"pulls",0,"branches","forks","envVars",{"_144":137,"_146":137},"connections",{"_144":137,"_145":137},"count","unfilledCount","emptyCount",{"_43":129,"_32":28,"_30":31,"_130":-5,"_41":42,"_40":14,"_131":25,"_38":148,"_13":133,"_33":34,"_35":37,"_24":25,"_134":-5,"_149":150,"_27":151},["D",1777847147081],"children",[],[28],["D",1777010963006],["D",1789530642963],{"_97":96,"_104":100},{"_97":96,"_98":-5,"_99":100,"_18":54,"_101":102,"_103":25},{"_13":86,"_32":87,"_43":42,"_88":44,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":45,"_95":96},"ctx",{"_79":-5,"_125":190,"_191":192,"_193":194,"_195":25,"_196":25,"_197":25,"_198":123,"_199":-5,"_200":-7,"_201":-7,"_202":137,"_203":25,"_204":25,"_205":-5,"_206":25,"_207":25,"_208":25,"_209":-5},"ENV",{"_161":162,"_163":164,"_165":87,"_166":167,"_168":169,"_170":171,"_172":173,"_174":175,"_176":177,"_178":179,"_180":181,"_182":183,"_184":185,"_186":187,"_188":189},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v200