X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=lib%2FSQL%2FAbstract%2FClauses.pm;h=fc36e742f41f5fcbbd818e43799802d4e468d3b6;hb=a01911a20b326afd1a45f97f14aca68206708eba;hp=877117df2920e21997e971d11f39a61f60f40197;hpb=58ebc7fa5f9ccaabc1ce23d57ab642c6825bdebc;p=scpubgit%2FQ-Branch.git diff --git a/lib/SQL/Abstract/Clauses.pm b/lib/SQL/Abstract/Clauses.pm index 877117d..fc36e74 100644 --- a/lib/SQL/Abstract/Clauses.pm +++ b/lib/SQL/Abstract/Clauses.pm @@ -16,12 +16,12 @@ sub register_defaults { my ($self) = @_; $self->{clauses_of}{select} = [ qw(select from where order_by) ]; $self->{expand}{select} = sub { shift->_expand_statement(@_) }; - $self->{render}{select} = sub { shift->_render_statement(select => @_) }; + $self->{render}{select} = sub { shift->_render_statement(@_) }; $self->{expand_clause}{"select.$_"} = "_expand_select_clause_$_" for @{$self->{clauses_of}{select}}; $self->{clauses_of}{update} = [ qw(target set where returning) ]; $self->{expand}{update} = sub { shift->_expand_statement(@_) }; - $self->{render}{update} = sub { shift->_render_statement(update => @_) }; + $self->{render}{update} = sub { shift->_render_statement(@_) }; $self->{expand_clause}{"update.$_"} = "_expand_update_clause_$_" for @{$self->{clauses_of}{update}}; $self->{expand_clause}{'update.update'} = '_expand_update_clause_target'; @@ -32,7 +32,7 @@ sub register_defaults { }; $self->{clauses_of}{delete} = [ qw(target where returning) ]; $self->{expand}{delete} = sub { shift->_expand_statement(@_) }; - $self->{render}{delete} = sub { shift->_render_statement(delete => @_) }; + $self->{render}{delete} = sub { shift->_render_statement(@_) }; $self->{expand_clause}{"delete.$_"} = "_expand_delete_clause_$_" for @{$self->{clauses_of}{delete}}; $self->{expand_clause}{"delete.from"} = '_expand_delete_clause_target'; @@ -45,7 +45,7 @@ sub register_defaults { 'target', 'fields', 'from', 'returning' ]; $self->{expand}{insert} = sub { shift->_expand_statement(@_) }; - $self->{render}{insert} = sub { shift->_render_statement(insert => @_) }; + $self->{render}{insert} = sub { shift->_render_statement(@_) }; $self->{expand_clause}{'insert.into'} = '_expand_insert_clause_target'; $self->{expand_clause}{'insert.target'} = '_expand_insert_clause_target'; $self->{expand_clause}{'insert.fields'} = sub { @@ -128,6 +128,10 @@ sub _expand_delete_clause_returning { sub _expand_statement { my ($self, $type, $args) = @_; my $ec = $self->{expand_clause}; + if ($args->{_}) { + $args = { %$args }; + $args->{$type} = delete $args->{_} + } return +{ "-${type}" => +{ map { my $val = $args->{$_}; @@ -164,7 +168,7 @@ sub _render_statement { next unless defined($sql) and length($sql); push @parts, \@part; } - my ($sql, @bind) = $self->_join_parts(' ', @parts); + my ($sql, @bind) = $self->join_clauses(' ', @parts); return ( (our $Render_Top_Level ? $sql : '('.$sql.')'), @bind @@ -259,8 +263,8 @@ sub _expand_values { } sub _render_values { - my ($self, $values) = @_; - my ($v_sql, @bind) = $self->_join_parts( + my ($self, undef, $values) = @_; + my ($v_sql, @bind) = $self->join_clauses( ', ', map [ $self->render_aqt($_) ], ref($values) eq 'ARRAY' ? @$values : $values @@ -274,14 +278,14 @@ sub _render_values { sub _ext_rw { my ($self, $name, $key, $value) = @_; - return $self->{$name}{$key} unless @_ > 2; + return $self->{$name}{$key} unless @_ > 3; $self->{$name}{$key} = $value; return $self; } BEGIN { foreach my $type (qw( - expand op_expand render op_renderer clause_expand clause_render + expand op_expand render op_render clause_expand clause_render )) { my $key = join '_', reverse split '_', $type; my $singular = "${type}er"; @@ -302,6 +306,9 @@ sub clauses_of { unless (@clauses) { return @{$self->{clauses_of}{$of}||[]}; } + if (ref($clauses[0]) eq 'CODE') { + @clauses = $self->${\($clauses[0])}(@{$self->{clauses_of}{$of}||[]}); + } $self->{clauses_of}{$of} = \@clauses; return $self; }