Struct Database 

pub struct Database { /* private fields */ }

Wrapper around a rusqlite::Connection with project-standard pragmas applied and migrations run.

Implementations

impl Database

pub fn open(path: &Path) -> Result<Database>

Open or create a SQLite database at path, apply pragmas, and run any pending migrations.

Tilde-expansion is applied to path.

Errors

• TgaError::DbError for SQLite-level failures.
• TgaError::MigrationError if a migration fails.

pub fn open_in_memory() -> Result<Database>

Open an in-memory database. Primarily intended for tests.

Errors

See Database::open.

pub fn connection(&self) -> &Connection

Borrow the underlying connection (read-only).

pub fn connection_mut(&mut self) -> &mut Connection

Borrow the underlying connection mutably.

pub fn journal_mode(&self) -> Result<String>

Return the active journal mode (e.g. "wal" or "memory").

Errors

Returns TgaError::DbError if the pragma query fails.

pub fn schema_version(&self) -> Result<i64>

Return the highest applied migration version.

Errors

Returns TgaError::DbError if the query fails.

pub fn wal_checkpoint(&self, mode: CheckpointMode) -> Result<()>

Checkpoint the WAL into the main database file.

Why: SQLite WAL mode defers writes to a separate -wal file; if the process exits (or is killed) before a checkpoint, the main database file can lag behind the WAL. On clean exit callers should call wal_checkpoint(CheckpointMode::Truncate) to flush and zero the WAL, guaranteeing durability. During long-running writes, periodic wal_checkpoint(CheckpointMode::Passive) calls limit the data-loss window on crash. See bug #298.

What: executes PRAGMA wal_checkpoint(<mode>) and logs the result. Returns Ok(()) on success; returns an error if the checkpoint pragma fails (e.g. SQLITE_CORRUPT).

Checkpoint modes

• CheckpointMode::Passive — copies frames from the WAL without blocking writers. Safe to call mid-run; used for periodic crash- resilience checkpoints.
• CheckpointMode::Truncate — flushes all WAL frames to the main database and truncates the WAL file to zero. Call on clean exit to guarantee durability and cap the WAL file size.

Errors

Returns TgaError::DbError if the pragma query fails.

Test

See tests::wal_checkpoint_truncate_zeroes_wal_on_file_db.