| 1 | use strict; use warnings; | ||
| 2 | |||
| 3 | package API::Eulerian::EDW::Sql::Join; | ||
| 4 | |||
| 5 | sub new | ||
| 6 | { | ||
| 7 | my $proto = shift; | ||
| 8 | my $class = ref( $proto ) || $proto; | ||
| 9 | my $setup = shift; | ||
| 10 | return bless( { | ||
| 11 | name => $setup->{ name } || undef, | ||
| 12 | left => $setup->{ left } || undef, | ||
| 13 | right => $setup->{ right } || undef, | ||
| 14 | filter => $setup->{ filter } || undef, | ||
| 15 | } | ||
| 16 | ); | ||
| 17 | } | ||
| 18 | |||
| 19 | # | ||
| 20 | # | ||
| 21 | # | ||
| 22 | # | ||
| 23 | sub isset | ||
| 24 | { | ||
| 25 | my ( $self, $key ) = @_; | ||
| 26 | return exists( $self->{ $key } ) && | ||
| 27 | defined( $self->{ $key } ); | ||
| 28 | } | ||
| 29 | |||
| 30 | # | ||
| 31 | # @brief | ||
| 32 | # | ||
| 33 | # @return | ||
| 34 | # | ||
| 35 | sub str | ||
| 36 | { | ||
| 37 | my ( $self ) = @_; | ||
| 38 | my $str = ''; | ||
| 39 | |||
| 40 | $str .= $self->{ left }; | ||
| 41 | $str .= ' WITH '; | ||
| 42 | $str .= $self->{ right }; | ||
| 43 | if( $self->isset( 'filter' ) ) { | ||
| 44 | $str .= " IF { "; | ||
| 45 | $str .= $self->{ filter }; | ||
| 46 | $str .= " } AS $self->{ name }"; | ||
| 47 | } | ||
| 48 | |||
| 49 | return $str; | ||
| 50 | } | ||
| 51 | |||
| 52 | 1; | ||
| 53 | |||
| 54 | __END__ |