Example

// if on a browser:
import { BrowserGD } from "gatelogue-types";
import sqlite3InitModule from "@sqlite.org/sqlite-wasm";
const sqlite3 = await sqlite3InitModule();
const gd = await BrowserGD.get(sqlite3); // retrieve data, no sources
const gd = await BrowserGD.get(sqlite3, true); // retrieve data, with sources

// if on node:
import { NodeGD } from "gatelogue-types";
import Database from "better-sqlite3";
const gd = await NodeGD.get(Database); // retrieve data, no sources
const gd = await NodeGD.get(Database, true); // retrieve data, with sources
Copy

Using the ORM does not require SQL and makes for generally clean code. However, doing this is very inefficient as each attribute access is one SQL query.

for (const airport of gd.airAirports) {
  for (const gate of airport.gates) {
    console.log(`Airport ${airport.code} has gate ${gate.code}`);
  }
}
Copy

Querying the underlying SQLite database directly with sql.js is generally more efficient and faster. It is also the only way to access the *Source tables, if you retrieved the database with those.

for (const [airportCode, gateCode] of gd.execGetMany<[string, string]>(
  "SELECT A.code, G.code FROM AirGate G INNER JOIN AirAirport A ON G.airport = A.i")
) {
  console.log(`Airport ${airportCode} has gate ${gateCode}`);
}
Copy