Function snapshotTables

snapshotTables(
    sql: UpdbSql,
    options?: UpdbOptions,
):
    | {
        counts?: undefined;
        error: string;
        missing?: undefined;
        ok: boolean;
        rowsWritten?: undefined;
        statements?: undefined;
        total?: undefined;
    }
    | {
        counts: Record<string, number>;
        error: string;
        missing?: undefined;
        ok: boolean;
        rowsWritten?: undefined;
        statements?: undefined;
        total: number;
    }
    | {
        counts: Record<string, number>;
        error?: undefined;
        missing: string[];
        ok: boolean;
        rowsWritten: number;
        statements: number;
        total: number;
    }
Copies the bookkeeping tables (CREATE TABLE ... AS SELECT), refusing past a 20,000-row ceiling, a fifth of the 100,000 rows/day meter; the refusal names the largest table.
Parameters
- sql: UpdbSql
- options: UpdbOptions = {}
Returns
    | {
        counts?: undefined;
        error: string;
        missing?: undefined;
        ok: boolean;
        rowsWritten?: undefined;
        statements?: undefined;
        total?: undefined;
    }
    | {
        counts: Record<string, number>;
        error: string;
        missing?: undefined;
        ok: boolean;
        rowsWritten?: undefined;
        statements?: undefined;
        total: number;
    }
    | {
        counts: Record<string, number>;
        error?: undefined;
        missing: string[];
        ok: boolean;
        rowsWritten: number;
        statements: number;
        total: number;
    }
- Defined in src/ops/updb.ts:663

Function snapshotTables

Parameters

Settings