Module is.codion.framework.model

Package is.codion.framework.model

Interface EntityQueryModel

public interface EntityQueryModel

Provides entities based on query conditions. The default data source can be overridden by using dataSource().

tableModel.queryModel().dataSource().set(queryModel -> {
	 EntityConnection connection = queryModel.connectionProvider().connection();

  return connection.select(Employee.NAME.equalTo("John"));
});

See Also:

• entityQueryModel(EntityTableConditionModel)

Nested Class Summary

Nested Classes

Modifier and Type	Interface	Description
static interface	EntityQueryModel.AdditionalCondition	Specifies an additional condition supplier.
static interface	EntityQueryModel.SelectAttributes	Manages the attributes to include when querying.

Field Summary

Fields

Modifier and Type	Field	Description
static final PropertyValue<Integer>	LIMIT	Specifes a default limit() to set for query models.

Method Summary

Modifier and Type	Method	Description
EntityQueryModel.SelectAttributes	attributes()
ObservableState	conditionChanged()	This state is reset each time query() returns successfully.
Value<ObservableState>	conditionEnabled()	It can be necessary to prevent the user from selecting too much data, when working with a large dataset.
State	conditionRequired()	Returns a State controlling whether this query model should query all underlying entities when no query condition has been set.
EntityTableConditionModel	conditions()
EntityConnectionProvider	connectionProvider()
Value<Function<EntityQueryModel,List<Entity>>>	dataSource()	A Value controlling the data source.
static EntityQueryModel	entityQueryModel(EntityTableConditionModel conditionModel)
EntityType	entityType()
EntityQueryModel.AdditionalCondition	having()	Controls the additional HAVING condition, which can be used in conjunction with conditions().
Value<Integer>	limit()	Returns the Value controlling the maximum number of rows to fetch, a null value means all rows should be fetched
Value<OrderBy>	orderBy()	Controls the order by clause to use when selecting the data for this model.
List<Entity>	query()	Performs a query and returns the result.
EntityConnection.Select	select()
EntityQueryModel.AdditionalCondition	where()	Controls the additional WHERE condition, which can be used in conjunction with conditions().

Field Details

LIMIT

static final PropertyValue<Integer> LIMIT

Specifes a default limit() to set for query models.

• Value type: Integer
• Default value: null

Method Details

entityType

EntityType entityType()

Returns:

the type of the entity this query model is based on

connectionProvider

EntityConnectionProvider connectionProvider()

Returns:

the connection provider

query

List<Entity> query()

Performs a query and returns the result. Note that if a query condition is required (conditionRequired()) and the condition is not enabled (conditionEnabled()) an empty list is returned.

Returns:

entities selected from the database according to the query condition.

See Also:

• select()

select

EntityConnection.Select select()

Returns:

a EntityConnection.Select instance based on the current state of this EntityQueryModel

conditions

EntityTableConditionModel conditions()

Returns:

the EntityTableConditionModel instance used by this query model

where

EntityQueryModel.AdditionalCondition where()

Controls the additional WHERE condition, which can be used in conjunction with conditions(). The condition supplier may return null in case of no condition. Note that in order for the conditionChanged() ObservableState to indicate a changed condition, the additional condition must be set via Value.set(Object), changing the return value of the underlying Supplier instance does not trigger a changed condition.

Returns:

the EntityQueryModel.AdditionalCondition instance controlling the additional WHERE condition

having

EntityQueryModel.AdditionalCondition having()

Controls the additional HAVING condition, which can be used in conjunction with conditions(). The condition supplier may return null in case of no condition. Note that in order for the conditionChanged() ObservableState to indicate a changed condition, the additional condition must be set via Value.set(Object), changing the return value of the underlying Supplier instance does not trigger a changed condition.

Returns:

the EntityQueryModel.AdditionalCondition instance controlling the additional HAVING condition

conditionRequired

State conditionRequired()

Returns a State controlling whether this query model should query all underlying entities when no query condition has been set. Setting this value to 'true' prevents all rows from being fetched by accident, when no condition has been set, which is recommended for queries with a large underlying dataset.

Returns:

a State controlling whether this query model requires a query condition

See Also:

• conditionEnabled()

conditionChanged

ObservableState conditionChanged()

This state is reset each time query() returns successfully.

Returns:

an ObservableState indicating if the search condition has changed since last reset

attributes

EntityQueryModel.SelectAttributes attributes()

Returns:

the EntityQueryModel.SelectAttributes instance

limit

Value<Integer> limit()

Returns the Value controlling the maximum number of rows to fetch, a null value means all rows should be fetched

Returns:

the Value controlling the query limit

orderBy

Value<OrderBy> orderBy()

Controls the order by clause to use when selecting the data for this model. Setting this value to null reverts back to the default order by for the underlying entity, if one has been specified

Returns:

the Value controlling the order by clause

See Also:

• EntityDefinition.orderBy()

conditionEnabled

Value<ObservableState> conditionEnabled()

It can be necessary to prevent the user from selecting too much data, when working with a large dataset. This can be done by enabling the conditionRequired() State, which prevents a refresh as long as the ObservableState controlled via this method is disabled. The default ObservableState is simply EntityTableConditionModel.enabled(). Override for a more fine-grained control, such as requiring a specific column condition to be enabled.

Returns:

the Value controlling the ObservableState specifying if enough conditions are enabled for a safe refresh

See Also:

• conditionRequired()

dataSource

Value<Function<EntityQueryModel,List<Entity>>> dataSource()

A Value controlling the data source. Use this to replace the default one.

Returns:

the Value controlling the data source

entityQueryModel

static EntityQueryModel entityQueryModel(EntityTableConditionModel conditionModel)

Parameters:

conditionModel - the EntityTableConditionModel

Returns:

a new EntityQueryModel instance based on the given EntityTableConditionModel