GSP
Quick Navigator

Search Site

Unix VPS
A - Starter
B - Basic
C - Preferred
D - Commercial
MPS - Dedicated
Previous VPSs
* Sign Up! *

Support
Contact Us
Online Help
Handbooks
Domain Status
Man Pages

FAQ
Virtual Servers
Pricing
Billing
Technical

Network
Facilities
Connectivity
Topology Map

Miscellaneous
Server Agreement
Year 2038
Credits
 

USA Flag

 

 

Man Pages


Manual Reference Pages  -  BIGTOP::SCRIPTHELP::STYLE::PG8LIVE (3)

.ds Aq ’

NAME

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

CONTENTS

SYNOPSIS

For normal use:



    bigtop -n AppName -s Pg8Live \
        dbi:Pg:dbname=yourdb user pass [schema]



Do the same for tentmaker. It also works for -a:



    bigtop -a docs/app.bigtop \
        -s Pg8Live dbi:Pg:dbname=yourdb user pass [schema]



Only tables not in docs/app.bigtop will be affected.

For use in scripts:



    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 makes queries on internal postgres tables to retrieve its data. The queries are probably specific to postgres 8.x. They may work for earlier versions, but I wouldn’t want to put any money down on that.

This module pulls these things from the database whose dsn you supply:
o table names
o column names
o SQL type of each column
o primary keys
o column default values
o foreign keys

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 with a single invocation, but there is no rule against rerunning with the -a flag to bring in others.

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.

Search for    or go to Top of page |  Section 3 |  Main Index


perl v5.20.3 BIGTOP::SCRIPTHELP::STYLE::PG8LIVE (3) 2016-04-03

Powered by GSP Visit the GSP FreeBSD Man Page Interface.
Output converted with manServer 1.07.