[weld-dev] SQL framework proof of concept

[Arbi Sookazian]

Ok, ran the Main client.  Results:

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

The testQuery() is too long.  Yes, it's typesafe and tool-friendly, but it's
too busy.  But obviously several lines (e.g. comments) can be eliminated off
the bat.

Also, not 100% sure but it appears that hsqldb supports stored procs:
http://hsqldb.sourceforge.net/web/hsqlFAQ.html#STORED

I imagine that eventually this will need to be tested using mysql:
http://dev.mysql.com/doc/refman/5.1/en/stored-routines.html


On Wed, Nov 25, 2009 at 11:40 PM, Arbi Sookazian <asookazian at gmail.com>wrote:

> 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 at 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 at gmail.com
>> http://in.relation.to/Bloggers/Gavin
>> http://hibernate.org
>> http://seamframework.org
>>
>> _______________________________________________
>> weld-dev mailing list
>> weld-dev at lists.jboss.org
>> https://lists.jboss.org/mailman/listinfo/weld-dev
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/weld-dev/attachments/20091126/244fbffc/attachment-0001.html