public class CustomSQLUtil
extends java.lang.Object
com.liferay.util.dao.orm.CustomSQLUtil
Modifier and Type | Method and Description |
---|---|
static java.lang.String |
appendCriteria(java.lang.String sql,
java.lang.String criteria) |
static java.lang.String |
get(java.lang.Class<?> clazz,
java.lang.String id) |
static java.lang.String |
get(java.lang.Class<?> clazz,
java.lang.String id,
com.liferay.portal.kernel.dao.orm.QueryDefinition<?> queryDefinition) |
static java.lang.String |
get(java.lang.Class<?> clazz,
java.lang.String id,
com.liferay.portal.kernel.dao.orm.QueryDefinition<?> queryDefinition,
java.lang.String tableName) |
static boolean |
isVendorDB2() |
static boolean |
isVendorHSQL() |
static boolean |
isVendorInformix() |
static boolean |
isVendorMySQL() |
static boolean |
isVendorOracle() |
static boolean |
isVendorSybase() |
static java.lang.String[] |
keywords(java.lang.String keywords) |
static java.lang.String[] |
keywords(java.lang.String[] keywordsArray) |
static java.lang.String[] |
keywords(java.lang.String[] keywordsArray,
boolean lowerCase) |
static java.lang.String[] |
keywords(java.lang.String keywords,
boolean lowerCase) |
static java.lang.String[] |
keywords(java.lang.String keywords,
boolean lowerCase,
com.liferay.portal.kernel.dao.orm.WildcardMode wildcardMode) |
static java.lang.String[] |
keywords(java.lang.String keywords,
com.liferay.portal.kernel.dao.orm.WildcardMode wildcardMode) |
static void |
reloadCustomSQL(java.lang.Class<?> clazz)
Deprecated.
As of 1.0.0, with no direct replacement
|
static java.lang.String |
removeGroupBy(java.lang.String sql) |
static java.lang.String |
removeOrderBy(java.lang.String sql) |
static java.lang.String |
replaceAndOperator(java.lang.String sql,
boolean andOperator) |
static java.lang.String |
replaceGroupBy(java.lang.String sql,
java.lang.String groupBy) |
static java.lang.String |
replaceIsNull(java.lang.String sql) |
static java.lang.String |
replaceKeywords(java.lang.String sql,
java.lang.String field,
boolean last,
int[] values) |
static java.lang.String |
replaceKeywords(java.lang.String sql,
java.lang.String field,
boolean last,
long[] values) |
static java.lang.String |
replaceKeywords(java.lang.String sql,
java.lang.String field,
java.lang.String operator,
boolean last,
java.lang.String[] values) |
static java.lang.String |
replaceOrderBy(java.lang.String sql,
com.liferay.portal.kernel.util.OrderByComparator<?> obc) |
public static java.lang.String appendCriteria(java.lang.String sql, java.lang.String criteria)
public static java.lang.String get(java.lang.Class<?> clazz, java.lang.String id)
public static java.lang.String get(java.lang.Class<?> clazz, java.lang.String id, com.liferay.portal.kernel.dao.orm.QueryDefinition<?> queryDefinition)
public static 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 static boolean isVendorDB2()
public static boolean isVendorHSQL()
public static boolean isVendorInformix()
public static boolean isVendorMySQL()
public static boolean isVendorOracle()
public static boolean isVendorSybase()
public static java.lang.String[] keywords(java.lang.String keywords)
public static java.lang.String[] keywords(java.lang.String keywords, boolean lowerCase)
public static java.lang.String[] keywords(java.lang.String keywords, boolean lowerCase, com.liferay.portal.kernel.dao.orm.WildcardMode wildcardMode)
public static java.lang.String[] keywords(java.lang.String keywords, com.liferay.portal.kernel.dao.orm.WildcardMode wildcardMode)
public static java.lang.String[] keywords(java.lang.String[] keywordsArray)
public static java.lang.String[] keywords(java.lang.String[] keywordsArray, boolean lowerCase)
@Deprecated public static void reloadCustomSQL(java.lang.Class<?> clazz) throws java.sql.SQLException
java.sql.SQLException
public static java.lang.String removeGroupBy(java.lang.String sql)
public static java.lang.String removeOrderBy(java.lang.String sql)
public static java.lang.String replaceAndOperator(java.lang.String sql, boolean andOperator)
public static java.lang.String replaceGroupBy(java.lang.String sql, java.lang.String groupBy)
public static java.lang.String replaceIsNull(java.lang.String sql)
public static java.lang.String replaceKeywords(java.lang.String sql, java.lang.String field, boolean last, int[] values)
public static java.lang.String replaceKeywords(java.lang.String sql, java.lang.String field, boolean last, long[] values)
public static java.lang.String replaceKeywords(java.lang.String sql, java.lang.String field, java.lang.String operator, boolean last, java.lang.String[] values)
public static java.lang.String replaceOrderBy(java.lang.String sql, com.liferay.portal.kernel.util.OrderByComparator<?> obc)