The London Perl and Raku Workshop takes place on 26th Oct 2024. If your company depends on Perl, please consider sponsoring and/or attending.

NAME

DBIx::Inspector - Get information from $dbh

SYNOPSIS

use DBIx::Inspector;

my $dbh = DBI->connect(...) or die;
my $inspector = DBIx::Inspector->new(dbh => $dbh);
my @tables = $inspector->tables;
for my $table (@tables) {
    print "  pk:\n";
    for my $pk ($table->primary_key) {
        print "    ", $pk->name, "\n";
    }
    print "  columns:\n";
    for my $column ($table->columns) {
        print "    ", $column->name, "\n";
    }
}

DESCRIPTION

DBIx::Inspector is a inspector for $dbh.

This is under development. Any API will change without notice.

METHODS

my $inspector = DBIx::Inspector->new(dbh => $dbh);

Create new instance of DBIx::Inspector.

my @tables = $inspector->tables();

Retrieve table objects from $dbh. Every elements in @tables is instance of DBIx::Inspector::Table.

my $table = $inspector->table($table_name);

Retrieve table object from $dbh. Return value is instance of DBIx::Inspector::Table.

my @views = $inspector->views();

Retrieve view objects from $dbh. Every elements in @views is instance of DBIx::Inspector::Table.

my $view = $inspector->view($view_name);

Retrieve view object from $dbh. Return value is instance of DBIx::Inspector::Table.

AUTHOR

Tokuhiro Matsuno <tokuhirom AAJKLFJEF@ GMAIL COM>

SEE ALSO

DBI

LICENSE

Copyright (C) Tokuhiro Matsuno

This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.