SQLite Dump Util

A utility function that generates SQL statements to dump the data and schema of tables in a SQLite database.

This example specifically dumps the users table and logs the output:

Create val
import { sqliteDump } from "https://esm.town/v/nbbaier/sqliteDump";

const dump = await sqliteDump(["users"]);
console.log(dump)

You can optionally specify a callback to handle the result. The example below dumps the users table and emails it using std/email.

Create val
import { email } from "https://esm.town/v/std/email";
import { sqliteDump } from "https://esm.town/v/nbbaier/sqliteDump";

await sqliteDump(["users"], async (res) => {
  await email({ text: res });
});

function sqliteDump(tables?: string[], callback?: ((result: string) => string | void | Promise<void>) | undefined): Promise<string | void>

• tables: (Optional) Array of table names to include in the dump. If not provided, all tables will be included.
• callback: (Optional) An (potentially async) callback function to process the dump result. The callback receives the dump string as its argument.