2 Tests for status table manipulation.
8 import nominatim.db.status
9 from nominatim.errors import UsageError
11 def test_compute_database_date_place_empty(status_table, place_table, temp_db_conn):
12 with pytest.raises(UsageError):
13 nominatim.db.status.compute_database_date(temp_db_conn)
16 <osm version="0.6" generator="OpenStreetMap server" copyright="OpenStreetMap and contributors" attribution="http://www.openstreetmap.org/copyright" license="http://opendatacommons.org/licenses/odbl/1-0/">
17 <node id="45673" visible="true" version="1" changeset="2047" timestamp="2006-01-27T22:09:10Z" user="Foo" uid="111" lat="48.7586670" lon="8.1343060">
23 return dt.datetime.strptime(date, nominatim.db.status.ISODATE_FORMAT)\
24 .replace(tzinfo=dt.timezone.utc)
27 def test_compute_database_date_valid(monkeypatch, status_table, place_row, temp_db_conn):
28 place_row(osm_type='N', osm_id=45673)
32 requested_url.append(url)
35 monkeypatch.setattr(nominatim.db.status, "get_url", mock_url)
37 date = nominatim.db.status.compute_database_date(temp_db_conn)
39 assert requested_url == ['https://www.openstreetmap.org/api/0.6/node/45673/1']
40 assert date == iso_date('2006-01-27T22:09:10')
43 def test_compute_database_broken_api(monkeypatch, status_table, place_row, temp_db_conn):
44 place_row(osm_type='N', osm_id=45673)
48 requested_url.append(url)
49 return '<osm version="0.6" generator="OpenStre'
51 monkeypatch.setattr(nominatim.db.status, "get_url", mock_url)
53 with pytest.raises(UsageError):
54 date = nominatim.db.status.compute_database_date(temp_db_conn)
57 def test_set_status_empty_table(status_table, temp_db_conn, temp_db_cursor):
58 date = dt.datetime.fromordinal(1000000).replace(tzinfo=dt.timezone.utc)
59 nominatim.db.status.set_status(temp_db_conn, date=date)
61 assert temp_db_cursor.row_set("SELECT * FROM import_status") == \
65 def test_set_status_filled_table(status_table, temp_db_conn, temp_db_cursor):
66 date = dt.datetime.fromordinal(1000000).replace(tzinfo=dt.timezone.utc)
67 nominatim.db.status.set_status(temp_db_conn, date=date)
69 assert temp_db_cursor.table_rows('import_status') == 1
71 date = dt.datetime.fromordinal(1000100).replace(tzinfo=dt.timezone.utc)
72 nominatim.db.status.set_status(temp_db_conn, date=date, seq=456, indexed=False)
74 assert temp_db_cursor.row_set("SELECT * FROM import_status") == \
78 def test_set_status_missing_date(status_table, temp_db_conn, temp_db_cursor):
79 date = dt.datetime.fromordinal(1000000).replace(tzinfo=dt.timezone.utc)
80 nominatim.db.status.set_status(temp_db_conn, date=date)
82 assert temp_db_cursor.table_rows('import_status') == 1
84 nominatim.db.status.set_status(temp_db_conn, date=None, seq=456, indexed=False)
86 assert temp_db_cursor.row_set("SELECT * FROM import_status") == \
90 def test_get_status_empty_table(status_table, temp_db_conn):
91 assert nominatim.db.status.get_status(temp_db_conn) == (None, None, None)
94 def test_get_status_success(status_table, temp_db_conn):
95 date = dt.datetime.fromordinal(1000000).replace(tzinfo=dt.timezone.utc)
96 nominatim.db.status.set_status(temp_db_conn, date=date, seq=667, indexed=False)
98 assert nominatim.db.status.get_status(temp_db_conn) == \
102 @pytest.mark.parametrize("old_state", [True, False])
103 @pytest.mark.parametrize("new_state", [True, False])
104 def test_set_indexed(status_table, temp_db_conn, temp_db_cursor, old_state, new_state):
105 date = dt.datetime.fromordinal(1000000).replace(tzinfo=dt.timezone.utc)
106 nominatim.db.status.set_status(temp_db_conn, date=date, indexed=old_state)
107 nominatim.db.status.set_indexed(temp_db_conn, new_state)
109 assert temp_db_cursor.scalar("SELECT indexed FROM import_status") == new_state
112 def test_set_indexed_empty_status(status_table, temp_db_conn, temp_db_cursor):
113 nominatim.db.status.set_indexed(temp_db_conn, True)
115 assert temp_db_cursor.table_rows("import_status") == 0
118 def text_log_status(status_table, temp_db_conn):
119 date = dt.datetime.fromordinal(1000000).replace(tzinfo=dt.timezone.utc)
120 start = dt.datetime.now() - dt.timedelta(hours=1)
121 nominatim.db.status.set_status(temp_db_conn, date=date, seq=56)
122 nominatim.db.status.log_status(temp_db_conn, start, 'index')
124 assert temp_db_cursor.table_rows("import_osmosis_log") == 1
125 assert temp_db_cursor.scalar("SELECT seq FROM import_osmosis_log") == 56
126 assert temp_db_cursor.scalar("SELECT date FROM import_osmosis_log") == date