Function checkpointTruncate

apps/local/src/db/v1-v2-migration.ts:1374–1386

(client: Client, path: string)

};

const checkpointTruncate = async (client: Client, path: string): Promise<void> => {
  const result = await client.execute("PRAGMA wal_checkpoint(TRUNCATE)");
  const row = result.rows[0] ?? {};
  const busy = Number(row["busy"] ?? 0);
  const log = Number(row["log"] ?? 0);
  const checkpointed = Number(row["checkpointed"] ?? 0);
  if (busy !== 0 || log !== checkpointed) {
    throw new LocalV1V2MigrationError({
      message: `Could not fully checkpoint SQLite WAL for ${path}`,
      cause: row,
    });
  }
};

const checkpointSqliteFileSetIfBaseExists = async (path: string): Promise<void> => {
  if (!fs.existsSync(path)) return;