com.liferay.util.dao.orm
Class CustomSQLUtil

java.lang.Object
  extended by com.liferay.util.dao.orm.CustomSQLUtil

public class CustomSQLUtil
extends java.lang.Object

View Source

Author:
Brian Wing Shun Chan, Bruno Farache

Method Summary
static java.lang.String get(java.lang.String id)
           
static boolean isVendorDB2()
           
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 removeOrderBy(java.lang.String sql)
           
static java.lang.String replaceAndOperator(java.lang.String sql, boolean andOperator)
           
static java.lang.String replaceIsNull(java.lang.String sql)
           
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)
           
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Method Detail

get

public static java.lang.String get(java.lang.String id)

isVendorDB2

public static boolean isVendorDB2()

isVendorInformix

public static boolean isVendorInformix()

isVendorMySQL

public static boolean isVendorMySQL()

isVendorOracle

public static boolean isVendorOracle()

isVendorSybase

public static boolean isVendorSybase()

keywords

public static java.lang.String[] keywords(java.lang.String keywords)

keywords

public static java.lang.String[] keywords(java.lang.String keywords,
                                          boolean lowerCase)

keywords

public static java.lang.String[] keywords(java.lang.String[] keywordsArray)

keywords

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

replaceAndOperator

public static java.lang.String replaceAndOperator(java.lang.String sql,
                                                  boolean andOperator)

replaceIsNull

public static java.lang.String replaceIsNull(java.lang.String sql)

replaceKeywords

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

removeOrderBy

public static java.lang.String removeOrderBy(java.lang.String sql)

replaceOrderBy

public static java.lang.String replaceOrderBy(java.lang.String sql,
                                              com.liferay.portal.kernel.util.OrderByComparator obc)