use MooseX::Declare;
-use MooseX::Method::Signatures;
-
class SQL::Abstract {
use Data::Dump qw/pp/;
use Moose::Util::TypeConstraints;
- use MooseX::Types -declare => [qw/NameSeparator/];
- use MooseX::Types::Moose qw/ArrayRef Str/;
+ use MooseX::Types::Moose qw/ArrayRef Str Int HashRef CodeRef/;
use MooseX::AttributeHelpers;
-
- use namespace::clean -except => ['meta'];
-
- subtype NameSeparator,
- as ArrayRef[Str];
- #where { @$_ == 1 ||| @$_ == 2 },
- #message { "Name separator must be one or two elements" };
-
- coerce NameSeparator, from Str, via { [ $_ ] };
+ use SQL::Abstract::Types qw/NameSeparator QuoteChars AST/;
+ use Devel::PartialDump qw/dump/;
our $VERSION = '2.000000';
or => 50
);
- our %OP_MAP = (
+ our %BINOP_MAP = (
+
+ '+' => '+',
+ '-' => '-',
+ '/' => '/',
+ '*' => '*',
+
'>' => '>',
+ '>=' => '>=',
'<' => '<',
+ '<=' => '<=',
'==' => '=',
'!=' => '!=',
+ # LIKE is always "field LIKE <value>"
+ 'like' => 'LIKE',
+ 'not_like' => 'NOT LIKE',
);
- has name_separator => (
+ has expr_dispatch_table => (
+ is => 'ro',
+ lazy => 1,
+ builder => '_build_expr_dispatch_table',
+ isa => HashRef[CodeRef],
+ metaclass => 'Collection::ImmutableHash',
+ provides => {
+ get => 'lookup_expr_dispatch'
+ }
+ );
+
+ has binop_map => (
+ is => 'ro',
+ lazy => 1,
+ builder => '_build_binops',
+ isa => HashRef,
+ metaclass => 'Collection::ImmutableHash',
+ provides => {
+ exists => 'is_valid_binop',
+ get => 'binop_mapping',
+ keys => 'binary_operators'
+ }
+ );
+
+ # List of default binary operators (for in where clauses)
+ sub _build_binops { return {%BINOP_MAP} };
+
+ method _build_expr_dispatch_table {
+ my $binop = $self->can('_binop') or croak "InternalError: $self can't do _binop!";
+ return {
+ map { $_ => $binop } $self->binary_operators
+ }
+ }
+
+ has ast_version => (
+ is => 'ro',
+ isa => Int,
+ required => 1
+ );
+
+ has ident_separator => (
is => 'rw',
isa => NameSeparator,
- default => sub { ['.'] },
- coerece => 1,
+ default => '.',
required => 1,
);
required => 1,
);
+ has quote_chars => (
+ is => 'rw',
+ isa => QuoteChars,
+ predicate => 'is_quoting',
+ clearer => 'disable_quoting',
+ coerce => 1,
+ );
+
has binds => (
isa => ArrayRef,
+ is => 'ro',
+ clearer => '_clear_binds',
+ lazy => 1,
default => sub { [ ] },
metaclass => 'Collection::Array',
provides => {
push => 'add_bind',
- get => 'binds'
}
);
- method generate (Object|ClassName $self: ArrayRef $ast) {
- $self = $self->new unless blessed($self);
+ # TODO: once MXMS supports %args, use that here
+ # TODO: improve this so you can pass other args
+ method create(ClassName $class: Int $ver) {
+ croak "AST version $ver is greater than supported version of $AST_VERSION"
+ if $ver > $AST_VERSION;
- local $_ = $ast->[0];
- s/^-/_/ or croak "Unknown type tag '$_'";
- my $meth = $self->can($_) || \&_generic_func;
- return $meth->($self, $ast);
- }
+ my $name = "${class}::AST::v$ver";
+ Class::MOP::load_class($name);
- method _select(ArrayRef $ast) {
-
+ return $name->new(ast_version => $ver);
}
- method _name(ArrayRef $ast) {
- my (undef, @names) = @$ast;
-
- my $sep = $self->name_separator;
+ # Main entry point
+ method generate(ClassName $class: AST $ast) {
+ my $ver = $ast->{-ast_version};
+ croak "SQL::Abstract AST version not specified"
+ unless defined $ver;
- return $sep->[0] .
- join( $sep->[1] . $sep->[0], @names ) .
- $sep->[1]
- if (@$sep > 1);
+ # TODO: once MXMS supports %args, use that here
+ my $self = $class->create($ver);
- return join($sep->[0], @names);
+ return ($self->dispatch($ast), $self->binds);
}
- method _list(ArrayRef $ast) {
- my (undef, @items) = @$ast;
-
- return join(
- $self->list_separator,
- map { $self->generate($_) } @items);
- }
-
- method _alias(ArrayRef $ast) {
- my (undef, $alias, $as) = @$ast;
-
- return $self->generate($alias) . " AS $as";
-
+ method reset() {
+ $self->_clear_binds();
}
- method _value(ArrayRef $ast) {
- my ($undef, $value) = @$ast;
+ method dispatch (AST $ast) {
- $self->add_bind($value);
- return "?";
+ my $tag = "_" . $ast->{-type};
+
+ my $meth = $self->can($tag) || croak "Unknown tag '$tag'";
+ return $meth->($self, $ast);
}
- method _where(ArrayRef $ast) {
- my (undef, @clauses) = @$ast;
-
- return 'WHERE ' . $self->_recurse_where(\@clauses);
- }
+};
- method _recurse_where($clauses) {
+__END__
- my $OP = 'AND';
- my $prio = $PRIO{and};
- my $first = $clauses->[0];
+=head1 NAME
- if (!ref $first && $first =~ /^-(and|or)$/) {
- $OP = uc($1);
- $prio = $PRIO{$1};
- shift @$clauses;
- }
+SQL::Abstract - AST based re-implementation of SQL::Abstract
- my @output;
- foreach (@$clauses) {
- croak "invalid component in where clause" unless ArrayRef->check($_);
- my $op = $_->[0];
-
- unless (substr($op, 0, 1) eq '-') {
- # A simple comparison op (==, >, etc.)
-
- push @output, $self->_binop(@$_);
-
- } elsif ($op =~ /^-(and|or)$/) {
- my $sub_prio = $PRIO{$1};
-
- if ($sub_prio <= $prio) {
- push @output, $self->_recurse_where($_);
- } else {
- push @output, '(' . $self->_recurse_where($_) . ')';
- }
- } else {
- push @output, $self->generate($_);
- }
- }
+=head1 LICENSE
- return join(" $OP ", @output);
- }
+=head1 AUTHORS
- method _binop($op, $lhs, $rhs) {
- join (' ', $self->generate($lhs),
- $OP_MAP{$op} || croak("Unknown binary operator $op"),
- $self->generate($rhs)
- );
- }
+Ash Berlin C<< <ash@cpan.org> >>
- method _generic_func(ArrayRef $ast) {
- }
+=head1 LICENSE
+This program is free software; you can redistribute it and/or modify it under
+the same terms as Perl itself.
-};