Validate the current ledgr DuckDB schema

Compares every current table, ordered column, type, nullability, default, constraint and index with ledgr's current schema catalogue.

Usage

ledgr_validate_schema(con)

Arguments

con

A DBI connection to DuckDB.

Value

Invisibly returns TRUE on success.

Examples

db_path <- tempfile(fileext = ".duckdb")
con <- ledgr_db_init(db_path)
ledgr_validate_schema(con)
DBI::dbDisconnect(con, shutdown = TRUE)