Statistics
| Revision:

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 @ 44207

History | View | Annotate | Download (17.2 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
    public static final String FUNCTION_ST_UNIONAGGREGATE = "ST_UnionAggregate";
54
    public static final String FUNCTION_ST_EXTENTAGGREGATE = "ST_ExtentAggregate";
55
56
    public static final String FUNCTION_IIF = "IIF";
57
    public static final String FUNCTION_IFNULL = "IFNULL";
58
59
    public static final String FUNCTION_LEFT = "LEFT";
60
    public static final String FUNCTION_RIGHT = "RIGHT";
61
    public static final String FUNCTION_LOCATE = "LOCATE";
62
    public static final String FUNCTION_POSITION = "POSITION";
63
    public static final String FUNCTION_LPAD = "LPAD";
64
    public static final String FUNCTION_RPAD = "RPAD";
65
    public static final String FUNCTION_LTRIM = "LTRIM";
66
    public static final String FUNCTION_RTRIM = "RTRIM";
67
    public static final String FUNCTION_TRIM = "TRIM";
68
    public static final String FUNCTION_REPEAT = "REPEAT";
69
    public static final String FUNCTION_REPLACE = "REPLACE";
70
    public static final String FUNCTION_ASCII = "ASCII";
71
    public static final String FUNCTION_LENGHT = "LENGHT";
72
    public static final String FUNCTION_INSTR = "INSTR";
73
    public static final String FUNCTION_LOWER = "LOWER";
74
    public static final String FUNCTION_UPPER = "UPPER";
75
    public static final String FUNCTION_SPACE = "SPACE";
76
    public static final String FUNCTION_SUBSTRING = "SUBSTRING";
77
    public static final String FUNCTION_ACOS = "ACOS";
78
    public static final String FUNCTION_ASIN = "ASIN";
79
    public static final String FUNCTION_ATAN = "ATAN";
80
    public static final String FUNCTION_COS = "COS";
81
    public static final String FUNCTION_COSH = "COSH";
82
    public static final String FUNCTION_COT = "COT";
83
    public static final String FUNCTION_BITAND = "BITAND";
84
    public static final String FUNCTION_BITOR = "BITOR";
85
    public static final String FUNCTION_BITXOR = "BITXOR";
86
    public static final String FUNCTION_CEIL = "CEIL";
87
    public static final String FUNCTION_DEGREES = "DEGREES";
88
    public static final String FUNCTION_EXP = "EXP";
89
    public static final String FUNCTION_FLOOR = "FLOOR";
90
    public static final String FUNCTION_LOG = "LOG";
91
    public static final String FUNCTION_LOG10 = "LOG10";
92
    public static final String FUNCTION_PI = "PI";
93
    public static final String FUNCTION_POWER = "POWER";
94
    public static final String FUNCTION_RADIANS = "RADIANS";
95
    public static final String FUNCTION_RAND = "RAND";
96
    public static final String FUNCTION_ROUND = "ROUND";
97
    public static final String FUNCTION_SQRT = "SQRT";
98
    public static final String FUNCTION_SIGN = "SIGN";
99
    public static final String FUNCTION_SIN = "SIN";
100
    public static final String FUNCTION_SINH = "SINH";
101
    public static final String FUNCTION_TAN = "TAN";
102
    public static final String FUNCTION_TANH = "TANH";
103
    public static final String FUNCTION_ZERO = "ZERO";
104
    public static final String FUNCTION_CHR = "CHR";
105
    public static final String FUNCTION_DATE = "DATE";
106
    public static final String FUNCTION_NOW = "NOW";
107
    public static final String FUNCTION_TIME = "TIME";
108
    public static final String FUNCTION_TIMESTAMP = "TIMESTAMP";
109
110
    public static final String FUNCTION_CAST = "CAST";
111
    public static final String FUNCTION_DECODE = "DECODE";
112
    public static final String FUNCTION_TODOUBLE = "TODOUBLE";
113
    public static final String FUNCTION_TOFLOAT = "TOFLOAT";
114
    public static final String FUNCTION_TOINTEGER = "TOINTEGER";
115
    public static final String FUNCTION_TOLONG = "TOLONG";
116
    public static final String FUNCTION_TOSTR = "TOSTR";
117
118 44206 jjdelcerro
    public static final String FUNCTION_INCR = "INCR";
119
    public static final String FUNCTION_DECR = "DECR";
120
121 44207 jjdelcerro
    public static final String FUNCTION_RANGE = "RANGE";
122
123 43020 jjdelcerro
    public enum GeometrySupportType {
124
        WKT,
125
        WKB,
126 43358 jjdelcerro
        EWKB,
127
        NATIVE
128 43020 jjdelcerro
    }
129
130
    public enum ParameterType {
131
        Variable,
132
        Constant,
133
        Geometry
134
    }
135 44198 jjdelcerro
136 43020 jjdelcerro
    public interface VisitorFilter {
137
        boolean accept(Visitable visitable);
138
    }
139
140
     public interface Visitor {
141
        public void visit(Visitable value);
142
    }
143
144
    public interface Visitable {
145
        public void accept(Visitor visitor, VisitorFilter filter);
146
    }
147
148 44198 jjdelcerro
    public interface Value extends Visitable, PropertiesSupport {
149
        public String toString(Formatter<Value> formatter);
150 43020 jjdelcerro
    }
151
152
    public interface Group extends Value {
153 44198 jjdelcerro
        public Value value();
154 43020 jjdelcerro
    }
155
156
    public interface Constant extends Value {
157 44198 jjdelcerro
        public Object value();
158 43020 jjdelcerro
    }
159
160
    public interface Custom extends Value {
161 44198 jjdelcerro
        public Object value();
162 43020 jjdelcerro
        public Custom add(Variable variable);
163
        public Custom add(Parameter parameter);
164
    }
165
166
    public interface Variable extends Value, Comparable<Variable> {
167 44198 jjdelcerro
        public String name();
168 43020 jjdelcerro
    }
169
170
    public interface Parameter extends Value {
171
        public Parameter as_constant();
172
        public Parameter as_variable();
173 43093 jjdelcerro
        public Parameter as_geometry_variable();
174 43020 jjdelcerro
        public Parameter srs(Value srs);
175
        public Parameter srs(IProjection srs);
176 43093 jjdelcerro
        public Parameter value(Object value);
177
        public Parameter name(String value);
178 44198 jjdelcerro
        public String name();
179
        public Object value();
180
        public ParameterType type();
181
        public Value srs();
182 43020 jjdelcerro
        public boolean is_constant();
183
        public boolean is_variable();
184
        public boolean is_geometry_variable();
185
    }
186 43093 jjdelcerro
187 44198 jjdelcerro
    public interface Function extends Value {
188
        public String name();
189
        public List<Value> parameters();
190
        public Function parameter(Value parameter);
191 43093 jjdelcerro
    }
192 43020 jjdelcerro
193 44198 jjdelcerro
    public interface Method extends Value {
194
        public String name();
195
        public Value instance();
196 43020 jjdelcerro
        public List<Value> parameters();
197
        public Function parameter(Value parameter);
198
    }
199
200
    public interface BinaryOperator extends Value {
201 44198 jjdelcerro
        public String name();
202
        public Value left();
203
        public Value right();
204
        public BinaryOperator left(Value operand);
205
        public BinaryOperator right(Value operand);
206 43020 jjdelcerro
    }
207 44198 jjdelcerro
208
    public abstract class AbstractValue implements Value {
209
210
        private PropertiesSupport properties;
211
212
        protected AbstractValue() {
213
            this.properties = new PropertiesSupportHelper();
214
        }
215
216
        @Override
217
        public void accept(Visitor visitor, VisitorFilter filter) {
218
            if (filter == null || filter.accept(this)) {
219
                visitor.visit(this);
220
            }
221
        }
222
223
        @Override
224
        public Map<String, Object> getProperties() {
225
            return this.properties.getProperties();
226
        }
227
228
        @Override
229
        public Object getProperty(String name) {
230
            return this.properties.getProperty(name);
231
        }
232
233
        @Override
234
        public void setProperty(String name, Object value) {
235
            this.properties.setProperty(name, value);
236
        }
237
238
    }
239
240
    public class ClassVisitorFilter implements VisitorFilter {
241
242
        private final Class classFilter;
243
244
        public ClassVisitorFilter(Class classFilter) {
245
            this.classFilter = classFilter;
246
        }
247
248
        @Override
249
        public boolean accept(Visitable visitable) {
250
            return classFilter.isInstance(visitable);
251
        }
252
253
    }
254
255
    public static final Formatter<Value> EMPTY_FORMATTER = new Formatter<Value>() {
256
        @Override
257
        public boolean canApply(Value value) {
258
            return false;
259
        }
260
261
        @Override
262
        public String format(Value value) {
263
            return "";
264
        }
265
    };
266
267
    public String quote_for_identifiers();
268 43020 jjdelcerro
269 44198 jjdelcerro
    public String quote_for_strings();
270
271 43020 jjdelcerro
    public void accept(Visitor visitor, VisitorFilter filter);
272
273 44198 jjdelcerro
    public List<Variable> variables();
274 43020 jjdelcerro
275 44198 jjdelcerro
    public List<String> variables_names();
276 43020 jjdelcerro
277 44198 jjdelcerro
    public List<Parameter> parameters();
278 43020 jjdelcerro
279 44198 jjdelcerro
    public List<String> parameters_names();
280
281 43020 jjdelcerro
    public GeometrySupportType geometry_support_type();
282 44198 jjdelcerro
283
    public ExpressionBuilder geometry_support_type(GeometrySupportType geometrySupportType);
284 43020 jjdelcerro
285
    public String identifier(String name);
286
287 44006 jjdelcerro
    public String bytearray_hex(byte[] data);
288 43020 jjdelcerro
289 44006 jjdelcerro
    public String bytearray_0x(byte[] data);
290
291
    public String bytearray_x(byte[] data);
292
293 43020 jjdelcerro
    public String string(String s);
294
295 44198 jjdelcerro
    public Object srs_id(IProjection projection);
296 43020 jjdelcerro
297 44198 jjdelcerro
    public Value value();
298
299
    public ExpressionBuilder value(Value value);
300 43020 jjdelcerro
301 44198 jjdelcerro
    public Group group(Value group);
302 43020 jjdelcerro
303 44198 jjdelcerro
    public Constant bytearray(byte[] data);
304 43020 jjdelcerro
305
    public Variable variable(String name);
306
307
    public Variable column(String name); // Alias for variable(name)
308
309 43093 jjdelcerro
    public Parameter parameter(String name);
310 43020 jjdelcerro
311 43093 jjdelcerro
    public Parameter parameter();
312
313 43020 jjdelcerro
    public Constant constant(Object value);
314
315 44198 jjdelcerro
    public Constant geometry(Geometry geom, IProjection projection);
316 43020 jjdelcerro
317 44198 jjdelcerro
    public Constant geometry(Geometry geom);
318 43020 jjdelcerro
319 44198 jjdelcerro
    public Constant envelope(Envelope envelope, IProjection projection);
320 44006 jjdelcerro
321 44198 jjdelcerro
    public Constant envelope(Envelope envelope);
322 43034 jjdelcerro
323 44198 jjdelcerro
    public Constant srs(IProjection projection);
324 44006 jjdelcerro
325 43020 jjdelcerro
    public Custom custom(Object value);
326
327 44198 jjdelcerro
    public Function as_geometry(Value value);
328 44020 jjdelcerro
329 44198 jjdelcerro
    public Method method(Value instance, String name, Value... values);
330 43020 jjdelcerro
331 44198 jjdelcerro
    public Function function(String name, Value... values);
332
333
    public BinaryOperator binaryOperator(String name, Value leftOperand, Value rightOperand);
334 43020 jjdelcerro
335 44198 jjdelcerro
    public Value toValue(String expression);
336 43020 jjdelcerro
337 44198 jjdelcerro
    public String toString(Formatter<Value> formatter);
338
339 43020 jjdelcerro
    public Function not(Value value);
340
341 44198 jjdelcerro
    public Function not_is_null(Value value);
342 43020 jjdelcerro
343 44198 jjdelcerro
    public Function is_null(Value value);
344 43020 jjdelcerro
345
    public Function ST_SRID(Value geom);
346
347
    public Function ST_AsText(Value geom);
348
349
    public Function ST_AsBinary(Value geom);
350
351
    public Function ST_AsEWKB(Value geom);
352
353
    public Function ST_Envelope(Value geom);
354
355
    public Function ST_GeomFromText(Value geom, Value crs);
356
357
    public Function ST_GeomFromWKB(Value geom, Value crs);
358
359
    public Function ST_GeomFromEWKB(Value geom, Value crs);
360
361 43355 jjdelcerro
    public Function ST_Simplify(Value geom, Value tolerance);
362
363 43034 jjdelcerro
    public Function ST_Equals(Value geom1, Value geom2);
364
365 43020 jjdelcerro
    public Function ST_Intersects(Value geom1, Value geom2);
366
367
    public Function ST_Contains(Value geom1, Value geom2);
368
369 43034 jjdelcerro
    public Function ST_Disjoint(Value geom1, Value geom2);
370
371 43020 jjdelcerro
    public Function ST_Crosses(Value geom1, Value geom2);
372
373
    public Function ST_IsClosed(Value geom1);
374
375
    public Function ST_Overlaps(Value geom1, Value geom2);
376
377
    public Function ST_Touches(Value geom1, Value geom2);
378
379
    public Function ST_Within(Value geom1, Value geom2);
380
381 44198 jjdelcerro
    public Function ST_UnionAggregate(Value geom);
382 43020 jjdelcerro
383 44198 jjdelcerro
    public Function ST_ExtentAggregate(Value geom);
384
385 43020 jjdelcerro
    public BinaryOperator and(Value op1, Value op2);
386
387
    public BinaryOperator or(Value op1, Value op2);
388
389
    public BinaryOperator eq(Value op1, Value op2);
390
391
    public BinaryOperator ne(Value op1, Value op2);
392
393
    public BinaryOperator gt(Value op1, Value op2);
394
395
    public BinaryOperator ge(Value op1, Value op2);
396
397
    public BinaryOperator lt(Value op1, Value op2);
398
399
    public BinaryOperator le(Value op1, Value op2);
400
401
    public BinaryOperator like(Value op1, Value op2);
402
403
    public BinaryOperator ilike(Value op1, Value op2);
404
405
    public BinaryOperator add(Value op1, Value op2);
406
407
    public BinaryOperator subst(Value op1, Value op2);
408
409
    public BinaryOperator mult(Value op1, Value op2);
410
411
    public BinaryOperator div(Value op1, Value op2);
412
413
    public BinaryOperator concat(Value op1, Value op2);
414
415
    public ExpressionBuilder set(Value value);
416 44198 jjdelcerro
417 43020 jjdelcerro
    public ExpressionBuilder and(Value value);
418
419
    public ExpressionBuilder or(Value value);
420
421 44038 jjdelcerro
    public Function iif(Value condition, Value iftrue, Value iffalse);
422
423
    public Function ifnull(Value value, Value iftrue, Value iffalse);
424
425 43020 jjdelcerro
    public ExpressionBuilder createExpressionBuilder();
426 44051 omartinez
427
    public Function left(Value str, Value size);
428
429
    public Function right(Value str, Value len);
430
431
    public Function locate(Value search, Value str, Value start) ;
432
433
    public Function position(Value search, Value str);
434
435
    public Function lpad(Value str, Value len, Value padstr) ;
436
437
    public Function rpad(Value str, Value len, Value padstr);
438
439
    public Function ltrim(Value str);
440
441
    public Function rtrim(Value str);
442
443
    public Function trim(Value str);
444
445
    public Function repeat(Value str, Value size);
446
447
    public Function replace(Value str, Value search, Value replstr);
448
449
    public Function ascii(Value str);
450
451
    public Function lenght(Value str);
452
453
    public Function instr(Value str, Value search, Value start);
454
455
    public Function lower(Value str);
456
457
    public Function upper(Value str);
458
459
    public Function space(Value size);
460
461
    public Function substring(Value str, Value start, Value len);
462
463
    public Function acos(Value num);
464
465
    public Function asin(Value num);
466
467
    public Function atan(Value num);
468
469
    public Function cos(Value num);
470
471
    public Function cosh(Value num);
472
473
    public Function cot(Value num);
474
475
    public Function bitand(Value num1, Value num2);
476
477
    public Function bitor(Value num1, Value num2);
478
479
    public Function bitxor(Value num1, Value num2);
480
481
    public Function ceil(Value num);
482
483
    public Function degrees(Value num);
484
485
    public Function exp(Value num);
486
487
    public Function floor(Value num);
488
489
    public Function log(Value num);
490
491
    public Function log10(Value num);
492
493
    public Function pi(Value num);
494
495
    public Function power(Value num);
496
497
    public Function radians(Value num);
498
499
    public Function rand(Value num);
500
501
    public Function round(Value num);
502
503
    public Function sqrt(Value num);
504
505
    public Function sign(Value num);
506
507
    public Function sin(Value num);
508
509
    public Function sinh(Value num);
510
511
    public Function tan(Value num);
512
513
    public Function tanh(Value num);
514
515
    public Function zero();
516 44054 omartinez
517
    public Function chr(Value num);
518 44198 jjdelcerro
519
    public Function decode(Value value, Value format);
520
521
    public Function cast(Value object, Value typeName);
522
523
    public Function toDouble(Value object);
524
525
    public Function toFloat(Value object);
526
527
    public Function toLong(Value object);
528
529
    public Function toInteger(Value object);
530
531
    public Function toStr(Value object);
532
533 43020 jjdelcerro
}