Uses of Class
org.linuxforhealth.fhir.database.utils.query.Select
-
-
Uses of Select in org.linuxforhealth.fhir.database.utils.query
Methods in org.linuxforhealth.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 managingSelect
With. getSelectClause()
Methods in org.linuxforhealth.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-clausevoid
FromClause. addInnerJoin(Select sub, Alias alias, ExpNode joinOnPredicate)
Add an inner join clause to the FROM items listvoid
Select. addInnerJoin(Select sub, Alias alias, ExpNode joinOnPredicate)
Add an inner join to the from clause for this select statement where the joining row source is a sub-querySelectItemSubQuery
SelectList. addSubQuery(Select subQuery, Alias alias)
void
Select. addWithClause(Select selectClause, Alias alias)
Add a new WITH clause to the select statement for example WITH alias AS (SELECT ...) SELECT ...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 clauseFromAdapter
FromAdapter. innerJoin(Select sub, Alias alias, WhereFragment joinOnPredicate)
Add an INNER JOIN for the given sub selectT
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 ALLSelectAdapter
SelectAdapter. with(Select selectClause, Alias alias)
Add a WITH x AS (SELECT ...) statement to the beginning of the selectConstructors in org.linuxforhealth.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, 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")WhereAdapter(Select select, WhereClause whereClause, ExpNode predicate)
With(Select selectClause, Alias alias)
Canonical constructor -
Uses of Select in org.linuxforhealth.fhir.database.utils.query.expression
Methods in org.linuxforhealth.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(java.util.List<With> withClauses, 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(java.util.List<With> withClauses, boolean distinct, SelectList selectList, FromClause fromClause, WhereClause whereClause, GroupByClause groupByClause, HavingClause havingClause, OrderByClause orderByClause, PaginationClause paginationClause, boolean unionAll, Select union)
-
Uses of Select in org.linuxforhealth.fhir.database.utils.query.node
Methods in org.linuxforhealth.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 org.linuxforhealth.fhir.database.utils.query.node with parameters of type Select Constructor Description SelectExpNode(Select select)
Public constructor -
Uses of Select in org.linuxforhealth.fhir.persistence.jdbc.dao.api
Methods in org.linuxforhealth.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 org.linuxforhealth.fhir.persistence.jdbc.dao.impl
Methods in org.linuxforhealth.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 org.linuxforhealth.fhir.persistence.jdbc.util
Methods in org.linuxforhealth.fhir.persistence.jdbc.util that return Select Modifier and Type Method Description Select
NewQueryBuilder. buildCountQuery(java.lang.Class<?> resourceType, FHIRSearchContext searchContext, SchemaType schemaType)
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, SchemaType schemaType)
Builds a query that returns included resources.Select
NewQueryBuilder. buildQuery(java.lang.Class<?> resourceType, FHIRSearchContext searchContext, SchemaType schemaType)
Construct a FHIR search querySelect
NewQueryBuilder. buildWholeSystemDataQuery(FHIRSearchContext searchContext, java.util.Map<java.lang.Integer,java.util.List<java.lang.Long>> resourceTypeIdToLogicalResourceIdMap, SchemaType schemaType)
Builds a query that returns resource data for the specified whole-system search.
-