Examples of GSVirtualTableEncoder

it.geosolutions.geoserver.rest.encoder.metadata.virtualtable.GSVirtualTableEncoder

geoserver.org/latest/en/user/data/database/sqlview.html#parameterizing-sql-views}):

 {
@code // Set-up the vtGeom final VTGeometryEncoder vtGeom = new VTGeometryEncoder(); vtGeom.setName("the_geom"); vtGeom.setType("MultiPolygon"); vtGeom.setSrid("4326"); // Set-up 2 virtual table parameters final VTParameterEncoder vtParam1 = new VTParameterEncoder("high", "100000000", "^[\\d]+$"); final VTParameterEncoder vtParam2 = new VTParameterEncoder("low", "0", "^[\\d]+$"); // sql String sql = "select gid, state_name, the_geom from pgstates where persons between %low% and %high%"; // Set-up the virtual table final GSVirtualTableEncoder vte = new GSVirtualTableEncoder(); vte.setName("popstates"); vte.setSql("select gid, state_name, the_geom from pgstates where persons between %low% and %high%"); vte.addKeyColumn("gid"); vte.addVirtualTableGeometry(vtGeom); vte.addVirtualTableParameter(vtParam1); vte.addVirtualTableParameter(vtParam2); }

For this example, the XML output is:

 {@code  popstates select gid, state_name, the_geom from pgstates where persons between %low% and %high%  the_geom MultiPolygon 4326  gid  high 100000000 ^[\d]+$   low 0 ^[\d]+$  }

@author Emmanuel Blondel - emmanuel.blondel1@gmail.com |emmanuel.blondel@fao.org

Examples of it.geosolutions.geoserver.rest.encoder.metadata.virtualtable.GSVirtualTableEncoder


        // sql
        String sql = "select gid, state_name, the_geom from pgstates where persons between %low% and %high% and state_abbr = '%state%'";


        // set-up the virtual table
        final GSVirtualTableEncoder vte = new GSVirtualTableEncoder();
        vte.setName(nativeName);
        vte.setSql(sql);
        vte.addVirtualTableGeometry(vtGeom);
        vte.addVirtualTableParameter(vtParam1);
        vte.addVirtualTableParameter(vtParam2);


        // modif the vte
        vte.delVirtualTableGeometry("the_geom");
        vte.addVirtualTableGeometry("the_geom", "MultiPolygon", "4326");


        final VTParameterEncoder vtParam3 = new VTParameterEncoder("state", "FL", "^[\\w\\d\\s]+$");
        vte.addVirtualTableParameter(vtParam3);
        vte.addKeyColumn("gid");


        fte.setMetadataVirtualTable(vte); // Set the virtual table


        // Layer encoder
        // -------------

View Full Code Here

Examples of it.geosolutions.geoserver.rest.encoder.metadata.virtualtable.GSVirtualTableEncoder


    // sql
    String sql = "select the_geom, id, field1, field2 from mytable where field1 = '%fieldname1%' and field2 = '%fieldname2%'";


    // Set-up the virtual table
    final GSVirtualTableEncoder vte = new GSVirtualTableEncoder();
    vte.setName("mysqlview");
    vte.setSql(sql);
    vte.addKeyColumn("id");
    vte.addVirtualTableGeometry(vtGeom);
    vte.addVirtualTableParameter(vtParam1);
    vte.addVirtualTableParameter(vtParam2);


    // TESTS


    Assert.assertEquals("mysqlview", vte.getName());
    Assert.assertEquals(sql, vte.getSql());
    Assert.assertEquals("id", vte.getRoot().getChildText("keyColumn"));


    final Element ge = (Element) vte.getRoot().getChild("geometry");
    Assert.assertEquals("the_geom",
        ge.getChildText(VTGeometry.name.toString()));
    Assert.assertEquals("MultiPolygon",
        ge.getChildText(VTGeometry.type.toString()));
    Assert.assertEquals("4326", ge.getChildText(VTGeometry.srid.toString()));


    final Element p1 = (Element) vte.getRoot().getChildren("parameter")
        .get(0);
    final Element p2 = (Element) vte.getRoot().getChildren("parameter")
        .get(1);
    Assert.assertEquals("fieldname1",
        p1.getChildText(VTParameter.name.toString()));
    Assert.assertEquals("default_value1",
        p1.getChildText(VTParameter.defaultValue.toString()));
    Assert.assertEquals("^[\\w\\d\\s]+$",
        p1.getChildText(VTParameter.regexpValidator.toString()));
    Assert.assertEquals("fieldname2",
        p2.getChildText(VTParameter.name.toString()));
    Assert.assertEquals("default_value2",
        p2.getChildText(VTParameter.defaultValue.toString()));
    Assert.assertEquals("^[\\w\\d\\s]+$",
        p2.getChildText(VTParameter.regexpValidator.toString()));


    vte.delKeyColumn("id");
    Assert.assertNull(vte.getRoot().getChildText("keyColumn"));
    Assert.assertEquals("mysqlview", vte.getName());
    Assert.assertEquals(sql, vte.getSql());


    vtGeom.setType("Point");
    vtParam1.setName("newfieldname");


    Assert.assertEquals("Point",
        ((Element) vte.getRoot().getChildren("geometry").get(0))
            .getChildText(VTGeometry.type.toString()));
    Assert.assertEquals("newfieldname", ((Element) vte.getRoot()
        .getChildren("parameter").get(0)).getChildText(VTParameter.name
        .toString()));


    Assert.assertTrue(vtGeom.delSrid());
    Assert.assertTrue(vtParam1.delRegexpValidator());

View Full Code Here

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.