com.github.vincentrussell.query.mongodb.sql.converter.util

Class SqlUtils

java.lang.Object

com.github.vincentrussell.query.mongodb.sql.converter.util.SqlUtils

public class SqlUtils
extends Object

Method Summary

Modifier and Type	Method and Description
static boolean	containsIgnoreCase(List<String> list, String soughtFor)
static ParseException	convertParseException(net.sf.jsqlparser.parser.ParseException incomingException)
static String	fixDoubleSingleQuotes(String regex)
static Object	forceBool(Object value)
static Object	forceDate(Object value)
static Object	forceNumber(Object value)
static String	forceString(Object value)
static List<String>	getGroupByColumnReferences(net.sf.jsqlparser.statement.select.PlainSelect plainSelect)
static long	getLimit(net.sf.jsqlparser.statement.select.Limit limit)
static String	getStringValue(net.sf.jsqlparser.expression.Expression expression)
static Object	getValue(net.sf.jsqlparser.expression.Expression incomingExpression, net.sf.jsqlparser.expression.Expression otherSide, FieldType defaultFieldType, Map<String,FieldType> fieldNameToFieldTypeMapping)
static boolean	isCountAll(List<net.sf.jsqlparser.statement.select.SelectItem> selectItems)
static DateFunction	isDateFunction(net.sf.jsqlparser.expression.Expression incomingExpression)
static void	isFalse(boolean expression, String message)
static ObjectIdFunction	isObjectIdFunction(WhereCauseProcessor whereCauseProcessor, net.sf.jsqlparser.expression.Expression incomingExpression)
static RegexFunction	isRegexFunction(net.sf.jsqlparser.expression.Expression incomingExpression)
static boolean	isSelectAll(List<net.sf.jsqlparser.statement.select.SelectItem> selectItems)
static boolean	isSpecialtyFunction(net.sf.jsqlparser.expression.Expression incomingExpression)
static void	isTrue(boolean expression, String message)
static Object	normalizeValue(Object value, FieldType fieldType)
static Object	parseFunctionArguments(net.sf.jsqlparser.expression.operators.relational.ExpressionList parameters, FieldType defaultFieldType, Map<String,FieldType> fieldNameToFieldTypeMapping)
static Date	parseNaturalLanguageDate(String text)
static String	replaceGroup(String source, int groupToReplace, int groupOccurrence, String replacement)
static String	replaceRegexCharacters(String value)

Methods inherited from class java.lang.Object

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

Method Detail

getStringValue

public static String getStringValue(net.sf.jsqlparser.expression.Expression expression)

getValue

public static Object getValue(net.sf.jsqlparser.expression.Expression incomingExpression,
                              net.sf.jsqlparser.expression.Expression otherSide,
                              FieldType defaultFieldType,
                              Map<String,FieldType> fieldNameToFieldTypeMapping)
                       throws ParseException

Throws:

ParseException

isSpecialtyFunction

public static boolean isSpecialtyFunction(net.sf.jsqlparser.expression.Expression incomingExpression)

containsIgnoreCase

public static boolean containsIgnoreCase(List<String> list,
                                         String soughtFor)

parseFunctionArguments

public static Object parseFunctionArguments(net.sf.jsqlparser.expression.operators.relational.ExpressionList parameters,
                                            FieldType defaultFieldType,
                                            Map<String,FieldType> fieldNameToFieldTypeMapping)

normalizeValue

public static Object normalizeValue(Object value,
                                    FieldType fieldType)
                             throws ParseException

Throws:

ParseException

getLimit

public static long getLimit(net.sf.jsqlparser.statement.select.Limit limit)
                     throws ParseException

Throws:

ParseException

fixDoubleSingleQuotes

public static String fixDoubleSingleQuotes(String regex)

isSelectAll

public static boolean isSelectAll(List<net.sf.jsqlparser.statement.select.SelectItem> selectItems)

isCountAll

public static boolean isCountAll(List<net.sf.jsqlparser.statement.select.SelectItem> selectItems)

forceBool

public static Object forceBool(Object value)

forceDate

public static Object forceDate(Object value)
                        throws ParseException

Throws:

ParseException

parseNaturalLanguageDate

public static Date parseNaturalLanguageDate(String text)

forceNumber

public static Object forceNumber(Object value)
                          throws ParseException

Throws:

ParseException

forceString

public static String forceString(Object value)

convertParseException

public static ParseException convertParseException(net.sf.jsqlparser.parser.ParseException incomingException)

replaceRegexCharacters

public static String replaceRegexCharacters(String value)

getGroupByColumnReferences

public static List<String> getGroupByColumnReferences(net.sf.jsqlparser.statement.select.PlainSelect plainSelect)

replaceGroup

public static String replaceGroup(String source,
                                  int groupToReplace,
                                  int groupOccurrence,
                                  String replacement)

isObjectIdFunction

public static ObjectIdFunction isObjectIdFunction(WhereCauseProcessor whereCauseProcessor,
                                                  net.sf.jsqlparser.expression.Expression incomingExpression)
                                           throws ParseException

Throws:

ParseException

isDateFunction

public static DateFunction isDateFunction(net.sf.jsqlparser.expression.Expression incomingExpression)
                                   throws ParseException

Throws:

ParseException

isRegexFunction

public static RegexFunction isRegexFunction(net.sf.jsqlparser.expression.Expression incomingExpression)
                                     throws ParseException

Throws:

ParseException

isTrue

public static void isTrue(boolean expression,
                          String message)
                   throws ParseException

Throws:

ParseException

isFalse

public static void isFalse(boolean expression,
                           String message)
                    throws ParseException

Throws:

ParseException