EnterpriseAir mock backend

This backend is live. It backs the AIDA voice-agent lab for the EnterpriseAir flight-status demo.

Endpoints

GET /flights?origin=BLR&destination=DEL — returns the recurring schedule with each flight's operating days. Add &date=YYYY-MM-DD to filter to just that day.
POST /verifybooking body: {\"booking_ref\":\"...\",\"last_name\":\"...\"} — last_name is matched loosely (typos/near-misses OK)
GET /flightstatus?token=...

Test bookings (all data fictitious)

\n \n \n ${bookingRows}\n

Booking ref	Passenger	Last name to test with	Flight	Travel date

Dates are computed relative to today, so this table always looks current.

\n`);\n }\n\n // -------------------------------------------------------------------\n // GET /flights?origin=&destination=[&date=YYYY-MM-DD]\n //\n // Without a date: returns the recurring schedule for that route, each\n // flight labelled with the days it operates (this is the default - a\n // schedule is recurring, so we don't pretend it belongs to one date).\n //\n // With a date: also filters down to flights operating on that specific\n // date's weekday, and echoes back the resolved date/weekday, for cases\n // where the caller (or the agent) wants a yes/no answer for one day.\n // -------------------------------------------------------------------\n if (url.pathname === \"/flights\" && req.method === \"GET\") {\n const origin = (url.searchParams.get(\"origin\") || \"\").trim().toUpperCase();\n const destination = (url.searchParams.get(\"destination\") || \"\").trim()\n .toUpperCase();\n const dateParam = url.searchParams.get(\"date\");\n\n if (!origin || !destination) {\n return json({\n error:\n \"origin and destination are required (airport codes or city names)\",\n }, 400);\n }\n\n const result = await sqlite.execute({\n sql: `select * from flights\n where (upper(origin_code) = :o or upper(origin_city) = :o)\n and (upper(destination_code) = :d or upper(destination_city) = :d)`,\n args: { o: origin, d: destination },\n });\n\n let matches = result.rows as any[];\n let resolvedDate: string | null = null;\n let resolvedWeekday: string | null = null;\n\n if (dateParam) {\n const targetDate = parseDateParam(dateParam);\n resolvedWeekday = weekdayShort(targetDate);\n resolvedDate = isoDate(targetDate);\n matches = matches.filter((f) =>\n String(f.days_of_week).split(\",\").includes(resolvedWeekday)\n );\n }\n\n return json({\n query: {\n origin,\n destination,\n date: resolvedDate,\n weekday: resolvedWeekday,\n },\n count: matches.length,\n flights: matches.map((f) => ({\n flight_number: f.flight_number,\n origin: `${f.origin_city} (${f.origin_code})`,\n destination: `${f.destination_city} (${f.destination_code})`,\n departure_time: f.departure_time,\n arrival_time: f.arrival_time,\n aircraft: f.aircraft,\n days_of_week: humanDays(f.days_of_week),\n })),\n });\n }\n\n // -------------------------------------------------------------------\n // POST /verifybooking { booking_ref, last_name }\n //\n // last_name is matched fuzzily - see isCloseNameMatch() - because it's a\n // voice-transcribed second factor, not the secret itself.\n // -------------------------------------------------------------------\n if (url.pathname === \"/verifybooking\" && req.method === \"POST\") {\n let body: any = {};\n try {\n body = await req.json();\n } catch {\n return json({ authenticated: false, error: \"invalid JSON body\" }, 400);\n }\n\n const bookingRef = String(body.booking_ref || \"\").trim().toUpperCase();\n const lastName = String(body.last_name || \"\").trim();\n\n const result = await sqlite.execute({\n sql: `select * from bookings where upper(booking_ref) = :ref`,\n args: { ref: bookingRef },\n });\n const booking = (result.rows as any[])[0];\n\n if (\n !booking ||\n !isCloseNameMatch(lastName, lastNameOf(booking.passenger_name))\n ) {\n return json({ authenticated: false });\n }\n\n const token = crypto.randomUUID();\n await sqlite.execute({\n sql:\n `insert into verify_tokens (token, flight_number, day_offset, created_at) values (?, ?, ?, ?)`,\n args: [token, booking.flight_number, booking.day_offset, Date.now()],\n });\n\n return json({\n authenticated: true,\n token,\n flight_number: booking.flight_number,\n travel_date: isoDateForOffset(booking.day_offset),\n });\n }\n\n // -------------------------------------------------------------------\n // GET /flightstatus?token=...\n // -------------------------------------------------------------------\n if (url.pathname === \"/flightstatus\" && req.method === \"GET\") {\n const token = url.searchParams.get(\"token\") || \"\";\n\n const tokenRes = await sqlite.execute({\n sql: `select * from verify_tokens where token = :t`,\n args: { t: token },\n });\n const tokenRow = (tokenRes.rows as any[])[0];\n if (!tokenRow) {\n return json({ error: \"invalid or expired token\" }, 401);\n }\n\n const statusRes = await sqlite.execute({\n sql:\n `select * from flight_status where flight_number = :f and day_offset = :o`,\n args: { f: tokenRow.flight_number, o: tokenRow.day_offset },\n });\n const status = (statusRes.rows as any[])[0];\n\n if (!status) {\n return json({\n flight_number: tokenRow.flight_number,\n travel_date: isoDateForOffset(tokenRow.day_offset),\n status: \"On Time\",\n delay_minutes: 0,\n });\n }\n\n return json({\n flight_number: status.flight_number,\n travel_date: isoDateForOffset(status.day_offset),\n status: status.status,\n delay_minutes: status.delay_minutes,\n new_departure_time: status.new_departure_time,\n gate: status.gate,\n });\n }\n\n return json({ error: \"not found\" }, 404);\n}","deleted","label",[120],"pulls",1,"forks","envVars",{"_142":55,"_144":55},"connections",{"_142":55,"_143":55},"count","unfilledCount","emptyCount",{"_20":119,"_13":120,"_121":49,"_122":-5,"_123":21,"_124":30,"_125":51,"_22":146,"_29":127,"_128":129,"_130":131,"_132":38,"_133":14,"_147":148,"_95":149},["D",1789042950821],"children",[],[120],["D",1789035356755],["D",1789472446807],{"_11":12,"_93":89},{"_11":12,"_86":87,"_88":89,"_46":-5,"_90":91,"_92":38},{"_29":30,"_13":26,"_20":21,"_27":28,"_31":-5,"_32":-5,"_81":-5,"_82":-5,"_83":-5,"_84":14,"_85":12},"ctx",{"_74":-5,"_115":188,"_189":190,"_191":192,"_193":38,"_194":38,"_195":38,"_196":51,"_197":-5,"_198":-7,"_199":-7,"_200":55,"_201":38,"_202":38,"_203":-5,"_204":38,"_205":38,"_206":38,"_207":-5},"ENV",{"_159":160,"_161":162,"_163":26,"_164":165,"_166":167,"_168":169,"_170":171,"_172":173,"_174":175,"_176":177,"_178":179,"_180":181,"_182":183,"_184":185,"_186":187},"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"]

Branches1

Branches
1