svn-gvsig-desktop / trunk / org.gvsig.desktop / org.gvsig.desktop.compat.cdc / org.gvsig.fmap.dal / org.gvsig.fmap.dal.impl / src / main / java / org / gvsig / expressionevaluator / impl / grammars / DataAccessGrammarFactory.java @ 44748
History | View | Annotate | Download (7.91 KB)
1 | 44738 | jjdelcerro | /**
|
---|---|---|---|
2 | * gvSIG. Desktop Geographic Information System.
|
||
3 | *
|
||
4 | * Copyright (C) 2007-2020 gvSIG Association.
|
||
5 | *
|
||
6 | * This program is free software; you can redistribute it and/or
|
||
7 | * modify it under the terms of the GNU General Public License
|
||
8 | * as published by the Free Software Foundation; either version 3
|
||
9 | * of the License, or (at your option) any later version.
|
||
10 | *
|
||
11 | * This program is distributed in the hope that it will be useful,
|
||
12 | * but WITHOUT ANY WARRANTY; without even the implied warranty of
|
||
13 | * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
|
||
14 | * GNU General Public License for more details.
|
||
15 | *
|
||
16 | * You should have received a copy of the GNU General Public License
|
||
17 | * along with this program; if not, write to the Free Software
|
||
18 | * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston,
|
||
19 | * MA 02110-1301, USA.
|
||
20 | *
|
||
21 | * For any additional information, do not hesitate to contact us
|
||
22 | * at info AT gvsig.com, or visit our website www.gvsig.com.
|
||
23 | */
|
||
24 | package org.gvsig.expressionevaluator.impl.grammars; |
||
25 | |||
26 | import java.util.UUID; |
||
27 | import org.gvsig.expressionevaluator.Code; |
||
28 | import org.gvsig.expressionevaluator.Code.Caller; |
||
29 | import org.gvsig.expressionevaluator.CodeBuilder; |
||
30 | import org.gvsig.expressionevaluator.ExpressionEvaluatorLocator; |
||
31 | import org.gvsig.expressionevaluator.ExpressionEvaluatorManager; |
||
32 | import org.gvsig.expressionevaluator.Grammar; |
||
33 | import org.gvsig.expressionevaluator.Statement; |
||
34 | import org.gvsig.expressionevaluator.Statement.StatementContext; |
||
35 | import org.gvsig.expressionevaluator.impl.DALFunctions; |
||
36 | import org.gvsig.expressionevaluator.impl.DefaultCodeBuilder.BaseCodes; |
||
37 | import org.gvsig.expressionevaluator.impl.DefaultStatement; |
||
38 | import org.gvsig.expressionevaluator.impl.DefaultStatement.ArgsBuilderFromNames; |
||
39 | import org.gvsig.expressionevaluator.impl.function.dataaccess.ExistsFunction; |
||
40 | import org.gvsig.expressionevaluator.spi.AbstractGrammarFactory; |
||
41 | 44748 | jjdelcerro | import static org.gvsig.fmap.dal.DataManager.FUNCTION_FOREING_VALUE; |
42 | import static org.gvsig.fmap.dal.DataManager.FUNCTION_SELECT; |
||
43 | import static org.gvsig.fmap.dal.DataManager.FUNCTION_SELECT_COUNT; |
||
44 | 44738 | jjdelcerro | |
45 | /**
|
||
46 | *
|
||
47 | * @author jjdelcerro
|
||
48 | */
|
||
49 | public class DataAccessGrammarFactory extends AbstractGrammarFactory { |
||
50 | |||
51 | private Grammar grammar;
|
||
52 | |||
53 | private class ExistsStatementBuilder extends DefaultStatement.StatementBuilderBase { |
||
54 | |||
55 | 44748 | jjdelcerro | private final String listID; |
56 | private final String existsID; |
||
57 | 44738 | jjdelcerro | |
58 | 44748 | jjdelcerro | public ExistsStatementBuilder(String listID, String existsID) { |
59 | super(ExistsFunction.NAME, new ArgsBuilderFromNames(listID,existsID)); |
||
60 | this.listID = listID;
|
||
61 | this.existsID = existsID;
|
||
62 | 44738 | jjdelcerro | } |
63 | |||
64 | @Override
|
||
65 | public Code build(StatementContext context) {
|
||
66 | |||
67 | CodeBuilder codeBuilder = context.getCodeBuilder(); |
||
68 | Caller code = (Caller) super.build(context);
|
||
69 | BaseCodes args = (BaseCodes) code.parameters(); |
||
70 | 44748 | jjdelcerro | if( args.size()<2 || args.get("ID")==null ) { |
71 | String exists_id = "EXISTS"+UUID.randomUUID().toString().replaceAll("-", ""); |
||
72 | args.add("ID", codeBuilder.constant(exists_id));
|
||
73 | } |
||
74 | 44738 | jjdelcerro | code = codeBuilder.function(ExistsFunction.NAME, args); |
75 | return code;
|
||
76 | } |
||
77 | |||
78 | } |
||
79 | 44740 | jjdelcerro | |
80 | 44738 | jjdelcerro | public DataAccessGrammarFactory() {
|
81 | super(DALFunctions.GRAMMAR_NAME, true); |
||
82 | } |
||
83 | |||
84 | @Override
|
||
85 | public Grammar create(Object... parameters) { |
||
86 | ExpressionEvaluatorManager manager = ExpressionEvaluatorLocator.getManager(); |
||
87 | if( this.grammar==null ) { |
||
88 | Grammar theGrammar = manager.createGrammar(this.getName());
|
||
89 | Statement stmt;
|
||
90 | |||
91 | theGrammar.addReservedWord("EXISTS");
|
||
92 | theGrammar.addReservedWord("SELECT");
|
||
93 | theGrammar.addReservedWord("FROM");
|
||
94 | theGrammar.addReservedWord("WHERE");
|
||
95 | theGrammar.addReservedWord("ORDER");
|
||
96 | theGrammar.addReservedWord("DESC");
|
||
97 | theGrammar.addReservedWord("ASC");
|
||
98 | theGrammar.addReservedWord("BY");
|
||
99 | |||
100 | stmt = theGrammar.createStatement("EXISTS");
|
||
101 | stmt.addRule(stmt.require_any_token("EXISTS"));
|
||
102 | 44748 | jjdelcerro | stmt.addRule(stmt.require_any_token("("));
|
103 | 44738 | jjdelcerro | stmt.addRule(stmt.require_expression("LIST"));
|
104 | 44748 | jjdelcerro | stmt.addRule(stmt.optional_any_token(",")
|
105 | .addRuleOnTrue(stmt.require_expression("ID"))
|
||
106 | ); |
||
107 | stmt.addRule(stmt.require_any_token(")"));
|
||
108 | stmt.builder(new ExistsStatementBuilder("LIST","ID")); |
||
109 | 44738 | jjdelcerro | theGrammar.addStatement(stmt); |
110 | |||
111 | 44740 | jjdelcerro | stmt = theGrammar.createStatement("FOREING_VALUE");
|
112 | stmt.addRule(stmt.require_any_token("FOREING"));
|
||
113 | stmt.addRule(stmt.require_any_token("VALUE"));
|
||
114 | stmt.addRule(stmt.require_any_token("FROM"));
|
||
115 | stmt.addRule(stmt.require_identifiers("IDENTIFIERS",".")); |
||
116 | stmt.code( |
||
117 | 44748 | jjdelcerro | FUNCTION_FOREING_VALUE, |
118 | 44740 | jjdelcerro | stmt.args_names("IDENTIFIERS")
|
119 | ); |
||
120 | theGrammar.addStatement(stmt); |
||
121 | 44738 | jjdelcerro | |
122 | stmt = theGrammar.createStatement("SELECT");
|
||
123 | stmt.addRule(stmt.require_any_token("SELECT"));
|
||
124 | stmt.addRule(stmt.require_any_token("*","1")); |
||
125 | stmt.addRule(stmt.require_any_token("FROM"));
|
||
126 | stmt.addRule(stmt.require_identifier("TABLE"));
|
||
127 | stmt.addRule(stmt.optional_any_token("WHERE")
|
||
128 | .addRuleOnTrue(stmt.require_expression("WHERE"))
|
||
129 | ); |
||
130 | |||
131 | stmt.addRule(stmt.optional_any_token("ORDER")
|
||
132 | .addRuleOnTrue(stmt.require_any_token("BY"))
|
||
133 | .addRuleOnTrue( |
||
134 | stmt.repeat() |
||
135 | .addRule(stmt.require_expression("ORDER#"))
|
||
136 | .addRule(stmt.switch_token() |
||
137 | .addCase("ASC",
|
||
138 | stmt.set_expression("ORDER_MODE#", true) |
||
139 | ) |
||
140 | .addCase("DESC",
|
||
141 | stmt.set_expression("ORDER_MODE#", false) |
||
142 | ) |
||
143 | .addDefault( |
||
144 | stmt.set_expression("ORDER_MODE#", true) |
||
145 | ) |
||
146 | ) |
||
147 | .addRule( |
||
148 | stmt.optional_any_token(",")
|
||
149 | .addRuleOnFalse(stmt.break_loop()) |
||
150 | ) |
||
151 | ) |
||
152 | ); |
||
153 | stmt.addRule(stmt.optional_any_token("LIMIT")
|
||
154 | .addRuleOnTrue(stmt.require_expression("LIMIT"))
|
||
155 | ); |
||
156 | stmt.addRule(stmt.require_any_token(";"));
|
||
157 | stmt.code( |
||
158 | 44748 | jjdelcerro | FUNCTION_SELECT, |
159 | 44738 | jjdelcerro | stmt.args_names("TABLE","WHERE","ORDER#","ORDER_MODE#","LIMIT") |
160 | ); |
||
161 | theGrammar.addStatement(stmt); |
||
162 | |||
163 | stmt = theGrammar.createStatement("SELECT_COUNT");
|
||
164 | stmt.addRule(stmt.require_any_token("SELECT"));
|
||
165 | stmt.addRule(stmt.require_any_token("COUNT"));
|
||
166 | stmt.addRule(stmt.require_any_token("("));
|
||
167 | stmt.addRule(stmt.require_any_token("*"));
|
||
168 | stmt.addRule(stmt.require_any_token(")"));
|
||
169 | stmt.addRule(stmt.require_any_token("FROM"));
|
||
170 | stmt.addRule(stmt.require_identifier("TABLE"));
|
||
171 | stmt.addRule(stmt.optional_any_token("WHERE")
|
||
172 | .addRuleOnTrue(stmt.require_expression("WHERE"))
|
||
173 | ); |
||
174 | stmt.addRule(stmt.require_any_token(";"));
|
||
175 | stmt.code( |
||
176 | 44748 | jjdelcerro | FUNCTION_SELECT_COUNT, |
177 | 44738 | jjdelcerro | stmt.args_names("TABLE","WHERE") |
178 | ); |
||
179 | theGrammar.addStatement(stmt); |
||
180 | |||
181 | this.grammar = theGrammar;
|
||
182 | } |
||
183 | return grammar;
|
||
184 | } |
||
185 | |||
186 | public static final void selfRegister() { |
||
187 | ExpressionEvaluatorManager manager = ExpressionEvaluatorLocator.getManager(); |
||
188 | manager.registerGrammar(new DataAccessGrammarFactory());
|
||
189 | } |
||
190 | } |