Uses of Interface
net.pricefx.formulaengine.DatamartContext.SqlQuery
-
Packages that use DatamartContext.SqlQuery Package Description net.pricefx.formulaengine Provides Formula Engine API classes.net.pricefx.formulaengine.optimization -
-
Uses of DatamartContext.SqlQuery in net.pricefx.formulaengine
Methods in net.pricefx.formulaengine that return DatamartContext.SqlQuery Modifier and Type Method Description DatamartContext.SqlQuery
DatamartContext.SqlQuery. addSource(DatamartContext.Query sourceQuery)
Adds aDatamartContext.Query
as a source for this SQL query.DatamartContext.SqlQuery
DatamartContext.SqlQuery. addSource(DatamartContext.Query sourceQuery, String alias)
Adds aDatamartContext.Query
as a source for this SQL query.DatamartContext.SqlQuery
DatamartContext.SqlQuery. addSource(DatamartContext.Table table)
Adds aDatamartContext.Table
as a source for this SQL query.DatamartContext.SqlQuery
DatamartContext.SqlQuery. addSource(DatamartContext.Table table, String alias)
Adds aDatamartContext.Table
as a source for this SQL query.DatamartContext.SqlQuery
DatamartContext.SqlQuery. addWith(String withClause, Object... bindings)
Adds a with clause to the SQL query, where every "?" char gets replaced by the values provided as additional parameters.DatamartContext.SqlQuery
DatamartContext.SqlQuery. addWith(String withClause, String alias, Object... bindings)
Adds a with clause to the SQL query, where every "?" char gets replaced by the values provided as additional parameters.DatamartContext.SqlQuery
DatamartContext. newSqlQuery()
Instantiates a query object for building SQL statements from source queries, with clauses and parameter bindings.DatamartContext.SqlQuery
DatamartContext.SqlQuery. setQuery(String sql, Object... bindings)
Sets the main SQL SELECT clause of this query, where every "?" char gets replaced by the values provided as additional parameters.Methods in net.pricefx.formulaengine with parameters of type DatamartContext.SqlQuery Modifier and Type Method Description Matrix2D
DatamartContext. executeSqlQuery(DatamartContext.SqlQuery sqlQuery)
Executes an ANSI compliant SQL SELECT statement in the PA DB. -
Uses of DatamartContext.SqlQuery in net.pricefx.formulaengine.optimization
Methods in net.pricefx.formulaengine.optimization with parameters of type DatamartContext.SqlQuery Modifier and Type Method Description long
ModelFormulaContextReadWrite. loadTable(DatamartContext.Table table, DatamartContext.SqlQuery source, boolean truncate)
Sample code:
-