prerna.query.querystruct.transform.QSParseParamStruct Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of semoss Show documentation
SEMOSS
The newest version!
package prerna.query.querystruct.transform;

import java.util.List;

import org.apache.logging.log4j.LogManager;
import org.apache.logging.log4j.Logger;

import prerna.om.Pixel;
import prerna.query.parsers.ParamStruct;
import prerna.query.parsers.ParamStructDetails;
import prerna.query.parsers.ParamStructDetails.BASE_QS_TYPE;
import prerna.query.querystruct.SelectQueryStruct;
import prerna.query.querystruct.filters.AndQueryFilter;
import prerna.query.querystruct.filters.IQueryFilter;
import prerna.query.querystruct.filters.OrQueryFilter;
import prerna.query.querystruct.filters.SimpleQueryFilter;
import prerna.query.querystruct.selectors.IQuerySelector;
import prerna.query.querystruct.selectors.QueryColumnSelector;
import prerna.sablecc2.om.PixelDataType;
import prerna.sablecc2.om.nounmeta.NounMetadata;

public class QSParseParamStruct {
	
	private static final Logger logger = LogManager.getLogger(QSParseParamStruct.class);
	
	private Pixel pixelObj = null;
	private SelectQueryStruct qs = null;;
	
	public QSParseParamStruct(SelectQueryStruct qs, Pixel pixelObj) {
		this.qs = qs;
		this.pixelObj = pixelObj;
	}
	
	/**
	 * This is the main method for this class.  Parses a generic filter
	 * @param filter
	 * @param paramList
	 */
	public void parseFilter(IQueryFilter filter, List paramList) {
		if(filter.getQueryFilterType() == IQueryFilter.QUERY_FILTER_TYPE.SIMPLE) {
			convertSimpleQueryFilter((SimpleQueryFilter) filter, paramList);
		} else if(filter.getQueryFilterType() == IQueryFilter.QUERY_FILTER_TYPE.AND) {
			parseAndQueryFilter((AndQueryFilter) filter, paramList);
		} else if(filter.getQueryFilterType() == IQueryFilter.QUERY_FILTER_TYPE.OR) {
			parseOrQueryFilter((OrQueryFilter) filter, paramList);
		}
		
	}

	public void parseOrQueryFilter(OrQueryFilter filter, List paramList) {
		for(IQueryFilter f : filter.getFilterList()) {
			parseFilter(f, paramList);
		}
	}

	public void parseAndQueryFilter(AndQueryFilter filter, List paramList) {
		for(IQueryFilter f : filter.getFilterList()) {
			parseFilter(f, paramList);
		}
	}

	public void convertSimpleQueryFilter(SimpleQueryFilter filter, List paramList) {
		boolean parameterizeLeft = false;
		boolean parameterizeRight = false;
		
		IQuerySelector selector = null;
		NounMetadata origL = filter.getLComparison();
		if(origL.getNounType() == PixelDataType.COLUMN) {
			selector = (IQuerySelector) origL.getValue();
			parameterizeRight = true;
		}
		
		NounMetadata origR = filter.getRComparison();
		if(origR.getNounType() == PixelDataType.COLUMN) {
			selector = (IQuerySelector) origL.getValue();
			parameterizeLeft = true;
		}
		
		if((parameterizeLeft && parameterizeRight)
				|| (!parameterizeLeft && !parameterizeRight)) {
			// cannot have both be columns
			// and need at least one to be a column
			// that is already in a sense a dynamically defined filter
			logger.debug("Must have at one part of the filter be a column");
			return;
		}
		
		if(!(selector instanceof QueryColumnSelector)) {
			logger.debug("Cannot parameterize on derived columns");
			return;
		}
		String comparator = filter.getComparator();
		
		ParamStruct param = new ParamStruct();
		ParamStructDetails paramDetails = new ParamStructDetails();
		paramDetails.setBaseQsType(BASE_QS_TYPE.SQS);
		paramDetails.setDatabaseId(qs.getEngineId());
		paramDetails.setPixelId(pixelObj.getId());
		paramDetails.setPixelString(pixelObj.getPixelString());
		paramDetails.setOperator(comparator);

		QueryColumnSelector columnSelector = (QueryColumnSelector) selector;
		paramDetails.setTableName(columnSelector.getTable());
		paramDetails.setColumnName(columnSelector.getColumn());
		if(parameterizeLeft) {
			// rhs is the column, lhs is the value
			Object paramValue = origL.getValue();
			paramDetails.setCurrentValue(paramValue);
			paramDetails.setType(origL.getNounType());
		} else if(parameterizeRight) {
			// lhs is the column, rhs is the value
			Object paramValue = origR.getValue();
			paramDetails.setCurrentValue(paramValue);
			paramDetails.setType(origR.getNounType());
		}
		// additional options based on the comparator
		if(IQueryFilter.comparatorIsNumeric(comparator)
				|| IQueryFilter.isRegexComparator(comparator)) {
			// single valued
			param.setMultiple(false);
			param.setSearchable(false);
		} else {
			// multiple values allowed
			param.setMultiple(true);
			param.setSearchable(true);
		}
		param.addParamStructDetails(paramDetails);
		// add to the list of params
		paramList.add(param);
	}
}