com.liferay.util.dao.orm

Class CustomSQLUtil

Object

com.liferay.util.dao.orm.CustomSQLUtil

public class CustomSQLUtil
extends Object

Author:

Brian Wing Shun Chan, Bruno Farache, Raymond Augé

See Also:

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

Method Summary

Modifier and Type	Method and Description
static String	appendCriteria(String sql, String criteria)
static String	get(String id)
static String	get(String id, com.liferay.portal.kernel.dao.orm.QueryDefinition<?> queryDefinition)
static String	get(String id, com.liferay.portal.kernel.dao.orm.QueryDefinition<?> queryDefinition, String tableName)
static boolean	isVendorDB2()
static boolean	isVendorHSQL()
static boolean	isVendorInformix()
static boolean	isVendorMySQL()
static boolean	isVendorOracle()
static boolean	isVendorSybase()
static String[]	keywords(String keywords)
static String[]	keywords(String[] keywordsArray)
static String[]	keywords(String[] keywordsArray, boolean lowerCase)
static String[]	keywords(String keywords, boolean lowerCase)
static String[]	keywords(String keywords, boolean lowerCase, com.liferay.portal.kernel.dao.orm.WildcardMode wildcardMode)
static String[]	keywords(String keywords, com.liferay.portal.kernel.dao.orm.WildcardMode wildcardMode)
static void	reloadCustomSQL()
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<?> obc)

Methods inherited from class Object

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

Method Detail

appendCriteria

public static String appendCriteria(String sql,
                                    String criteria)

get

public static String get(String id)

get

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

get

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

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()

isVendorSybase

public static boolean isVendorSybase()

keywords

public static String[] keywords(String keywords)

keywords

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

keywords

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

keywords

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

keywords

public static String[] keywords(String[] keywordsArray)

keywords

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

reloadCustomSQL

public static void reloadCustomSQL()
                            throws SQLException

Throws:

SQLException

removeGroupBy

public static String removeGroupBy(String sql)

removeOrderBy

public static String removeOrderBy(String sql)

replaceAndOperator

public static String replaceAndOperator(String sql,
                                        boolean andOperator)

replaceGroupBy

public static String replaceGroupBy(String sql,
                                    String groupBy)

replaceIsNull

public static String replaceIsNull(String sql)

replaceKeywords

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

replaceKeywords

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

replaceKeywords

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

replaceOrderBy

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