[
https://issues.apache.org/jira/browse/TORQUE-177?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Thomas Fox closed TORQUE-177.
-----------------------------
> SQLFunction interface should extend Column
> ------------------------------------------
>
> Key: TORQUE-177
> URL: https://issues.apache.org/jira/browse/TORQUE-177
> Project: Torque
> Issue Type: Improvement
> Components: Runtime
> Affects Versions: 4.0-beta1
> Reporter: CG Monroe
> Assignee: Thomas Fox
> Fix For: 4.0-beta1
>
>
> Support for DBA specific SQL Functions / Expression was added right after 3.3
> was released. See org.apache.torque.utils.SummaryHelper and
> org.apache.torque.utils.functions package. This allows for SQL functions to
> be specified in queries in an SQL version independent way. E.g. string
> concatenation can be different on different servers.
> Since SQLFunctions are created with all the same info that a Column object
> needs, it does not make sense to have to do:
> <pre>
> hoursMax = FunctionFactory.max(TimeCard.HOURS);
> Column col = new ColumnImpl(
> null,
> TimeCard.HOURS.getTableName(),
> TimeCard.HOURS.getColumnName(),
> maxHours.toSQL()
> );
> criteria.addAsColumn(col);
> </pre>
> Since SQLFunctions contain the needed info for columns, the SQLFunction
> interface extend Column and supply the required column info via the Column
> functions. This means that SQLFunctions could be just added via:
> criterial.addAsColumn(FunctionFactory.max(TimeCard.HOURS);
--
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
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
