4 use Test::More tests => 3;
7 use_ok('SQL::Abstract') or BAIL_OUT( "$@" );
9 my $sqla = SQL::Abstract->create(1);
13 tablespec => {-type => 'alias', ident => {-type => 'name', args => [qw/foo/]}, as => 'me' },
15 { -type => 'name', args => [qw/me id/] },
16 { -type => 'alias', ident => { -type => 'name', args => [qw/me foo_id/] }, as => 'foo' },
19 ), "SELECT me.id, me.foo_id AS foo FROM foo AS me",
20 "simple select clause";
25 tablespec => {-type => 'alias', ident => {-type => 'name', args => [qw/foo/]}, as => 'me' },
27 { -type => 'name', args => [qw/me id/] },
28 { -type => 'alias', ident => { -type => 'name', args => [qw/me foo_id/] }, as => 'foo' },
29 { -type => 'name', args => [qw/bar name/] },
35 from => [-alias => [-name => 'foo'] => 'me' ],
37 [ -name => qw/me id/ ],
38 [ -alias => [ -name => qw/me foo_id/ ], 'foo' ],
39 [ -name => qw/bar name/ ],
42 tablespec => [-name => qw/bar/],
43 on => [ '==', [-name => qw/bar id/], [ -name => qw/me bar_id/ ] ],
46 ), "SELECT me.id, me.foo_id AS foo, bar.name FROM foo AS me JOIN bar ON (bar.id = me.bar_id)",
47 "select with join clause";