def test_is_closed(self): r = session.query(Road).filter(Road.road_name=='Graeme Ave').one() l = session.query(Lake).filter(Lake.lake_name=='My Lake').one() assert not session.scalar(r.road_geom.is_closed) assert session.scalar(l.lake_geom.is_closed) ok_(session.query(Lake).filter(Lake.lake_geom.is_closed == True).first() is not None) eq_(session.scalar(functions.is_closed('LINESTRING(0 0, 1 1)')), False)
def test_is_closed(self): r = session.query(Road).filter(Road.road_name=='Graeme Ave').one() l = session.query(Lake).filter(Lake.lake_name=='My Lake').one() assert not session.scalar(r.road_geom.is_closed) # note Oracle always returns FALSE for polygons assert not session.scalar(l.lake_geom.is_closed) ok_(session.query(Lake).filter(Lake.lake_geom.is_closed).first() is None) # note that we manually have to set a geometry type for WKTSpatialElement eq_(session.scalar(functions.is_closed(WKTSpatialElement('LINESTRING(0 0, 1 1)', geometry_type=LineString.name))), False)