commons-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ole Ersoy <ole.er...@gmail.com>
Subject Re: [dbutils] Adding fluent api
Date Wed, 01 Jul 2015 16:07:08 GMT
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-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 <mansour.alakeel@gmail.com>:
>>
>>> 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 relatively easier, and keeps the query vendor
>>> independent.
>>> Some of the examples:
>>> * http://iciql.com/
>>> * http://jodd.org/doc/db/sqlgenerator.html
>>> * http://jdbi.org/
>>> * Jooq
>>> * https://mybatis.github.io/mybatis-3/statement-builders.html
>>>
>>> I am not talking about the mapping part. I am only suggesting
>>> generating the SQL string builder functionality. Something similar to
>>> MyBatis:
>>>
>>>    String sql = new SQL()
>>>      .INSERT_INTO("PERSON")
>>>      .VALUES("ID, FIRST_NAME", "${id}, ${firstName}")
>>>      .VALUES("LAST_NAME", "${lastName}")
>>>      .toString();
>>>
>>> I am wondering how much effort this can be, and most important if
>>> thers's interest in the community to create a separate independent
>>> component just for Sql String generation. MyBatis is under ASL 2.0
>>> license.
>>>
>>> Anyone else think there's a place in DBUtils for this functionaity ?
>>>
>>
>> That's kind of a domain specific StringBuilder for SQL, right?
>> How would you handle different data base dialects?
>>
>> Benedikt
>>
>>
>>>
>>> Thank you.
>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: dev-unsubscribe@commons.apache.org
>>> For additional commands, e-mail: dev-help@commons.apache.org
>>>
>>>
>>
>>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: dev-unsubscribe@commons.apache.org
> For additional commands, e-mail: dev-help@commons.apache.org
>
>


---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@commons.apache.org
For additional commands, e-mail: dev-help@commons.apache.org


Mime
View raw message