Application: gvSIG desktop

  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,

            0,

            0, 

            0

    );

    String sql = resultSetForSetProvider.getSQL();

    System.out.println("###### SQL:"+sql);

    System.out.println("###### EXP:"+expectedSQLs.get(4));

    assertEquals("ResultSetForSetProvider SQL", expectedSQLs.get(4), sql);

  }