[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_160":161,"_162":163},"routes/_app.x.$handle.$name",{"_100":99,"_32":45,"_109":90,"_27":110,"_13":14,"_111":-5,"_11":112,"_113":114,"_115":116,"_117":118,"_119":120,"_20":-5,"_121":-5,"_122":-5,"_123":25,"_124":125,"_126":59,"_127":-5,"_128":-5,"_129":130},"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":53,"_54":55,"_18":56,"_57":31,"_58":59,"_60":-5,"_61":-5,"_62":63,"_64":65,"_66":67,"_68":69,"_70":71,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":83,"_84":85,"_86":87,"_88":25},"version",5,"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","9cd2fe28-ad00-11f1-8f32-1607ee4eb77e","name","fileType","http","content","/**\n * EnterpriseAir mock backend for the AIDA voice-agent lab.\n *\n * Create this as a new HTTP val on val.town (e.g. name it \"enterpriseair-api\"),\n * paste this whole file in, and press Run once to let it seed itself.\n * Your base URL will be something like https://-enterpriseair-api.val.run\n *\n * Routes:\n * GET / -> status page + sample test data (open this first)\n * GET /flights?origin=BLR&destination=DEL -> schedule lookup (optional &date=YYYY-MM-DD, defaults to today)\n * POST /verifybooking { booking_ref, email } -> { authenticated, token, flight_number, travel_date }\n * GET /flightstatus?token=... -> { flight_number, travel_date, status, delay_minutes, ... }\n *\n * Data model (3 tables, one val-scoped SQLite database):\n * flights - the recurring published schedule (static, matches the Flight Schedule doc)\n * bookings - who is booked on which flight, expressed as an offset from \"today\" so the\n * demo always has a live, current-looking booking no matter when you run the lab\n * flight_status - the day-specific operational status of a flight (on time / delayed / cancelled)\n */\n\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\n// ---------------------------------------------------------------------------\n// Date helpers - bookings/status are keyed by an offset from \"today\" (0, 1, -1...)\n// so the seed data is always current, whenever this lab actually runs.\n// ---------------------------------------------------------------------------\n\nconst WEEKDAYS = [\"Sun\", \"Mon\", \"Tue\", \"Wed\", \"Thu\", \"Fri\", \"Sat\"];\n\nfunction dateForOffset(offsetDays: number): Date {\n const d = new Date();\n d.setUTCHours(0, 0, 0, 0);\n d.setUTCDate(d.getUTCDate() + offsetDays);\n return d;\n}\n\nfunction isoDate(d: Date): string {\n return d.toISOString().slice(0, 10);\n}\n\nfunction weekdayShort(d: Date): string {\n return WEEKDAYS[d.getUTCDay()];\n}\n\nfunction isoDateForOffset(offsetDays: number): string {\n return isoDate(dateForOffset(offsetDays));\n}\n\nfunction parseDateParam(dateStr: string | null): Date {\n if (!dateStr) return dateForOffset(0);\n const parsed = new Date(dateStr + \"T00:00:00Z\");\n return isNaN(parsed.getTime()) ? dateForOffset(0) : parsed;\n}\n\n// ---------------------------------------------------------------------------\n// Schema + seed (idempotent - only inserts if the tables are empty)\n// ---------------------------------------------------------------------------\n\nasync function ensureSchema() {\n await sqlite.batch([\n `create table if not exists flights (\n flight_number text not null,\n origin_code text not null,\n origin_city text not null,\n destination_code text not null,\n destination_city text not null,\n departure_time text not null,\n arrival_time text not null,\n days_of_week text not null,\n aircraft text not null\n )`,\n `create table if not exists bookings (\n booking_ref text primary key,\n email text not null,\n passenger_name text not null,\n flight_number text not null,\n day_offset integer not null\n )`,\n `create table if not exists flight_status (\n flight_number text not null,\n day_offset integer not null,\n status text not null,\n delay_minutes integer not null default 0,\n new_departure_time text,\n gate text,\n primary key (flight_number, day_offset)\n )`,\n `create table if not exists verify_tokens (\n token text primary key,\n flight_number text not null,\n day_offset integer not null,\n created_at integer not null\n )`,\n ]);\n\n const countRow = await sqlite.execute(\"select count(*) as n from flights\");\n const n = Number((countRow.rows[0] as any).n);\n if (n > 0) return; // already seeded\n\n // Domestic + international + seasonal schedule, matching the EnterpriseAir\n // Flight Schedule document exactly (flight numbers, times, routes).\n const DAILY = \"Sun,Mon,Tue,Wed,Thu,Fri,Sat\";\n\n const flights = [\n // Domestic\n [\n \"EA101\",\n \"BLR\",\n \"Bengaluru\",\n \"DEL\",\n \"Delhi\",\n \"06:00\",\n \"08:40\",\n DAILY,\n \"A321neo\",\n ],\n [\n \"EA102\",\n \"DEL\",\n \"Delhi\",\n \"BLR\",\n \"Bengaluru\",\n \"09:30\",\n \"12:10\",\n DAILY,\n \"A321neo\",\n ],\n [\n \"EA105\",\n \"BLR\",\n \"Bengaluru\",\n \"DEL\",\n \"Delhi\",\n \"18:15\",\n \"20:55\",\n DAILY,\n \"A321neo\",\n ],\n [\n \"EA106\",\n \"DEL\",\n \"Delhi\",\n \"BLR\",\n \"Bengaluru\",\n \"21:45\",\n \"00:25\",\n DAILY,\n \"A321neo\",\n ],\n [\n \"EA201\",\n \"BLR\",\n \"Bengaluru\",\n \"BOM\",\n \"Mumbai\",\n \"07:00\",\n \"08:45\",\n DAILY,\n \"A320neo\",\n ],\n [\n \"EA202\",\n \"BOM\",\n \"Mumbai\",\n \"BLR\",\n \"Bengaluru\",\n \"09:30\",\n \"11:15\",\n DAILY,\n \"A320neo\",\n ],\n [\n \"EA205\",\n \"BLR\",\n \"Bengaluru\",\n \"BOM\",\n \"Mumbai\",\n \"19:00\",\n \"20:45\",\n DAILY,\n \"A320neo\",\n ],\n [\n \"EA206\",\n \"BOM\",\n \"Mumbai\",\n \"BLR\",\n \"Bengaluru\",\n \"21:30\",\n \"23:15\",\n DAILY,\n \"A320neo\",\n ],\n [\n \"EA301\",\n \"BLR\",\n \"Bengaluru\",\n \"MAA\",\n \"Chennai\",\n \"06:30\",\n \"07:35\",\n DAILY,\n \"A320neo\",\n ],\n [\n \"EA302\",\n \"MAA\",\n \"Chennai\",\n \"BLR\",\n \"Bengaluru\",\n \"08:20\",\n \"09:25\",\n DAILY,\n \"A320neo\",\n ],\n [\n \"EA351\",\n \"BLR\",\n \"Bengaluru\",\n \"CCU\",\n \"Kolkata\",\n \"12:00\",\n \"14:30\",\n DAILY,\n \"A320neo\",\n ],\n [\n \"EA352\",\n \"CCU\",\n \"Kolkata\",\n \"BLR\",\n \"Bengaluru\",\n \"15:15\",\n \"17:45\",\n DAILY,\n \"A320neo\",\n ],\n [\n \"EA401\",\n \"BLR\",\n \"Bengaluru\",\n \"HYD\",\n \"Hyderabad\",\n \"13:00\",\n \"14:05\",\n DAILY,\n \"A320neo\",\n ],\n [\n \"EA402\",\n \"HYD\",\n \"Hyderabad\",\n \"BLR\",\n \"Bengaluru\",\n \"14:50\",\n \"15:55\",\n DAILY,\n \"A320neo\",\n ],\n [\n \"EA451\",\n \"BLR\",\n \"Bengaluru\",\n \"COK\",\n \"Kochi\",\n \"17:00\",\n \"18:15\",\n DAILY,\n \"A320neo\",\n ],\n [\n \"EA452\",\n \"COK\",\n \"Kochi\",\n \"BLR\",\n \"Bengaluru\",\n \"19:00\",\n \"20:15\",\n DAILY,\n \"A320neo\",\n ],\n // International\n [\n \"EA701\",\n \"BLR\",\n \"Bengaluru\",\n \"DXB\",\n \"Dubai\",\n \"02:30\",\n \"04:45\",\n DAILY,\n \"787-9\",\n ],\n [\n \"EA702\",\n \"DXB\",\n \"Dubai\",\n \"BLR\",\n \"Bengaluru\",\n \"15:30\",\n \"20:30\",\n DAILY,\n \"787-9\",\n ],\n [\n \"EA711\",\n \"BLR\",\n \"Bengaluru\",\n \"SIN\",\n \"Singapore\",\n \"09:00\",\n \"15:30\",\n DAILY,\n \"787-9\",\n ],\n [\n \"EA712\",\n \"SIN\",\n \"Singapore\",\n \"BLR\",\n \"Bengaluru\",\n \"17:00\",\n \"19:00\",\n DAILY,\n \"787-9\",\n ],\n [\n \"EA721\",\n \"BLR\",\n \"Bengaluru\",\n \"LHR\",\n \"London Heathrow\",\n \"01:15\",\n \"06:30\",\n \"Mon,Wed,Fri,Sat,Sun\",\n \"787-9\",\n ],\n [\n \"EA722\",\n \"LHR\",\n \"London Heathrow\",\n \"BLR\",\n \"Bengaluru\",\n \"09:00\",\n \"22:30\",\n \"Mon,Wed,Fri,Sat,Sun\",\n \"787-9\",\n ],\n [\n \"EA731\",\n \"BLR\",\n \"Bengaluru\",\n \"FRA\",\n \"Frankfurt\",\n \"02:00\",\n \"07:15\",\n \"Tue,Thu,Sat,Sun\",\n \"787-9\",\n ],\n [\n \"EA732\",\n \"FRA\",\n \"Frankfurt\",\n \"BLR\",\n \"Bengaluru\",\n \"10:00\",\n \"23:45\",\n \"Tue,Thu,Sat,Sun\",\n \"787-9\",\n ],\n [\n \"EA741\",\n \"BLR\",\n \"Bengaluru\",\n \"JFK\",\n \"New York JFK\",\n \"02:00\",\n \"19:30\",\n \"Mon,Thu,Sat\",\n \"787-9\",\n ],\n [\n \"EA742\",\n \"JFK\",\n \"New York JFK\",\n \"BLR\",\n \"Bengaluru\",\n \"21:00\",\n \"23:55\",\n \"Mon,Thu,Sat\",\n \"787-9\",\n ],\n // Seasonal\n [\n \"EA761\",\n \"BLR\",\n \"Bengaluru\",\n \"MLE\",\n \"Male\",\n \"08:00\",\n \"09:45\",\n \"Tue,Fri,Sun\",\n \"A321neo\",\n ],\n [\n \"EA762\",\n \"MLE\",\n \"Male\",\n \"BLR\",\n \"Bengaluru\",\n \"10:30\",\n \"14:15\",\n \"Tue,Fri,Sun\",\n \"A321neo\",\n ],\n ];\n\n await sqlite.batch(\n flights.map((f) => ({\n sql:\n `insert into flights (flight_number, origin_code, origin_city, destination_code, destination_city, departure_time, arrival_time, days_of_week, aircraft) values (?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n args: f,\n })),\n );\n\n // Bookings + their status, expressed relative to \"today\" so the lab always\n // has a mix of on-time, delayed and cancelled flights to demo, regardless\n // of the calendar date the lab is actually run on.\n const bookings = [\n // booking_ref, email, passenger_name, flight_number, day_offset\n [\"EA4F7K2\", \"sophie.turner@example.com\", \"Sophie Turner\", \"EA201\", 0],\n [\"EA9M2X8\", \"james.harrington@example.com\", \"James Harrington\", \"EA701\", 0],\n [\"EA1Q5T4\", \"elena.vasquez@example.com\", \"Elena Vasquez\", \"EA101\", 1],\n [\"EA7R3W9\", \"raj.mehta@example.com\", \"Raj Mehta\", \"EA731\", 0],\n [\"EA2K8L1\", \"amara.okafor@example.com\", \"Amara Okafor\", \"EA451\", -1],\n ];\n\n await sqlite.batch(\n bookings.map((b) => ({\n sql:\n `insert into bookings (booking_ref, email, passenger_name, flight_number, day_offset) values (?, ?, ?, ?, ?)`,\n args: b,\n })),\n );\n\n const statuses = [\n // flight_number, day_offset, status, delay_minutes, new_departure_time, gate\n [\"EA201\", 0, \"On Time\", 0, null, \"1A\"],\n [\"EA701\", 0, \"Delayed\", 45, \"03:15\", \"B12\"],\n [\"EA101\", 1, \"On Time\", 0, null, \"2C\"],\n [\"EA731\", 0, \"Cancelled\", 0, null, null],\n [\"EA451\", -1, \"On Time\", 0, null, \"1D\"],\n ];\n\n await sqlite.batch(\n statuses.map((s) => ({\n sql:\n `insert into flight_status (flight_number, day_offset, status, delay_minutes, new_departure_time, gate) values (?, ?, ?, ?, ?, ?)`,\n args: s,\n })),\n );\n}\n\n// ---------------------------------------------------------------------------\n// HTTP handler\n// ---------------------------------------------------------------------------\n\nconst CORS_HEADERS = {\n \"Access-Control-Allow-Origin\": \"*\",\n \"Access-Control-Allow-Methods\": \"GET, POST, OPTIONS\",\n \"Access-Control-Allow-Headers\": \"Content-Type\",\n};\n\nfunction json(data: unknown, status = 200): Response {\n return new Response(JSON.stringify(data, null, 2), {\n status,\n headers: { \"Content-Type\": \"application/json\", ...CORS_HEADERS },\n });\n}\n\nfunction html(body: string, status = 200): Response {\n return new Response(body, {\n status,\n headers: { \"Content-Type\": \"text/html; charset=utf-8\", ...CORS_HEADERS },\n });\n}\n\nexport default async function (req: Request): Promise {\n await ensureSchema();\n\n if (req.method === \"OPTIONS\") {\n return new Response(null, { status: 204, headers: CORS_HEADERS });\n }\n\n const url = new URL(req.url);\n\n // -------------------------------------------------------------------\n // GET / - status page, for humans checking the backend is alive\n // -------------------------------------------------------------------\n if (url.pathname === \"/\" && req.method === \"GET\") {\n const bookingsRes = await sqlite.execute(\"select * from bookings\");\n const rows = bookingsRes.rows as any[];\n const bookingRows = rows\n .map(\n (b) =>\n `${b.booking_ref}${b.email}${b.passenger_name}${b.flight_number}${\n isoDateForOffset(b.day_offset)\n }`,\n )\n .join(\"\\n\");\n\n return html(`\nEnterpriseAir mock API\n\n\n

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 (optional &date=YYYY-MM-DD)
POST /verifybooking body: {\"booking_ref\":\"...\",\"email\":\"...\"}
GET /flightstatus?token=...

Test bookings (all data fictitious)

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

Booking ref	Email	Passenger	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=\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 targetDate = parseDateParam(dateParam);\n const weekday = weekdayShort(targetDate);\n const isoTarget = isoDate(targetDate);\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 const matches = (result.rows as any[]).filter((f) =>\n String(f.days_of_week).split(\",\").includes(weekday)\n );\n\n return json({\n query: { origin, destination, date: isoTarget, weekday },\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 date: isoTarget,\n })),\n });\n }\n\n // -------------------------------------------------------------------\n // POST /verifybooking { booking_ref, email }\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 email = String(body.email || \"\").trim().toLowerCase();\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 (!booking || String(booking.email).toLowerCase() !== email) {\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}","/**\n * EnterpriseAir mock backend for the AIDA voice-agent lab.\n *\n * Create this as a new HTTP val on val.town (e.g. name it \"enterpriseair-api\"),\n * paste this whole file in, and press Run once to let it seed itself.\n * Your base URL will be something like https://-enterpriseair-api.val.run\n *\n * Routes:\n * GET / -> status page + sample test data (open this first)\n * GET /flights?origin=BLR&destination=DEL -> schedule lookup (optional &date=YYYY-MM-DD, defaults to today)\n * POST /verifybooking { booking_ref, email } -> { authenticated, token, flight_number, travel_date }\n * GET /flightstatus?token=... -> { flight_number, travel_date, status, delay_minutes, ... }\n *\n * Data model (3 tables, one val-scoped SQLite database):\n * flights - the recurring published schedule (static, matches the Flight Schedule doc)\n * bookings - who is booked on which flight, expressed as an offset from \"today\" so the\n * demo always has a live, current-looking booking no matter when you run the lab\n * flight_status - the day-specific operational status of a flight (on time / delayed / cancelled)\n */\n\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\n// ---------------------------------------------------------------------------\n// Date helpers - bookings/status are keyed by an offset from \"today\" (0, 1, -1...)\n// so the seed data is always current, whenever this lab actually runs.\n// ---------------------------------------------------------------------------\n\nconst WEEKDAYS = [\"Sun\", \"Mon\", \"Tue\", \"Wed\", \"Thu\", \"Fri\", \"Sat\"];\n\nfunction dateForOffset(offsetDays: number): Date {\n const d = new Date();\n d.setUTCHours(0, 0, 0, 0);\n d.setUTCDate(d.getUTCDate() + offsetDays);\n return d;\n}\n\nfunction isoDate(d: Date): string {\n return d.toISOString().slice(0, 10);\n}\n\nfunction weekdayShort(d: Date): string {\n return WEEKDAYS[d.getUTCDay()];\n}\n\nfunction isoDateForOffset(offsetDays: number): string {\n return isoDate(dateForOffset(offsetDays));\n}\n\nfunction parseDateParam(dateStr: string | null): Date {\n if (!dateStr) return dateForOffset(0);\n const parsed = new Date(dateStr + \"T00:00:00Z\");\n return isNaN(parsed.getTime()) ? dateForOffset(0) : parsed;\n}\n\n// ---------------------------------------------------------------------------\n// Schema + seed (idempotent - only inserts if the tables are empty)\n// ---------------------------------------------------------------------------\n\nasync function ensureSchema() {\n await sqlite.batch([\n `create table if not exists flights (\n flight_number text not null,\n origin_code text not null,\n origin_city text not null,\n destination_code text not null,\n destination_city text not null,\n departure_time text not null,\n arrival_time text not null,\n days_of_week text not null,\n aircraft text not null\n )`,\n `create table if not exists bookings (\n booking_ref text primary key,\n email text not null,\n passenger_name text not null,\n flight_number text not null,\n day_offset integer not null\n )`,\n `create table if not exists flight_status (\n flight_number text not null,\n day_offset integer not null,\n status text not null,\n delay_minutes integer not null default 0,\n new_departure_time text,\n gate text,\n primary key (flight_number, day_offset)\n )`,\n `create table if not exists verify_tokens (\n token text primary key,\n flight_number text not null,\n day_offset integer not null,\n created_at integer not null\n )`,\n ]);\n\n const countRow = await sqlite.execute(\"select count(*) as n from flights\");\n const n = Number((countRow.rows[0] as any).n);\n if (n > 0) return; // already seeded\n\n // Domestic + international + seasonal schedule, matching the EnterpriseAir\n // Flight Schedule document exactly (flight numbers, times, routes).\n const DAILY = \"Sun,Mon,Tue,Wed,Thu,Fri,Sat\";\n\n const flights = [\n // Domestic\n [\n \"EA101\",\n \"BLR\",\n \"Bengaluru\",\n \"DEL\",\n \"Delhi\",\n \"06:00\",\n \"08:40\",\n DAILY,\n \"A321neo\",\n ],\n [\n \"EA102\",\n \"DEL\",\n \"Delhi\",\n \"BLR\",\n \"Bengaluru\",\n \"09:30\",\n \"12:10\",\n DAILY,\n \"A321neo\",\n ],\n [\n \"EA105\",\n \"BLR\",\n \"Bengaluru\",\n \"DEL\",\n \"Delhi\",\n \"18:15\",\n \"20:55\",\n DAILY,\n \"A321neo\",\n ],\n [\n \"EA106\",\n \"DEL\",\n \"Delhi\",\n \"BLR\",\n \"Bengaluru\",\n \"21:45\",\n \"00:25\",\n DAILY,\n \"A321neo\",\n ],\n [\n \"EA201\",\n \"BLR\",\n \"Bengaluru\",\n \"BOM\",\n \"Mumbai\",\n \"07:00\",\n \"08:45\",\n DAILY,\n \"A320neo\",\n ],\n [\n \"EA202\",\n \"BOM\",\n \"Mumbai\",\n \"BLR\",\n \"Bengaluru\",\n \"09:30\",\n \"11:15\",\n DAILY,\n \"A320neo\",\n ],\n [\n \"EA205\",\n \"BLR\",\n \"Bengaluru\",\n \"BOM\",\n \"Mumbai\",\n \"19:00\",\n \"20:45\",\n DAILY,\n \"A320neo\",\n ],\n [\n \"EA206\",\n \"BOM\",\n \"Mumbai\",\n \"BLR\",\n \"Bengaluru\",\n \"21:30\",\n \"23:15\",\n DAILY,\n \"A320neo\",\n ],\n [\n \"EA301\",\n \"BLR\",\n \"Bengaluru\",\n \"MAA\",\n \"Chennai\",\n \"06:30\",\n \"07:35\",\n DAILY,\n \"A320neo\",\n ],\n [\n \"EA302\",\n \"MAA\",\n \"Chennai\",\n \"BLR\",\n \"Bengaluru\",\n \"08:20\",\n \"09:25\",\n DAILY,\n \"A320neo\",\n ],\n [\n \"EA351\",\n \"BLR\",\n \"Bengaluru\",\n \"CCU\",\n \"Kolkata\",\n \"12:00\",\n \"14:30\",\n DAILY,\n \"A320neo\",\n ],\n [\n \"EA352\",\n \"CCU\",\n \"Kolkata\",\n \"BLR\",\n \"Bengaluru\",\n \"15:15\",\n \"17:45\",\n DAILY,\n \"A320neo\",\n ],\n [\n \"EA401\",\n \"BLR\",\n \"Bengaluru\",\n \"HYD\",\n \"Hyderabad\",\n \"13:00\",\n \"14:05\",\n DAILY,\n \"A320neo\",\n ],\n [\n \"EA402\",\n \"HYD\",\n \"Hyderabad\",\n \"BLR\",\n \"Bengaluru\",\n \"14:50\",\n \"15:55\",\n DAILY,\n \"A320neo\",\n ],\n [\n \"EA451\",\n \"BLR\",\n \"Bengaluru\",\n \"COK\",\n \"Kochi\",\n \"17:00\",\n \"18:15\",\n DAILY,\n \"A320neo\",\n ],\n [\n \"EA452\",\n \"COK\",\n \"Kochi\",\n \"BLR\",\n \"Bengaluru\",\n \"19:00\",\n \"20:15\",\n DAILY,\n \"A320neo\",\n ],\n // International\n [\n \"EA701\",\n \"BLR\",\n \"Bengaluru\",\n \"DXB\",\n \"Dubai\",\n \"02:30\",\n \"04:45\",\n DAILY,\n \"787-9\",\n ],\n [\n \"EA702\",\n \"DXB\",\n \"Dubai\",\n \"BLR\",\n \"Bengaluru\",\n \"15:30\",\n \"20:30\",\n DAILY,\n \"787-9\",\n ],\n [\n \"EA711\",\n \"BLR\",\n \"Bengaluru\",\n \"SIN\",\n \"Singapore\",\n \"09:00\",\n \"15:30\",\n DAILY,\n \"787-9\",\n ],\n [\n \"EA712\",\n \"SIN\",\n \"Singapore\",\n \"BLR\",\n \"Bengaluru\",\n \"17:00\",\n \"19:00\",\n DAILY,\n \"787-9\",\n ],\n [\n \"EA721\",\n \"BLR\",\n \"Bengaluru\",\n \"LHR\",\n \"London Heathrow\",\n \"01:15\",\n \"06:30\",\n \"Mon,Wed,Fri,Sat,Sun\",\n \"787-9\",\n ],\n [\n \"EA722\",\n \"LHR\",\n \"London Heathrow\",\n \"BLR\",\n \"Bengaluru\",\n \"09:00\",\n \"22:30\",\n \"Mon,Wed,Fri,Sat,Sun\",\n \"787-9\",\n ],\n [\n \"EA731\",\n \"BLR\",\n \"Bengaluru\",\n \"FRA\",\n \"Frankfurt\",\n \"02:00\",\n \"07:15\",\n \"Tue,Thu,Sat,Sun\",\n \"787-9\",\n ],\n [\n \"EA732\",\n \"FRA\",\n \"Frankfurt\",\n \"BLR\",\n \"Bengaluru\",\n \"10:00\",\n \"23:45\",\n \"Tue,Thu,Sat,Sun\",\n \"787-9\",\n ],\n [\n \"EA741\",\n \"BLR\",\n \"Bengaluru\",\n \"JFK\",\n \"New York JFK\",\n \"02:00\",\n \"19:30\",\n \"Mon,Thu,Sat\",\n \"787-9\",\n ],\n [\n \"EA742\",\n \"JFK\",\n \"New York JFK\",\n \"BLR\",\n \"Bengaluru\",\n \"21:00\",\n \"23:55\",\n \"Mon,Thu,Sat\",\n \"787-9\",\n ],\n // Seasonal\n [\n \"EA761\",\n \"BLR\",\n \"Bengaluru\",\n \"MLE\",\n \"Male\",\n \"08:00\",\n \"09:45\",\n \"Tue,Fri,Sun\",\n \"A321neo\",\n ],\n [\n \"EA762\",\n \"MLE\",\n \"Male\",\n \"BLR\",\n \"Bengaluru\",\n \"10:30\",\n \"14:15\",\n \"Tue,Fri,Sun\",\n \"A321neo\",\n ],\n ];\n\n await sqlite.batch(\n flights.map((f) => ({\n sql:\n `insert into flights (flight_number, origin_code, origin_city, destination_code, destination_city, departure_time, arrival_time, days_of_week, aircraft) values (?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n args: f,\n })),\n );\n\n // Bookings + their status, expressed relative to \"today\" so the lab always\n // has a mix of on-time, delayed and cancelled flights to demo, regardless\n // of the calendar date the lab is actually run on.\n const bookings = [\n // booking_ref, email, passenger_name, flight_number, day_offset\n // All offsets are >= 1 (tomorrow onwards) so no booking is ever \"today\" or in the past.\n [\"EA4F7K2\", \"sophie.turner@example.com\", \"Sophie Turner\", \"EA201\", 1],\n [\"EA9M2X8\", \"james.harrington@example.com\", \"James Harrington\", \"EA701\", 1],\n [\"EA1Q5T4\", \"elena.vasquez@example.com\", \"Elena Vasquez\", \"EA101\", 2],\n [\"EA7R3W9\", \"raj.mehta@example.com\", \"Raj Mehta\", \"EA731\", 1],\n [\"EA2K8L1\", \"amara.okafor@example.com\", \"Amara Okafor\", \"EA451\", 3],\n ];\n\n await sqlite.batch(\n bookings.map((b) => ({\n sql:\n `insert into bookings (booking_ref, email, passenger_name, flight_number, day_offset) values (?, ?, ?, ?, ?)`,\n args: b,\n })),\n );\n\n const statuses = [\n // flight_number, day_offset, status, delay_minutes, new_departure_time, gate\n // day_offset here must match the booking's day_offset above for each flight_number.\n [\"EA201\", 1, \"On Time\", 0, null, \"1A\"],\n [\"EA701\", 1, \"Delayed\", 45, \"03:15\", \"B12\"],\n [\"EA101\", 2, \"On Time\", 0, null, \"2C\"],\n [\"EA731\", 1, \"Cancelled\", 0, null, null],\n [\"EA451\", 3, \"On Time\", 0, null, \"1D\"],\n ];\n\n await sqlite.batch(\n statuses.map((s) => ({\n sql:\n `insert into flight_status (flight_number, day_offset, status, delay_minutes, new_departure_time, gate) values (?, ?, ?, ?, ?, ?)`,\n args: s,\n })),\n );\n}\n\n// ---------------------------------------------------------------------------\n// HTTP handler\n// ---------------------------------------------------------------------------\n\nconst CORS_HEADERS = {\n \"Access-Control-Allow-Origin\": \"*\",\n \"Access-Control-Allow-Methods\": \"GET, POST, OPTIONS\",\n \"Access-Control-Allow-Headers\": \"Content-Type\",\n};\n\nfunction json(data: unknown, status = 200): Response {\n return new Response(JSON.stringify(data, null, 2), {\n status,\n headers: { \"Content-Type\": \"application/json\", ...CORS_HEADERS },\n });\n}\n\nfunction html(body: string, status = 200): Response {\n return new Response(body, {\n status,\n headers: { \"Content-Type\": \"text/html; charset=utf-8\", ...CORS_HEADERS },\n });\n}\n\nexport default async function (req: Request): Promise {\n await ensureSchema();\n\n if (req.method === \"OPTIONS\") {\n return new Response(null, { status: 204, headers: CORS_HEADERS });\n }\n\n const url = new URL(req.url);\n\n // -------------------------------------------------------------------\n // GET / - status page, for humans checking the backend is alive\n // -------------------------------------------------------------------\n if (url.pathname === \"/\" && req.method === \"GET\") {\n const bookingsRes = await sqlite.execute(\"select * from bookings\");\n const rows = bookingsRes.rows as any[];\n const bookingRows = rows\n .map(\n (b) =>\n `${b.booking_ref}${b.email}${b.passenger_name}${b.flight_number}${\n isoDateForOffset(b.day_offset)\n }`,\n )\n .join(\"\\n\");\n\n return html(`\nEnterpriseAir mock API\n\n\n

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 (optional &date=YYYY-MM-DD)
POST /verifybooking body: {\"booking_ref\":\"...\",\"email\":\"...\"}
GET /flightstatus?token=...

Test bookings (all data fictitious)

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

Booking ref	Email	Passenger	Flight	Travel date

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

Diff · v5