Revision 43739 trunk/org.gvsig.desktop/org.gvsig.desktop.compat.cdc/org.gvsig.fmap.dal/org.gvsig.fmap.dal.db/org.gvsig.fmap.dal.db.h2/src/main/java/org/gvsig/fmap/dal/store/h2/H2SpatialSQLBuilder.java
H2SpatialSQLBuilder.java | ||
---|---|---|
1 | 1 |
package org.gvsig.fmap.dal.store.h2; |
2 | 2 |
|
3 | 3 |
import java.sql.PreparedStatement; |
4 |
import java.sql.SQLException; |
|
5 | 4 |
import java.text.MessageFormat; |
6 | 5 |
import java.util.ArrayList; |
7 | 6 |
import java.util.Date; |
... | ... | |
146 | 145 |
builder.append(identifier(column)); |
147 | 146 |
sqls.add(builder.toString()); |
148 | 147 |
} |
149 |
for (ColumnDescriptorBuilderBase column : adds) {
|
|
148 |
for (ColumnDescriptor column : adds) { |
|
150 | 149 |
StringBuilder builder = new StringBuilder(); |
151 | 150 |
builder.append("ALTER TABLE "); |
152 | 151 |
builder.append(this.table.toString()); |
... | ... | |
198 | 197 |
sqls.add(sql); |
199 | 198 |
} |
200 | 199 |
} |
201 |
for (ColumnDescriptorBuilderBase column : alters) {
|
|
200 |
for (ColumnDescriptor column : alters) { |
|
202 | 201 |
StringBuilder builder = new StringBuilder(); |
203 | 202 |
builder.append("ALTER TABLE "); |
204 | 203 |
builder.append(this.table.toString()); |
... | ... | |
267 | 266 |
builder.append(this.table.toString()); |
268 | 267 |
builder.append(" ("); |
269 | 268 |
boolean first = true; |
270 |
for (ColumnDescriptorBuilder column : columns) {
|
|
269 |
for (ColumnDescriptor column : columns) { |
|
271 | 270 |
|
272 | 271 |
if (first) { |
273 | 272 |
first = false; |
... | ... | |
315 | 314 |
} |
316 | 315 |
builder.append(" )"); |
317 | 316 |
sqls.add(builder.toString()); |
318 |
for (ColumnDescriptorBuilderBase column : columns) {
|
|
317 |
for (ColumnDescriptor column : columns) { |
|
319 | 318 |
if( column.isGeometry() ) { |
320 | 319 |
String sql; |
321 | 320 |
String constraint_name = "constraint_" + this.table().getName() + "_" + column.getName()+"_dim"; |
Also available in: Unified diff