You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cayenne.apache.org by "Andrus Adamchik (JIRA)" <ji...@apache.org> on 2013/05/24 17:06:21 UTC
[jira] [Updated] (CAY-1828) SQLSelect - generics friendly selecting
raw sql query
[ https://issues.apache.org/jira/browse/CAY-1828?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Andrus Adamchik updated CAY-1828:
---------------------------------
Description:
Want to have something more usable than SQLTemplate... Its routing defaults, parameter bindings, etc. etc. are just not that user-friendly. So creating a simpler selecting version that will internally translate to SQLTemplate.
Here are construction examples:
SQLSelect<DataRow> q1 = SQLSelect.dataRowQuery("SELECT * FROM x");
SQLSelect<Artist> q2 = SQLSelect.query(Artist.class, "SELECT * FROM x");
List<DataRow> l1 = context.select(q1);
Also use fluent API:
q1.fetchLimit(2).fetchOffset(4).upperColumnNames();
was:
Want to have something more usable than SQLTemplate... Its routing defaults, parameter bindings, etc. etc. are just not that user-friendly. So creating a simpler selecting version that will internally translate to SQLTemplate.
Here are construction examples:
SQLSelect<DataRow> q1 = SQLSelect.dataRowQuery("SELECT * FROM x");
SQLSelect<Artist> q2 = SQLSelect.query(Artist.class, "SELECT * FROM x");
List<DataRow> l1 = context.select(q1);
> SQLSelect - generics friendly selecting raw sql query
> -----------------------------------------------------
>
> Key: CAY-1828
> URL: https://issues.apache.org/jira/browse/CAY-1828
> Project: Cayenne
> Issue Type: Bug
> Reporter: Andrus Adamchik
> Assignee: Andrus Adamchik
> Fix For: 3.2M1
>
>
> Want to have something more usable than SQLTemplate... Its routing defaults, parameter bindings, etc. etc. are just not that user-friendly. So creating a simpler selecting version that will internally translate to SQLTemplate.
> Here are construction examples:
> SQLSelect<DataRow> q1 = SQLSelect.dataRowQuery("SELECT * FROM x");
> SQLSelect<Artist> q2 = SQLSelect.query(Artist.class, "SELECT * FROM x");
> List<DataRow> l1 = context.select(q1);
> Also use fluent API:
> q1.fetchLimit(2).fetchOffset(4).upperColumnNames();
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira