4 use Test::More tests => 4;
7 use_ok('SQL::Abstract') or BAIL_OUT( "$@" );
9 my $sqla = SQL::Abstract->create(1);
11 my $foo = {-type => name => args => [qw/foo/]};
12 my $bar = {-type => name => args => [qw/bar/]},
13 my $fnord = {-type => name => args => [qw/fnord/]};
15 my $foo_id = { -type => 'name', args => [qw/foo id/] };
16 my $me_foo_id = { -type => 'name', args => [qw/me foo_id/] };
25 args => [ $foo_id, $me_foo_id ]
28 ), "bar JOIN foo ON (foo.id = me.foo_id)",
32 $foo_id = { -type => 'name', args => [qw/foo_id/] };
37 rhs => {-type => 'alias', ident => $foo, as => 'bar' },
40 ), "fnord JOIN foo AS bar USING (foo_id)",
48 rhs => {-type => 'alias', ident => $foo, as => 'bar' },
51 ), "fnord LEFT JOIN foo AS bar USING (foo_id)",
52 "using left join clause";