svn-gvsig-desktop / trunk / org.gvsig.desktop / org.gvsig.desktop.library / org.gvsig.expressionevaluator / org.gvsig.expressionevaluator.lib / org.gvsig.expressionevaluator.lib.api / src / main / java / org / gvsig / expressionevaluator / ExpressionBuilder.java @ 44369
History | View | Annotate | Download (19.1 KB)
1 | 44006 | jjdelcerro | package org.gvsig.expressionevaluator; |
---|---|---|---|
2 | 43020 | jjdelcerro | |
3 | import java.util.List; |
||
4 | 44198 | jjdelcerro | import java.util.Map; |
5 | 43020 | jjdelcerro | import org.cresques.cts.IProjection; |
6 | import org.gvsig.fmap.geom.Geometry; |
||
7 | 43034 | jjdelcerro | import org.gvsig.fmap.geom.primitive.Envelope; |
8 | 44198 | jjdelcerro | import org.gvsig.tools.util.PropertiesSupport; |
9 | import org.gvsig.tools.util.PropertiesSupportHelper; |
||
10 | 43020 | jjdelcerro | |
11 | public interface ExpressionBuilder { |
||
12 | |||
13 | 44198 | jjdelcerro | public static final String OPERATOR_NOT = "NOT"; |
14 | 44207 | jjdelcerro | public static final String OPERATOR_NEGATE = "NEGATE"; |
15 | 44198 | jjdelcerro | public static final String OPERATOR_IS = "IS"; |
16 | public static final String OPERATOR_AND = "AND"; |
||
17 | public static final String OPERATOR_OR = "OR"; |
||
18 | 44207 | jjdelcerro | public static final String OPERATOR_EQ = "="; |
19 | public static final String OPERATOR_NE = "<>"; |
||
20 | public static final String OPERATOR_GT = ">"; |
||
21 | public static final String OPERATOR_GE = ">="; |
||
22 | public static final String OPERATOR_LT = "<"; |
||
23 | public static final String OPERATOR_LE = "<="; |
||
24 | 44198 | jjdelcerro | public static final String OPERATOR_LIKE = "LIKE"; |
25 | public static final String OPERATOR_ILIKE = "ILIKE"; |
||
26 | 44207 | jjdelcerro | public static final String OPERATOR_ADD = "+"; |
27 | public static final String OPERATOR_SUBST = "-"; |
||
28 | public static final String OPERATOR_MULT = "*"; |
||
29 | public static final String OPERATOR_DIV = "/"; |
||
30 | public static final String OPERATOR_MOD = "%"; |
||
31 | public static final String OPERATOR_CONCAT = "||"; |
||
32 | public static final String OPERATOR_REGEXP = "~"; |
||
33 | public static final String OPERATOR_AND2 = "&&"; |
||
34 | 44198 | jjdelcerro | |
35 | public static final String FUNCTION_ST_SRID = "ST_SRID"; |
||
36 | public static final String FUNCTION_ST_ASTEXT = "ST_AsText"; |
||
37 | public static final String FUNCTION_ST_ASBINARY = "ST_AsBinary"; |
||
38 | public static final String FUNCTION_ST_ASEWKB = "ST_AsEWKB"; |
||
39 | public static final String FUNCTION_ST_ENVELOPE = "ST_Envelope"; |
||
40 | public static final String FUNCTION_ST_GEOMFROMTEXT = "ST_GeomFromText"; |
||
41 | public static final String FUNCTION_ST_GEOMFROMWKB = "ST_GeomFromWKB"; |
||
42 | public static final String FUNCTION_ST_GEOMFROMEWKB = "ST_GeomFromEWKB"; |
||
43 | public static final String FUNCTION_ST_SIMPLIFY = "ST_Simplify"; |
||
44 | public static final String FUNCTION_ST_EQUALS = "ST_Equals"; |
||
45 | public static final String FUNCTION_ST_INTERSECTS = "ST_Intersects"; |
||
46 | public static final String FUNCTION_ST_CONTAINS = "ST_Contains"; |
||
47 | public static final String FUNCTION_ST_DISJOINT = "ST_Disjoint"; |
||
48 | public static final String FUNCTION_ST_CROSSES = "ST_Crosses"; |
||
49 | public static final String FUNCTION_ST_ISCLOSED = "ST_IsClosed"; |
||
50 | public static final String FUNCTION_ST_OVERLAPS = "ST_Overlaps"; |
||
51 | public static final String FUNCTION_ST_TOUCHES = "ST_Touches"; |
||
52 | public static final String FUNCTION_ST_WITHIN = "ST_Within"; |
||
53 | 44253 | jjdelcerro | public static final String FUNCTION_ST_SETSRID = "ST_SetSRID"; |
54 | public static final String FUNCTION_ST_POINT = "ST_Point"; |
||
55 | 44198 | jjdelcerro | public static final String FUNCTION_ST_UNIONAGGREGATE = "ST_UnionAggregate"; |
56 | public static final String FUNCTION_ST_EXTENTAGGREGATE = "ST_ExtentAggregate"; |
||
57 | |||
58 | public static final String FUNCTION_IIF = "IIF"; |
||
59 | public static final String FUNCTION_IFNULL = "IFNULL"; |
||
60 | |||
61 | public static final String FUNCTION_LEFT = "LEFT"; |
||
62 | public static final String FUNCTION_RIGHT = "RIGHT"; |
||
63 | public static final String FUNCTION_LOCATE = "LOCATE"; |
||
64 | public static final String FUNCTION_POSITION = "POSITION"; |
||
65 | public static final String FUNCTION_LPAD = "LPAD"; |
||
66 | public static final String FUNCTION_RPAD = "RPAD"; |
||
67 | public static final String FUNCTION_LTRIM = "LTRIM"; |
||
68 | public static final String FUNCTION_RTRIM = "RTRIM"; |
||
69 | public static final String FUNCTION_TRIM = "TRIM"; |
||
70 | public static final String FUNCTION_REPEAT = "REPEAT"; |
||
71 | public static final String FUNCTION_REPLACE = "REPLACE"; |
||
72 | public static final String FUNCTION_ASCII = "ASCII"; |
||
73 | public static final String FUNCTION_LENGHT = "LENGHT"; |
||
74 | public static final String FUNCTION_INSTR = "INSTR"; |
||
75 | public static final String FUNCTION_LOWER = "LOWER"; |
||
76 | public static final String FUNCTION_UPPER = "UPPER"; |
||
77 | public static final String FUNCTION_SPACE = "SPACE"; |
||
78 | public static final String FUNCTION_SUBSTRING = "SUBSTRING"; |
||
79 | public static final String FUNCTION_ACOS = "ACOS"; |
||
80 | public static final String FUNCTION_ASIN = "ASIN"; |
||
81 | public static final String FUNCTION_ATAN = "ATAN"; |
||
82 | public static final String FUNCTION_COS = "COS"; |
||
83 | public static final String FUNCTION_COSH = "COSH"; |
||
84 | public static final String FUNCTION_COT = "COT"; |
||
85 | public static final String FUNCTION_BITAND = "BITAND"; |
||
86 | public static final String FUNCTION_BITOR = "BITOR"; |
||
87 | public static final String FUNCTION_BITXOR = "BITXOR"; |
||
88 | public static final String FUNCTION_CEIL = "CEIL"; |
||
89 | public static final String FUNCTION_DEGREES = "DEGREES"; |
||
90 | public static final String FUNCTION_EXP = "EXP"; |
||
91 | public static final String FUNCTION_FLOOR = "FLOOR"; |
||
92 | public static final String FUNCTION_LOG = "LOG"; |
||
93 | public static final String FUNCTION_LOG10 = "LOG10"; |
||
94 | public static final String FUNCTION_PI = "PI"; |
||
95 | public static final String FUNCTION_POWER = "POWER"; |
||
96 | public static final String FUNCTION_RADIANS = "RADIANS"; |
||
97 | public static final String FUNCTION_RAND = "RAND"; |
||
98 | public static final String FUNCTION_ROUND = "ROUND"; |
||
99 | public static final String FUNCTION_SQRT = "SQRT"; |
||
100 | public static final String FUNCTION_SIGN = "SIGN"; |
||
101 | public static final String FUNCTION_SIN = "SIN"; |
||
102 | public static final String FUNCTION_SINH = "SINH"; |
||
103 | public static final String FUNCTION_TAN = "TAN"; |
||
104 | public static final String FUNCTION_TANH = "TANH"; |
||
105 | public static final String FUNCTION_ZERO = "ZERO"; |
||
106 | public static final String FUNCTION_CHR = "CHR"; |
||
107 | public static final String FUNCTION_DATE = "DATE"; |
||
108 | 44266 | jjdelcerro | public static final String FUNCTION_DATEDIFF = "DATEDIFF"; |
109 | public static final String FUNCTION_DATEADD = "DATEADD"; |
||
110 | 44198 | jjdelcerro | public static final String FUNCTION_NOW = "NOW"; |
111 | public static final String FUNCTION_TIME = "TIME"; |
||
112 | public static final String FUNCTION_TIMESTAMP = "TIMESTAMP"; |
||
113 | |||
114 | public static final String FUNCTION_CAST = "CAST"; |
||
115 | public static final String FUNCTION_DECODE = "DECODE"; |
||
116 | public static final String FUNCTION_TODOUBLE = "TODOUBLE"; |
||
117 | public static final String FUNCTION_TOFLOAT = "TOFLOAT"; |
||
118 | public static final String FUNCTION_TOINTEGER = "TOINTEGER"; |
||
119 | public static final String FUNCTION_TOLONG = "TOLONG"; |
||
120 | public static final String FUNCTION_TOSTR = "TOSTR"; |
||
121 | |||
122 | 44206 | jjdelcerro | public static final String FUNCTION_INCR = "INCR"; |
123 | public static final String FUNCTION_DECR = "DECR"; |
||
124 | |||
125 | 44207 | jjdelcerro | public static final String FUNCTION_RANGE = "RANGE"; |
126 | 44269 | omartinez | public static final String FUNCTION_EVAL = "EVAL"; |
127 | 44262 | jjdelcerro | public static final String FUNCTION_LIST = "LIST"; |
128 | 44207 | jjdelcerro | |
129 | 43020 | jjdelcerro | public enum GeometrySupportType { |
130 | WKT, |
||
131 | WKB, |
||
132 | 43358 | jjdelcerro | EWKB, |
133 | NATIVE |
||
134 | 43020 | jjdelcerro | } |
135 | |||
136 | public enum ParameterType { |
||
137 | Variable, |
||
138 | Constant, |
||
139 | Geometry |
||
140 | } |
||
141 | 44198 | jjdelcerro | |
142 | 43020 | jjdelcerro | public interface VisitorFilter { |
143 | boolean accept(Visitable visitable);
|
||
144 | } |
||
145 | |||
146 | public interface Visitor { |
||
147 | public void visit(Visitable value); |
||
148 | } |
||
149 | |||
150 | public interface Visitable { |
||
151 | public void accept(Visitor visitor, VisitorFilter filter); |
||
152 | } |
||
153 | |||
154 | 44198 | jjdelcerro | public interface Value extends Visitable, PropertiesSupport { |
155 | public String toString(Formatter<Value> formatter); |
||
156 | 43020 | jjdelcerro | } |
157 | |||
158 | public interface Group extends Value { |
||
159 | 44198 | jjdelcerro | public Value value();
|
160 | 43020 | jjdelcerro | } |
161 | |||
162 | public interface Constant extends Value { |
||
163 | 44198 | jjdelcerro | public Object value(); |
164 | 43020 | jjdelcerro | } |
165 | |||
166 | public interface Custom extends Value { |
||
167 | 44198 | jjdelcerro | public Object value(); |
168 | 43020 | jjdelcerro | public Custom add(Variable variable);
|
169 | public Custom add(Parameter parameter);
|
||
170 | } |
||
171 | |||
172 | public interface Variable extends Value, Comparable<Variable> { |
||
173 | 44198 | jjdelcerro | public String name(); |
174 | 43020 | jjdelcerro | } |
175 | |||
176 | public interface Parameter extends Value { |
||
177 | public Parameter as_constant();
|
||
178 | public Parameter as_variable();
|
||
179 | 43093 | jjdelcerro | public Parameter as_geometry_variable();
|
180 | 43020 | jjdelcerro | public Parameter srs(Value srs);
|
181 | public Parameter srs(IProjection srs);
|
||
182 | 43093 | jjdelcerro | public Parameter value(Object value); |
183 | public Parameter name(String value); |
||
184 | 44198 | jjdelcerro | public String name(); |
185 | public Object value(); |
||
186 | public ParameterType type();
|
||
187 | public Value srs();
|
||
188 | 43020 | jjdelcerro | public boolean is_constant(); |
189 | public boolean is_variable(); |
||
190 | public boolean is_geometry_variable(); |
||
191 | } |
||
192 | 43093 | jjdelcerro | |
193 | 44198 | jjdelcerro | public interface Function extends Value { |
194 | public String name(); |
||
195 | public List<Value> parameters(); |
||
196 | public Function parameter(Value parameter);
|
||
197 | 43093 | jjdelcerro | } |
198 | 43020 | jjdelcerro | |
199 | 44198 | jjdelcerro | public interface Method extends Value { |
200 | public String name(); |
||
201 | public Value instance();
|
||
202 | 43020 | jjdelcerro | public List<Value> parameters(); |
203 | public Function parameter(Value parameter);
|
||
204 | } |
||
205 | |||
206 | public interface BinaryOperator extends Value { |
||
207 | 44198 | jjdelcerro | public String name(); |
208 | public Value left();
|
||
209 | public Value right();
|
||
210 | public BinaryOperator left(Value operand);
|
||
211 | public BinaryOperator right(Value operand);
|
||
212 | 43020 | jjdelcerro | } |
213 | 44198 | jjdelcerro | |
214 | public abstract class AbstractValue implements Value { |
||
215 | |||
216 | private PropertiesSupport properties;
|
||
217 | |||
218 | protected AbstractValue() {
|
||
219 | this.properties = new PropertiesSupportHelper(); |
||
220 | } |
||
221 | |||
222 | @Override
|
||
223 | public void accept(Visitor visitor, VisitorFilter filter) { |
||
224 | if (filter == null || filter.accept(this)) { |
||
225 | visitor.visit(this);
|
||
226 | } |
||
227 | } |
||
228 | |||
229 | @Override
|
||
230 | public Map<String, Object> getProperties() { |
||
231 | return this.properties.getProperties(); |
||
232 | } |
||
233 | |||
234 | @Override
|
||
235 | public Object getProperty(String name) { |
||
236 | return this.properties.getProperty(name); |
||
237 | } |
||
238 | |||
239 | @Override
|
||
240 | public void setProperty(String name, Object value) { |
||
241 | this.properties.setProperty(name, value);
|
||
242 | } |
||
243 | |||
244 | } |
||
245 | |||
246 | public class ClassVisitorFilter implements VisitorFilter { |
||
247 | |||
248 | private final Class classFilter; |
||
249 | |||
250 | public ClassVisitorFilter(Class classFilter) { |
||
251 | this.classFilter = classFilter;
|
||
252 | } |
||
253 | |||
254 | @Override
|
||
255 | public boolean accept(Visitable visitable) { |
||
256 | 44369 | jjdelcerro | if( classFilter==null ) { |
257 | return true; |
||
258 | } |
||
259 | 44198 | jjdelcerro | return classFilter.isInstance(visitable);
|
260 | } |
||
261 | |||
262 | } |
||
263 | |||
264 | public static final Formatter<Value> EMPTY_FORMATTER = new Formatter<Value>() { |
||
265 | @Override
|
||
266 | public boolean canApply(Value value) { |
||
267 | return false; |
||
268 | } |
||
269 | |||
270 | @Override
|
||
271 | public String format(Value value) { |
||
272 | return ""; |
||
273 | } |
||
274 | }; |
||
275 | |||
276 | public String quote_for_identifiers(); |
||
277 | 43020 | jjdelcerro | |
278 | 44198 | jjdelcerro | public String quote_for_strings(); |
279 | |||
280 | 43020 | jjdelcerro | public void accept(Visitor visitor, VisitorFilter filter); |
281 | |||
282 | 44198 | jjdelcerro | public List<Variable> variables(); |
283 | 43020 | jjdelcerro | |
284 | 44198 | jjdelcerro | public List<String> variables_names(); |
285 | 43020 | jjdelcerro | |
286 | 44198 | jjdelcerro | public List<Parameter> parameters(); |
287 | 43020 | jjdelcerro | |
288 | 44198 | jjdelcerro | public List<String> parameters_names(); |
289 | |||
290 | 43020 | jjdelcerro | public GeometrySupportType geometry_support_type();
|
291 | 44198 | jjdelcerro | |
292 | public ExpressionBuilder geometry_support_type(GeometrySupportType geometrySupportType);
|
||
293 | 43020 | jjdelcerro | |
294 | public String identifier(String name); |
||
295 | |||
296 | 44006 | jjdelcerro | public String bytearray_hex(byte[] data); |
297 | 43020 | jjdelcerro | |
298 | 44006 | jjdelcerro | public String bytearray_0x(byte[] data); |
299 | |||
300 | public String bytearray_x(byte[] data); |
||
301 | |||
302 | 43020 | jjdelcerro | public String string(String s); |
303 | |||
304 | 44198 | jjdelcerro | public Object srs_id(IProjection projection); |
305 | 43020 | jjdelcerro | |
306 | 44198 | jjdelcerro | public Value value();
|
307 | |||
308 | public ExpressionBuilder value(Value value);
|
||
309 | 43020 | jjdelcerro | |
310 | 44198 | jjdelcerro | public Group group(Value group); |
311 | 43020 | jjdelcerro | |
312 | 44198 | jjdelcerro | public Constant bytearray(byte[] data); |
313 | 43020 | jjdelcerro | |
314 | public Variable variable(String name); |
||
315 | |||
316 | public Variable column(String name); // Alias for variable(name) |
||
317 | |||
318 | 43093 | jjdelcerro | public Parameter parameter(String name); |
319 | 43020 | jjdelcerro | |
320 | 43093 | jjdelcerro | public Parameter parameter();
|
321 | |||
322 | 43020 | jjdelcerro | public Constant constant(Object value); |
323 | |||
324 | 44198 | jjdelcerro | public Constant geometry(Geometry geom, IProjection projection);
|
325 | 43020 | jjdelcerro | |
326 | 44198 | jjdelcerro | public Constant geometry(Geometry geom);
|
327 | 43020 | jjdelcerro | |
328 | 44198 | jjdelcerro | public Constant envelope(Envelope envelope, IProjection projection);
|
329 | 44006 | jjdelcerro | |
330 | 44198 | jjdelcerro | public Constant envelope(Envelope envelope);
|
331 | 43034 | jjdelcerro | |
332 | 44198 | jjdelcerro | public Constant srs(IProjection projection);
|
333 | 44006 | jjdelcerro | |
334 | 43020 | jjdelcerro | public Custom custom(Object value); |
335 | |||
336 | 44198 | jjdelcerro | public Function as_geometry(Value value);
|
337 | 44020 | jjdelcerro | |
338 | 44198 | jjdelcerro | public Method method(Value instance, String name, Value... values); |
339 | 43020 | jjdelcerro | |
340 | 44198 | jjdelcerro | public Function function(String name, Value... values); |
341 | |||
342 | public BinaryOperator binaryOperator(String name, Value leftOperand, Value rightOperand); |
||
343 | 43020 | jjdelcerro | |
344 | 44198 | jjdelcerro | public Value toValue(String expression); |
345 | 43020 | jjdelcerro | |
346 | 44198 | jjdelcerro | public String toString(Formatter<Value> formatter); |
347 | |||
348 | 43020 | jjdelcerro | public Function not(Value value);
|
349 | |||
350 | 44198 | jjdelcerro | public Function not_is_null(Value value);
|
351 | 43020 | jjdelcerro | |
352 | 44198 | jjdelcerro | public Function is_null(Value value);
|
353 | 43020 | jjdelcerro | |
354 | |||
355 | 44364 | jjdelcerro | public Function ST_Area(Value geom);
|
356 | 43020 | jjdelcerro | |
357 | public Function ST_AsBinary(Value geom);
|
||
358 | |||
359 | public Function ST_AsEWKB(Value geom);
|
||
360 | |||
361 | 44364 | jjdelcerro | public Function ST_AsText(Value geom);
|
362 | |||
363 | public Function ST_Buffer(Value geom);
|
||
364 | |||
365 | public Function ST_Centroid(Value geom);
|
||
366 | |||
367 | public Function ST_Contains(Value geom1, Value geom2);
|
||
368 | |||
369 | public Function ST_CoveredBy(Value geom1, Value geom2);
|
||
370 | |||
371 | public Function ST_Covers(Value geom1, Value geom2);
|
||
372 | |||
373 | public Function ST_Crosses(Value geom1, Value geom2);
|
||
374 | |||
375 | public Function ST_Diference(Value geom1, Value geom2);
|
||
376 | |||
377 | public Function ST_Dimension(Value geom1);
|
||
378 | |||
379 | public Function ST_Disjoint(Value geom1, Value geom2);
|
||
380 | |||
381 | public Function ST_Distance(Value geom1, Value geom2);
|
||
382 | |||
383 | public Function ST_EndPoint(Value geom1);
|
||
384 | |||
385 | 43020 | jjdelcerro | public Function ST_Envelope(Value geom);
|
386 | |||
387 | 44364 | jjdelcerro | public Function ST_Equals(Value geom1, Value geom2);
|
388 | |||
389 | 43020 | jjdelcerro | public Function ST_GeomFromText(Value geom, Value crs);
|
390 | |||
391 | public Function ST_GeomFromWKB(Value geom, Value crs);
|
||
392 | |||
393 | public Function ST_GeomFromEWKB(Value geom, Value crs);
|
||
394 | |||
395 | 44364 | jjdelcerro | public Function ST_Intersection(Value geom1, Value geom2);
|
396 | 43355 | jjdelcerro | |
397 | 43020 | jjdelcerro | public Function ST_Intersects(Value geom1, Value geom2);
|
398 | |||
399 | 44364 | jjdelcerro | public Function ST_IsClosed(Value geom);
|
400 | 43020 | jjdelcerro | |
401 | 44364 | jjdelcerro | public Function ST_IsSimple(Value geom);
|
402 | 43034 | jjdelcerro | |
403 | 44364 | jjdelcerro | public Function ST_IsValid(Value geom);
|
404 | 43020 | jjdelcerro | |
405 | 44364 | jjdelcerro | public Function ST_NumGeometries(Value geom);
|
406 | |||
407 | public Function ST_NumPoints(Value geom);
|
||
408 | 43020 | jjdelcerro | |
409 | public Function ST_Overlaps(Value geom1, Value geom2);
|
||
410 | |||
411 | 44364 | jjdelcerro | public Function ST_Perimeter(Value geom);
|
412 | |||
413 | public Function ST_Point(Value x, Value y);
|
||
414 | |||
415 | public Function ST_PointN(Value geom, Value n);
|
||
416 | |||
417 | public Function ST_SRID(Value geom);
|
||
418 | |||
419 | public Function ST_SetSRID(Value geom, Value srid);
|
||
420 | |||
421 | public Function ST_StartPoint(Value geom);
|
||
422 | |||
423 | public Function ST_Simplify(Value geom, Value tolerance);
|
||
424 | |||
425 | 43020 | jjdelcerro | public Function ST_Touches(Value geom1, Value geom2);
|
426 | |||
427 | 44364 | jjdelcerro | public Function ST_Union(Value geom1, Value geom2);
|
428 | |||
429 | 43020 | jjdelcerro | public Function ST_Within(Value geom1, Value geom2);
|
430 | |||
431 | 44364 | jjdelcerro | public Function ST_X(Value geom);
|
432 | 44253 | jjdelcerro | |
433 | 44364 | jjdelcerro | public Function ST_Y(Value geom);
|
434 | 44253 | jjdelcerro | |
435 | 44364 | jjdelcerro | public Function ST_Z(Value geom);
|
436 | |||
437 | |||
438 | 44198 | jjdelcerro | public Function ST_UnionAggregate(Value geom);
|
439 | 43020 | jjdelcerro | |
440 | 44198 | jjdelcerro | public Function ST_ExtentAggregate(Value geom);
|
441 | 44364 | jjdelcerro | |
442 | |||
443 | 44198 | jjdelcerro | |
444 | 43020 | jjdelcerro | public BinaryOperator and(Value op1, Value op2);
|
445 | |||
446 | 44274 | jjdelcerro | public BinaryOperator and(Expression op1, Expression op2); |
447 | |||
448 | public BinaryOperator and(Expression op1, Value op2); |
||
449 | |||
450 | 43020 | jjdelcerro | public BinaryOperator or(Value op1, Value op2);
|
451 | |||
452 | public BinaryOperator eq(Value op1, Value op2);
|
||
453 | |||
454 | public BinaryOperator ne(Value op1, Value op2);
|
||
455 | |||
456 | public BinaryOperator gt(Value op1, Value op2);
|
||
457 | |||
458 | public BinaryOperator ge(Value op1, Value op2);
|
||
459 | |||
460 | public BinaryOperator lt(Value op1, Value op2);
|
||
461 | |||
462 | public BinaryOperator le(Value op1, Value op2);
|
||
463 | |||
464 | public BinaryOperator like(Value op1, Value op2);
|
||
465 | |||
466 | public BinaryOperator ilike(Value op1, Value op2);
|
||
467 | |||
468 | public BinaryOperator add(Value op1, Value op2);
|
||
469 | |||
470 | public BinaryOperator subst(Value op1, Value op2);
|
||
471 | |||
472 | public BinaryOperator mult(Value op1, Value op2);
|
||
473 | |||
474 | public BinaryOperator div(Value op1, Value op2);
|
||
475 | |||
476 | public BinaryOperator concat(Value op1, Value op2);
|
||
477 | |||
478 | public ExpressionBuilder set(Value value);
|
||
479 | 44198 | jjdelcerro | |
480 | 43020 | jjdelcerro | public ExpressionBuilder and(Value value);
|
481 | |||
482 | public ExpressionBuilder or(Value value);
|
||
483 | |||
484 | 44038 | jjdelcerro | public Function iif(Value condition, Value iftrue, Value iffalse);
|
485 | |||
486 | public Function ifnull(Value value, Value iftrue, Value iffalse);
|
||
487 | |||
488 | 43020 | jjdelcerro | public ExpressionBuilder createExpressionBuilder();
|
489 | 44051 | omartinez | |
490 | public Function left(Value str, Value size);
|
||
491 | |||
492 | public Function right(Value str, Value len);
|
||
493 | |||
494 | public Function locate(Value search, Value str, Value start) ;
|
||
495 | |||
496 | public Function position(Value search, Value str);
|
||
497 | |||
498 | public Function lpad(Value str, Value len, Value padstr) ;
|
||
499 | |||
500 | public Function rpad(Value str, Value len, Value padstr);
|
||
501 | |||
502 | public Function ltrim(Value str);
|
||
503 | |||
504 | public Function rtrim(Value str);
|
||
505 | |||
506 | public Function trim(Value str);
|
||
507 | |||
508 | public Function repeat(Value str, Value size);
|
||
509 | |||
510 | public Function replace(Value str, Value search, Value replstr);
|
||
511 | |||
512 | public Function ascii(Value str);
|
||
513 | |||
514 | public Function lenght(Value str);
|
||
515 | |||
516 | public Function instr(Value str, Value search, Value start);
|
||
517 | |||
518 | public Function lower(Value str);
|
||
519 | |||
520 | public Function upper(Value str);
|
||
521 | |||
522 | public Function space(Value size);
|
||
523 | |||
524 | public Function substring(Value str, Value start, Value len);
|
||
525 | |||
526 | public Function acos(Value num);
|
||
527 | |||
528 | public Function asin(Value num);
|
||
529 | |||
530 | public Function atan(Value num);
|
||
531 | |||
532 | public Function cos(Value num);
|
||
533 | |||
534 | public Function cosh(Value num);
|
||
535 | |||
536 | public Function cot(Value num);
|
||
537 | |||
538 | public Function bitand(Value num1, Value num2);
|
||
539 | |||
540 | public Function bitor(Value num1, Value num2);
|
||
541 | |||
542 | public Function bitxor(Value num1, Value num2);
|
||
543 | |||
544 | public Function ceil(Value num);
|
||
545 | |||
546 | public Function degrees(Value num);
|
||
547 | |||
548 | public Function exp(Value num);
|
||
549 | |||
550 | public Function floor(Value num);
|
||
551 | |||
552 | public Function log(Value num);
|
||
553 | |||
554 | public Function log10(Value num);
|
||
555 | |||
556 | public Function pi(Value num);
|
||
557 | |||
558 | public Function power(Value num);
|
||
559 | |||
560 | public Function radians(Value num);
|
||
561 | |||
562 | public Function rand(Value num);
|
||
563 | |||
564 | public Function round(Value num);
|
||
565 | |||
566 | public Function sqrt(Value num);
|
||
567 | |||
568 | public Function sign(Value num);
|
||
569 | |||
570 | public Function sin(Value num);
|
||
571 | |||
572 | public Function sinh(Value num);
|
||
573 | |||
574 | public Function tan(Value num);
|
||
575 | |||
576 | public Function tanh(Value num);
|
||
577 | |||
578 | public Function zero();
|
||
579 | 44054 | omartinez | |
580 | public Function chr(Value num);
|
||
581 | 44198 | jjdelcerro | |
582 | public Function decode(Value value, Value format);
|
||
583 | |||
584 | public Function cast(Value object, Value typeName);
|
||
585 | |||
586 | public Function toDouble(Value object);
|
||
587 | |||
588 | public Function toFloat(Value object);
|
||
589 | |||
590 | public Function toLong(Value object);
|
||
591 | |||
592 | public Function toInteger(Value object);
|
||
593 | |||
594 | public Function toStr(Value object);
|
||
595 | |||
596 | 44262 | jjdelcerro | public Function list();
|
597 | |||
598 | 44259 | jjdelcerro | public boolean isEmpty(); |
599 | 43020 | jjdelcerro | } |