NAME

Verby::Action::Mysql::Util - A table introspection utility library.

SYNOPSIS

        use Verby::Action::Mysql::Util;

        my $m = Verby::Action::Mysql::Util->new(
                dbh => $dbh,
                use_time_piece => 1, # date objects are Time::Piece
        );

        my $table_info = $m->get_info("table_name");

        my $time_piece = $table_info->{update_time};

DESCRIPTION

This utility module knows to query a MySQL database handle for into regarding a table, mostly concerning the structure metadata itself.

METHODS

new DBH

new PARAMS

Create a new meta data extractor thingamabob.

It takes either a single database handle, or a list of key/value pairs, with the key being the name of the corresponding method as named below.

get_info TABLE_NAME

This method returns a hash containing the various fields of data regarding a table.

dbh

Returns the database handle being used.

use_time_piece BOOL

Returns or set

TABLE INFO DATA FIELDS

BUGS

None that we are aware of. Of course, if you find a bug, let us know, and we will be sure to fix it.

CODE COVERAGE

We use Devel::Cover to test the code coverage of the tests, please refer to COVERAGE section of the Verby module for more information.

SEE ALSO

AUTHOR

Yuval Kogman, <nothingmuch@woobling.org>

COPYRIGHT AND LICENSE

Copyright 2005, 2006 by Infinity Interactive, Inc.

http://www.iinteractive.com

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