OK. I played around with it a bit, but it’s all pretty new
to me. I mean not only the seam-sql, but the whole JEE stack and everything
that comes with it. I’ve monitored this mail list for a while though and
it’s very interesting and I really learn a lot.
Regarding the seam-sql I added a Drop (to speed up my small
tests), Alter (to add foreign keys) and a Join (a bit messy when/if using
aliases) to try to understand how Gavin had did the other stuff. There’s
a lot of stuff I don’t fully understand… (is a join an Expression
for example?).
Anyway, my idea was to make some tests using (some of) the tables
added when running add-identity-management by seam-gen (user_account, user_role
and user_account_role). I have tested it (DROP/ALTER/JOIN) on MySQL and it
seems to work, but I’m not sure I fully understand how to follow the “pattern”
that Gavin have put together.
Anyway, if I can help in any way please let me know, I might get
some time to help with tests or whatever.
Regards
Marcus
From: Arbi Sookazian
[mailto:asookazian@gmail.com]
Sent: den 26 november 2009 18:03
To: Marcus Smedman
Cc: Weld-Dev
Subject: Re: [weld-dev] SQL framework proof of concept
Marcus, yep, this is basically
exactly what I did. Now I need to spend some more time with the API and
testing, etc. And unfortunately, today is not a good day... So thx
for the zip offer but I don't think I'll need it for now. Eventually I'd
like to run some load tests to compare performance vs. iBATIS and Spring JDBC
equivalents. I'll need to come up with a plan/roadmap for this
sub-project first and then I'll post that on this list.
On Thu, Nov 26, 2009 at 12:12 AM, Marcus Smedman <marcus@smedman.org> wrote:
Hi Arbi,
Not sure if this is what you
where referring to, but I got it up and running by doing this:
1. Create an Eclipse project
and add the source from seam-sql.zip
2. Download weld from http://seamframework.org/Download
3. Unpack and add the
following libs to the project:
* <weld-x.y.z>\artifacts\weld\weld-se.jar
* <weld-x.y.z>\artifacts\weld\weld-servlet.jar
4. Add a hsql jdbc driver to
the project (from http://sourceforge.net/projects/hsqldb/files/ or
<jboss-seam-x.y.z>\lib\hsqldb.jar)
5. Uncomment the eg.Main.main
method and execute it. Generates the following output:
create table
users (name varchar not null, username varchar not null primary key, password
varchar not null)
insert into
users (name, username, password) values (?, ?, ?)
update users set
name=?, password=? where username=?
select u.name as n from users as u where
(u.username=? and u.password=?)
Gavin King
I have an Eclipse proj packed
up in a zip if you’d like it (4MB).
Regards
Marcus
From: weld-dev-bounces@lists.jboss.org [mailto:weld-dev-bounces@lists.jboss.org]
On Behalf Of Arbi Sookazian
Sent: den 26 november 2009 08:41
To: Gavin King
Cc: Weld-Dev
Subject: Re: [weld-dev] SQL framework proof of concept
I'm
interested. Plz provide instructions on how to build/deploy so I can test
it out (it's getting late so I haven't even opened the project in Eclipse
yet). I noticed that the public static void main() in Main class is
commented out. Is it safe to assume that this is basically a Weld SE app
(or soon to be Seam3) to test with? thx.
On
Wed, Nov 25, 2009 at 11:02 PM, Gavin King <gavin.king@gmail.com>
wrote:
Here's
a proof-of concept for the typesafe SQL framework. There's lots
of stuff missing, but I can already do basic queries, inserts and
updates. Anyone want to take over from here?
--
Gavin King
gavin.king@gmail.com
http://in.relation.to/Bloggers/Gavin
http://hibernate.org
http://seamframework.org
_______________________________________________
weld-dev mailing list
weld-dev@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/weld-dev