view release on metacpan or  search on metacpan

script/diff-pg-schema  view on Meta::CPAN

use 5.010001;
use strict;
use warnings;

use Perinci::CmdLine::Any;

my $cmdline = Perinci::CmdLine::Any->new(
    url => "/App/DiffDBSchemaUtils/diff_pg_schema",
    program_name => "diff-pg-schema",
    read_config => 0,
    read_env => 0,
);

$cmdline->run;

# ABSTRACT: Diff two PostgreSQL database schemas
# PODNAME: diff-pg-schema

__END__

=pod

=encoding UTF-8

=head1 NAME

diff-pg-schema - Diff two PostgreSQL database schemas

=head1 VERSION

This document describes version 0.002 of diff-pg-schema (from Perl distribution App-DiffDBSchemaUtils), released on 2018-12-03.

=head1 SYNOPSIS

Usage:

 % diff-pg-schema [options] <db1> <db2>

=head1 DESCRIPTION

Convenient thin wrapper for C<diff_db_schema>, when you have two PostgreSQL
databases. Instead of having to specify two DSN's, you just specify two database
names.

=head1 OPTIONS

C<*> marks required options.

=head2 Db connection options

=over

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

Name of the first PostgreSQL database.

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

Name of the second PostgreSQL database.

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

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

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

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

=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<--help>, B<-h>, B<-?>

Display help message and exit.

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

Display program's version and exit.

=back