Re: [dbutils] Adding fluent api

2015-07-06 Thread Mansour Al Akeel
Awesome. Thank you for the letting us know. In fact I went ahead and started working on this. https://github.com/malakeel/dbutils What I had in mind, is a multiple components to be added under DBUtils, * DML component: implementation for fluent API DML (Data manuplation) include MERGE or UPSERT

Re: [dbutils] Adding fluent api

2015-07-06 Thread William Speirs
commons-dbutils already has a fluent API: http://svn.apache.org/viewvc/commons/proper/dbutils/branches/2_0/ Someone just needs to put the finishing touches on it, and/or use my fork of commons-dbutils: https://github.com/wspeirs/sop4j-dbutils Bill- On Wed, Jul 1, 2015 at 11:28 PM, Ole Ersoy wro

Re: [dbutils] Adding fluent api

2015-07-01 Thread Ole Ersoy
On 07/01/2015 04:00 PM, Mansour Al Akeel wrote: Hello Kervin, Alot of these libraries, including JPA need to generate beans before you can use the query builder. QueryDSL is one example. I haven't used JOOQ, but I have seen their examples, and it looks a lot like what I thinking of. I am unabl

Re: [dbutils] Adding fluent api

2015-07-01 Thread Mansour Al Akeel
Hello Kervin, Alot of these libraries, including JPA need to generate beans before you can use the query builder. QueryDSL is one example. I haven't used JOOQ, but I have seen their examples, and it looks a lot like what I thinking of. I am unable to find the licensing of JOOQ, and if it's ASL com

Re: [dbutils] Adding fluent api

2015-07-01 Thread Mansour Al Akeel
On Wed, Jul 1, 2015 at 8:07 PM, Ole Ersoy wrote: > Just curious...would this be similar to JOOQ? > > http://www.jooq.org/ > > Cheers, > - Ole Yes. Something similar. We just need to generate SQL string. > > > On 07/01/2015 10:21 AM, Adrian Crum wrote: >> >> You can make the builder support gener

Re: [dbutils] Adding fluent api

2015-07-01 Thread Mansour Al Akeel
Hello all, Benedikt, you are right, all we need is a StringBuilder-Style query builder. And like Aderian said, we can suppor a default dialect, and allow overriding. This is the mechanist used by iciql (www.iciql.com). A problem will be faced is with support for properiatory (none-open source) da

Re: [dbutils] Adding fluent api

2015-07-01 Thread Kervin Pierre
Left out... * https://github.com/JSQLParser/JSqlParser * http://querydsl.com JSqlParser does a really good job of handling dialects if I remember correctly. QueryDSL also "does the mapping part" as you put it. It gives you a type-safe query language across Java Collections, JPA Datasources and

Re: [dbutils] Adding fluent api

2015-07-01 Thread Ole Ersoy
Just curious...would this be similar to JOOQ? http://www.jooq.org/ Cheers, - Ole On 07/01/2015 10:21 AM, Adrian Crum wrote: You can make the builder support generic SQL 2003, and provide a way to extend the builder with vendor-specific grammar. Adrian Crum Sandglass Software www.sandglass-so

Re: [dbutils] Adding fluent api

2015-07-01 Thread Adrian Crum
You can make the builder support generic SQL 2003, and provide a way to extend the builder with vendor-specific grammar. Adrian Crum Sandglass Software www.sandglass-software.com On 6/30/2015 11:10 PM, Benedikt Ritter wrote: Hello Mansour, 2015-06-30 23:57 GMT+02:00 Mansour Al Akeel : I am

Re: [dbutils] Adding fluent api

2015-06-30 Thread Benedikt Ritter
Hello Mansour, 2015-06-30 23:57 GMT+02:00 Mansour Al Akeel : > I am not sure if this is the right place to suggest this. Please let > me know, before filling a Jira Ticket. > I believe DbUtils has place for additional component: > > - A fluent API to generate SQL string: > > Developers find it di

[dbutils] Adding fluent api

2015-06-30 Thread Mansour Al Akeel
I am not sure if this is the right place to suggest this. Please let me know, before filling a Jira Ticket. I believe DbUtils has place for additional component: - A fluent API to generate SQL string: Developers find it difficult to concatenate strings to build a query. A fluent API makes it rela