4 use Test::More tests => 9;
7 use_ok('SQL::Abstract') or BAIL_OUT( "$@" );
9 my $sqla = SQL::Abstract->create(1);
11 # TODO: once MXMS supports %args, use that here
12 is $sqla->dispatch( [ -name => qw/me id/]), "me.id",
13 "Simple name generator";
17 ), "0 = 1", "false value";
21 ), "1 = 1", "true value";
25 [ -name => qw/me id/],
26 [ -name => qw/me foo bar/],
29 ), "me.id, me.foo.bar, bar",
33 [ -alias => [ -name => qw/me id/], "foobar", ]
38 [ -order_by => [ -name => qw/me date/ ] ]
39 ), "ORDER BY me.date",
44 [ -name => qw/me date/ ],
45 [ -name => qw/me foobar/ ],
47 ), "ORDER BY me.date, me.foobar",
51 [ -order_by => [ -desc => [ -name => qw/me date/ ] ] ]
52 ), "ORDER BY me.date DESC",