| 1 | use strict; use warnings; | ||
| 2 | |||
| 3 | package API::Eulerian::EDW::Sql::Group; | ||
| 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 | with => $setup->{ with } || undef, | ||
| 13 | filter => $setup->{ filter } || undef, | ||
| 14 | } | ||
| 15 | ); | ||
| 16 | } | ||
| 17 | # | ||
| 18 | # | ||
| 19 | # | ||
| 20 | # | ||
| 21 | sub isset | ||
| 22 | { | ||
| 23 | my ( $self, $key ) = @_; | ||
| 24 | return exists( $self->{ $key } ) && | ||
| 25 | defined( $self->{ $key } ); | ||
| 26 | } | ||
| 27 | |||
| 28 | sub str | ||
| 29 | { | ||
| 30 | my ( $self ) = @_; | ||
| 31 | my $str = ''; | ||
| 32 | |||
| 33 | $str .= $self->{ name }; | ||
| 34 | $str .= ' WITH '; | ||
| 35 | $str .= $self->{ with }; | ||
| 36 | if( $self->isset( 'filter' ) ) { | ||
| 37 | $str .= " IF { "; | ||
| 38 | $str .= $self->{ filter }; | ||
| 39 | $str .= " } "; | ||
| 40 | } | ||
| 41 | |||
| 42 | return $str; | ||
| 43 | } | ||
| 44 | |||
| 45 | 1; | ||
| 46 | |||
| 47 | __END__ |