public class CustomSQL
extends java.lang.Object
com.liferay.util.dao.orm.CustomSQL
Modifier and Type | Field and Description |
---|---|
static java.lang.String |
DB2_FUNCTION_IS_NOT_NULL |
static java.lang.String |
DB2_FUNCTION_IS_NULL |
static java.lang.String |
INFORMIX_FUNCTION_IS_NOT_NULL |
static java.lang.String |
INFORMIX_FUNCTION_IS_NULL |
static java.lang.String |
MYSQL_FUNCTION_IS_NOT_NULL |
static java.lang.String |
MYSQL_FUNCTION_IS_NULL |
static java.lang.String |
SYBASE_FUNCTION_IS_NOT_NULL |
static java.lang.String |
SYBASE_FUNCTION_IS_NULL |
Constructor and Description |
---|
CustomSQL() |
CustomSQL(java.lang.Class<?> clazz) |
Modifier and Type | Method and Description |
---|---|
java.lang.String |
appendCriteria(java.lang.String sql,
java.lang.String criteria) |
java.lang.String |
get(java.lang.Class<?> clazz,
java.lang.String id) |
java.lang.String |
get(java.lang.Class<?> clazz,
java.lang.String id,
com.liferay.portal.kernel.dao.orm.QueryDefinition<?> queryDefinition) |
java.lang.String |
get(java.lang.Class<?> clazz,
java.lang.String id,
com.liferay.portal.kernel.dao.orm.QueryDefinition<?> queryDefinition,
java.lang.String tableName) |
java.lang.String |
get(java.lang.String id) |
protected java.lang.String[] |
getConfigs() |
protected java.lang.String |
insertWildcard(java.lang.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. |
java.lang.String[] |
keywords(java.lang.String keywords) |
java.lang.String[] |
keywords(java.lang.String[] keywordsArray) |
java.lang.String[] |
keywords(java.lang.String[] keywordsArray,
boolean lowerCase) |
java.lang.String[] |
keywords(java.lang.String keywords,
boolean lowerCase) |
java.lang.String[] |
keywords(java.lang.String keywords,
boolean lowerCase,
com.liferay.portal.kernel.dao.orm.WildcardMode wildcardMode) |
java.lang.String[] |
keywords(java.lang.String keywords,
com.liferay.portal.kernel.dao.orm.WildcardMode wildcardMode) |
protected void |
read(org.osgi.framework.BundleContext bundleContext,
java.lang.ClassLoader classLoader,
java.lang.String source) |
void |
reloadCustomSQL(java.lang.Class<?> clazz) |
java.lang.String |
removeGroupBy(java.lang.String sql) |
java.lang.String |
removeOrderBy(java.lang.String sql) |
java.lang.String |
replaceAndOperator(java.lang.String sql,
boolean andOperator) |
java.lang.String |
replaceGroupBy(java.lang.String sql,
java.lang.String groupBy) |
java.lang.String |
replaceIsNull(java.lang.String sql) |
java.lang.String |
replaceKeywords(java.lang.String sql,
java.lang.String field,
boolean last,
int[] values) |
java.lang.String |
replaceKeywords(java.lang.String sql,
java.lang.String field,
boolean last,
long[] values) |
java.lang.String |
replaceKeywords(java.lang.String sql,
java.lang.String field,
java.lang.String operator,
boolean last,
java.lang.String[] values) |
java.lang.String |
replaceOrderBy(java.lang.String sql,
com.liferay.portal.kernel.util.OrderByComparator<?> obc) |
protected java.lang.String |
transform(java.lang.String sql) |
public static final java.lang.String DB2_FUNCTION_IS_NOT_NULL
public static final java.lang.String DB2_FUNCTION_IS_NULL
public static final java.lang.String INFORMIX_FUNCTION_IS_NOT_NULL
public static final java.lang.String INFORMIX_FUNCTION_IS_NULL
public static final java.lang.String MYSQL_FUNCTION_IS_NOT_NULL
public static final java.lang.String MYSQL_FUNCTION_IS_NULL
public static final java.lang.String SYBASE_FUNCTION_IS_NOT_NULL
public static final java.lang.String SYBASE_FUNCTION_IS_NULL
public CustomSQL() throws java.sql.SQLException
java.sql.SQLException
public CustomSQL(java.lang.Class<?> clazz) throws java.sql.SQLException
java.sql.SQLException
public java.lang.String appendCriteria(java.lang.String sql, java.lang.String criteria)
public java.lang.String get(java.lang.Class<?> clazz, java.lang.String id)
public java.lang.String get(java.lang.Class<?> clazz, java.lang.String id, com.liferay.portal.kernel.dao.orm.QueryDefinition<?> queryDefinition)
public java.lang.String get(java.lang.Class<?> clazz, java.lang.String id, com.liferay.portal.kernel.dao.orm.QueryDefinition<?> queryDefinition, java.lang.String tableName)
public java.lang.String get(java.lang.String id)
public boolean isVendorDB2()
true
if Hibernate is connecting to a DB2 database.true
if Hibernate is connecting to a DB2 databasepublic boolean isVendorHSQL()
true
if Hibernate is connecting to a Hypersonic
database.true
if Hibernate is connecting to a Hypersonic
databasepublic boolean isVendorInformix()
true
if Hibernate is connecting to an Informix
database.true
if Hibernate is connecting to an Informix
databasepublic boolean isVendorMySQL()
true
if Hibernate is connecting to a MySQL database.true
if Hibernate is connecting to a MySQL databasepublic boolean isVendorOracle()
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.true
if Hibernate is connecting to an Oracle
databasepublic boolean isVendorPostgreSQL()
true
if Hibernate is connecting to a PostgreSQL
database.true
if Hibernate is connecting to a PostgreSQL
databasepublic boolean isVendorSybase()
true
if Hibernate is connecting to a Sybase
database.true
if Hibernate is connecting to a Sybase databasepublic java.lang.String[] keywords(java.lang.String keywords)
public java.lang.String[] keywords(java.lang.String keywords, boolean lowerCase)
public java.lang.String[] keywords(java.lang.String keywords, boolean lowerCase, com.liferay.portal.kernel.dao.orm.WildcardMode wildcardMode)
public java.lang.String[] keywords(java.lang.String keywords, com.liferay.portal.kernel.dao.orm.WildcardMode wildcardMode)
public java.lang.String[] keywords(java.lang.String[] keywordsArray)
public java.lang.String[] keywords(java.lang.String[] keywordsArray, boolean lowerCase)
public void reloadCustomSQL(java.lang.Class<?> clazz) throws java.sql.SQLException
java.sql.SQLException
public java.lang.String removeGroupBy(java.lang.String sql)
public java.lang.String removeOrderBy(java.lang.String sql)
public java.lang.String replaceAndOperator(java.lang.String sql, boolean andOperator)
public java.lang.String replaceGroupBy(java.lang.String sql, java.lang.String groupBy)
public java.lang.String replaceIsNull(java.lang.String sql)
public java.lang.String replaceKeywords(java.lang.String sql, java.lang.String field, boolean last, int[] values)
public java.lang.String replaceKeywords(java.lang.String sql, java.lang.String field, boolean last, long[] values)
public java.lang.String replaceKeywords(java.lang.String sql, java.lang.String field, java.lang.String operator, boolean last, java.lang.String[] values)
public java.lang.String replaceOrderBy(java.lang.String sql, com.liferay.portal.kernel.util.OrderByComparator<?> obc)
protected java.lang.String[] getConfigs()
protected java.lang.String insertWildcard(java.lang.String keyword, com.liferay.portal.kernel.dao.orm.WildcardMode wildcardMode)
protected void read(org.osgi.framework.BundleContext bundleContext, java.lang.ClassLoader classLoader, java.lang.String source) throws java.lang.Exception
java.lang.Exception
protected java.lang.String transform(java.lang.String sql)