Function interactive

db/cli.ts:292–313

* Launches an interactive terminal with Knex.js.

(options?: {
  env?: string;
  schema?: string;
  args?: string[];
})

 * Launches an interactive terminal with Knex.js.
 */
async function interactive(options?: {
  env?: string;
  schema?: string;
  args?: string[];
}) {
  const db = getDatabase(options);
  Object.defineProperty(globalThis, "db", { value: db });

  // Fetch the current database version
  const [x] = await db.select(
    db.raw("version(), current_database() as database"),
  );

  console.log(`Connected to ${chalk.greenBright(x.database)}. Usage example:`);
  console.log(``);
  console.log(`   await db.table("user").first()`);
  console.log(`   await db.select(db.raw("version()"))`);
  console.log(`   await db.fn.newUserId()`);
  console.log(``);
  console.log(`Type ${chalk.greenBright(".exit")} to exit the REPL shell`);
  repl.start(chalk.blueBright(`#> `)).on("exit", () => db?.destroy());
}

/**
 * Exports database data to a backup file.