DBIx::SQLEngine::Criteria - Struct for database criteria info
my $crit = DBIx::SQLEngine::Criteria->type_new( $type, ... ); print $crit->sql_where();
DBIx::SQLEngine::Criteria objects hold information about particular query criteria.
Multiple subclasses based on type.
Abstract. Implemented in each subclass
DBIx::SQLEngine::Criteria->type_new( $type, @args ) : $criteria
Looks up type, then calls new.
Multiple subclasses based on type. (See "subclass_name" in Class::MakeMethods::Template::ClassName.)
DBIx::SQLEngine::Criteria->auto( $sql_string ) : $criteria DBIx::SQLEngine::Criteria->auto( [ $sql_string, @params ] ) : $criteria DBIx::SQLEngine::Criteria->auto( { fieldname => matchvalue, ... } ) : $criteria DBIx::SQLEngine::Criteria->auto( $criteria_object ) : $criteria_object
Convert any one of several standard criteria representations into a DBIx::SQLEngine::Criteria object.
DBIx::SQLEngine::Criteria->auto( @any_of_the_above ) : $criteria
Create a single criteria requiring the satisfaction of each of the separate criteria passed in. Supports the same argument forms as auto.
DBIx::SQLEngine::Criteria->auto_where( @any_of_the_above ) : $sql, @params
Create a single criteria requiring the satisfaction of each of the separate criteria passed in, and returns its sql_where results. Supports the same argument forms as auto.
The following criteria subclasses are included in this distribution:
Requires all of its subclauses to be true.
Requires at least one of its subclauses to be true.
Requires its one subclause to be false.
Requires an exact match with its comparison value.
Requires a value higher than its comparison value.
Requires a value lower than its comparison value.
Requires a value that matches its comparison value, including any SQL wildcards.
Functions as an Equality unless a wildcard is used, in which case it's a Like.
Easy way to create a group of StringComparison criteria.
Encapsulates a snippet of literal SQL, optionally with placeholder parameters.
Empty subclass to support an old name for Equality Criteria.
Empty subclass to support an old name for Lesser Criteria.
See DBIx::SQLEngine for the overall interface and developer documentation.
See DBIx::SQLEngine::Docs::ReadMe for general information about this distribution, including installation and license information.
To install DBIx::SQLEngine, copy and paste the appropriate command in to your terminal.
cpanm
cpanm DBIx::SQLEngine
CPAN shell
perl -MCPAN -e shell install DBIx::SQLEngine
For more information on module installation, please visit the detailed CPAN module installation guide.