App::DBCritic - Critique a database schema for best practices
version 0.023
use App::DBCritic; my $critic = App::DBCritic->new( dsn => 'dbi:Oracle:HR', username => 'scott', password => 'tiger'); $critic->critique();
This package is used to scan a database schema and catalog any violations of best practices as defined by a set of policy plugins. It takes conceptual and API inspiration from Perl::Critic.
dbcritic is the command line interface.
This is a work in progress - please see the "SUPPORT" section below for information on how to contribute. It especially needs ideas (and implementations!) of new policies!
The optional username used to connect to the database.
The optional password used to connect to the database.
The name of a DBIx::Class::Schema class you wish to "critique". Only settable at construction time.
The DBI data source name (required) used to connect to the database. If no "class_name" or "schema" is provided, DBIx::Class::Schema::Loader will then construct schema classes dynamically to be critiqued.
A DBIx::Class::Schema object you wish to "critique". Only settable at construction time.
An attribute predicates that is true or false, depending on whether "schema" has been defined.
Returns an array of loaded policy names that will be applied during "critique". By default all modules under the App::DBCritic::Policy namespace are loaded.
App::DBCritic::Policy
Runs the "schema" through the App::DBCritic engine using all the policies that have been loaded and dumps a string representation of "violations" to STDOUT.
App::DBCritic
STDOUT
Returns an array reference of all App::DBCritic::Violations picked up by the various policies.
You can find documentation for this module with the perldoc command.
perldoc App::DBCritic
The following websites have more information about this module, and may be of help to you. As always, in addition to those websites please use your favorite search engine to discover more resources.
Search CPAN
The default CPAN search engine, useful to view POD in HTML format.
http://search.cpan.org/dist/App-DBCritic
CPAN Ratings
The CPAN Ratings is a website that allows community ratings and reviews of Perl modules.
http://cpanratings.perl.org/d/App-DBCritic
CPANTS
The CPANTS is a website that analyzes the Kwalitee ( code metrics ) of a distribution.
http://cpants.cpanauthors.org/dist/App-DBCritic
CPAN Testers
The CPAN Testers is a network of smoke testers who run automated tests on uploaded CPAN distributions.
http://www.cpantesters.org/distro/A/App-DBCritic
CPAN Testers Matrix
The CPAN Testers Matrix is a website that provides a visual overview of the test results for a distribution on various Perls/platforms.
http://matrix.cpantesters.org/?dist=App-DBCritic
CPAN Testers Dependencies
The CPAN Testers Dependencies is a website that shows a chart of the test results of all dependencies for a distribution.
http://deps.cpantesters.org/?module=bin::dbcritic
Please report any bugs or feature requests through the web interface at https://github.com/mjgardner/dbcritic/issues. You will be automatically notified of any progress on the request by the system.
The code is open to the world, and available for you to hack on. Please feel free to browse it and play with it, or whatever. If you want to contribute patches, please send me a diff or prod me to pull from your repository :)
https://github.com/mjgardner/dbcritic
git clone git://github.com/mjgardner/dbcritic.git
Mark Gardner <mjgardner@cpan.org>
This software is copyright (c) 2019 by Mark Gardner.
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::DBCritic, copy and paste the appropriate command in to your terminal.
cpanm
cpanm App::DBCritic
CPAN shell
perl -MCPAN -e shell install App::DBCritic
For more information on module installation, please visit the detailed CPAN module installation guide.