commons-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Benedikt Ritter <brit...@apache.org>
Subject Re: [dbutils] Adding fluent api
Date Wed, 01 Jul 2015 06:10:01 GMT
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
>
>


-- 
http://people.apache.org/~britter/
http://www.systemoutprintln.de/
http://twitter.com/BenediktRitter
http://github.com/britter

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message