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 @ 44053
History | View | Annotate | Download (9.11 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 | 44038 | jjdelcerro | import org.gvsig.expressionevaluator.impl.function.obj.IFNULLFunction; |
38 | import org.gvsig.expressionevaluator.impl.function.obj.IIFFunction; |
||
39 | 43983 | jjdelcerro | import org.gvsig.expressionevaluator.impl.function.operator.AddOperator; |
40 | import org.gvsig.expressionevaluator.impl.function.operator.AndOperator; |
||
41 | import org.gvsig.expressionevaluator.impl.function.operator.DivOperator; |
||
42 | import org.gvsig.expressionevaluator.impl.function.operator.EqOperator; |
||
43 | import org.gvsig.expressionevaluator.impl.function.operator.GeOperator; |
||
44 | import org.gvsig.expressionevaluator.impl.function.operator.GtOperator; |
||
45 | 44009 | jjdelcerro | import org.gvsig.expressionevaluator.impl.function.operator.IsOperator; |
46 | 43983 | jjdelcerro | import org.gvsig.expressionevaluator.impl.function.operator.LeOperator; |
47 | import org.gvsig.expressionevaluator.impl.function.operator.LtOperator; |
||
48 | import org.gvsig.expressionevaluator.impl.function.operator.ModOperator; |
||
49 | import org.gvsig.expressionevaluator.impl.function.operator.MulOperator; |
||
50 | import org.gvsig.expressionevaluator.impl.function.operator.NeOperator; |
||
51 | import org.gvsig.expressionevaluator.impl.function.operator.NotOperator; |
||
52 | import org.gvsig.expressionevaluator.impl.function.operator.OrOperator; |
||
53 | import org.gvsig.expressionevaluator.impl.function.operator.SubstOperator; |
||
54 | import org.gvsig.expressionevaluator.impl.function.predicate.IlikeOperator; |
||
55 | import org.gvsig.expressionevaluator.impl.function.predicate.LikeOperator; |
||
56 | import org.gvsig.expressionevaluator.impl.function.string.AsciiFunction; |
||
57 | import org.gvsig.expressionevaluator.impl.function.string.CharFunction; |
||
58 | import org.gvsig.expressionevaluator.impl.function.string.ConcatFunction; |
||
59 | 44006 | jjdelcerro | import org.gvsig.expressionevaluator.impl.function.string.DecodeFunction; |
60 | 43983 | jjdelcerro | import org.gvsig.expressionevaluator.impl.function.string.InstrFunction; |
61 | import org.gvsig.expressionevaluator.impl.function.string.LTrimFunction; |
||
62 | import org.gvsig.expressionevaluator.impl.function.string.LeftFunction; |
||
63 | import org.gvsig.expressionevaluator.impl.function.string.LengthFunction; |
||
64 | import org.gvsig.expressionevaluator.impl.function.string.LocateFunction; |
||
65 | import org.gvsig.expressionevaluator.impl.function.string.LowerFunction; |
||
66 | import org.gvsig.expressionevaluator.impl.function.string.LpadFunction; |
||
67 | import org.gvsig.expressionevaluator.impl.function.string.PositionFunction; |
||
68 | import org.gvsig.expressionevaluator.impl.function.string.RTrimFunction; |
||
69 | import org.gvsig.expressionevaluator.impl.function.string.RepeatFunction; |
||
70 | import org.gvsig.expressionevaluator.impl.function.string.ReplaceFunction; |
||
71 | import org.gvsig.expressionevaluator.impl.function.string.RightFunction; |
||
72 | import org.gvsig.expressionevaluator.impl.function.string.RpadFunction; |
||
73 | import org.gvsig.expressionevaluator.impl.function.string.SpaceFunction; |
||
74 | import org.gvsig.expressionevaluator.impl.function.string.SubstringFunction; |
||
75 | import org.gvsig.expressionevaluator.impl.function.string.TrimFunction; |
||
76 | import org.gvsig.expressionevaluator.impl.function.string.UpperFunction; |
||
77 | import org.gvsig.expressionevaluator.spi.AbstractSymbolTable; |
||
78 | |||
79 | /**
|
||
80 | *
|
||
81 | * @author jjdelcerro
|
||
82 | */
|
||
83 | public class SQLSymbolTable extends AbstractSymbolTable { |
||
84 | |||
85 | 43987 | jjdelcerro | @SuppressWarnings("OverridableMethodCallInConstructor") |
86 | 43983 | jjdelcerro | public SQLSymbolTable() {
|
87 | super("SQL"); |
||
88 | |||
89 | this.addOperator(new AndOperator()); |
||
90 | this.addOperator(new AddOperator()); |
||
91 | this.addOperator(new DivOperator()); |
||
92 | this.addOperator(new EqOperator()); |
||
93 | 44009 | jjdelcerro | this.addOperator(new IsOperator()); |
94 | 43983 | jjdelcerro | this.addOperator(new GeOperator()); |
95 | this.addOperator(new GtOperator()); |
||
96 | this.addOperator(new LeOperator()); |
||
97 | this.addOperator(new LtOperator()); |
||
98 | this.addOperator(new ModOperator()); |
||
99 | this.addOperator(new NeOperator()); |
||
100 | this.addOperator(new ModOperator()); |
||
101 | this.addOperator(new MulOperator()); |
||
102 | this.addOperator(new NeOperator()); |
||
103 | this.addOperator(new NotOperator()); |
||
104 | this.addOperator(new OrOperator()); |
||
105 | this.addOperator(new SubstOperator()); |
||
106 | |||
107 | this.addOperator(new IlikeOperator()); |
||
108 | this.addOperator(new LikeOperator()); |
||
109 | |||
110 | this.addFunction(new ACosFunction()); |
||
111 | this.addFunction(new ASinFunction()); |
||
112 | this.addFunction(new ATanFunction()); |
||
113 | this.addFunction(new AbsFunction()); |
||
114 | this.addFunction(new BitAndFunction()); |
||
115 | this.addFunction(new BitOrFunction()); |
||
116 | this.addFunction(new BitXorFunction()); |
||
117 | 44053 | omartinez | this.addFunction(new BitGetFunction()); |
118 | 43983 | jjdelcerro | this.addFunction(new CeilFunction()); |
119 | this.addFunction(new CosFunction()); |
||
120 | this.addFunction(new CoshFunction()); |
||
121 | this.addFunction(new CotFunction()); |
||
122 | this.addFunction(new DegreesFunction()); |
||
123 | this.addFunction(new ExpFunction()); |
||
124 | this.addFunction(new FloorFunction()); |
||
125 | this.addFunction(new Log10Function()); |
||
126 | this.addFunction(new LogFunction()); |
||
127 | this.addFunction(new PiFunction()); |
||
128 | this.addFunction(new PowFunction()); |
||
129 | this.addFunction(new RadiansFunction()); |
||
130 | this.addFunction(new RandFunction()); |
||
131 | this.addFunction(new RoundFunction()); |
||
132 | this.addFunction(new SignFunction()); |
||
133 | this.addFunction(new SinFunction()); |
||
134 | this.addFunction(new SinhFunction()); |
||
135 | this.addFunction(new SqrtFunction()); |
||
136 | this.addFunction(new TanFunction()); |
||
137 | this.addFunction(new TanhFunction()); |
||
138 | this.addFunction(new ZeroFunction()); |
||
139 | |||
140 | this.addFunction(new AsciiFunction()); |
||
141 | this.addFunction(new CharFunction()); |
||
142 | this.addFunction(new ConcatFunction()); |
||
143 | this.addFunction(new InstrFunction()); |
||
144 | this.addFunction(new LTrimFunction()); |
||
145 | this.addFunction(new LeftFunction()); |
||
146 | this.addFunction(new LengthFunction()); |
||
147 | this.addFunction(new LocateFunction()); |
||
148 | this.addFunction(new LowerFunction()); |
||
149 | this.addFunction(new LpadFunction()); |
||
150 | this.addFunction(new PositionFunction()); |
||
151 | this.addFunction(new RTrimFunction()); |
||
152 | this.addFunction(new RepeatFunction()); |
||
153 | this.addFunction(new ReplaceFunction()); |
||
154 | this.addFunction(new RightFunction()); |
||
155 | this.addFunction(new RpadFunction()); |
||
156 | this.addFunction(new SpaceFunction()); |
||
157 | this.addFunction(new SubstringFunction()); |
||
158 | this.addFunction(new TrimFunction()); |
||
159 | this.addFunction(new UpperFunction()); |
||
160 | |||
161 | 43987 | jjdelcerro | this.addFunction(new NowFunction()); |
162 | this.addFunction(new DateFunction()); |
||
163 | this.addFunction(new TimeFunction()); |
||
164 | this.addFunction(new TimestampFunction()); |
||
165 | 44006 | jjdelcerro | |
166 | this.addFunction(new DecodeFunction()); |
||
167 | 44038 | jjdelcerro | |
168 | this.addFunction(new IIFFunction()); |
||
169 | this.addFunction(new IFNULLFunction()); |
||
170 | 43983 | jjdelcerro | } |
171 | |||
172 | private void addOperator(Function operator) { |
||
173 | this.addFunction(operator);
|
||
174 | } |
||
175 | |||
176 | } |