/ - Diff - Application: gvSIG desktop - gvSIG

           ("countries"."LASTCENSUS" < 0)) LIMIT 1)),TRUE,FALSE)
       GROUP BY "Long";
     -- Simple
     SELECT
         "Byte", "Bool1", "Long", "Timestamp", "Date", "Time",
         "Bool2", "String", "Bool3", "Double", "Bool4", "Float", "Bool5", "Decimal",
         NVL2("Geometry",ST_AsBinary("Geometry"),NULL), "ID"
       FROM "PUBLIC"."test";

       public void testConstantColumnPrimaryKey() throws Exception {
         JDBCHelper helper = TestUtils.getJDBCHelper();
         JDBCSQLBuilderBase sqlbuilder = helper.createSQLBuilder();
         OperationsFactory operations = helper.getOperations();
         List<String> expectedSQLs = TestUtils.getSQLs("resultSetForSetProvider.sql");
         FeatureStore sourceStore = TestUtils.openSourceStore1();
         TableReference table = operations.createTableReference(
                 "dbtest",
                 sqlbuilder.default_schema(),
                 "test",
                 null
         );
     //    meterle como constantCOlumn ID
         FeatureType featureType = sourceStore.getDefaultFeatureType();
         FeatureQuery query = sourceStore.createFeatureQuery();
         query.setConstantsAttributeNames(new String[]{"ID"});
         ResultSetForSetProviderOperation resultSetForSetProvider = operations.createResultSetForSetProvider(
                 table,
                 null,
                 null,
                 query,
                 featureType,
                 featureType,
 ,
 ,
         );
         String sql = resultSetForSetProvider.getSQL();
         System.out.println("###### SQL:"+sql);
         System.out.println("###### EXP:"+expectedSQLs.get(4));
         assertEquals("ResultSetForSetProvider SQL", expectedSQLs.get(4), sql);
+      }
       // TODO: a?adir un test con where, group y order.
+    }

                 for(String attrName : query.getGroupByColumns() ) {
                     select.group_by(expbuilder.column(attrName));
+                }
             } else {
                 for(String attrName : forcedColumns ) {
                     select.column().name(attrName);
                     columns.add(setType.getAttributeDescriptor(attrName));
+                }
+            }
             select.from().table()

     import org.gvsig.fmap.dal.exception.DataException;
     import org.gvsig.fmap.dal.feature.EditableFeature;
     import org.gvsig.fmap.dal.feature.EditableFeatureAttributeDescriptor;
     import org.gvsig.fmap.dal.feature.EditableFeatureType;
     import org.gvsig.fmap.dal.feature.Feature;
     import org.gvsig.fmap.dal.feature.FeatureAttributeDescriptor;
     import org.gvsig.fmap.dal.feature.FeatureIndexes;
     import org.gvsig.fmap.dal.feature.FeatureQuery;
     import org.gvsig.fmap.dal.feature.FeatureQueryOrder;
-...
                 transformsToUse.getSourceFeatureTypeFrom(this.defaultFeatureType);
             theQueryForProvider.setFeatureTypeId(ftype.getId());
             this.defatulFeatureTypeForProvider = ftype;
             if (transformsToUse.isTransformsOriginalValues()) {
                 theQueryForProvider.clearFilter();
                 FeatureQueryOrder fqo = theQueryForProvider.getOrder();
-...
             return true;
+        }
         @Override
         public FeatureType getDefaultFeatureType() {
             return this.defaultFeatureType;
+        }
         @Override
         public List getFeatureTypes() {
             return Collections.unmodifiableList(this.featureTypes);
+        }
         @Override
         public long getSize() throws DataException {
             this.checkSourceStoreModified();
             if (size < 0) {
-...
+        }
         @Override
         public void delete(Feature feature) throws DataException {
             this.featureToIgnoreNotification = feature;
             this.store.delete(feature);
-...
             this.ownFeaturesModified = true;
+        }
         @Override
         public void insert(EditableFeature feature) throws DataException {
             this.featureToIgnoreNotification = feature;
             this.store.insert(feature);
-...
             this.ownFeaturesModified = true;
+        }
         @Override
         public void update(EditableFeature feature) throws DataException {
             this.featureToIgnoreNotification = feature;
             this.store.update(feature);
-...
             this.ownFeaturesModified = true;
+        }
         @Override
         public void commitChanges() throws DataException {
             this.ignoreChanges = true;
             this.store.commitChanges();
-...
+        }
         @Override
         public FeatureStore getFeatureStore() {
             return store;
+        }

Application: gvSIG desktop

Revision 44854