Package com.liferay.util.dao.orm
Class CustomSQLUtil
Object
com.liferay.util.dao.orm.CustomSQLUtil
- Author:
- Brian Wing Shun Chan, Bruno Farache, Raymond Augé
- See Also:
-
com.liferay.portal.dao.orm.custom.sql.CustomSQLUtil
-
Method Summary
Modifier and TypeMethodDescriptionstatic String
appendCriteria
(String sql, String criteria) static String
static String
static String
get
(String id, com.liferay.portal.kernel.dao.orm.QueryDefinition<?> queryDefinition, String tableName) static boolean
static boolean
static boolean
static boolean
static boolean
static String[]
static String[]
static String[]
static String[]
static String[]
keywords
(String keywords, boolean lowerCase, com.liferay.portal.kernel.dao.orm.WildcardMode wildcardMode) static String[]
static void
static String
removeGroupBy
(String sql) static String
removeOrderBy
(String sql) static String
replaceAndOperator
(String sql, boolean andOperator) static String
replaceGroupBy
(String sql, String groupBy) static String
replaceIsNull
(String sql) static String
replaceKeywords
(String sql, String field, boolean last, int[] values) static String
replaceKeywords
(String sql, String field, boolean last, long[] values) static String
replaceKeywords
(String sql, String field, String operator, boolean last, String[] values) static String
replaceOrderBy
(String sql, com.liferay.portal.kernel.util.OrderByComparator<?> orderByComparator)
-
Method Details
-
appendCriteria
-
get
-
get
-
get
-
isVendorDB2
public static boolean isVendorDB2() -
isVendorHSQL
public static boolean isVendorHSQL() -
isVendorInformix
public static boolean isVendorInformix() -
isVendorMySQL
public static boolean isVendorMySQL() -
isVendorOracle
public static boolean isVendorOracle() -
keywords
-
keywords
-
keywords
-
keywords
-
keywords
-
keywords
-
reloadCustomSQL
- Throws:
SQLException
-
removeGroupBy
-
removeOrderBy
-
replaceAndOperator
-
replaceGroupBy
-
replaceIsNull
-
replaceKeywords
-
replaceKeywords
-
replaceKeywords
-
replaceOrderBy
-