NAME

App::DBCritic::Policy::NullableTextColumn - Check for ResultSources with nullable text columns

VERSION

version 0.021

SYNOPSIS

use App::DBCritic;

my $critic = App::DBCritic->new(
    dsn => 'dbi:Oracle:HR', username => 'scott', password => 'tiger');
$critic->critique();

DESCRIPTION

This policy returns a violation if a DBIx::Class::ResultSource has nullable text columns.

ATTRIBUTES

description

"Nullable text column"

explanation

"Text columns should not be nullable. Default to empty string instead."

applies_to

This policy applies to ResultSources.

METHODS

violates

Returns details of each column from the "current element" that maps to following data types and "is nullable":

TEXT

NTEXT

CLOB

NCLOB

CHARACTER

CHAR

NCHAR

VARCHAR

VARCHAR2

NVARCHAR2

CHARACTER VARYING

SQL_CHAR

SQL_CLOB

SQL_VARCHAR

SQL_WVARCHAR

SQL_LONGVARCHAR

SQL_WLONGVARCHAR

SUPPORT

Perldoc

You can find documentation for this module with the perldoc command.

perldoc bin::dbcritic

Websites

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

• AnnoCPAN

  The AnnoCPAN is a website that allows community annotations of Perl module documentation.

  http://annocpan.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 smokers 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

Bugs / Feature Requests

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.

Source Code

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

AUTHOR

Mark Gardner <mjgardner@cpan.org>

COPYRIGHT AND LICENSE

This software is copyright (c) 2014 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.

cpanm App::DBCritic

perl -MCPAN -e shell
install App::DBCritic