App::DiffDBSchemaUtils - Utilities related to diff-ing DB schemas
This document describes version 0.002 of App::DiffDBSchemaUtils (from Perl distribution App-DiffDBSchemaUtils), released on 2018-12-03.
This distribution includes several utilities:
diff_db_schema(%args) -> [status, msg, payload, meta]
Diff two database schemas.
This function is not exported.
Arguments ('*' denotes required arguments):
dsn1* => str
dsn2* => str
password1 => str
password2 => str
username1 => str
username2 => str
Returns an enveloped result (an array).
First element (status) is an integer containing HTTP status code (200 means OK, 4xx caller error, 5xx function error). Second element (msg) is a string containing error message, or 'OK' if status is 200. Third element (payload) is optional, the actual result. Fourth element (meta) is called result metadata and is optional, a hash that contains extra information.
Return value: (any)
diff_mysql_schema(%args) -> [status, msg, payload, meta]
Diff two MySQL database schemas.
Convenient thin wrapper for diff_db_schema, when you have two MySQL databases. Instead of having to specify two DSN's, you just specify two database names.
db1* => str
Name of the first MySQL database.
db2* => str
Name of the second MySQL database.
diff_pg_schema(%args) -> [status, msg, payload, meta]
Diff two PostgreSQL database schemas.
Convenient thin wrapper for diff_db_schema, when you have two PostgreSQL databases. Instead of having to specify two DSN's, you just specify two database names.
Name of the first PostgreSQL database.
Name of the second PostgreSQL database.
diff_sqlite_schema(%args) -> [status, msg, payload, meta]
Diff two SQLite database schemas.
Convenient thin wrapper for diff_db_schema, when you have two SQLite databases. Instead of having to specify two DSN's, you just specify two database paths.
Please visit the project's homepage at https://metacpan.org/release/App-DiffDBSchemaUtils.
Source repository is at https://github.com/perlancar/perl-App-DiffDBSchemaUtils.
Please report any bugs or feature requests on the bugtracker website 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.
For MySQL: MySQL::Diff and its CLI mysqldiff which can compare live database schemas or database schemas specified as SQL. Outputs SQL statements that express the difference.
This software is copyright (c) 2018 by firstname.lastname@example.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.
To install App::DiffDBSchemaUtils, copy and paste the appropriate command in to your terminal.
perl -MCPAN -e shell
For more information on module installation, please visit the detailed CPAN module installation guide.