svn-gvsig-desktop / trunk / org.gvsig.desktop / org.gvsig.desktop.library / org.gvsig.expressionevaluator / org.gvsig.expressionevaluator.lib / org.gvsig.expressionevaluator.lib.impl / src / main / java / org / gvsig / expressionevaluator / impl / symboltable / SQLSymbolTable.java @ 44080
History | View | Annotate | Download (9.38 KB)
1 |
package org.gvsig.expressionevaluator.impl.symboltable; |
---|---|
2 |
|
3 |
import org.gvsig.expressionevaluator.Function; |
4 |
import org.gvsig.expressionevaluator.impl.function.date.DateFunction; |
5 |
import org.gvsig.expressionevaluator.impl.function.date.NowFunction; |
6 |
import org.gvsig.expressionevaluator.impl.function.date.RelativeInstantFunction; |
7 |
import org.gvsig.expressionevaluator.impl.function.date.RelativeIntervalFunction; |
8 |
import org.gvsig.expressionevaluator.impl.function.date.TimeFunction; |
9 |
import org.gvsig.expressionevaluator.impl.function.date.TimestampFunction; |
10 |
import org.gvsig.expressionevaluator.impl.function.numeric.ACosFunction; |
11 |
import org.gvsig.expressionevaluator.impl.function.numeric.ASinFunction; |
12 |
import org.gvsig.expressionevaluator.impl.function.numeric.ATanFunction; |
13 |
import org.gvsig.expressionevaluator.impl.function.numeric.AbsFunction; |
14 |
import org.gvsig.expressionevaluator.impl.function.numeric.BitAndFunction; |
15 |
import org.gvsig.expressionevaluator.impl.function.numeric.BitGetFunction; |
16 |
import org.gvsig.expressionevaluator.impl.function.numeric.BitOrFunction; |
17 |
import org.gvsig.expressionevaluator.impl.function.numeric.BitXorFunction; |
18 |
import org.gvsig.expressionevaluator.impl.function.numeric.CeilFunction; |
19 |
import org.gvsig.expressionevaluator.impl.function.numeric.CosFunction; |
20 |
import org.gvsig.expressionevaluator.impl.function.numeric.CoshFunction; |
21 |
import org.gvsig.expressionevaluator.impl.function.numeric.CotFunction; |
22 |
import org.gvsig.expressionevaluator.impl.function.numeric.DegreesFunction; |
23 |
import org.gvsig.expressionevaluator.impl.function.numeric.ExpFunction; |
24 |
import org.gvsig.expressionevaluator.impl.function.numeric.FloorFunction; |
25 |
import org.gvsig.expressionevaluator.impl.function.numeric.Log10Function; |
26 |
import org.gvsig.expressionevaluator.impl.function.numeric.LogFunction; |
27 |
import org.gvsig.expressionevaluator.impl.function.numeric.PiFunction; |
28 |
import org.gvsig.expressionevaluator.impl.function.numeric.PowFunction; |
29 |
import org.gvsig.expressionevaluator.impl.function.numeric.RadiansFunction; |
30 |
import org.gvsig.expressionevaluator.impl.function.numeric.RandFunction; |
31 |
import org.gvsig.expressionevaluator.impl.function.numeric.RoundFunction; |
32 |
import org.gvsig.expressionevaluator.impl.function.numeric.SignFunction; |
33 |
import org.gvsig.expressionevaluator.impl.function.numeric.SinFunction; |
34 |
import org.gvsig.expressionevaluator.impl.function.numeric.SinhFunction; |
35 |
import org.gvsig.expressionevaluator.impl.function.numeric.SqrtFunction; |
36 |
import org.gvsig.expressionevaluator.impl.function.numeric.TanFunction; |
37 |
import org.gvsig.expressionevaluator.impl.function.numeric.TanhFunction; |
38 |
import org.gvsig.expressionevaluator.impl.function.numeric.ZeroFunction; |
39 |
import org.gvsig.expressionevaluator.impl.function.obj.IFNULLFunction; |
40 |
import org.gvsig.expressionevaluator.impl.function.obj.IIFFunction; |
41 |
import org.gvsig.expressionevaluator.impl.function.operator.AddOperator; |
42 |
import org.gvsig.expressionevaluator.impl.function.operator.AndOperator; |
43 |
import org.gvsig.expressionevaluator.impl.function.operator.DivOperator; |
44 |
import org.gvsig.expressionevaluator.impl.function.operator.EqOperator; |
45 |
import org.gvsig.expressionevaluator.impl.function.operator.GeOperator; |
46 |
import org.gvsig.expressionevaluator.impl.function.operator.GtOperator; |
47 |
import org.gvsig.expressionevaluator.impl.function.operator.IsOperator; |
48 |
import org.gvsig.expressionevaluator.impl.function.operator.LeOperator; |
49 |
import org.gvsig.expressionevaluator.impl.function.operator.LtOperator; |
50 |
import org.gvsig.expressionevaluator.impl.function.operator.ModOperator; |
51 |
import org.gvsig.expressionevaluator.impl.function.operator.MulOperator; |
52 |
import org.gvsig.expressionevaluator.impl.function.operator.NeOperator; |
53 |
import org.gvsig.expressionevaluator.impl.function.operator.NotOperator; |
54 |
import org.gvsig.expressionevaluator.impl.function.operator.OrOperator; |
55 |
import org.gvsig.expressionevaluator.impl.function.operator.SubstOperator; |
56 |
import org.gvsig.expressionevaluator.impl.function.predicate.IlikeOperator; |
57 |
import org.gvsig.expressionevaluator.impl.function.predicate.LikeOperator; |
58 |
import org.gvsig.expressionevaluator.impl.function.string.AsciiFunction; |
59 |
import org.gvsig.expressionevaluator.impl.function.string.CharFunction; |
60 |
import org.gvsig.expressionevaluator.impl.function.string.ConcatFunction; |
61 |
import org.gvsig.expressionevaluator.impl.function.string.DecodeFunction; |
62 |
import org.gvsig.expressionevaluator.impl.function.string.InstrFunction; |
63 |
import org.gvsig.expressionevaluator.impl.function.string.LTrimFunction; |
64 |
import org.gvsig.expressionevaluator.impl.function.string.LeftFunction; |
65 |
import org.gvsig.expressionevaluator.impl.function.string.LengthFunction; |
66 |
import org.gvsig.expressionevaluator.impl.function.string.LocateFunction; |
67 |
import org.gvsig.expressionevaluator.impl.function.string.LowerFunction; |
68 |
import org.gvsig.expressionevaluator.impl.function.string.LpadFunction; |
69 |
import org.gvsig.expressionevaluator.impl.function.string.PositionFunction; |
70 |
import org.gvsig.expressionevaluator.impl.function.string.RTrimFunction; |
71 |
import org.gvsig.expressionevaluator.impl.function.string.RepeatFunction; |
72 |
import org.gvsig.expressionevaluator.impl.function.string.ReplaceFunction; |
73 |
import org.gvsig.expressionevaluator.impl.function.string.RightFunction; |
74 |
import org.gvsig.expressionevaluator.impl.function.string.RpadFunction; |
75 |
import org.gvsig.expressionevaluator.impl.function.string.SpaceFunction; |
76 |
import org.gvsig.expressionevaluator.impl.function.string.SubstringFunction; |
77 |
import org.gvsig.expressionevaluator.impl.function.string.TrimFunction; |
78 |
import org.gvsig.expressionevaluator.impl.function.string.UpperFunction; |
79 |
import org.gvsig.expressionevaluator.spi.AbstractSymbolTable; |
80 |
|
81 |
/**
|
82 |
*
|
83 |
* @author jjdelcerro
|
84 |
*/
|
85 |
public class SQLSymbolTable extends AbstractSymbolTable { |
86 |
|
87 |
@SuppressWarnings("OverridableMethodCallInConstructor") |
88 |
public SQLSymbolTable() {
|
89 |
super("SQL"); |
90 |
|
91 |
this.addOperator(new AndOperator()); |
92 |
this.addOperator(new AddOperator()); |
93 |
this.addOperator(new DivOperator()); |
94 |
this.addOperator(new EqOperator()); |
95 |
this.addOperator(new IsOperator()); |
96 |
this.addOperator(new GeOperator()); |
97 |
this.addOperator(new GtOperator()); |
98 |
this.addOperator(new LeOperator()); |
99 |
this.addOperator(new LtOperator()); |
100 |
this.addOperator(new ModOperator()); |
101 |
this.addOperator(new NeOperator()); |
102 |
this.addOperator(new ModOperator()); |
103 |
this.addOperator(new MulOperator()); |
104 |
this.addOperator(new NeOperator()); |
105 |
this.addOperator(new NotOperator()); |
106 |
this.addOperator(new OrOperator()); |
107 |
this.addOperator(new SubstOperator()); |
108 |
|
109 |
this.addOperator(new IlikeOperator()); |
110 |
this.addOperator(new LikeOperator()); |
111 |
|
112 |
this.addFunction(new ACosFunction()); |
113 |
this.addFunction(new ASinFunction()); |
114 |
this.addFunction(new ATanFunction()); |
115 |
this.addFunction(new AbsFunction()); |
116 |
this.addFunction(new BitAndFunction()); |
117 |
this.addFunction(new BitOrFunction()); |
118 |
this.addFunction(new BitXorFunction()); |
119 |
this.addFunction(new BitGetFunction()); |
120 |
this.addFunction(new CeilFunction()); |
121 |
this.addFunction(new CosFunction()); |
122 |
this.addFunction(new CoshFunction()); |
123 |
this.addFunction(new CotFunction()); |
124 |
this.addFunction(new DegreesFunction()); |
125 |
this.addFunction(new ExpFunction()); |
126 |
this.addFunction(new FloorFunction()); |
127 |
this.addFunction(new Log10Function()); |
128 |
this.addFunction(new LogFunction()); |
129 |
this.addFunction(new PiFunction()); |
130 |
this.addFunction(new PowFunction()); |
131 |
this.addFunction(new RadiansFunction()); |
132 |
this.addFunction(new RandFunction()); |
133 |
this.addFunction(new RoundFunction()); |
134 |
this.addFunction(new SignFunction()); |
135 |
this.addFunction(new SinFunction()); |
136 |
this.addFunction(new SinhFunction()); |
137 |
this.addFunction(new SqrtFunction()); |
138 |
this.addFunction(new TanFunction()); |
139 |
this.addFunction(new TanhFunction()); |
140 |
this.addFunction(new ZeroFunction()); |
141 |
|
142 |
this.addFunction(new AsciiFunction()); |
143 |
this.addFunction(new CharFunction()); |
144 |
this.addFunction(new ConcatFunction()); |
145 |
this.addFunction(new InstrFunction()); |
146 |
this.addFunction(new LTrimFunction()); |
147 |
this.addFunction(new LeftFunction()); |
148 |
this.addFunction(new LengthFunction()); |
149 |
this.addFunction(new LocateFunction()); |
150 |
this.addFunction(new LowerFunction()); |
151 |
this.addFunction(new LpadFunction()); |
152 |
this.addFunction(new PositionFunction()); |
153 |
this.addFunction(new RTrimFunction()); |
154 |
this.addFunction(new RepeatFunction()); |
155 |
this.addFunction(new ReplaceFunction()); |
156 |
this.addFunction(new RightFunction()); |
157 |
this.addFunction(new RpadFunction()); |
158 |
this.addFunction(new SpaceFunction()); |
159 |
this.addFunction(new SubstringFunction()); |
160 |
this.addFunction(new TrimFunction()); |
161 |
this.addFunction(new UpperFunction()); |
162 |
|
163 |
this.addFunction(new NowFunction()); |
164 |
this.addFunction(new DateFunction()); |
165 |
this.addFunction(new TimeFunction()); |
166 |
this.addFunction(new TimestampFunction()); |
167 |
|
168 |
this.addFunction(new DecodeFunction()); |
169 |
|
170 |
this.addFunction(new IIFFunction()); |
171 |
this.addFunction(new IFNULLFunction()); |
172 |
|
173 |
this.addFunction(new RelativeInstantFunction()); |
174 |
this.addFunction(new RelativeIntervalFunction()); |
175 |
} |
176 |
|
177 |
private void addOperator(Function operator) { |
178 |
this.addFunction(operator);
|
179 |
} |
180 |
|
181 |
} |