com.anylogic.engine.database.SelectQuery

public class SelectQuery
extends SelectQueryBasic<SelectQuery>

SelectQuery for building and execution of SELECT SQL statements

Constructor Summary

Constructor	Description
`SelectQuery(ModelDatabase database, com.querydsl.sql.RelationalPathBase<?> table, Utilities owner)`

Method Summary

Modifier and Type	Method	Description
`double[]`	`arrayOfDouble(com.querydsl.core.types.Expression<? extends Number> valueColumn)`	Executes the given SELECT query which should return 1 column with numbers.
`int[]`	`arrayOfInt(com.querydsl.core.types.Expression<? extends Number> valueColumn)`	Executes the given SELECT query which should return 1 column with numbers.
`ResultSet`	`getResults(com.querydsl.core.types.Expression<?>... columns)`	Get the results as an JDBC result set
`TableFunction`	`tableFunction(TableFunction tableFunction, com.querydsl.core.types.Expression<? extends Number> argumentColumn, com.querydsl.core.types.Expression<? extends Number> valueColumn)`	Executes the given SELECT query which should return 2 columns of data: the first column contains arguments numbers, the second column contains values numbers.

Methods inherited from class com.anylogic.engine.database.SelectQueryBasic

count, count, distinct, exists, firstResult, firstResult, firstResult, firstResult, firstResult, firstResult, fullJoin, fullJoin, getDSLQuery, getSQL, groupBy, groupBy, hasResults, hasResults, innerJoin, innerJoin, join, join, leftJoin, leftJoin, limit, list, list, list, offset, on, on, orderBy, orderBy, rightJoin, rightJoin, uniqueResult, uniqueResult, uniqueResult, uniqueResult, uniqueResult, uniqueResult, where, where

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

SelectQuery

@AnyLogicInternalAPI
public SelectQuery(ModelDatabase database,
 com.querydsl.sql.RelationalPathBase<?> table,
 Utilities owner)

Method Details

getResults

public ResultSet getResults(com.querydsl.core.types.Expression<?>... columns)

Get the results as an JDBC result set

Parameters:: columns - to select
Returns:: selected ResultSet

tableFunction

public TableFunction tableFunction(TableFunction tableFunction,
 com.querydsl.core.types.Expression<? extends Number> argumentColumn,
 com.querydsl.core.types.Expression<? extends Number> valueColumn)

Executes the given SELECT query which should return 2 columns of data: the first column contains arguments numbers, the second column contains values numbers.

Parameters:: tableFunction - the table function to fill; argumentColumn - column with arguments; valueColumn - column with values
Returns:: the given table function, for convenience

arrayOfDouble

public double[] arrayOfDouble(com.querydsl.core.types.Expression<? extends Number> valueColumn)

Executes the given SELECT query which should return 1 column with numbers. Returns the array of numbers from the column. An empty array is returned for no results

Parameters:: valueColumn - column with values
Returns:: array of 'double' numbers

arrayOfInt

public int[] arrayOfInt(com.querydsl.core.types.Expression<? extends Number> valueColumn)