All Downloads are FREE. Search and download functionalities are using the official Maven repository.

com.yuehuanghun.mybatis.milu.generic.impl.GenericCountByExampleProviderSql Maven / Gradle / Ivy

There is a newer version: 1.18.0
Show newest version
/*
 * Copyright 2020-2022 the original author or authors.
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *      https://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */
package com.yuehuanghun.mybatis.milu.generic.impl;

import java.util.Collection;

import com.yuehuanghun.mybatis.milu.annotation.Mode;
import com.yuehuanghun.mybatis.milu.data.SqlBuildingHelper;
import com.yuehuanghun.mybatis.milu.generic.AbstractGenericExampleProviderSql;
import com.yuehuanghun.mybatis.milu.generic.GenericProviderContext;
import com.yuehuanghun.mybatis.milu.metamodel.Entity;
import com.yuehuanghun.mybatis.milu.metamodel.Entity.Attribute;
import com.yuehuanghun.mybatis.milu.metamodel.Entity.RangeCondition;
import com.yuehuanghun.mybatis.milu.tool.Segment;

public class GenericCountByExampleProviderSql extends AbstractGenericExampleProviderSql {

	@Override
	public String provideCachingSql(GenericProviderContext context, Object params) {
		Entity entity = context.getEntity();
		
		Collection attributes = entity.getAttributes();
		StringBuilder sqlBuilder = new StringBuilder(1024).append(Segment.SCRIPT_LABEL);
		
		sqlBuilder.append(Segment.SELECT_COUNT_FROM).append(wrapTableName(entity, context));
		
		sqlBuilder.append(Segment.WHERE_LABEL);
		for(Attribute attr : attributes) {
			if(!attr.isConditionable()) {
				continue;
			}
			
			if(attr.getConditionMode() == Mode.ALL) {
				sqlBuilder.append(Segment.AND_B)
				    .append(wrapIdentifier(attr.getColumnName(), context))
				    .append(SqlBuildingHelper.matchExpression(attr, context.getConfiguration()));
			} else if(attr.getConditionMode() == Mode.NOT_EMPTY && CharSequence.class.isAssignableFrom(attr.getJavaType())) {
				sqlBuilder.append(Segment.IF_TEST_EXAMPLE)
				    .append(attr.getName()).append(Segment.NOT_EQUAL_NULL_AND_EXAMPLE)
				    .append(attr.getName()).append(Segment.NOT_EMPTY_NULL_CLOSING).append(Segment.AND_B)
				    .append(wrapIdentifier(attr.getColumnName(), context))
				    .append(SqlBuildingHelper.matchExpression(attr, context.getConfiguration()))
				    .append(Segment.IF_LABEL_END);
			} else {
				sqlBuilder.append(Segment.IF_TEST_EXAMPLE)
				    .append(attr.getName()).append(Segment.NOT_EQUAL_NULL_CLOSING).append(Segment.AND_B)
				    .append(wrapIdentifier(attr.getColumnName(), context))
				    .append(SqlBuildingHelper.matchExpression(attr, context.getConfiguration()))
				    .append(Segment.IF_LABEL_END);
			}
			for(RangeCondition range : attr.getRangeList()) {
				sqlBuilder.append(Segment.IF_TEST_EXAMPLE_NOT_BLANK)
				    .append(range.getKeyName()).append(Segment.RIGHT_BRACKET_CLOSING).append(Segment.AND_B)
				    .append(wrapIdentifier(attr.getColumnName(), context))
				    .append(SqlBuildingHelper.matchExpression(range.getType(), range.getKeyName(), attr, context.getConfiguration()))
				    .append(Segment.IF_LABEL_END);
			}
			
		}
		sqlBuilder.append(Segment.WHERE_LABEL_END).append(Segment.SCRIPT_LABEL_END);
		
		return sqlBuilder.toString();
	}

	@Override
	public String getMethodName() {
		return "countByExample";
	}

}




© 2015 - 2024 Weber Informatics LLC | Privacy Policy