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

History | View | Annotate | Download (15.2 KB)

1
package org.gvsig.expressionevaluator;
2

    
3
import java.util.List;
4
import java.util.Map;
5
import org.apache.commons.lang3.tuple.Pair;
6
import org.gvsig.tools.util.PropertiesSupport;
7
import org.gvsig.tools.util.PropertiesSupportHelper;
8

    
9
public interface ExpressionBuilder {
10

    
11
    public static final String OPERATOR_NOT = "NOT";
12
    public static final String OPERATOR_NEGATE = "NEGATE";
13
    public static final String OPERATOR_IS = "IS";
14
    public static final String OPERATOR_AND = "AND";
15
    public static final String OPERATOR_OR = "OR";
16
    public static final String OPERATOR_EQ = "=";
17
    public static final String OPERATOR_NE = "<>";
18
    public static final String OPERATOR_GT = ">";
19
    public static final String OPERATOR_GE = ">=";
20
    public static final String OPERATOR_LT = "<";
21
    public static final String OPERATOR_LE = "<=";
22
    public static final String OPERATOR_LIKE = "LIKE";
23
    public static final String OPERATOR_ILIKE = "ILIKE";
24
    public static final String OPERATOR_ADD = "+";
25
    public static final String OPERATOR_SUBST = "-";
26
    public static final String OPERATOR_MULT = "*";
27
    public static final String OPERATOR_DIV = "/";
28
    public static final String OPERATOR_MOD = "%";
29
    public static final String OPERATOR_CONCAT = "||";
30
    public static final String OPERATOR_REGEXP = "~";
31
    public static final String OPERATOR_AND2 = "&&";
32

    
33
    public static final String FUNCTION_IIF = "IIF";
34
    public static final String FUNCTION_IFNULL = "IFNULL";
35
    
36
    public static final String FUNCTION_LEFT = "LEFT";
37
    public static final String FUNCTION_RIGHT = "RIGHT";
38
    public static final String FUNCTION_LOCATE = "LOCATE";
39
    public static final String FUNCTION_POSITION = "POSITION";
40
    public static final String FUNCTION_LPAD = "LPAD";
41
    public static final String FUNCTION_RPAD = "RPAD";
42
    public static final String FUNCTION_LTRIM = "LTRIM";
43
    public static final String FUNCTION_RTRIM = "RTRIM";
44
    public static final String FUNCTION_TRIM = "TRIM";
45
    public static final String FUNCTION_REPEAT = "REPEAT";
46
    public static final String FUNCTION_REPLACE = "REPLACE";
47
    public static final String FUNCTION_ASCII = "ASCII";
48
    public static final String FUNCTION_LENGHT = "LENGHT";
49
    public static final String FUNCTION_INSTR = "INSTR";
50
    public static final String FUNCTION_LOWER = "LOWER";
51
    public static final String FUNCTION_UPPER = "UPPER";
52
    public static final String FUNCTION_SPACE = "SPACE";
53
    public static final String FUNCTION_SUBSTRING = "SUBSTRING";
54
    public static final String FUNCTION_ABS = "ABS";
55
    public static final String FUNCTION_ACOS = "ACOS";
56
    public static final String FUNCTION_ASIN = "ASIN";
57
    public static final String FUNCTION_ATAN = "ATAN";
58
    public static final String FUNCTION_COS = "COS";
59
    public static final String FUNCTION_COSH = "COSH";
60
    public static final String FUNCTION_COT = "COT";
61
    public static final String FUNCTION_BITAND = "BITAND";
62
    public static final String FUNCTION_BITOR = "BITOR";
63
    public static final String FUNCTION_BITXOR = "BITXOR";
64
    public static final String FUNCTION_CEIL = "CEIL";
65
    public static final String FUNCTION_DEGREES = "DEGREES";
66
    public static final String FUNCTION_EXP = "EXP";
67
    public static final String FUNCTION_FLOOR = "FLOOR";
68
    public static final String FUNCTION_LOG = "LOG";
69
    public static final String FUNCTION_LOG10 = "LOG10";
70
    public static final String FUNCTION_PI = "PI";
71
    public static final String FUNCTION_POWER = "POWER";
72
    public static final String FUNCTION_RADIANS = "RADIANS";
73
    public static final String FUNCTION_RAND = "RAND";
74
    public static final String FUNCTION_ROUND = "ROUND";
75
    public static final String FUNCTION_SQRT = "SQRT";
76
    public static final String FUNCTION_SIGN = "SIGN";
77
    public static final String FUNCTION_SIN = "SIN";
78
    public static final String FUNCTION_SINH = "SINH";
79
    public static final String FUNCTION_TAN = "TAN";
80
    public static final String FUNCTION_TANH = "TANH";
81
    public static final String FUNCTION_ZERO = "ZERO";
82
    public static final String FUNCTION_CHR = "CHR";
83
    public static final String FUNCTION_DATE = "DATE";
84
    public static final String FUNCTION_DATEDIFF = "DATEDIFF";
85
    public static final String FUNCTION_DATEADD = "DATEADD";
86
    public static final String FUNCTION_NOW = "NOW";
87
    public static final String FUNCTION_TIME = "TIME";
88
    public static final String FUNCTION_TIMESTAMP = "TIMESTAMP";
89

    
90
    public static final String FUNCTION_CAST = "CAST";
91
    public static final String FUNCTION_DECODE = "DECODE";
92
    public static final String FUNCTION_TODOUBLE = "TODOUBLE";
93
    public static final String FUNCTION_TOFLOAT = "TOFLOAT";
94
    public static final String FUNCTION_TOINTEGER = "TOINTEGER";
95
    public static final String FUNCTION_TOLONG = "TOLONG";
96
    public static final String FUNCTION_TOSTR = "TOSTR";
97
    
98
    public static final String FUNCTION_INCR = "INCR";
99
    public static final String FUNCTION_DECR = "DECR";
100
    
101
    public static final String FUNCTION_RANGE = "RANGE";
102
    public static final String FUNCTION_EVAL = "EVAL";
103
    public static final String FUNCTION_LIST = "LIST";
104
    public static final String FUNCTION_TUPLE = "TUPLE";
105
    
106
    public static final String FUNCTION_GETATTR = "GETATTR";
107
    
108
    public static final int PARAMETER_TYPE_CONSTANT = 0;
109
    public static final int PARAMETER_TYPE_VARIABLE = 1;
110
    
111
    public interface VisitorFilter {
112
        boolean accept(Visitable visitable);
113
    }
114

    
115
     public interface Visitor {
116
        public void visit(Visitable value);
117
    }
118

    
119
    public interface Visitable {
120
        public void accept(Visitor visitor, VisitorFilter filter);
121
    }
122
        
123
    public interface Value extends Visitable, PropertiesSupport {
124
        public String toString(Formatter<Value> formatter);
125
        public void replace(Value target, Value replacement);
126
    }
127

    
128
    public interface Group extends Value {
129
        public Value value();
130
    }
131

    
132
    public interface Constant extends Value {
133
        public Object value();
134
    }
135

    
136
    public interface Custom extends Value {
137
        public Object value();
138
        public Custom add(Variable variable);
139
        public Custom add(Parameter parameter);
140
    }
141

    
142
    public interface Variable extends Value, Comparable<Variable> {
143
        public String name();
144
    }
145

    
146
    public interface Parameter extends Value {
147
        public Parameter as_constant();
148
        public Parameter as_variable();        
149
        public Parameter value(Object value);
150
        public Parameter name(String value);
151
        public int type();
152
        public String name();
153
        public Object value();
154
        public boolean is_constant();
155
        public boolean is_variable();
156
    }
157
    
158
    public interface Function extends Value {
159
        public String name();
160
        public List<Pair<String,Value>> parameters();
161
        public Function parameter(Value parameter);
162
        public Function parameter(String name, Value parameter);
163
        public Value getParameter(String name);
164
        public Value getParameter(String name, int index);
165
        public boolean containsParameter(String name, int index);
166
    }
167

    
168
    public interface Method extends Value {
169
        public String name();
170
        public Value instance();
171
        public List<Pair<String,Value>> parameters();
172
        public Function parameter(Value parameter);
173
        public Function parameter(String name, Value parameter);
174
    }
175

    
176
    public interface BinaryOperator extends Value {
177
        public String name();
178
        public Value left();
179
        public Value right();
180
        public BinaryOperator left(Value operand);
181
        public BinaryOperator right(Value operand);
182
    }
183

    
184
    public abstract class AbstractValue implements Value {
185

    
186
        private PropertiesSupport properties;
187
        
188
        protected AbstractValue() {
189
            this.properties = new PropertiesSupportHelper();
190
        }
191
        
192
        @Override
193
        public void accept(Visitor visitor, VisitorFilter filter) {
194
            if (filter == null || filter.accept(this)) {
195
                visitor.visit(this);
196
            }
197
        }
198

    
199
        @Override
200
        public Map<String, Object> getProperties() {
201
            return this.properties.getProperties();
202
        }
203

    
204
        @Override
205
        public Object getProperty(String name) {
206
            return this.properties.getProperty(name);
207
        }
208

    
209
        @Override
210
        public void setProperty(String name, Object value) {
211
            this.properties.setProperty(name, value);
212
        }
213

    
214
        @Override
215
        public void replace(Value target, Value replacement) {
216
            // Do nothing
217
        }
218
    }
219

    
220
    public class ClassVisitorFilter implements VisitorFilter {
221

    
222
        private final Class classFilter;
223

    
224
        public ClassVisitorFilter(Class classFilter) {
225
            this.classFilter = classFilter;
226
        }
227

    
228
        @Override
229
        public boolean accept(Visitable visitable) {
230
            if( classFilter==null ) {
231
                return true;
232
            }
233
            return classFilter.isInstance(visitable);
234
        }
235

    
236
    }
237

    
238
    public static final Formatter<Value> EMPTY_FORMATTER = new Formatter<Value>() {
239
        @Override
240
        public boolean canApply(Value value) {
241
            return false;
242
        }
243

    
244
        @Override
245
        public String format(Value value) {
246
            return "";
247
        }
248
    };
249
            
250
    public String quote_for_identifiers();
251
    
252
    public String quote_for_strings();
253
    
254
    public void accept(Visitor visitor, VisitorFilter filter);
255

    
256
    public List<Variable> variables();
257
    
258
    public List<String> variables_names();
259
    
260
    public List<Parameter> parameters();
261
    
262
    public List<String> parameters_names();
263
    
264
    public String identifier(String name);
265

    
266
    public String bytearray_hex(byte[] data);
267

    
268
    public String bytearray_0x(byte[] data);
269

    
270
    public String bytearray_x(byte[] data);
271

    
272
    public String string(String s);
273
   
274
    public Value value();
275
    
276
    public ExpressionBuilder value(Value value);
277

    
278
    public Group group(Value group);
279
    
280
    public Constant bytearray(byte[] data);
281
    
282
    public Variable variable(String name);
283
    
284
    public Variable column(String name); // Alias for variable(name)
285

    
286
    public Parameter parameter(String name);
287

    
288
    public Parameter parameter();
289

    
290
    public Constant constant(Object value);
291
    
292
    public Custom custom(Object value);
293

    
294
    public Method method(Value instance, String name, Value... values);
295

    
296
    public Function function(String name, Value... values);
297
    
298
    public BinaryOperator binaryOperator(String name, Value leftOperand, Value rightOperand);
299

    
300
    public Value toValue(String expression);
301

    
302
    public String repr(Object value);
303
    
304
    public String toString(Formatter<Value> formatter);
305
    
306
    public Function not(Value value);
307

    
308
    public Function not_is_null(Value value);
309
    
310
    public Function is_null(Value value);
311

    
312
      
313
    public BinaryOperator and(Value op1, Value op2);
314

    
315
    public BinaryOperator and(Expression op1, Expression op2);
316

    
317
    public BinaryOperator and(Expression op1, Value op2);
318

    
319
    public BinaryOperator or(Value op1, Value op2);
320

    
321
    public BinaryOperator eq(Value op1, Value op2);
322
    
323
    public BinaryOperator ne(Value op1, Value op2);
324
    
325
    public BinaryOperator gt(Value op1, Value op2);
326
    
327
    public BinaryOperator ge(Value op1, Value op2);
328

    
329
    public BinaryOperator lt(Value op1, Value op2);
330
    
331
    public BinaryOperator le(Value op1, Value op2);
332

    
333
    public BinaryOperator like(Value op1, Value op2);
334

    
335
    public BinaryOperator ilike(Value op1, Value op2);
336

    
337
    public BinaryOperator add(Value op1, Value op2);
338

    
339
    public BinaryOperator subst(Value op1, Value op2);
340

    
341
    public BinaryOperator mult(Value op1, Value op2);
342

    
343
    public BinaryOperator div(Value op1, Value op2);
344

    
345
    public BinaryOperator concat(Value op1, Value op2);
346

    
347
    public ExpressionBuilder set(Value value);
348
    
349
    public ExpressionBuilder and(Value value);
350

    
351
    public ExpressionBuilder or(Value value);
352

    
353
    public Function iif(Value condition, Value iftrue, Value iffalse);
354
    
355
    public Function ifnull(Value value, Value iftrue, Value iffalse);
356

    
357
    public ExpressionBuilder createExpressionBuilder();
358
   
359
    public Function left(Value str, Value size);
360
    
361
    public Function right(Value str, Value len);
362
    
363
    public Function locate(Value search, Value str, Value start) ;
364
    
365
    public Function position(Value search, Value str);
366
    
367
    public Function lpad(Value str, Value len, Value padstr) ;
368
    
369
    public Function rpad(Value str, Value len, Value padstr);
370
    
371
    public Function ltrim(Value str);
372
    
373
    public Function rtrim(Value str);
374
    
375
    public Function trim(Value str);
376
    
377
    public Function repeat(Value str, Value size);
378
    
379
    public Function replace(Value str, Value search, Value replstr);
380
    
381
    public Function ascii(Value str);
382
    
383
    public Function lenght(Value str);
384

    
385
    public Function instr(Value str, Value search, Value start);
386
    
387
    public Function lower(Value str);
388
    
389
    public Function upper(Value str);
390
    
391
    public Function space(Value size);
392
    
393
    public Function substring(Value str, Value start, Value len);
394
    
395
    public Function abs(Value num);
396
    
397
    public Function acos(Value num);
398
    
399
    public Function asin(Value num);
400
    
401
    public Function atan(Value num);
402
    
403
    public Function cos(Value num);
404
    
405
    public Function cosh(Value num);
406
    
407
    public Function cot(Value num);
408
    
409
    public Function bitand(Value num1, Value num2);
410
    
411
    public Function bitor(Value num1, Value num2);
412
    
413
    public Function bitxor(Value num1, Value num2);
414
    
415
    public Function ceil(Value num);
416
    
417
    public Function degrees(Value num);
418
    
419
    public Function exp(Value num);
420
    
421
    public Function floor(Value num);
422
    
423
    public Function log(Value num);
424
    
425
    public Function log10(Value num);
426
    
427
    public Function pi();
428
    
429
    public Function power(Value num);
430
    
431
    public Function radians(Value num);
432
    
433
    public Function rand(Value num);
434
    
435
    public Function round(Value num);
436
    
437
    public Function sqrt(Value num);
438
    
439
    public Function sign(Value num);
440
    
441
    public Function sin(Value num);
442
    
443
    public Function sinh(Value num);
444
    
445
    public Function tan(Value num);
446
    
447
    public Function tanh(Value num);
448
    
449
    public Function zero();
450
    
451
    public Function chr(Value num);
452

    
453
    public Function decode(Value value, Value format);
454

    
455
    public Function cast(Value object, Value typeName);
456

    
457
    public Function toDouble(Value object);
458

    
459
    public Function toFloat(Value object);
460

    
461
    public Function toLong(Value object);
462

    
463
    public Function toInteger(Value object);
464

    
465
    public Function toStr(Value object);
466

    
467
    public Function list();
468
    
469
    public Function tuple();
470
    
471
    public Function tuple(Constant... values);
472
    
473
    public Function getattr(Value object, String attrname);
474
    
475
    public boolean isEmpty();
476
}