def test_within_distance(self): r1 = session.query(Road).filter(Road.road_name=='Jeff Rd').one() r2 = session.query(Road).filter(Road.road_name=='Graeme Ave').one() r3 = session.query(Road).filter(Road.road_name=='Geordie Rd').one() roads_within_distance = session.query(Road).filter( Road.road_geom.within_distance(r1.road_geom, 0.20)).all() ok_(r2 in roads_within_distance) ok_(r3 not in roads_within_distance) eq_(session.scalar(functions.within_distance('POINT(-88.9139332929936 42.5082802993631)', 'POINT(-88.9139332929936 35.5082802993631)', 10)), True)
def test_within_distance(self): r1 = session.query(Road).filter(Road.road_name=='Jeff Rd').one() r2 = session.query(Road).filter(Road.road_name=='Graeme Ave').one() r3 = session.query(Road).filter(Road.road_name=='Geordie Rd').one() roads_within_distance = session.query(Road).filter( Road.road_geom.within_distance(r1.road_geom, 0.20)).all() ok_(r2 in roads_within_distance) ok_(r3 not in roads_within_distance) eq_(session.scalar(functions.within_distance('POINT(-88.9139332929936 42.5082802993631)', 'POINT(-88.9139332929936 35.5082802993631)', 10)), True)
def test_issue17(self): r1 = session.query(Road).filter(Road.road_name=='Jeff Rd').one() lakes_within_distance = session.query(Lake).filter( Lake.road.has(functions._within_distance(Road.road_geom,r1.road_geom, 0.20))).all() lakes_within_distance = session.query(Lake).filter( Lake.road.has(functions.within_distance(Road.road_geom,r1.road_geom, 0.20))).all()
def test_issue17(self): r1 = session.query(Road).filter(Road.road_name=='Jeff Rd').one() lakes_within_distance = session.query(Lake).filter( Lake.road.has(functions._within_distance(Road.road_geom,r1.road_geom, 0.20))).all() lakes_within_distance = session.query(Lake).filter( Lake.road.has(functions.within_distance(Road.road_geom,r1.road_geom, 0.20))).all()