Hi,
I think I'm done with the first implementation of the parametrized
sql views proposal implementation:
http://geoserver.org/display/GEOS/GSIP+48+-+Parametric+SQL+views+in+GeoServer
I've attached a patch to http://jira.codehaus.org/browse/GEOS-4047 for
anyone that wants to review.
The patch depends on two other patches that are still pending,
http://jira.codehaus.org/browse/GEOT-3181 and
http://jira.codehaus.org/browse/GEOT-3158
so if you want to try it out you'll fist have to patch also Geotools.
What's in the patch? Pretty much everything that the GSIP involved:
- ability to add a parametric view as a new layer
- visual editors for the sql queries and the params
- full configuration storage and resource pool changes to handle
the views
- ability to specify parameter values in GetMap and GetFeature requests
- user documentation (the patch is missing the pngs)
What is missing? Well, if it was Christmas I would ask for a H2 based
test harness allowing to actually test parametrized GetMap and
GetFeature against a database.
Missing that I added tests for KVP readers and all the low level
persistence stuff.
Reviews and comments welcomed. If there are no complaints I'll
commit the patch in a few days, GT dependent patches permitting.
Cheers
Andrea
--
Andrea Aime
OpenGeo - http://opengeo.org
Expert service straight from the developers.