com.xdev.jadoth.sqlengine

Class SQL.util

java.lang.Object

com.xdev.jadoth.sqlengine.SQL.util

Enclosing class:

SQL

public abstract static class SQL.util
extends Object

The Class util.

Field Summary

Fields

Modifier and Type	Field and Description
protected static char	c_apo The Constant c_apo.

Constructor Summary

Constructors

Constructor and Description
util()

Method Summary

Modifier and Type	Method and Description
static StringBuilder	assembleEscape(StringBuilder sb, String s) Assemble escape.
static String	assembleTimestamp(int... parts) Assemble timestamp.
static String	escape(String s) Escape.
static String	escapeIfNecessary(String s) Escape if necessary.
static StringBuilder	escapeIfNecessary(String s, StringBuilder sb) Escape if necessary.
static String	escapeReservedWord(String s)
static String	getColumnName(Object o) Gets the column name.
static String	guessAlias(String tablename) Guess alias.
static String	guessAlias(String tablename, int charCount) Guess alias.
static String	guessAlias(String tablename, int minChars, int maxChars) Guess alias.
static boolean	needsEscaping(SQL.DATATYPE columnType) Needs escaping.
static SqlCondition	parseCondition(Object object) Parses the condition.
static SqlExpression	parseExpression(Object obj) Parses the expression.
static SqlExpression[]	parseExpressionArray(Object... objects) Parses the expression array.
static String[]	parseFullQualifiedTablename(String fullQualifiedTablename) Parses the full qualified tablename.
static String	qualify(Object... parts) Qualify.
static Boolean	recognizeBoolean(Object object) Utility method than recognizes Boolean values. object can have several values that are recognized as boolean values: - null value: returns null - Boolean value: returns object - Number value: return false for value 0, true otherwise - String value (caseinsensitive): returns false for "N" or "NO" , true for "Y" or "YES", otherwise value is not recognized Any unrecognizable value will cause a ClassCastException. Notes: - this method is inefficient if the type of object is already known. - use this method only if you are sure that the provided value is meant to be a boolean value of some form - the main purpose of this method is to handle boolean and pseudo-boolean values returned from different DBMS generically, no matter if it's a true boolean or 0/1 or stupid 0/-1 or "YES/NO", etc.
static boolean	recognizeBooleanPrimitive(Object object) Like recognizeBoolean, but maps null value to false.

Methods inherited from class java.lang.Object

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

Field Detail

c_apo

protected static final char c_apo

The Constant c_apo.

See Also:

Constant Field Values

Constructor Detail

util

public util()

Method Detail

needsEscaping

public static final boolean needsEscaping(SQL.DATATYPE columnType)

Needs escaping.

Parameters:

columnType - the column type

Returns:

true, if successful

assembleEscape

public static StringBuilder assembleEscape(StringBuilder sb,
                                           String s)

Assemble escape.

Parameters:

sb - the sb

s - the s

Returns:

the string builder

escape

public static String escape(String s)

Escape.

Parameters:

s - the s

Returns:

the string

guessAlias

public static final String guessAlias(String tablename)

Guess alias.

Parameters:

tablename - the tablename

Returns:

the string

guessAlias

public static final String guessAlias(String tablename,
                                      int charCount)

Guess alias.

Parameters:

tablename - the tablename

charCount - the char count

Returns:

the string

escapeReservedWord

public static final String escapeReservedWord(String s)

guessAlias

public static final String guessAlias(String tablename,
                                      int minChars,
                                      int maxChars)

Guess alias.

Parameters:

tablename - the tablename

minChars - the min chars

maxChars - the max chars

Returns:

the string

recognizeBoolean

public static final Boolean recognizeBoolean(Object object)
                                      throws ClassCastException

Utility method than recognizes Boolean values.
object can have several values that are recognized as boolean values: - null value: returns null
- Boolean value: returns object
- Number value: return false for value 0, true otherwise
- String value (caseinsensitive): returns false for "N" or "NO" , true for "Y" or "YES", otherwise value is not recognized

Any unrecognizable value will cause a ClassCastException.

Notes:
- this method is inefficient if the type of object is already known.
- use this method only if you are sure that the provided value is meant to be a boolean value of some form - the main purpose of this method is to handle boolean and pseudo-boolean values returned from different DBMS generically, no matter if it's a true boolean or 0/1 or stupid 0/-1 or "YES/NO", etc.

Parameters:

object - the object

Returns:

the boolean

Throws:

ClassCastException - the class cast exception

recognizeBooleanPrimitive

public static final boolean recognizeBooleanPrimitive(Object object)
                                               throws ClassCastException

Like recognizeBoolean, but maps null value to false.

Parameters:

object - the object

Returns:

true or false :-)

Throws:

ClassCastException - the class cast exception

escapeIfNecessary

public static final StringBuilder escapeIfNecessary(String s,
                                                    StringBuilder sb)

Escape if necessary.

Parameters:

s - the s

sb - the sb

Returns:

the string builder

escapeIfNecessary

public static final String escapeIfNecessary(String s)

Escape if necessary.

Parameters:

s - the s

Returns:

the string

parseExpression

public static final SqlExpression parseExpression(Object obj)

Parses the expression.

Parameters:

obj - the obj

Returns:

the sql expression

parseExpressionArray

public static final SqlExpression[] parseExpressionArray(Object... objects)

Parses the expression array.

Parameters:

objects - the objects

Returns:

the sql expression[]

parseCondition

public static final SqlCondition parseCondition(Object object)

Parses the condition.

Parameters:

object - the object

Returns:

the sql condition

parseFullQualifiedTablename

public static final String[] parseFullQualifiedTablename(String fullQualifiedTablename)

Parses the full qualified tablename.

Parameters:

fullQualifiedTablename - the full qualified tablename

Returns:

the string[]

assembleTimestamp

public static final String assembleTimestamp(int... parts)

Assemble timestamp.

Parameters:

parts - the parts

Returns:

the string

qualify

public static final String qualify(Object... parts)

Qualify.

Parameters:

parts - the parts

Returns:

the string

getColumnName

public static final String getColumnName(Object o)

Gets the column name.

Parameters:

o - the o

Returns:

the column name