@Test public void testVirtualTableOrder() throws Exception { FeatureTypeInfo ft = persister.load( getClass() .getResourceAsStream( "/org/geoserver/config/virtualtable_order_error.xml"), FeatureTypeInfo.class); VirtualTable vtc = (VirtualTable) ft.getMetadata().get(FeatureTypeInfo.JDBC_VIRTUAL_TABLE); assertEquals(vtc.getSql(), "select * from table\n"); assertEquals(vtc.getName(), "sqlview"); }
writer.endNode(); writer.startNode("sql"); writer.setValue(vt.getSql()); writer.endNode(); writer.startNode("escapeSql");
public void testInvalidQuery() throws Exception { String sql = dataStore.getVirtualTables().get("riverReduced").getSql(); VirtualTable vt = new VirtualTable("riverPolluted", "SOME EXTRA GARBAGE " + sql); vt.addGeometryMetadatata("geom", LineString.class, -1); try { dataStore.addVirtualTable(vt); fail("Should have failed with invalid sql definition"); } catch (IOException e) { // ok, that's what we expected } }
sql = virtualTable.getSql();
sql = virtualTable.getSql(); escapeSql = virtualTable.isEscapeSql();