public int deleteCascade ( SpatialReferenceSystem srs ) throws SQLException { int count = 0 ; if ( srs != null ) { // Delete Contents ForeignCollection < Contents > contentsCollection = srs . getContents ( ) ; if ( ! contentsCollection . isEmpty ( ) ) { ContentsDao dao = getContentsDao ( ) ; dao . deleteCascade ( contentsCollection ) ; } // Delete Geometry Columns GeometryColumnsDao geometryColumnsDao = getGeometryColumnsDao ( ) ; if ( geometryColumnsDao . isTableExists ( ) ) { ForeignCollection < GeometryColumns > geometryColumnsCollection = srs . getGeometryColumns ( ) ; if ( ! geometryColumnsCollection . isEmpty ( ) ) { geometryColumnsDao . delete ( geometryColumnsCollection ) ; } } // Delete Tile Matrix Set TileMatrixSetDao tileMatrixSetDao = getTileMatrixSetDao ( ) ; if ( tileMatrixSetDao . isTableExists ( ) ) { ForeignCollection < TileMatrixSet > tileMatrixSetCollection = srs . getTileMatrixSet ( ) ; if ( ! tileMatrixSetCollection . isEmpty ( ) ) { tileMatrixSetDao . delete ( tileMatrixSetCollection ) ; } } // Delete count = delete ( srs ) ; } return count ; }
Delete the Spatial Reference System cascading