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 SelectFromAdapter. build()Provide the select statement we've been buildingSelectGroupByAdapter. build()SelectHavingAdapter. build()SelectOrderByAdapter. build()Get the select statement we've been buildingSelectSelectAdapter. build()Get the statement we've been constructingSelectWhereAdapter. build()Get the select statement wrapped by this adapterSelectSelectAdapter. getSelect()Getter for the select statement we are managingSelectWith. getSelectClause()Methods in org.linuxforhealth.fhir.database.utils.query with parameters of type Select Modifier and Type Method Description voidFromClause. addFrom(Select sub, Alias alias)Add the sub-query as an item in the from listvoidSelect. addFrom(Select sub, Alias alias)Add a sub-select statement with an alias to the from-clausevoidFromClause. addInnerJoin(Select sub, Alias alias, ExpNode joinOnPredicate)Add an inner join clause to the FROM items listvoidSelect. 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-querySelectItemSubQuerySelectList. addSubQuery(Select subQuery, Alias alias)voidSelect. addWithClause(Select selectClause, Alias alias)Add a new WITH clause to the select statement for example WITH alias AS (SELECT ...) SELECT ...TBaseWhereAdapter. exists(Select correlatedSubSelect)Add an exists clause using the given correlated sub-select statementFromAdapterSelectAdapter. from(Select sub, Alias alias)Add the sub-query select to the FROM clauseFromAdapterFromAdapter. innerJoin(Select sub, Alias alias, WhereFragment joinOnPredicate)Add an INNER JOIN for the given sub selectTBaseWhereAdapter. notExists(Select correlatedSubSelect)Add a NOT EXISTS clause using the given correlated sub-select statementstatic java.sql.PreparedStatementQueryUtil. prepareSelect(java.sql.Connection connection, Select select, IDatabaseTranslator translator)Prepares the given Select statement and sets any bind parameters.voidSelect. setUnion(Select union)Set a select to UNION with this query.voidSelect. setUnionAll(Select unionAll)Set a select to UNION ALL with this query.voidSelectAdapter. union(Select unionSelect)Add a select via UNIONvoidSelectAdapter. unionAll(Select unionAllSelect)Add a select via UNION ALLSelectAdapterSelectAdapter. 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.StringDebugExpNodeVisitor. select(Select select)TStatementRenderer. 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.StringStringExpNodeVisitor. select(Select select)java.lang.StringStringStatementRenderer. 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 TExpNodeVisitor. 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.intResourceDAO. searchCount(Select countQuery)Executes a count query based on the data contained in the passedSelectstatement, 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 intFHIRDbDAOImpl. 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 givenSelectstatementjava.util.List<Resource>ResourceDAOImpl. search(Select select)intResourceDAOImpl. 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 SelectNewQueryBuilder. 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.SelectNewQueryBuilder. 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.SelectNewQueryBuilder. buildQuery(java.lang.Class<?> resourceType, FHIRSearchContext searchContext, SchemaType schemaType)Construct a FHIR search querySelectNewQueryBuilder. 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.
-