001
014
015 package com.liferay.util.dao.orm;
016
017 import com.liferay.portal.kernel.dao.orm.QueryDefinition;
018 import com.liferay.portal.kernel.dao.orm.WildcardMode;
019 import com.liferay.portal.kernel.log.Log;
020 import com.liferay.portal.kernel.log.LogFactoryUtil;
021 import com.liferay.portal.kernel.util.OrderByComparator;
022
023 import java.sql.SQLException;
024
025
030 public class CustomSQLUtil {
031
032 public static String appendCriteria(String sql, String criteria) {
033 return _instance._customSQL.appendCriteria(sql, criteria);
034 }
035
036 public static String get(String id) {
037 return _instance._customSQL.get(id);
038 }
039
040 public static String get(String id, QueryDefinition<?> queryDefinition) {
041 return _instance._customSQL.get(id, queryDefinition);
042 }
043
044 public static String get(
045 String id, QueryDefinition<?> queryDefinition, String tableName) {
046
047 return _instance._customSQL.get(id, queryDefinition, tableName);
048 }
049
050 public static boolean isVendorDB2() {
051 return _instance._customSQL.isVendorDB2();
052 }
053
054 public static boolean isVendorHSQL() {
055 return _instance._customSQL.isVendorHSQL();
056 }
057
058 public static boolean isVendorInformix() {
059 return _instance._customSQL.isVendorInformix();
060 }
061
062 public static boolean isVendorMySQL() {
063 return _instance._customSQL.isVendorMySQL();
064 }
065
066 public static boolean isVendorOracle() {
067 return _instance._customSQL.isVendorOracle();
068 }
069
070 public static boolean isVendorSybase() {
071 return _instance._customSQL.isVendorSybase();
072 }
073
074 public static String[] keywords(String keywords) {
075 return _instance._customSQL.keywords(keywords);
076 }
077
078 public static String[] keywords(String keywords, boolean lowerCase) {
079 return _instance._customSQL.keywords(keywords, lowerCase);
080 }
081
082 public static String[] keywords(
083 String keywords, boolean lowerCase, WildcardMode wildcardMode) {
084
085 return _instance._customSQL.keywords(keywords, lowerCase, wildcardMode);
086 }
087
088 public static String[] keywords(
089 String keywords, WildcardMode wildcardMode) {
090
091 return _instance._customSQL.keywords(keywords, wildcardMode);
092 }
093
094 public static String[] keywords(String[] keywordsArray) {
095 return _instance._customSQL.keywords(keywordsArray);
096 }
097
098 public static String[] keywords(String[] keywordsArray, boolean lowerCase) {
099 return _instance._customSQL.keywords(keywordsArray, lowerCase);
100 }
101
102 public static void reloadCustomSQL() throws SQLException {
103 _instance._customSQL.reloadCustomSQL();
104 }
105
106 public static String removeGroupBy(String sql) {
107 return _instance._customSQL.removeGroupBy(sql);
108 }
109
110 public static String removeOrderBy(String sql) {
111 return _instance._customSQL.removeOrderBy(sql);
112 }
113
114 public static String replaceAndOperator(String sql, boolean andOperator) {
115 return _instance._customSQL.replaceAndOperator(sql, andOperator);
116 }
117
118 public static String replaceGroupBy(String sql, String groupBy) {
119 return _instance._customSQL.replaceGroupBy(sql, groupBy);
120 }
121
122 public static String replaceIsNull(String sql) {
123 return _instance._customSQL.replaceIsNull(sql);
124 }
125
126 public static String replaceKeywords(
127 String sql, String field, boolean last, int[] values) {
128
129 return _instance._customSQL.replaceKeywords(sql, field, last, values);
130 }
131
132 public static String replaceKeywords(
133 String sql, String field, boolean last, long[] values) {
134
135 return _instance._customSQL.replaceKeywords(sql, field, last, values);
136 }
137
138 public static String replaceKeywords(
139 String sql, String field, String operator, boolean last,
140 String[] values) {
141
142 return _instance._customSQL.replaceKeywords(
143 sql, field, operator, last, values);
144 }
145
146 public static String replaceOrderBy(String sql, OrderByComparator<?> obc) {
147 return _instance._customSQL.replaceOrderBy(sql, obc);
148 }
149
150 private CustomSQLUtil() {
151 CustomSQL customSQL = null;
152
153 try {
154 customSQL = new CustomSQL();
155 }
156 catch (Exception e) {
157 _log.error(e, e);
158 }
159
160 _customSQL = customSQL;
161 }
162
163 private static final Log _log = LogFactoryUtil.getLog(CustomSQLUtil.class);
164
165 private static final CustomSQLUtil _instance = new CustomSQLUtil();
166
167 private final CustomSQL _customSQL;
168
169 }