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