Package io.jmix.dynmodel.impl.db

Class DynamicEntitySqlQueryBuilder

java.lang.Object

io.jmix.dynmodel.impl.db.DynamicEntitySqlQueryBuilder

@Component("dynmod_DynamicEntitySqlQueryBuilder")
public class DynamicEntitySqlQueryBuilder
extends Object

Nested Class Summary

Nested Classes

Modifier and Type	Class	Description
protected static class	DynamicEntitySqlQueryBuilder.PathBuildState
protected static final record	DynamicEntitySqlQueryBuilder.PathExpression
protected static class	DynamicEntitySqlQueryBuilder.QueryBuildContext
protected static final record	DynamicEntitySqlQueryBuilder.SortExpression
static final record	DynamicEntitySqlQueryBuilder.SqlQuery
protected static enum	DynamicEntitySqlQueryBuilder.StorageKind

Field Summary

Fields

Modifier and Type	Field	Description
protected CoreProperties	coreProperties
protected DynamicModelDbSupportResolver	dbSupportResolver
protected DynamicModelTools	dynamicModelTools
protected static final String	LIKE_ESCAPE
protected Metadata	metadata
protected MetadataTools	metadataTools
protected QueryParamValuesManager	queryParamValuesManager
protected ReferenceToEntitySupport	referenceToEntitySupport
protected static final String	ROOT_ALIAS
protected StaticEntityKeyDescriptorSupport	staticEntityKeyDescriptorSupport

Constructor Summary

Constructors

Constructor	Description
DynamicEntitySqlQueryBuilder()

Method Summary

Modifier and Type	Method	Description
protected @Nullable Condition	actualizeCondition(LoadContext.Query query)
protected void	addSortExpressions(MetaClass rootMetaClass, String propertyPath, Sort.Direction direction, DynamicEntitySqlQueryBuilder.QueryBuildContext buildContext, List<DynamicEntitySqlQueryBuilder.SortExpression> sortExpressions, int depth)
protected void	addStableOrderIfNeeded(List<DynamicEntitySqlQueryBuilder.SortExpression> sortExpressions, DynamicEntitySqlQueryBuilder.QueryBuildContext buildContext, boolean pagingRequested)
DynamicEntitySqlQueryBuilder.SqlQuery	buildCountQuery(LoadContext<?> context)
protected String	buildInClause(int size)
DynamicEntitySqlQueryBuilder.SqlQuery	buildListQuery(LoadContext<?> context)
protected String	buildLogicalWhere(LogicalCondition logicalCondition, DynamicEntitySqlQueryBuilder.QueryBuildContext buildContext)
protected DynamicEntitySqlQueryBuilder.PathExpression	buildPathExpression(MetaClass rootMetaClass, String propertyPath, DynamicEntitySqlQueryBuilder.QueryBuildContext buildContext)
protected String	buildPropertyWhere(PropertyCondition propertyCondition, DynamicEntitySqlQueryBuilder.QueryBuildContext buildContext)
protected String	buildSelectSql(String selection, DynamicEntitySqlQueryBuilder.QueryBuildContext buildContext, String where, List<DynamicEntitySqlQueryBuilder.SortExpression> sortExpressions)
protected List<DynamicEntitySqlQueryBuilder.SortExpression>	buildSortExpressions(LoadContext.Query query, DynamicEntitySqlQueryBuilder.QueryBuildContext buildContext)
protected String	buildWhere(@Nullable Condition condition, DynamicEntitySqlQueryBuilder.QueryBuildContext buildContext)
protected @Nullable Object	convertToDbValue(@Nullable Object value, MetaProperty property)
protected String	escapeLikeParameter(String value)
protected @Nullable Object	getConditionParameterValue(PropertyCondition propertyCondition, MetaProperty property, LoadContext.Query query)
protected Collection<MetaProperty>	getInstanceNameProperties(MetaClass metaClass)
protected LoadContext.Query	getQuery(LoadContext<?> context)
protected String	getReferenceColumn(MetaProperty referenceProperty, DynamicEntitySqlQueryBuilder.StorageKind storageKind)
protected String	getRootIdColumn(MetaClass metaClass)
protected String	getSimplePrimaryKeyColumn(MetaClass metaClass)
protected String	getSimpleSideTableKeyColumn(MetaClass metaClass)
protected String	getStaticTableName(MetaClass metaClass)
protected String	getTerminalColumn(MetaProperty property, DynamicEntitySqlQueryBuilder.StorageKind storageKind)
protected String	getUnarySqlOperation(PropertyCondition propertyCondition, LoadContext.Query query)
protected boolean	isLikeOperation(PropertyCondition propertyCondition)
protected boolean	isPagingRequested(LoadContext.Query query)
protected void	moveByReference(DynamicEntitySqlQueryBuilder.PathBuildState state, MetaProperty referenceProperty, MetaProperty nextProperty, String propertyPath, DynamicEntitySqlQueryBuilder.QueryBuildContext buildContext)
protected Collection<?>	toCollection(@Nullable Object parameterValue)
protected IllegalStateException	unsupportedPath(String propertyPath, String segmentName)
protected void	validatePath(List<MetaProperty> properties, String propertyPath)

Methods inherited from class java.lang.Object

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

Field Details

ROOT_ALIAS

protected static final String ROOT_ALIAS

See Also:

• Constant Field Values

LIKE_ESCAPE

protected static final String LIKE_ESCAPE

See Also:

• Constant Field Values

metadata

@Autowired
protected Metadata metadata

metadataTools

@Autowired
protected MetadataTools metadataTools

dynamicModelTools

@Autowired
protected DynamicModelTools dynamicModelTools

dbSupportResolver

@Autowired
protected DynamicModelDbSupportResolver dbSupportResolver

staticEntityKeyDescriptorSupport

@Autowired
protected StaticEntityKeyDescriptorSupport staticEntityKeyDescriptorSupport

referenceToEntitySupport

@Autowired
protected ReferenceToEntitySupport referenceToEntitySupport

coreProperties

@Autowired
protected CoreProperties coreProperties

queryParamValuesManager

@Autowired
protected QueryParamValuesManager queryParamValuesManager

Constructor Details

DynamicEntitySqlQueryBuilder

public DynamicEntitySqlQueryBuilder()

Method Details

buildListQuery

public DynamicEntitySqlQueryBuilder.SqlQuery buildListQuery(LoadContext<?> context)

buildCountQuery

public DynamicEntitySqlQueryBuilder.SqlQuery buildCountQuery(LoadContext<?> context)

getQuery

protected LoadContext.Query getQuery(LoadContext<?> context)

actualizeCondition

protected @Nullable Condition actualizeCondition(LoadContext.Query query)

buildWhere

protected String buildWhere(@Nullable Condition condition,
 DynamicEntitySqlQueryBuilder.QueryBuildContext buildContext)

buildLogicalWhere

protected String buildLogicalWhere(LogicalCondition logicalCondition,
 DynamicEntitySqlQueryBuilder.QueryBuildContext buildContext)

buildPropertyWhere

protected String buildPropertyWhere(PropertyCondition propertyCondition,
 DynamicEntitySqlQueryBuilder.QueryBuildContext buildContext)

getUnarySqlOperation

protected String getUnarySqlOperation(PropertyCondition propertyCondition,
 LoadContext.Query query)

getConditionParameterValue

protected @Nullable Object getConditionParameterValue(PropertyCondition propertyCondition,
 MetaProperty property,
 LoadContext.Query query)

escapeLikeParameter

protected String escapeLikeParameter(String value)

isLikeOperation

protected boolean isLikeOperation(PropertyCondition propertyCondition)

buildSortExpressions

protected List<DynamicEntitySqlQueryBuilder.SortExpression> buildSortExpressions(LoadContext.Query query,
 DynamicEntitySqlQueryBuilder.QueryBuildContext buildContext)

addSortExpressions

protected void addSortExpressions(MetaClass rootMetaClass,
 String propertyPath,
 Sort.Direction direction,
 DynamicEntitySqlQueryBuilder.QueryBuildContext buildContext,
 List<DynamicEntitySqlQueryBuilder.SortExpression> sortExpressions,
 int depth)

getInstanceNameProperties

protected Collection<MetaProperty> getInstanceNameProperties(MetaClass metaClass)

addStableOrderIfNeeded

protected void addStableOrderIfNeeded(List<DynamicEntitySqlQueryBuilder.SortExpression> sortExpressions,
 DynamicEntitySqlQueryBuilder.QueryBuildContext buildContext,
 boolean pagingRequested)

isPagingRequested

protected boolean isPagingRequested(LoadContext.Query query)

buildSelectSql

protected String buildSelectSql(String selection,
 DynamicEntitySqlQueryBuilder.QueryBuildContext buildContext,
 String where,
 List<DynamicEntitySqlQueryBuilder.SortExpression> sortExpressions)

buildPathExpression

protected DynamicEntitySqlQueryBuilder.PathExpression buildPathExpression(MetaClass rootMetaClass,
 String propertyPath,
 DynamicEntitySqlQueryBuilder.QueryBuildContext buildContext)

validatePath

protected void validatePath(List<MetaProperty> properties,
 String propertyPath)

moveByReference

protected void moveByReference(DynamicEntitySqlQueryBuilder.PathBuildState state,
 MetaProperty referenceProperty,
 MetaProperty nextProperty,
 String propertyPath,
 DynamicEntitySqlQueryBuilder.QueryBuildContext buildContext)

getTerminalColumn

protected String getTerminalColumn(MetaProperty property,
 DynamicEntitySqlQueryBuilder.StorageKind storageKind)

getReferenceColumn

protected String getReferenceColumn(MetaProperty referenceProperty,
 DynamicEntitySqlQueryBuilder.StorageKind storageKind)

getStaticTableName

protected String getStaticTableName(MetaClass metaClass)

getRootIdColumn

protected String getRootIdColumn(MetaClass metaClass)

getSimplePrimaryKeyColumn

protected String getSimplePrimaryKeyColumn(MetaClass metaClass)

getSimpleSideTableKeyColumn

protected String getSimpleSideTableKeyColumn(MetaClass metaClass)

convertToDbValue

protected @Nullable Object convertToDbValue(@Nullable Object value,
 MetaProperty property)

toCollection

protected Collection<?> toCollection(@Nullable Object parameterValue)

buildInClause

protected String buildInClause(int size)

unsupportedPath

protected IllegalStateException unsupportedPath(String propertyPath,
 String segmentName)