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.