X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=lib%2FSQL%2FAbstract%2FExtraClauses.pm;h=5e2e9a17c15f8faae6c9c0205e94b2f9ce9ce1a8;hb=58ebc7fa5f9ccaabc1ce23d57ab642c6825bdebc;hp=b874be57e5c12d2fbe5e2f125f247ee46d3dff34;hpb=e0eb8d26a5a2548ac7f015b66512981a730474ac;p=scpubgit%2FQ-Branch.git diff --git a/lib/SQL/Abstract/ExtraClauses.pm b/lib/SQL/Abstract/ExtraClauses.pm index b874be5..5e2e9a1 100644 --- a/lib/SQL/Abstract/ExtraClauses.pm +++ b/lib/SQL/Abstract/ExtraClauses.pm @@ -8,32 +8,41 @@ use base qw(SQL::Abstract::Clauses); BEGIN { *puke = \&SQL::Abstract::puke } -sub new { - my ($proto, @args) = @_; - my $new = $proto->next::method(@args); - $new->{clauses_of}{select} = [ - @{$new->{clauses_of}{select}}, qw(group_by having) - ]; - $new->{expand_clause}{'select.group_by'} = sub { - $_[0]->_expand_maybe_list_expr($_[1], -ident) - }; - $new->{expand_clause}{'select.having'} = sub { - $_[0]->expand_expr($_[1]) - }; - $new->{expand}{from_list} = '_expand_from_list'; - $new->{render}{from_list} = '_render_from_list'; - $new->{expand}{join} = '_expand_join'; - $new->{render}{join} = '_render_join'; - $new->{expand_op}{as} = '_expand_op_as'; - $new->{expand}{as} = '_expand_op_as'; - $new->{render}{as} = '_render_as'; - splice(@{$new->{clauses_of}{update}}, 2, 0, 'from'); - splice(@{$new->{clauses_of}{delete}}, 1, 0, 'using'); - $new->{expand_clause}{'update.from'} = '_expand_select_clause_from'; - $new->{expand_clause}{'delete.using'} = sub { - +(using => $_[0]->_expand_from_list(undef, $_[1])); - }; - return $new; +sub register_defaults { + my $self = shift; + $self->next::method(@_); + $self->clauses_of( + select => $self->clauses_of('select'), qw(group_by having) + ); + $self->clause_expanders( + 'select.group_by', sub { + $_[0]->_expand_maybe_list_expr($_[1], -ident) + }, + 'select.having', 'expand_expr', + ); + $self->${\"${_}er"}(from_list => "_${_}_from_list") + for qw(expand render); + $self->{expand}{join} = '_expand_join'; + $self->{render}{join} = '_render_join'; + $self->{expand_op}{as} = '_expand_op_as'; + $self->{expand}{as} = '_expand_op_as'; + $self->{render}{as} = '_render_as'; + + splice(@{$self->{clauses_of}{update}}, 2, 0, 'from'); + splice(@{$self->{clauses_of}{delete}}, 1, 0, 'using'); + $self->clause_expanders( + 'update.from' => '_expand_select_clause_from', + 'delete.using' => sub { + +(using => $_[0]->_expand_from_list(undef, $_[1])); + }, + 'insert.rowvalues' => sub { + +(from => $_[0]->expand_expr({ -values => $_[1] })); + }, + 'insert.select' => sub { + +(from => $_[0]->expand_expr({ -select => $_[1] })); + }, + ); + return $self; } sub _expand_select_clause_from { @@ -47,7 +56,7 @@ sub _expand_from_list { return { -from_list => [ $self->expand_expr($args) ] }; } my @list; - my @args = ref($args) ? @$args : ($args); + my @args = ref($args) eq 'ARRAY' ? @$args : ($args); while (my $entry = shift @args) { if (!ref($entry) and $entry =~ /^-(.*)/) { if ($1 eq 'as') { @@ -133,9 +142,7 @@ sub _render_as { my ($thing, $as, @cols) = @$args; return $self->_join_parts( ' ', - [ $self->render_aqt( - map +($_->{-ident} ? $_ : { -row => [ $_ ] }), $thing - ) ], + [ $self->render_aqt($thing) ], [ $self->_sqlcase('as') ], (@cols ? [ $self->_join_parts('',