NewfieQ manages mutable SQL queries stored in an XML source file. Base queries are modified with named boolean conditions and variables. Schemas are assigned to table names via a property file for switching between test and production on a single system.
Be the first to post a text review of NewfieQ. Rate and review a project by clicking thumbs up or thumbs down in the right column.
NewfieQ 0.97b is now available for download in its first public release. NewfieQ is an LGPL open source utility for managing dynamically mutable SQL queries within Java programs. It combines the benefits of a dynamically generated statements with the security of a PreparedStatements. It also provides named boolean parameters within WHERE clauses, named selection of ORDER BY clauses and property file driver replacement of schemas for simple switching between test and production environments hosted on a single system. The initial NewfieQ beta is stable and currently in use in a few small production systems. Implementation notes, documentation or feedback from first time users would be greatly appreciated (I am willing to compile and edit contributions into a cohesive whole). With NewfieQ you may: Name multiple replaceable WHERE clauses within joins and nested subqueries using replacement variables (e.g., "${where.1}", "${where.inner}", etc.). You may optionally designate that the clause appends to an existing WHERE clause with ".append" as in "${where.1.append}". Define named boolean expressions and variables within a name WHERE clause such as "1.initalDate", "1.amount" and "inner.amount". Where two or more clauses share a name both may be set to the same value by omitting the prefix (e.g., "amount"). Designate an optional sort via a named ORDER BY clause (e.g., "${order-by.ob}"). Select a particular sort within the clause by name ("ob.last_first_zip", "ob.zip_last_first", etc.). Optionally include table names within a special replacement variable structure (table "ADDRESSES" included in source as "${:addresses:}") to dynamically assign schemas at run time. Further details appear in the Javadoc package description for com.dkmicro.sql. The source distribution includes a few usage examples within the JUnit tests. Download the latest version of NewfieQ at: https://sourceforge.net/project/showfiles.php?group_id=175221 NewfieQ includes a binary release of the LGPL XML utility NewEl (source at https://sourceforge.net/project/showfiles.php?group_id=175287) for reading the SQL definitions from an XML file.
Be the first person to add a text review.
Copyright © 2009 Geeknet, Inc. All rights reserved. Terms of Use
Thanks for your rating!
Would you also like to write a review?