| 1 | use strict; use warnings; | ||
| 2 | |||
| 3 | package API::Eulerian::EDW::Sql::Outputs; | ||
| 4 | |||
| 5 | use API::Eulerian::EDW::Sql::Array; | ||
| 6 | use API::Eulerian::EDW::Sql::Output; | ||
| 7 | |||
| 8 | sub new | ||
| 9 | { | ||
| 10 | my $proto = shift; | ||
| 11 | my $class = ref( $proto ) || $proto; | ||
| 12 | my $setup = shift; | ||
| 13 | return bless( { | ||
| 14 | master => $setup->{ master } || undef, | ||
| 15 | mode => $setup->{ mode } || undef, | ||
| 16 | filter => $setup->{ filter } || undef, | ||
| 17 | formulas => new API::Eulerian::EDW::Sql::Array( { sep => ", " } ), | ||
| 18 | } | ||
| 19 | ); | ||
| 20 | } | ||
| 21 | |||
| 22 | sub master | ||
| 23 | { | ||
| 24 | my ( $self, $master ) = @_; | ||
| 25 | |||
| 26 | if( defined( $master ) ) { | ||
| 27 | $self->{ master } = $master; | ||
| 28 | } else { | ||
| 29 | $master = $self->{ master }; | ||
| 30 | } | ||
| 31 | |||
| 32 | return $master; | ||
| 33 | } | ||
| 34 | |||
| 35 | sub mode | ||
| 36 | { | ||
| 37 | my ( $self, $mode ) = @_; | ||
| 38 | |||
| 39 | if( defined( $mode ) ) { | ||
| 40 | $self->{ mode } = $mode; | ||
| 41 | } else { | ||
| 42 | $mode = $self->{ mode }; | ||
| 43 | } | ||
| 44 | |||
| 45 | return $mode; | ||
| 46 | } | ||
| 47 | |||
| 48 | sub filter | ||
| 49 | { | ||
| 50 | my ( $self, $filter ) = @_; | ||
| 51 | |||
| 52 | if( defined( $filter ) ) { | ||
| 53 | $self->{ filter } = $filter; | ||
| 54 | } else { | ||
| 55 | $filter = $self->{ filter }; | ||
| 56 | } | ||
| 57 | |||
| 58 | return $filter; | ||
| 59 | } | ||
| 60 | |||
| 61 | sub add | ||
| 62 | { | ||
| 63 | my ( $self, $formula ) = @_; | ||
| 64 | my $formulas = $self->{ formulas }; | ||
| 65 | |||
| 66 | $formulas->push( | ||
| 67 | new API::Eulerian::EDW::Sql::Output( { | ||
| 68 | formula => $formula | ||
| 69 | } ) | ||
| 70 | ); | ||
| 71 | |||
| 72 | return $formulas->count(); | ||
| 73 | } | ||
| 74 | |||
| 75 | sub str | ||
| 76 | { | ||
| 77 | my ( $self ) = @_; | ||
| 78 | my $formulas = $self->{ formulas }; | ||
| 79 | my $filter = $self->{ filter }; | ||
| 80 | my $str = ''; | ||
| 81 | |||
| 82 | $str .= $self->mode(); | ||
| 83 | $str .= '( '; | ||
| 84 | $str .= $self->master(); | ||
| 85 | $str .= " ) { "; | ||
| 86 | if( $formulas->count() ) { | ||
| 87 | $str .= $formulas->str(); | ||
| 88 | } | ||
| 89 | $str .= " } "; | ||
| 90 | if( defined( $filter ) ) { | ||
| 91 | $str .= "IF { "; | ||
| 92 | $str .= $filter; | ||
| 93 | $str .= " } "; | ||
| 94 | } | ||
| 95 | |||
| 96 | return $str; | ||
| 97 | } | ||
| 98 | |||
| 99 | 1; | ||
| 100 | |||
| 101 | __END__ |