Ticket #73
Package airlines reference data as a Wombat delivery
closed
feature
normal
-
2026-06-15 19:34:17
2026-06-15T21:58:37
Description
The Add Airline lookup button (GET /airlines/lookup) queries the local airlines table for IATA/ICAO/callsign/country. On a fresh client install this table is empty, so the lookup returns nothing. The reference airline data (all airlines with codes and callsigns) needs to be packaged as a Wombat capability and delivered via Marmot on first install, the same way registries are. Suggested approach: export a SQL dump of the airlines table from .158 (name, iata, icao, callsign, country, ceased fields only — no IDs), bundle it as a Wombat package, add an airlines capability key to entitlements for all paid customers, and have Marmot import it on delivery. This is a base dataset, not a frequently-updated registry, so a single delivery on first install is sufficient.
Ticket Events
-
status_change
—
Closed. 229 airlines merged into .155 via Wombat/Marmot. Fixed _install_registry(): INSERT IGNORE regex + merge mode (skip DELETE FROM for reference datasets). Regenerated SQL with correct single-quote escaping. Package re-signed and re-dispatched.
2026-06-15T21:58:44
Add Comment