Menu

query builder

Donal
2008-09-16
2012-09-14
  • Donal

    Donal - 2008-09-16

    Hi,

    I think the SQL Query Builder's OO-approach to query construction could be really useful to me. I just have one suggestion regarding the syntax that is shown in one of the examples:

    SelectBuilder builder = new SelectBuilder().select("*")
    .from("members", "m")
    .where().and("deleted='N'");

    Personally, I think the following would be a slight improvement:

    SelectBuilder builder = new SelectBuilder().select("*")
    .from("members", "m")
    .where("deleted='N'");

    One other question, assume that the query encapsulated by a SelectBuilder is in fact a prepared statement (i.e. contains '?' placeholders). Does SQLOrm provide any support with supplying values for those placeholders?

    Cheers,
    D.

     
    • Nisha Parveen Banu T

      Is there any commits happening on this project? I am looking for similar functionality for my project. This suits good but lacks good documentation and other example resources. Anyone could help??

      NishaP

       
  • Kasper B. Graversen

    The project is somewhat dormant. The codebase is very small, I encourage you
    to extend it.. I'll review and update the project..

     

Log in to post a comment.