Mercurial > dive4elements > gnv-client
comparison 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 |
comparison
equal
deleted
inserted
replaced
| 895:eb777022b628 | 896:c7756576044f |
|---|---|
| 94 M.MESHID = MEDIAN.MESHPOINT.MESHID AND \ | 94 M.MESHID = MEDIAN.MESHPOINT.MESHID AND \ |
| 95 INTERSECTS(SHAPE, \ | 95 INTERSECTS(SHAPE, \ |
| 96 (SELECT st_astext(SHAPE) FROM MEDIAN.FEATUREAREA WHERE (FEATURETYPE = 7 OR FEATURETYPE = 8) AND FEATURECODE = 41 )\ | 96 (SELECT st_astext(SHAPE) FROM MEDIAN.FEATUREAREA WHERE (FEATURETYPE = 7 OR FEATURETYPE = 8) AND FEATURECODE = 41 )\ |
| 97 ) \ | 97 ) \ |
| 98 order by M.NAME | 98 order by M.NAME |
| 99 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 | |
| 100 | |
| 101 | |
| 102 updated_tables = SELECT FULLTABLENAME \ | |
| 103 FROM MEDIAN.LASTUPDATED \ | |
| 104 WHERE LASTUPDATE >= to_date('?', 'YYYY.MM.DD HH24:MI:SS') |