org.relique.jdbc.csv.RelopExpression Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of csvjdbc Show documentation
a Java JDBC driver for reading comma-separated-value files
There is a newer version: 1.0.46
/*
 *  CsvJdbc - a JDBC driver for CSV files
 *  Copyright (C) 2008  Mario Frasca
 *
 *  This library is free software; you can redistribute it and/or
 *  modify it under the terms of the GNU Lesser General Public
 *  License as published by the Free Software Foundation; either
 *  version 2.1 of the License, or (at your option) any later version.
 *
 *  This library is distributed in the hope that it will be useful,
 *  but WITHOUT ANY WARRANTY; without even the implied warranty of
 *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
 *  Lesser General Public License for more details.
 *
 *  You should have received a copy of the GNU Lesser General Public
 *  License along with this library; if not, write to the Free Software
 *  Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301  USA
 */
package org.relique.jdbc.csv;

import java.sql.Date;
import java.sql.SQLException;
import java.sql.Time;
import java.sql.Timestamp;
import java.util.LinkedList;
import java.util.List;
import java.util.Map;
import java.util.Set;

class RelopExpression extends LogicalExpression
{
	String op;
	Expression left, right;
	boolean isValid;
	public RelopExpression(String op, Expression left, Expression right)
	{
		isValid = !(left instanceof LogicalExpression || right instanceof LogicalExpression);
		this.op = op;
		this.left = left;
		this.right = right;
	}
	@Override
	public Boolean isTrue(Map env) throws SQLException
	{
		Boolean result = null;
		Comparable leftValue = (Comparable)left.eval(env);
		Comparable rightValue = (Comparable)right.eval(env);
		Integer leftComparedToRightObj = compare(leftValue, rightValue,  env);
		if (leftComparedToRightObj != null)
		{
			int leftComparedToRight = leftComparedToRightObj.intValue();
			if (leftValue != null && rightValue != null)
			{
				if (op.equals("="))
				{
					result = Boolean.valueOf(leftComparedToRight == 0);
				}
				else if (op.equals("<>") || op.equals("!="))
				{
					result = Boolean.valueOf(leftComparedToRight != 0);
				}
				else if (op.equals(">"))
				{
					result = Boolean.valueOf(leftComparedToRight>0);
				}
				else if (op.equals("<"))
				{
					result = Boolean.valueOf(leftComparedToRight<0);
				}
				else if (op.equals("<=") || op.equals("=<"))
				{
					result = Boolean.valueOf(leftComparedToRight <= 0);
				}
				else if (op.equals(">=") || op.equals("=>"))
				{
					result = Boolean.valueOf(leftComparedToRight >= 0);
				}
			}
		}
		return result;
	}
	public static Integer compare(Comparable leftValue,
		Comparable rightValue, Map env) throws SQLException
	{
		Integer leftComparedToRightObj = null;
		try
		{
			if (leftValue != null && rightValue != null)
				leftComparedToRightObj = Integer.valueOf(leftValue.compareTo(rightValue));
		}
		catch (ClassCastException e)
		{
		}
		try
		{
			if (leftComparedToRightObj == null)
			{
				if (leftValue == null || rightValue == null)
				{
					/*
					 * Do nothing.  Anything compared with NULL is false.
					 */
				}
				else if (leftValue instanceof Date)
				{
					Expression stringConverter = new ColumnName(StringConverter.COLUMN_NAME);
					StringConverter sc = (StringConverter) stringConverter.eval(env);
					Date date = sc.parseDate(rightValue.toString());
					if (date != null)
						leftComparedToRightObj = Integer.valueOf(leftValue.compareTo(date));
				}
				else if (rightValue instanceof Date)
				{
					Expression stringConverter = new ColumnName(StringConverter.COLUMN_NAME);
					StringConverter sc = (StringConverter) stringConverter.eval(env);
					Date date = sc.parseDate(leftValue.toString());
					if (date != null)
						leftComparedToRightObj = Integer.valueOf(date.compareTo((Date)rightValue));
				}
				else if (leftValue instanceof Time)
				{
					Expression stringConverter = new ColumnName(StringConverter.COLUMN_NAME);
					StringConverter sc = (StringConverter) stringConverter.eval(env);
					Time time = sc.parseTime(rightValue.toString());
					if (time != null)
						leftComparedToRightObj = Integer.valueOf(leftValue.compareTo(time));
				}
				else if (rightValue instanceof Time)
				{
					Expression stringConverter = new ColumnName(StringConverter.COLUMN_NAME);
					StringConverter sc = (StringConverter) stringConverter.eval(env);
					Time time = sc.parseTime(leftValue.toString());
					if (time != null)
						leftComparedToRightObj = Integer.valueOf(time.compareTo((Time)rightValue));
				}
				else if (leftValue instanceof Timestamp)
				{
					Expression stringConverter = new ColumnName(StringConverter.COLUMN_NAME);
					StringConverter sc = (StringConverter) stringConverter.eval(env);
					Timestamp timestamp = sc.parseTimestamp(rightValue.toString());
					if (timestamp != null)
						leftComparedToRightObj = Integer.valueOf(leftValue.compareTo(timestamp));
				}
				else if (rightValue instanceof Timestamp)
				{
					Expression stringConverter = new ColumnName(StringConverter.COLUMN_NAME);
					StringConverter sc = (StringConverter) stringConverter.eval(env);
					Timestamp timestamp = sc.parseTimestamp(leftValue.toString());
					if (timestamp != null)
						leftComparedToRightObj = Integer.valueOf(timestamp.compareTo((Timestamp)rightValue));
				}
				else if (leftValue instanceof Boolean)
				{
					Boolean leftBoolean = (Boolean)leftValue;
					Boolean rightBoolean = Boolean.valueOf(rightValue.toString());

					// false (0) is less than true (1) in Boolean algebra
					if (leftBoolean.equals(rightBoolean))
						leftComparedToRightObj = Integer.valueOf(0);
					else if (!leftBoolean.booleanValue())
						leftComparedToRightObj = Integer.valueOf(-1);
					else
						leftComparedToRightObj = Integer.valueOf(1);
				}
				else
				{
					Double leftDouble = Double.valueOf(((Number)leftValue).toString());
					Double rightDouble = Double.valueOf(((Number)rightValue).toString());
					leftComparedToRightObj = Integer.valueOf(leftDouble.compareTo(rightDouble));
				}
			}
		}
		catch (ClassCastException | NumberFormatException e)
		{
		}
		return leftComparedToRightObj;
	}
	@Override
	public String toString()
	{
		return op+" "+left+" "+right;
	}
	@Override
	public List usedColumns(Set availableColumns)
	{
		List result = new LinkedList<>();
		result.addAll(left.usedColumns(availableColumns));
		result.addAll(right.usedColumns(availableColumns));
		return result;
	}
	@Override
	public List aggregateFunctions()
	{
		List result = new LinkedList<>();
		result.addAll(left.aggregateFunctions());
		result.addAll(right.aggregateFunctions());
		return result;
	}
	@Override
	public boolean isValid()
	{
		return isValid;
	}
}