view release on metacpan or  search on metacpan

bin/dump-dbi-table-info  view on Meta::CPAN

#!perl

use 5.010001;
use strict;
use warnings;

use DBI;
use Perinci::CmdLine::Any;

our %SPEC;

$SPEC{dump_dbi_table_info} = {
    v => 1.1,
    summary => 'Dump DBI table_info() information',
    args => {
        dsn => {
            schema => 'str*',
            req => 1,
            pos => 0,
        },
        user => {
            schema => 'str*',
        },
        password => {
            schema => 'str*',
        },
        catalog => {
            schema => 'str*',
        },
        schema => {
            schema => 'str*',
            default => 'main',
        },
    },
};
sub dump_dbi_table_info {
    my %args = @_;

    my $dbh = DBI->connect($args{dsn}, $args{user}, $args{password},
                           {RaiseError=>1});
    my @rows;
    my $sth = $dbh->table_info($args{catalog}, $args{schema}, "%", undef);
    while (my $row = $sth->fetchrow_hashref) {
        push @rows, $row;
    }
    [200, "OK", \@rows];
}

Perinci::CmdLine::Any->new(url => '/main/dump_dbi_table_info')->run;

# ABSTRACT: Dump DBI table_info() information
# PODNAME: dump-dbi-table-info

__END__

=pod

=encoding UTF-8

=head1 NAME

dump-dbi-table-info - Dump DBI table_info() information

=head1 VERSION

This document describes version 0.001 of dump-dbi-table-info (from Perl distribution App-DBIUtils), released on 2016-07-09.

=head1 SYNOPSIS

Usage:

 % dump-dbi-table-info [options] <dsn>

=head1 OPTIONS

C<*> marks required options.

=head2 Configuration options

=over

=item B<--config-path>=I<filename>

Set path to configuration file.

Can be specified multiple times.

=item B<--config-profile>=I<s>

Set configuration profile to use.

=item B<--no-config>

Do not use any configuration file.

=back

=head2 Environment options

=over

=item B<--no-env>

Do not read environment for default options.

=back

=head2 Output options

=over

=item B<--format>=I<s>

Choose output format, e.g. json, text.

Default value:

 undef

=item B<--json>

Set output format to json.

=item B<--naked-res>

When outputing as JSON, strip result envelope.

Default value:

 0

By default, when outputing as JSON, the full enveloped result is returned, e.g.:

    [200,"OK",[1,2,3],{"func.extra"=>4}]

The reason is so you can get the status (1st element), status message (2nd
element) as well as result metadata/extra result (4th element) instead of just
the result (3rd element). However, sometimes you want just the result, e.g. when
you want to pipe the result for more post-processing. In this case you can use
`--naked-res` so you just get:

    [1,2,3]


=back

=head2 Other options

=over

=item B<--catalog>=I<s>

=item B<--dsn>=I<s>*

=item B<--help>, B<-h>, B<-?>

Display help message and exit.

=item B<--password>=I<s>

=item B<--schema>=I<s>

Default value:

 "main"

=item B<--user>=I<s>

=item B<--version>, B<-v>

Display program's version and exit.

=back

=head1 COMPLETION

This script has shell tab completion capability with support for several
shells.

=head2 bash

To activate bash completion for this script, put:

 complete -C dump-dbi-table-info dump-dbi-table-info

in your bash startup (e.g. C<~/.bashrc>). Your next shell session will then
recognize tab completion for the command. Or, you can also directly execute the
line above in your shell to activate immediately.

It is recommended, however, that you install L<shcompgen> which allows you to
activate completion scripts for several kinds of scripts on multiple shells.
Some CPAN distributions (those that are built with
L<Dist::Zilla::Plugin::GenShellCompletion>) will even automatically enable shell
completion for their included scripts (using C<shcompgen>) at installation time,
so you can immadiately have tab completion.

=head2 tcsh

To activate tcsh completion for this script, put:

 complete dump-dbi-table-info 'p/*/`dump-dbi-table-info`/'

in your tcsh startup (e.g. C<~/.tcshrc>). Your next shell session will then
recognize tab completion for the command. Or, you can also directly execute the
line above in your shell to activate immediately.

It is also recommended to install C<shcompgen> (see above).

=head2 other shells

For fish and zsh, install C<shcompgen> as described above.

=head1 CONFIGURATION FILE

This script can read configuration file, which by default is searched at ~/.config/dump-dbi-table-info.conf, ~/dump-dbi-table-info.conf or /etc/dump-dbi-table-info.conf (can be changed by specifying C<--config-path>). All found files will be read and...

To disable searching for configuration files, pass C<--no-config>.

Configuration file is in the format of L<IOD>, which is basically INI with some extra features.

You can put multiple profiles in a single file by using section names like C<[profile=SOMENAME]> (filter by profile). Those sections will only be read if you specify the matching C<--config-profile SOMENAME>.

You can also put configuration for multiple programs inside a single file, and use filter C<program=NAME> in section names, e.g. C<[program=foo ...]>. The section will then only be used when the reading program matches.

Finally, you can filter a section by environment variable using the filter C<env=CONDITION> in section names. For example if you only want a section to be read if a certain environment variable is true: C<[env=SOMEVAR ...]>. If you only want a sectio...

List of available configuration parameters:

 catalog (see --catalog)
 dsn (see --dsn)
 format (see --format)
 naked_res (see --naked-res)
 password (see --password)
 schema (see --schema)
 user (see --user)

=head1 ENVIRONMENT

=head2 DUMP_DBI_TABLE_INFO_OPT => str

Specify additional command-line options

=head1 FILES

~/.config/dump-dbi-table-info.conf

~/dump-dbi-table-info.conf

/etc/dump-dbi-table-info.conf

=head1 HOMEPAGE

Please visit the project's homepage at L<https://metacpan.org/release/App-DBIUtils>.

=head1 SOURCE

Source repository is at L<https://github.com/perlancar/perl-App-DBIUtils>.

=head1 BUGS

Please report any bugs or feature requests on the bugtracker website L<https://rt.cpan.org/Public/Dist/Display.html?Name=App-DBIUtils>

When submitting a bug or request, please include a test-file or a
patch to an existing test-file that illustrates the bug or desired
feature.

=head1 AUTHOR

perlancar <perlancar@cpan.org>

=head1 COPYRIGHT AND LICENSE

This software is copyright (c) 2016 by perlancar@cpan.org.

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

=cut