File Coverage

blib/lib/ORM/Filter/Case.pm

Criterion	Covered	Total	%
statement	6	47	12.7
branch	0	16	0.0
condition			n/a
subroutine	2	6	33.3
pod	0	2	0.0
total	8	71	11.2

#
# DESCRIPTION
#   PerlORM - Object relational mapper (ORM) for Perl. PerlORM is Perl
#   library that implements object-relational mapping. Its features are
#   much similar to those of Java's Hibernate library, but interface is
#   much different and easier to use.
#
# AUTHOR
#   Alexey V. Akimov
#
# COPYRIGHT
#   Copyright (C) 2005-2006 Alexey V. Akimov
#
#   This library is free software; you can redistribute it and/or
#   modify it under the terms of the GNU Lesser General Public
#   License as published by the Free Software Foundation; either
#   version 2.1 of the License, or (at your option) any later version.
#
#   This library is distributed in the hope that it will be useful,
#   but WITHOUT ANY WARRANTY; without even the implied warranty of
#   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
#   Lesser General Public License for more details.
#
#   You should have received a copy of the GNU Lesser General Public
#   License along with this library; if not, write to the Free Software
#   Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA  02110-1301  USA
#

package ORM::Filter::Case;

$VERSION=0.8;

use overload 'fallback' => 1;
use base 'ORM::Filter';

##
## CONSTRUCTORS
##

sub new
{
    my $class = shift;
    my $self  = {};

    if( ref $_[0] ne 'ARRAY' )
    {
        $self->{value} = shift;
        unless( UNIVERSAL::isa( $self->{value}, 'ORM::Expr' ) )
        {
            $self->{value} = ORM::Const->new( $self->{value} );
        }
    }

    @{$self->{case}} = @_;

    if( ref $self->{case}[-1] ne 'ARRAY' )
    {
        $self->{else} = pop @{$self->{case}};
    }

    return bless $self, $class;
}

##
## PROPERTIES
##

sub _sql_str
{
    my $self = shift;
    my %arg  = @_;
    my $sql;

    $sql .= 'CASE';
    $sql .= ' '.$self->{value}->_sql_str( %arg ) if( $self->{value} );
    $sql .= "\n";

    for my $case ( @{$self->{case}} )
    {
        $sql .=
            $arg{ident}
            . '  WHEN '.$self->scalar2sql( $case->[0], $arg{tjoin}, $arg{ident}.'  ' )
            . ' THEN '.$self->scalar2sql( $case->[1], $arg{tjoin}, $arg{ident}.'  ' ) . "\n";
    }

    if( exists $self->{else} )
    {
        $sql .= $arg{ident}.'  ELSE '.$self->scalar2sql( $self->{else}, $arg{tjoin}, $arg{ident}.'  ' )."\n";
    }

    $sql .= $arg{ident}."  END";

    return $sql;
}

sub _tjoin
{
    my $self  = shift;
    my $tjoin = ORM::Tjoin->new;

    for my $arg ( $self->{value}, $self->{else} )
    {
        if( UNIVERSAL::isa( $arg, 'ORM::Expr' ) )
        {
            $tjoin->merge( $arg->_tjoin );
        }
    }

    for my $arg ( @{$self->{case}} )
    {
        if( UNIVERSAL::isa( $arg->[0], 'ORM::Expr' ) )
        {
            $tjoin->merge( $arg->[0]->_tjoin );
        }
        if( UNIVERSAL::isa( $arg->[1], 'ORM::Expr' ) )
        {
            $tjoin->merge( $arg->[1]->_tjoin );
        }
    }

    return $tjoin;
}

##
## METHODS
##

sub add_case
{
    my $self = shift;
    my $case = shift;

    push @{$self->{case}}, $case;
}