def test_osm_polygon_with_null_names_get_deleted(session, schema, tables): session.add(tables.osm_polygon(name="gugus")) session.add(tables.osm_polygon()) session.commit() delete_unusable_entries() assert session.query(tables.osm_polygon).count(), 1
def test_osm_linestring_with_blank_names_get_deleted(session, schema, tables): session.add(tables.osm_linestring(name="gugus")) session.add(tables.osm_linestring(name="")) session.commit() delete_unusable_entries() assert session.query(tables.osm_linestring).count(), 1
def test_osm_point_with_blank_names_get_deleted(session, tables): session.add(tables.osm_point(name="gugus")) session.add(tables.osm_point(name="")) session.commit() delete_unusable_entries() assert session.query(tables.osm_point).count() == 1
def test_osm_polygon_with_blank_names_get_deleted(session, tables): session.add(tables.osm_polygon(name="gugus")) session.add(tables.osm_polygon(name="")) session.commit() delete_unusable_entries() assert session.query(tables.osm_polygon).count() == 1
def test_osm_polygon_with_empty_geometries_get_deleted(session, tables): session.add(tables.osm_polygon(name="some polygon", geometry=POLYGON_GEOMETRY)) session.add(tables.osm_polygon(name="an empty polygon", geometry=WKTElement('POLYGON EMPTY', srid=3857))) session.commit() delete_unusable_entries() assert session.query(tables.osm_polygon).count() == 1
def test_osm_linestring_get_deleted_if_polygon_with_same_osm_id_exists(session, tables): session.add(tables.osm_linestring(name="some linestring", osm_id=1337)) session.add(tables.osm_polygon(name="some polygon", osm_id=1337, geometry=POLYGON_GEOMETRY)) session.commit() delete_unusable_entries() assert session.query(tables.osm_linestring).count() == 0 assert session.query(tables.osm_polygon).count() == 1
def test_osm_linestring_get_deleted_if_polygon_with_same_osm_id_exists( session, schema, tables): session.add(tables.osm_linestring(osm_id=1337)) session.add(tables.osm_polygon(osm_id=1337)) session.commit() delete_unusable_entries() assert session.query(tables.osm_linestring).count(), 0 assert session.query(tables.osm_polygon).count(), 1
def test_osm_polygon_with_empty_geometries_get_deleted(session, tables): session.add( tables.osm_polygon(name="some polygon", geometry=POLYGON_GEOMETRY)) session.add( tables.osm_polygon(name="an empty polygon", geometry=WKTElement('POLYGON EMPTY', srid=3857))) session.commit() delete_unusable_entries() assert session.query(tables.osm_polygon).count() == 1
def test_osm_polygon_with_empty_geometries_get_deleted(session, schema, tables): session.add( tables.osm_polygon( geometry=WKTElement('POLYGON((1 2, 3 4, 5 6, 1 2))', srid=3857))) session.add( tables.osm_polygon(geometry=WKTElement('POLYGON EMPTY', srid=3857))) session.commit() delete_unusable_entries() assert session.query(tables.osm_polygon).count(), 1
def test_osm_linestring_get_deleted_if_polygon_with_same_osm_id_exists( session, tables): session.add(tables.osm_linestring(name="some linestring", osm_id=1337)) session.add( tables.osm_polygon(name="some polygon", osm_id=1337, geometry=POLYGON_GEOMETRY)) session.commit() delete_unusable_entries() assert session.query(tables.osm_linestring).count() == 0 assert session.query(tables.osm_polygon).count() == 1