Mercurial > dive4elements > gnv-client
diff geo-backend/src/test/ressources/QueryExecutorTestCase.properties @ 896:c7756576044f
Integrated Testcase for testing the Basefunctionality of the CacheCleaner
geo-backend/trunk@959 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Tim Englich <tim.englich@intevation.de> |
|---|---|
| date | Tue, 20 Apr 2010 12:46:40 +0000 |
| parents | 31595c0a1a33 |
| children |
line wrap: on
line diff
--- a/geo-backend/src/test/ressources/QueryExecutorTestCase.properties Tue Apr 20 12:42:17 2010 +0000 +++ b/geo-backend/src/test/ressources/QueryExecutorTestCase.properties Tue Apr 20 12:46:40 2010 +0000 @@ -96,3 +96,9 @@ (SELECT st_astext(SHAPE) FROM MEDIAN.FEATUREAREA WHERE (FEATURETYPE = 7 OR FEATURETYPE = 8) AND FEATURECODE = 41 )\ ) \ order by M.NAME +test_regionfilter = SELECT M.OBJECTID KEY, M.NAME VALUE FROM MEDIAN.MESHPOINT, MEDIAN.MESH M WHERE M.SOURCEID IN (2) AND M.MESHID = MEDIAN.MESHPOINT.MESHID AND INTERSECTS(SHAPE, (SELECT st_astext(SHAPE) FROM MEDIAN.FEATUREAREA WHERE (FEATURETYPE = 7 OR FEATURETYPE = 8) AND FEATURECODE = ? )) order by M.NAME + + +updated_tables = SELECT FULLTABLENAME \ + FROM MEDIAN.LASTUPDATED \ + WHERE LASTUPDATE >= to_date('?', 'YYYY.MM.DD HH24:MI:SS')