NAME
DBIO::SQLite::Introspect - Introspect a SQLite database via sqlite_master and PRAGMAs
VERSION
version 0.900000
DESCRIPTION
DBIO::SQLite::Introspect reads the live state of a SQLite database via sqlite_master and the relevant PRAGMA statements and returns a unified model hashref. It is the source side of the test-deploy-and- compare strategy used by DBIO::SQLite::Deploy.
my $intro = DBIO::SQLite::Introspect->new(dbh => $dbh);
my $model = $intro->model;
# $model->{tables}, $model->{columns}, $model->{indexes}, $model->{foreign_keys}
The model shape mirrors DBIO::PostgreSQL::Introspect so the same diff/deploy patterns apply, but only covers what SQLite actually has (no schemas, types, functions, RLS).
AUTHOR
DBIO & DBIx::Class Authors
COPYRIGHT AND LICENSE
Copyright (C) 2026 DBIO Authors Portions Copyright (C) 2005-2025 DBIx::Class Authors Based on DBIx::Class, heavily modified.
This is free software; you can redistribute it and/or modify it under the same terms as the Perl 5 programming language system itself.