com.liferay.util.dao.orm

Class CustomSQL

Object

com.liferay.util.dao.orm.CustomSQL

public class CustomSQL
extends Object

Author:

Brian Wing Shun Chan, Bruno Farache, Raymond Augé

See Also:

com.liferay.portal.dao.orm.custom.sql.CustomSQL

Field Summary

Fields

Modifier and Type	Field and Description
static String	DB2_FUNCTION_IS_NOT_NULL
static String	DB2_FUNCTION_IS_NULL
static String	INFORMIX_FUNCTION_IS_NOT_NULL
static String	INFORMIX_FUNCTION_IS_NULL
static String	MYSQL_FUNCTION_IS_NOT_NULL
static String	MYSQL_FUNCTION_IS_NULL
static String	SYBASE_FUNCTION_IS_NOT_NULL
static String	SYBASE_FUNCTION_IS_NULL

Constructor Summary

Constructors

Constructor and Description
CustomSQL()

Method Summary

Modifier and Type	Method and Description
String	appendCriteria(String sql, String criteria)
String	get(String id)
String	get(String id, com.liferay.portal.kernel.dao.orm.QueryDefinition<?> queryDefinition)
String	get(String id, com.liferay.portal.kernel.dao.orm.QueryDefinition<?> queryDefinition, String tableName)
protected String[]	getConfigs()
protected String	insertWildcard(String keyword, com.liferay.portal.kernel.dao.orm.WildcardMode wildcardMode)
boolean	isVendorDB2() Returns true if Hibernate is connecting to a DB2 database.
boolean	isVendorHSQL() Returns true if Hibernate is connecting to a Hypersonic database.
boolean	isVendorInformix() Returns true if Hibernate is connecting to an Informix database.
boolean	isVendorMySQL() Returns true if Hibernate is connecting to a MySQL database.
boolean	isVendorOracle() Returns true if Hibernate is connecting to an Oracle database.
boolean	isVendorPostgreSQL() Returns true if Hibernate is connecting to a PostgreSQL database.
boolean	isVendorSybase() Returns true if Hibernate is connecting to a Sybase database.
String[]	keywords(String keywords)
String[]	keywords(String[] keywordsArray)
String[]	keywords(String[] keywordsArray, boolean lowerCase)
String[]	keywords(String keywords, boolean lowerCase)
String[]	keywords(String keywords, boolean lowerCase, com.liferay.portal.kernel.dao.orm.WildcardMode wildcardMode)
String[]	keywords(String keywords, com.liferay.portal.kernel.dao.orm.WildcardMode wildcardMode)
void	reloadCustomSQL()
String	removeGroupBy(String sql)
String	removeOrderBy(String sql)
String	replaceAndOperator(String sql, boolean andOperator)
String	replaceGroupBy(String sql, String groupBy)
String	replaceIsNull(String sql)
String	replaceKeywords(String sql, String field, boolean last, int[] values)
String	replaceKeywords(String sql, String field, boolean last, long[] values)
String	replaceKeywords(String sql, String field, String operator, boolean last, String[] values)
String	replaceOrderBy(String sql, com.liferay.portal.kernel.util.OrderByComparator<?> orderByComparator)
protected String	transform(String sql)

Methods inherited from class Object

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

Field Detail

DB2_FUNCTION_IS_NOT_NULL

public static final String DB2_FUNCTION_IS_NOT_NULL

See Also:

Constant Field Values

DB2_FUNCTION_IS_NULL

public static final String DB2_FUNCTION_IS_NULL

See Also:

Constant Field Values

INFORMIX_FUNCTION_IS_NOT_NULL

public static final String INFORMIX_FUNCTION_IS_NOT_NULL

See Also:

Constant Field Values

INFORMIX_FUNCTION_IS_NULL

public static final String INFORMIX_FUNCTION_IS_NULL

See Also:

Constant Field Values

MYSQL_FUNCTION_IS_NOT_NULL

public static final String MYSQL_FUNCTION_IS_NOT_NULL

See Also:

Constant Field Values

MYSQL_FUNCTION_IS_NULL

public static final String MYSQL_FUNCTION_IS_NULL

See Also:

Constant Field Values

SYBASE_FUNCTION_IS_NOT_NULL

public static final String SYBASE_FUNCTION_IS_NOT_NULL

See Also:

Constant Field Values

SYBASE_FUNCTION_IS_NULL

public static final String SYBASE_FUNCTION_IS_NULL

See Also:

Constant Field Values

Constructor Detail

CustomSQL

public CustomSQL()
          throws SQLException

Throws:

SQLException

Method Detail

appendCriteria

public String appendCriteria(String sql,
                             String criteria)

get

public String get(String id)

get

public String get(String id,
                  com.liferay.portal.kernel.dao.orm.QueryDefinition<?> queryDefinition)

get

public String get(String id,
                  com.liferay.portal.kernel.dao.orm.QueryDefinition<?> queryDefinition,
                  String tableName)

isVendorDB2

public boolean isVendorDB2()

Returns true if Hibernate is connecting to a DB2 database.

Returns:

true if Hibernate is connecting to a DB2 database

isVendorHSQL

public boolean isVendorHSQL()

Returns true if Hibernate is connecting to a Hypersonic database.

Returns:

true if Hibernate is connecting to a Hypersonic database

isVendorInformix

public boolean isVendorInformix()

Returns true if Hibernate is connecting to an Informix database.

Returns:

true if Hibernate is connecting to an Informix database

isVendorMySQL

public boolean isVendorMySQL()

Returns true if Hibernate is connecting to a MySQL database.

Returns:

true if Hibernate is connecting to a MySQL database

isVendorOracle

public boolean isVendorOracle()

Returns true if Hibernate is connecting to an Oracle database. Oracle has a nasty bug where it treats '' as a NULL value. See http://thedailywtf.com/forums/thread/26879.aspx for more information on this nasty bug.

Returns:

true if Hibernate is connecting to an Oracle database

isVendorPostgreSQL

public boolean isVendorPostgreSQL()

Returns true if Hibernate is connecting to a PostgreSQL database.

Returns:

true if Hibernate is connecting to a PostgreSQL database

isVendorSybase

public boolean isVendorSybase()

Returns true if Hibernate is connecting to a Sybase database.

Returns:

true if Hibernate is connecting to a Sybase database

keywords

public String[] keywords(String keywords)

keywords

public String[] keywords(String keywords,
                         boolean lowerCase)

keywords

public String[] keywords(String keywords,
                         boolean lowerCase,
                         com.liferay.portal.kernel.dao.orm.WildcardMode wildcardMode)

keywords

public String[] keywords(String keywords,
                         com.liferay.portal.kernel.dao.orm.WildcardMode wildcardMode)

keywords

public String[] keywords(String[] keywordsArray)

keywords

public String[] keywords(String[] keywordsArray,
                         boolean lowerCase)

reloadCustomSQL

public void reloadCustomSQL()
                     throws SQLException

Throws:

SQLException

removeGroupBy

public String removeGroupBy(String sql)

removeOrderBy

public String removeOrderBy(String sql)

replaceAndOperator

public String replaceAndOperator(String sql,
                                 boolean andOperator)

replaceGroupBy

public String replaceGroupBy(String sql,
                             String groupBy)

replaceIsNull

public String replaceIsNull(String sql)

replaceKeywords

public String replaceKeywords(String sql,
                              String field,
                              boolean last,
                              int[] values)

replaceKeywords

public String replaceKeywords(String sql,
                              String field,
                              boolean last,
                              long[] values)

replaceKeywords

public String replaceKeywords(String sql,
                              String field,
                              String operator,
                              boolean last,
                              String[] values)

replaceOrderBy

public String replaceOrderBy(String sql,
                             com.liferay.portal.kernel.util.OrderByComparator<?> orderByComparator)

getConfigs

protected String[] getConfigs()

insertWildcard

protected String insertWildcard(String keyword,
                                com.liferay.portal.kernel.dao.orm.WildcardMode wildcardMode)

transform

protected String transform(String sql)