Re: [weld-dev] SQL framework proof of concept

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(a)smedman.org&gt; 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(a)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(a)gmail.com&gt; 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(a)gmail.com http://in.relation.to/Bloggers/Gavin http://hibernate.org http://seamframework.org _______________________________________________ weld-dev mailing list weld-dev(a)lists.jboss.org https://lists.jboss.org/mailman/listinfo/weld-dev