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

Author:
Brian Wing Shun Chan, Bruno Farache, Raymond Augé

Method Summary
static java.lang.String appendCriteria(java.lang.String sql, java.lang.String criteria)
           
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 void reloadCustomSQL()
           
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)
           
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Method Detail

appendCriteria

public static java.lang.String appendCriteria(java.lang.String sql,
                                              java.lang.String criteria)

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)

reloadCustomSQL

public static void reloadCustomSQL()
                            throws java.sql.SQLException
Throws:
java.sql.SQLException

removeGroupBy

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

removeOrderBy

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

replaceAndOperator

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

replaceGroupBy

public static java.lang.String replaceGroupBy(java.lang.String sql,
                                              java.lang.String groupBy)

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,
                                               boolean last,
                                               int[] values)

replaceKeywords

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

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)

replaceOrderBy

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