4 use Test::More tests => 11;
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";
15 is $sqla->dispatch( [ -name => qw/me */]),
17 "Simple name generator";
19 $sqla->quote_chars(['`']);
21 is $sqla->dispatch( [ -name => qw/me */]),
23 "Simple name generator";
25 $sqla->disable_quoting;
29 ), "0 = 1", "false value";
33 ), "1 = 1", "true value";
37 [ -name => qw/me id/],
38 [ -name => qw/me foo bar/],
41 ), "me.id, me.foo.bar, bar",
45 [ -alias => [ -name => qw/me id/], "foobar", ]
50 [ -order_by => [ -name => qw/me date/ ] ]
51 ), "ORDER BY me.date",
56 [ -name => qw/me date/ ],
57 [ -name => qw/me foobar/ ],
59 ), "ORDER BY me.date, me.foobar",
63 [ -order_by => [ -desc => [ -name => qw/me date/ ] ] ]
64 ), "ORDER BY me.date DESC",