query.where( and( eq( fromUsers.get(users.username), usernameParameter ), <br> eq( fromUsers.get(users.password), passwordParameter ) ) );<br><br>what about left/right outer joins?<br><br><div class="gmail_quote">
On Thu, Nov 26, 2009 at 4:05 PM, Arbi Sookazian <span dir="ltr"><<a href="mailto:asookazian@gmail.com">asookazian@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Not too bad, but that makes sense if I have a tool that shows me the native sql generated by the query. or better yet, I write a native sql statement (say a query) and it reverse engineers it into the typesafe syntax you have in your API.<br>
<br>honestly, this:<div class="im"><br><br>From<users> u = query.from(users.table);<br>
Join<permissions> p = fromUser.join(permissions.<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">table)<br>
p.on( eq( u.get(<a href="http://users.id/" target="_blank">users.id</a>), p.get(permissions.userId) ) );</blockquote></div><div><br>seems a little busy and difficult to "swallow"... <br></div><div><div></div>
<div class="h5"><br><br><div class="gmail_quote">
On Thu, Nov 26, 2009 at 12:36 PM, Gavin King <span dir="ltr"><<a href="mailto:gavin.king@gmail.com" target="_blank">gavin.king@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div>On Thu, Nov 26, 2009 at 3:16 PM, Marcus Smedman <<a href="mailto:marcus@smedman.org" target="_blank">marcus@smedman.org</a>> wrote:<br>
<br>
> Regarding the seam-sql I added a Drop (to speed up my small tests), Alter<br>
> (to add foreign keys) and a Join (a bit messy when/if using aliases) to try<br>
> to understand how Gavin had did the other stuff. There’s a lot of stuff I<br>
> don’t fully understand… (is a join an Expression for example?).<br>
<br>
</div>Join is probably a subclass of From:<br>
<br>
From<users> u = query.from(users.table);<br>
Join<permissions> p = fromUser.join(permissions.table)<br>
p.on( eq( u.get(<a href="http://users.id" target="_blank">users.id</a>), p.get(permissions.userId) ) );<br>
<br>
Does that make sense?<br>
<font color="#888888"><br>
<br>
<br>
--<br>
</font><div><div></div><div>Gavin King<br>
<a href="mailto:gavin.king@gmail.com" target="_blank">gavin.king@gmail.com</a><br>
<a href="http://in.relation.to/Bloggers/Gavin" target="_blank">http://in.relation.to/Bloggers/Gavin</a><br>
<a href="http://hibernate.org" target="_blank">http://hibernate.org</a><br>
<a href="http://seamframework.org" target="_blank">http://seamframework.org</a><br>
</div></div></blockquote></div><br>
</div></div></blockquote></div><br>