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 Details

    • 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()
    • 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<?> orderByComparator)