—

              
#!perl
# Note: This script is a CLI for Riap function /App/DiffDBSchemaUtils/diff_sqlite_schema
# and generated automatically using Perinci::CmdLine::Gen version 0.487
our $DATE = '2018-12-03'; # DATE
our $DIST = 'App-DiffDBSchemaUtils'; # DIST
our $VERSION = '0.002'; # VERSION
use 5.010001;
use strict;
use warnings;
use Perinci::CmdLine::Any;
my $cmdline = Perinci::CmdLine::Any->new(
    url => "/App/DiffDBSchemaUtils/diff_sqlite_schema",
    program_name => "diff-sqlite-schema",
    read_config => 0,
    read_env => 0,
);
$cmdline->run;
# ABSTRACT: Diff two SQLite database schemas
# PODNAME: diff-sqlite-schema
__END__
HideShow 166 lines of Pod
=pod
=encoding UTF-8
=head1 NAME
diff-sqlite-schema - Diff two SQLite database schemas
=head1 VERSION
This document describes version 0.002 of diff-sqlite-schema (from Perl distribution App-DiffDBSchemaUtils), released on 2018-12-03.
=head1 SYNOPSIS
Usage:
 % diff-sqlite-schema [options] <db1> <db2>
=head1 DESCRIPTION
Convenient thin wrapper for C<diff_db_schema>, when you have two SQLite
databases. Instead of having to specify two DSN's, you just specify two database
paths.
=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
=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 diff-sqlite-schema diff-sqlite-schema
in your bash startup (e.g. F<~/.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 modules using L<cpanm-shcompgen>
which can activate shell completion for scripts immediately.
=head2 tcsh
To activate tcsh completion for this script, put:
 complete diff-sqlite-schema 'p/*/`diff-sqlite-schema`/'
in your tcsh startup (e.g. F<~/.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 L<shcompgen> (see above).
=head2 other shells
For fish and zsh, install L<shcompgen> as described above.
=head1 HOMEPAGE
Please visit the project's homepage at L<https://metacpan.org/release/App-DiffDBSchemaUtils>.
=head1 SOURCE
Source repository is at L<https://github.com/perlancar/perl-App-DiffDBSchemaUtils>.
=head1 BUGS
Please report any bugs or feature requests on the bugtracker website L<https://rt.cpan.org/Public/Dist/Display.html?Name=App-DiffDBSchemaUtils>
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) 2018 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