def test_point_n(self): l = session.query(Lake).get(1) r = session.query(Road).get(1) ok_(session.scalar(l.lake_geom.point_n(1))) ok_(session.query(Road).filter(Road.road_geom.point_n(5) == WKTSpatialElement('POINT(-88.3655256496815 43.1402866687898)')).first() is not None) eq_(session.scalar(functions.wkt(r.road_geom.point_n(5))), 'POINT (-88.3655256496815 43.1402866687898)') eq_(session.scalar(functions.wkt(functions.point_n('LINESTRING(77.29 29.07,77.42 29.26,77.27 29.31,77.29 29.07)', 1))) , 'POINT (77.29 29.07)')
def test_point_n(self): l = session.query(Lake).get(1) r = session.query(Road).get(1) ok_(not session.scalar(l.lake_geom.point_n(1))) ok_(session.query(Road).filter(Road.road_geom.point_n(5) == WKTSpatialElement('POINT(-88.3655256496815 43.1402866687898)')).first() is not None) eq_(session.scalar(r.road_geom.point_n(5).wkt), 'POINT(-88.3655256496815 43.1402866687898)') eq_(session.scalar(functions.wkt(functions.point_n('LINESTRING(77.29 29.07,77.42 29.26,77.27 29.31,77.29 29.07)', 1))) , 'POINT(77.29 29.07)')
def test_point_n(self): r = session.query(Road).get(1) ok_(session.query(Road).filter(and_(Road.road_geom.point_n(5) <> None, functions.wkt(Road.road_geom.point_n(5)) == 'POINT (-88.3655256496815 43.1402866687898)')).first() is not None) eq_(session.scalar(r.road_geom.point_n(5).wkt), u'POINT (-88.3655256496815 43.1402866687898)') eq_(session.scalar(functions.wkt(functions.point_n( WKTSpatialElement('LINESTRING(77.29 29.07,77.42 29.26,77.27 29.31,77.29 29.07)', geometry_type=LineString.name), 1))), u'POINT (77.29 29.07)')