NAME

Bigtop::ScriptHelp::Style::PgLive - gets its descriptions from Postgresql

SYNOPSIS

use Bigtop::ScriptHelp::Style;

my $style = Bigtop::ScriptHelp::Style->get_style( 'PgLive' );

# then pass $style to methods of Bigtop::ScriptHelp

DESCRIPTION

See Bigtop::ScriptHelp::Style for a description of what this module must do in general.

This module pulls the database layout from the supplied database. It uses a subset of the techniques in DBIx::Class::Schema::Loader and its Postgres support modules DBIx::Class::Schema::Loader::DBI and DBIx::Class::Schema::Loader::DBI::Pg.

Basically, this means that it uses standard DBI or SQL features to extract the structure whenever possible. Some contortions are required.

This module currently only pulls table names (not columns and their types). This is severely limiting and I hope it changes in the near future.

METHODS

get_db_layout

This method does not use standard in. Instead, it expects these command line arguments (in order):

dsn

Suitable for handing to DBI->connect. Example:

dbi:Pg:dbname=yourdb

database user

password for user

(optional) schema

Defaults to 'public.' Use this if you need to bring in tables from one schema. There is no support for handling multiple schemas

AUTHOR

Phil Crow, <crow.phil@gmail.com>

COPYRIGHT AND LICENSE

Copyright (C) 2007, Phil Crow

This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself, either Perl version 5.8.6 or, at your option, any later version of Perl 5 you may have available.