Adrian Witas > SQL-Entity > SQL::Entity::Condition

Download:
SQL-Entity-0.05.tar.gz

Dependencies

Annotate this POD

CPAN RT

Open  1
View/Report Bugs
Module Version: 0.01   Source  

NAME ^

SQL::Entity::Condition - Entity SQL Condition abstraction.

DESCRIPTION ^

Represents sql condition.

SYNOPSIS ^

    use SQL::Entity::Condition ':all';

    #Creates "a = 1" condition
    my $cond = sql_cond('a', '=', 1);

    #Creates "a = 1 AND b > 1 AND c < 1" condition
    my $cond = sql_and( 
        sql_cond('a', '=', 1),
        sql_cond('b', '>', 1),
        sql_cond('c', '<', 1),
    );    

    Creates "a = 1 OR b > 1 OR c < 1" condition
    my $cond = sql_or( 
      sql_cond('a', '=', 1),
      sql_cond('b', '>', 1),
      sql_cond('c', '<', 1),
    );    

    Creates "(a = 1 AND  b = 1) OR c LIKE 1" condition
    my $cond = sql_and(
      sql_cond('a', '=', 1),
      sql_cond('b', '=', 1),
    )->or( 
      sql_cond('c', 'LIKE', 1)
    );

EXPORT

None by default. sql_cond sql_and sql_or by tag 'all'

ATTRIBUTES

operand1

First operand for condition.

set_operand1

Sets the first condition operand .

operator

Operator

operand2

Second operand for condition.

set_operand2

Sets the secound condition operand .

relation

Relation between compsite condition.

conditions

Association to composie condition

METHOD

new
condition_iterator
sql_cond( string | SQL::Entity::Column: $operand1, string: $operator, string | SQL::Entity::Column: $operand2) returns SQL::Entity::Condition

Create simple Condition object.

and

Create a composite Condition object with AND relation between current object and passed in condition list.

or

Create a composite Condition object with OR relation between current object an passed in condition list.

sql_and

Create a composite Condition object with AND relation.

sql_or

Create a composite Condition object with OR relation.

sql_composite

Create a composite Condition object.

as_string

Converts condition to string

operand

Return expression for passed in operand.

extend_bind_variables
struct_to_condition

Converts passed in data structure to condition object. SQL::Entity::Condition->struct_to_condition(a => 1, b => 3); converts to a = 1 AND b = 3

SQL::Entity::Condition->struct_to_condition(a => 1, b => [1,3]); converts to a = 1 AND b IN (1,3)

SQL::Entity::Condition->struct_to_condition(a => 1, b => {operator => '!=', operand => 3}); converts to a = 1 AND b != 3

SQL::Entity::Condition->struct_to_condition(a => 1, b => {operator => 'LIKE', operand => "'A%'", relation => 'OR'}); coverts to a = 1 OR b LIKE 'A%'

convert_extended_operand

Return operator, operand2, relation for passed in operand

SEE ALSO ^

SQL::Query SQL::Entity SQL::Entity::Column

COPYRIGHT AND LICENSE ^

The SQL::Entity::Condition module is free software. You may distribute under the terms of either the GNU General Public License or the Artistic License, as specified in the Perl README file.

AUTHOR ^

Adrian Witas, adrian@webapp.strefa.pl

syntax highlighting: