Uses of Class
com.ibm.fhir.database.utils.query.Select
-
-
Uses of Select in com.ibm.fhir.database.utils.query
Methods in com.ibm.fhir.database.utils.query that return Select Modifier and Type Method Description Select
FromAdapter. build()
Provide the select statement we've been buildingSelect
GroupByAdapter. build()
Select
HavingAdapter. build()
Select
OrderByAdapter. build()
Get the select statement we've been buildingSelect
SelectAdapter. build()
Get the statement we've been constructingSelect
WhereAdapter. build()
Get the select statement wrapped by this adapterSelect
SelectAdapter. getSelect()
Getter for the select statement we are managingMethods in com.ibm.fhir.database.utils.query with parameters of type Select Modifier and Type Method Description void
FromClause. addFrom(Select sub, Alias alias)
Add the sub-query as an item in the from listvoid
Select. addFrom(Select sub, Alias alias)
Add a sub-select statement with an alias to the from-clauseSelectItemSubQuery
SelectList. addSubQuery(Select subQuery, Alias alias)
T
BaseWhereAdapter. exists(Select correlatedSubSelect)
Add an exists clause using the given correlated sub-select statementFromAdapter
SelectAdapter. from(Select sub, Alias alias)
Add the sub-query select to the FROM clauseT
BaseWhereAdapter. notExists(Select correlatedSubSelect)
Add a NOT EXISTS clause using the given correlated sub-select statementstatic java.sql.PreparedStatement
QueryUtil. prepareSelect(java.sql.Connection connection, Select select, IDatabaseTranslator translator)
Prepares the given Select statement and sets any bind parameters.void
Select. setUnion(Select union)
Set a select to UNION with this query.void
Select. setUnionAll(Select unionAll)
Set a select to UNION ALL with this query.void
SelectAdapter. union(Select unionSelect)
Add a select via UNIONvoid
SelectAdapter. unionAll(Select unionAllSelect)
Add a select via UNION ALLConstructors in com.ibm.fhir.database.utils.query with parameters of type Select Constructor Description FromAdapter(Select select)
Model the "from" part of the select statementFromSubQueryAdapter(Select parentSelect, FromAdapter from)
constructorGroupByAdapter(Select select, GroupByClause gb, java.lang.String... expressions)
Protected constructor for modeling the GROUP BY part of a SELECT statement.HavingAdapter(Select select)
Protected constructor.OrderByAdapter(Select select, OrderByClause ob)
Protected constructor for modeling the GROUP BY part of a SELECT statement.SelectAdapter(Select select)
Adapter this select statementSelectItemSubQuery(Select subQuery, Alias alias)
SelectRowSource(Select subQuery)
Protected constructorWhereAdapter(Select select, WhereClause whereClause)
Public constructor to start the WHERE clause in a select statementWhereAdapter(Select select, WhereClause whereClause, ExpNode predicate)
WhereAdapter(Select select, WhereClause whereClause, java.lang.String predicate)
Public constructorWhereAdapter(Select select, WhereClause whereClause, java.lang.String tableAlias, java.lang.String columnName)
Convenience for when the statement is written like .where("lr", "current_resource_id").eq("r", "resource_id") -
Uses of Select in com.ibm.fhir.database.utils.query.expression
Methods in com.ibm.fhir.database.utils.query.expression with parameters of type Select Modifier and Type Method Description java.util.Set<java.lang.String>
ColumnExpNodeVisitor. select(Select select)
java.lang.String
DebugExpNodeVisitor. select(Select select)
T
StatementRenderer. select(boolean distinct, SelectList selectList, FromClause fromClause, WhereClause whereClause, GroupByClause groupByClause, HavingClause havingClause, OrderByClause orderByClause, PaginationClause paginationClause, boolean unionAll, Select union)
Render the select statement using each of the components, some of which may be optional (null)java.lang.String
StringExpNodeVisitor. select(Select select)
java.lang.String
StringStatementRenderer. select(boolean distinct, SelectList selectList, FromClause fromClause, WhereClause whereClause, GroupByClause groupByClause, HavingClause havingClause, OrderByClause orderByClause, PaginationClause paginationClause, boolean unionAll, Select union)
-
Uses of Select in com.ibm.fhir.database.utils.query.node
Methods in com.ibm.fhir.database.utils.query.node with parameters of type Select Modifier and Type Method Description T
ExpNodeVisitor. select(Select select)
Process a sub-select statementConstructors in com.ibm.fhir.database.utils.query.node with parameters of type Select Constructor Description SelectExpNode(Select select)
Public constructor -
Uses of Select in com.ibm.fhir.persistence.jdbc.dao.api
Methods in com.ibm.fhir.persistence.jdbc.dao.api with parameters of type Select Modifier and Type Method Description java.util.List<Resource>
ResourceDAO. search(Select select)
Executes the search contained in the passedSelect
, using its encapsulated search string and bind variables.int
ResourceDAO. searchCount(Select countQuery)
Executes a count query based on the data contained in the passedSelect
statement, using its encapsulated search string and bind variables.java.util.List<java.lang.Long>
ResourceDAO. searchForIds(Select dataQuery)
This method supports the execution of a specialized query designed to return Resource ids, based on the contents of the passed select statement.java.util.Map<java.lang.Integer,java.util.List<java.lang.Long>>
ResourceDAO. searchWholeSystem(Select select)
Executes the whole-system filter search contained in the passedSelect
, using its encapsulated search string and bind variables. -
Uses of Select in com.ibm.fhir.persistence.jdbc.dao.impl
Methods in com.ibm.fhir.persistence.jdbc.dao.impl with parameters of type Select Modifier and Type Method Description protected int
FHIRDbDAOImpl. runCountQuery(Select countQuery)
Creates and executes a PreparedStatement for the passed sql containing a 'SELECT COUNT...'.protected java.util.List<Resource>
FHIRDbDAOImpl. runQuery(Select select)
Retrieve the FHIR objects by executing the givenSelect
statementjava.util.List<Resource>
ResourceDAOImpl. search(Select select)
int
ResourceDAOImpl. searchCount(Select countQuery)
java.util.List<java.lang.Long>
ResourceDAOImpl. searchForIds(Select dataQuery)
java.util.Map<java.lang.Integer,java.util.List<java.lang.Long>>
ResourceDAOImpl. searchWholeSystem(Select wholeSystemQuery)
-
Uses of Select in com.ibm.fhir.persistence.jdbc.util
Methods in com.ibm.fhir.persistence.jdbc.util that return Select Modifier and Type Method Description Select
NewQueryBuilder. buildCountQuery(java.lang.Class<?> resourceType, FHIRSearchContext searchContext)
Builds a query that returns the count of the search results that would be found by applying the search parameters contained within the passed search context.Select
NewQueryBuilder. buildIncludeQuery(java.lang.Class<?> resourceType, FHIRSearchContext searchContext, InclusionParameter inclusionParm, java.util.List<java.lang.Long> logicalResourceIds, java.lang.String inclusionType)
Builds a query that returns included resources.Select
NewQueryBuilder. buildQuery(java.lang.Class<?> resourceType, FHIRSearchContext searchContext)
Construct a FHIR search querySelect
NewQueryBuilder. buildWholeSystemDataQuery(FHIRSearchContext searchContext, java.util.Map<java.lang.Integer,java.util.List<java.lang.Long>> resourceTypeIdToLogicalResourceIdMap)
Builds a query that returns resource data for the specified whole-system search.
-