Python set_country_codes Examples

Example #1

File: test_set_country_codes.py Project: tramka/OSMNames

def test_osm_polygon_country_code_get_set_with_most_intersecting_country(
        session, tables):
    session.add(
        tables.country_osm_grid(country_code='CH',
                                geometry=WKTElement(
                                    "POLYGON((0 0,4 0,4 1,0 1,0 0))",
                                    srid=3857)))

    session.add(
        tables.country_osm_grid(country_code='DE',
                                geometry=WKTElement(
                                    "POLYGON((0 0,4 0,4 4,0 4,0 0))",
                                    srid=3857)))

    session.add(
        tables.osm_polygon(id=1,
                           name="Some country with missing country_code",
                           place_rank=4,
                           geometry=WKTElement(
                               "POLYGON((0 0,4 0,4 4,0 4,0 0))", srid=3857)))

    session.commit()

    set_country_codes()

    assert session.query(tables.osm_polygon).get(1).country_code == 'de'

Example #2

File: test_set_country_codes.py Project: geometalab/OSMNames

def test_osm_polygon_country_code_get_set_with_most_intersecting_country(session, tables):
    session.add(
            tables.country_osm_grid(
                country_code='CH',
                geometry=WKTElement("POLYGON((0 0,4 0,4 1,0 1,0 0))", srid=3857)
            )
        )

    session.add(
            tables.country_osm_grid(
                country_code='DE',
                geometry=WKTElement("POLYGON((0 0,4 0,4 4,0 4,0 0))", srid=3857)
            )
        )

    session.add(
            tables.osm_polygon(
                id=1,
                name="Some country with missing country_code",
                place_rank=4,
                geometry=WKTElement("POLYGON((0 0,4 0,4 4,0 4,0 0))", srid=3857)
            )
        )

    session.commit()

    set_country_codes()

    assert session.query(tables.osm_polygon).get(1).country_code == 'de'

Example #3

File: test_set_country_codes.py Project: tramka/OSMNames

def test_osm_polygon_country_code_get_set_bases_on_imported_country_code(
        session, tables):
    session.add(tables.osm_polygon(
        id=1,
        imported_country_code='CH',
    ))

    session.commit()

    set_country_codes()

    assert session.query(tables.osm_polygon).get(1).country_code == 'ch'

Example #4

File: test_set_country_codes.py Project: geometalab/OSMNames

def test_osm_polygon_country_code_get_set_bases_on_imported_country_code(session, tables):
    session.add(
            tables.osm_polygon(
                id=1,
                imported_country_code='CH',
            )
        )

    session.commit()

    set_country_codes()

    assert session.query(tables.osm_polygon).get(1).country_code == 'ch'

Example #5

File: test_set_country_codes.py Project: tramka/OSMNames

def test_osm_polygon_country_code_get_set_base_on_country_grid(
        session, tables):
    session.add(
        tables.country_osm_grid(country_code='CH',
                                geometry=WKTElement(
                                    "POLYGON((0 0,4 0,4 4,0 4,0 0))",
                                    srid=3857)))

    session.add(
        tables.osm_polygon(
            id=1,
            name="Some Polygon with missing country_code",
            geometry=WKTElement("POLYGON((1 1, 2 1, 2 2, 1 2,1 1))",
                                srid=3857)))

    session.commit()

    set_country_codes()

    assert session.query(tables.osm_polygon).get(1).country_code == 'ch'

Example #6

File: test_set_country_codes.py Project: geometalab/OSMNames

def test_osm_polygon_country_code_get_set_base_on_country_grid(session, tables):
    session.add(
            tables.country_osm_grid(
                country_code='CH',
                geometry=WKTElement("POLYGON((0 0,4 0,4 4,0 4,0 0))", srid=3857)
            )
        )

    session.add(
            tables.osm_polygon(
                id=1,
                name="Some Polygon with missing country_code",
                geometry=WKTElement("POLYGON((1 1, 2 1, 2 2, 1 2,1 1))", srid=3857)
            )
        )

    session.commit()

    set_country_codes()

    assert session.query(tables.osm_polygon).get(1).country_code == 'ch'