svn-gvsig-desktop / trunk / org.gvsig.desktop / org.gvsig.desktop.compat.cdc / org.gvsig.fmap.dal / org.gvsig.fmap.dal.api / src / main / java / org / gvsig / fmap / dal / feature / SQLBuilder_save.java @ 44363
History | View | Annotate | Download (9.02 KB)
1 | 43020 | jjdelcerro | package org.gvsig.fmap.dal.feature; |
---|---|---|---|
2 | |||
3 | import java.util.List; |
||
4 | import org.cresques.cts.IProjection; |
||
5 | import org.gvsig.fmap.geom.Geometry; |
||
6 | import org.gvsig.fmap.geom.primitive.Envelope; |
||
7 | import org.gvsig.tools.dataTypes.DataType; |
||
8 | |||
9 | public interface SQLBuilder_save { |
||
10 | |||
11 | public enum Privilege { |
||
12 | SELECT, |
||
13 | INSERT, |
||
14 | UPDATE, |
||
15 | DELETE, |
||
16 | TRUNCATE, |
||
17 | REFERENCE, |
||
18 | TRIGGER, |
||
19 | ALL |
||
20 | }; |
||
21 | |||
22 | public enum GeometrySupportType { |
||
23 | WKT, |
||
24 | WKB, |
||
25 | EWKB |
||
26 | } |
||
27 | |||
28 | public interface Parameter { |
||
29 | public int getType(); |
||
30 | public String getName(); |
||
31 | public IProjection getCRS();
|
||
32 | public boolean isConstant(); |
||
33 | public Object getValue(); |
||
34 | } |
||
35 | |||
36 | public interface ExpBuilder { |
||
37 | public boolean isEmpty(); |
||
38 | public ExpBuilder set(String value); |
||
39 | public ExpBuilder set(OpBuilder op);
|
||
40 | public ExpBuilder and(String value); |
||
41 | public ExpBuilder and(OpBuilder op);
|
||
42 | public ExpBuilder or(String value); |
||
43 | public ExpBuilder or(OpBuilder op);
|
||
44 | } |
||
45 | |||
46 | public interface ColumnBuilder { |
||
47 | public ColumnBuilder name(String name); |
||
48 | public ColumnBuilder geometry(String name); |
||
49 | public ColumnBuilder expression(String value); |
||
50 | public ColumnBuilder as(String alias); |
||
51 | public String getName(); |
||
52 | public String getAlias(); |
||
53 | public String getExpression(); |
||
54 | } |
||
55 | |||
56 | public interface OpBuilder { |
||
57 | public OpBuilder setop1(String op); |
||
58 | public OpBuilder setop2(String op); |
||
59 | } |
||
60 | |||
61 | public interface FromBuilder { |
||
62 | public FromBuilder table(String tableName); |
||
63 | public FromBuilder table(String dbname, String schemaName, String tableName); |
||
64 | public FromBuilder subquery(String subquery); |
||
65 | public FromBuilder passThrough(String passthrough); |
||
66 | } |
||
67 | |||
68 | public interface SelectBuilder { |
||
69 | public ColumnBuilder column();
|
||
70 | public boolean has_column(String name); |
||
71 | public FromBuilder from();
|
||
72 | public FromBuilder from(String s); |
||
73 | public ExpBuilder where();
|
||
74 | public ExpBuilder where(String s); |
||
75 | public ExpBuilder where(OpBuilder s);
|
||
76 | public SelectBuilder limit(long limit); |
||
77 | public SelectBuilder offset(long offset); |
||
78 | public SelectBuilder add_order_by(String order); |
||
79 | public SelectBuilder add_order_by(String column, boolean ascending); |
||
80 | public boolean has_order_by(); |
||
81 | } |
||
82 | |||
83 | public interface UpdateBuilder { |
||
84 | public UpdateBuilder table(String tableName); |
||
85 | public UpdateBuilder table(String dbName, String schemaName, String tableName); |
||
86 | public UpdateBuilder set(String fieldname, String value); |
||
87 | public UpdateBuilder setGeometry(String fieldname, String value, IProjection crs); |
||
88 | public ExpBuilder where();
|
||
89 | public boolean hasWhere(); |
||
90 | } |
||
91 | |||
92 | public interface InsertBuilder { |
||
93 | public InsertBuilder table(String tableName); |
||
94 | public InsertBuilder table(String dbName, String schemaName, String tableName); |
||
95 | public InsertBuilder set(String fieldname, String value); |
||
96 | public InsertBuilder setGeometry(String fieldname, String value, IProjection crs); |
||
97 | } |
||
98 | |||
99 | public interface DeleteBuilder { |
||
100 | public DeleteBuilder table(String tableid); |
||
101 | public DeleteBuilder table(String dbName, String schemaName, String tableName); |
||
102 | public ExpBuilder where();
|
||
103 | public boolean hasWhere(); |
||
104 | } |
||
105 | |||
106 | public interface AlterTableBuilder { |
||
107 | public AlterTableBuilder table(String tableName); |
||
108 | public AlterTableBuilder table(String dbName, String schemaName, String tableName); |
||
109 | public AlterTableBuilder drop_column(String columnName); |
||
110 | public AlterTableBuilder add_column(String columnName, int type, int type_p, int type_s, boolean isPk, boolean allowNulls, boolean isAutomatic, Object defaultValue); |
||
111 | public AlterTableBuilder alter_column(String columnName, int type, int type_p, int type_s, boolean isPk, boolean allowNulls, boolean isAutomatic, Object defaultValue); |
||
112 | public AlterTableBuilder rename_column(String source, String target); |
||
113 | public List<String> toStrings(); |
||
114 | } |
||
115 | |||
116 | public interface CreateTableBuilder { |
||
117 | public CreateTableBuilder table(String tableName); |
||
118 | public CreateTableBuilder table(String dbname, String schemaName, String tableName); |
||
119 | public CreateTableBuilder add_column(String columnName, int type, int type_p, int type_s, boolean isPk, boolean allowNulls, boolean isAutomatic, Object defaultValue); |
||
120 | public List<String> toStrings(); |
||
121 | } |
||
122 | |||
123 | public interface UpdateTableStatisticsBuilder { |
||
124 | public UpdateTableStatisticsBuilder table(String tableName); |
||
125 | public UpdateTableStatisticsBuilder table(String dbName, String schemaName, String tableName); |
||
126 | public List<String> toStrings(); |
||
127 | } |
||
128 | |||
129 | public interface GrantBuilder { |
||
130 | public GrantBuilder table(String tableName); |
||
131 | public GrantBuilder table(String dbName, String schemaName, String tableName); |
||
132 | public GrantBuilder add(String roleid, Privilege privilege); |
||
133 | public GrantBuilder select(String roleid); |
||
134 | public GrantBuilder insert(String roleid); |
||
135 | public GrantBuilder delete(String roleid); |
||
136 | public GrantBuilder truncate(String roleid); |
||
137 | public GrantBuilder reference(String roleid); |
||
138 | public GrantBuilder trigger(String roleid); |
||
139 | public GrantBuilder all(String roleid); |
||
140 | public GrantBuilder select();
|
||
141 | public GrantBuilder insert();
|
||
142 | public GrantBuilder delete();
|
||
143 | public GrantBuilder truncate();
|
||
144 | public GrantBuilder reference();
|
||
145 | public GrantBuilder trigger();
|
||
146 | public GrantBuilder all();
|
||
147 | public List<String> toStrings(); |
||
148 | } |
||
149 | |||
150 | public interface DropTableBuilder { |
||
151 | public DropTableBuilder table(String tableName); |
||
152 | public DropTableBuilder table(String dbName, String schemaName, String tableName); |
||
153 | public List<String> toStrings(); |
||
154 | } |
||
155 | |||
156 | boolean has_spatial_functions();
|
||
157 | |||
158 | String ST_AsText(String geom); |
||
159 | |||
160 | String ST_AsBinary(String geom); |
||
161 | |||
162 | String ST_AsEWKB(String geom); |
||
163 | |||
164 | String ST_Envelope(String geom); |
||
165 | |||
166 | String ST_ExtentAggregate(String geom); |
||
167 | |||
168 | String ST_UnionAggregate(String geom); |
||
169 | |||
170 | String ST_GeomFromText(String geom, String crs); |
||
171 | |||
172 | String ST_GeomFromWKB(String geom, String crs); |
||
173 | |||
174 | String ST_GeomFromEWKB(String geom, String crs); |
||
175 | |||
176 | String ST_GeomFromText(String geom, int crs); |
||
177 | |||
178 | String ST_GeomFromText(Geometry geom, IProjection crs);
|
||
179 | |||
180 | String ST_GeomFromWKB(Geometry geom, IProjection crs);
|
||
181 | |||
182 | String ST_GeomFromEWKB(Geometry geom, IProjection crs);
|
||
183 | |||
184 | String ST_GeomFromText(Envelope env, IProjection crs);
|
||
185 | |||
186 | String ST_Intersects(String geom1, String geom2); |
||
187 | |||
188 | String ST_Contains(String geom1, String geom2); |
||
189 | |||
190 | String ST_Crosses(String geom1, String geom2); |
||
191 | |||
192 | String ST_IsClosed(String geom1, String geom2); |
||
193 | |||
194 | String ST_Overlaps(String geom1, String geom2); |
||
195 | |||
196 | String ST_Touches(String geom1, String geom2); |
||
197 | |||
198 | String ST_Within(String geom1, String geom2); |
||
199 | |||
200 | String isNull(String s); |
||
201 | |||
202 | String default_schema();
|
||
203 | |||
204 | String count(String column); |
||
205 | |||
206 | String lcase(String s); |
||
207 | |||
208 | String ucase(String s); |
||
209 | |||
210 | String getWKT(Geometry geom);
|
||
211 | byte[] getWKB(Geometry geom); |
||
212 | byte[] getEWKB(Geometry geom); |
||
213 | |||
214 | String getWKT(Envelope env);
|
||
215 | byte[] getWKB(Envelope env); |
||
216 | byte[] getEWKB(Envelope env); |
||
217 | |||
218 | String geometry(Geometry geom, IProjection crs);
|
||
219 | |||
220 | String geometry(Envelope env, IProjection crs);
|
||
221 | |||
222 | String string(String s); |
||
223 | |||
224 | String identifier(String id); |
||
225 | |||
226 | String bytearray(byte[] data); |
||
227 | |||
228 | String crs(String crs); |
||
229 | |||
230 | String crs(IProjection crs);
|
||
231 | |||
232 | String sqltype(int dataType, int p, int s); |
||
233 | |||
234 | GeometrySupportType geometry_support_type(); |
||
235 | |||
236 | OpBuilder and(String op1, String op2); |
||
237 | |||
238 | OpBuilder or(String op1, String op2); |
||
239 | |||
240 | OpBuilder eq(String op1, String op2); |
||
241 | |||
242 | OpBuilder ne(String op1, String op2); |
||
243 | |||
244 | OpBuilder gt(String op1, String op2); |
||
245 | |||
246 | OpBuilder ge(String op1, String op2); |
||
247 | |||
248 | OpBuilder lt(String op1, String op2); |
||
249 | |||
250 | OpBuilder le(String op1, String op2); |
||
251 | |||
252 | OpBuilder like(String op1, String op2); |
||
253 | |||
254 | OpBuilder ilike(String op1, String op2); |
||
255 | |||
256 | ExpBuilder createExpresionBuilder(String x);
|
||
257 | |||
258 | ExpBuilder createExpresionBuilder(OpBuilder x); |
||
259 | |||
260 | ExpBuilder createExpresionBuilder(); |
||
261 | |||
262 | void clearParameters();
|
||
263 | |||
264 | void addParameter(DataType type, String name); |
||
265 | |||
266 | void addParameter(int type, String name); |
||
267 | |||
268 | void addParameter(int type, String name, IProjection crs); |
||
269 | |||
270 | void addConstantParameter(Object value); |
||
271 | |||
272 | List<Parameter> getParameters();
|
||
273 | |||
274 | SelectBuilder select(); |
||
275 | |||
276 | UpdateBuilder update(); |
||
277 | |||
278 | InsertBuilder insert(); |
||
279 | |||
280 | DeleteBuilder delete(); |
||
281 | |||
282 | AlterTableBuilder alter_table(); |
||
283 | |||
284 | CreateTableBuilder create_table(); |
||
285 | |||
286 | GrantBuilder grant(); |
||
287 | |||
288 | DropTableBuilder drop_table(); |
||
289 | |||
290 | UpdateTableStatisticsBuilder update_table_statistics(); |
||
291 | } |