/ 
DBIO-SQLite-0.900000
/ DBIO::SQLite::Introspect::ForeignKeys

NAME

DBIO::SQLite::Introspect::ForeignKeys - Introspect SQLite foreign keys

VERSION

version 0.900000

DESCRIPTION

Fetches foreign key metadata via PRAGMA foreign_key_list(). Composite FKs are grouped by their id via "_aggregate_by_ordered" in DBIO::Introspect::Base (preserves both first-seen id order and column-seq order within each FK).

METHODS

fetch

my $fks = DBIO::SQLite::Introspect::ForeignKeys->fetch($dbh, $tables);

Returns a hashref keyed by table name. Each value is an arrayref of FK hashrefs with keys: fk_id, from_columns (arrayref), to_table, to_columns (arrayref), on_update, on_delete, match.

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.