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:<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><br>seems a little busy and difficult to "swallow"... <br></div><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">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 class="im">On Thu, Nov 26, 2009 at 3:16 PM, Marcus Smedman <<a href="mailto:marcus@smedman.org">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 class="h5">Gavin King<br>
<a href="mailto:gavin.king@gmail.com">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>