X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/ccfad57fcab0559ad780f9c703c6e059e7e359ad..a33f2c0f5ba43df533b6e137f9151fe67feb20a1:/test/python/test_tools_tiger_data.py?ds=sidebyside diff --git a/test/python/test_tools_tiger_data.py b/test/python/test_tools_tiger_data.py index 63e72e16..1ed89782 100644 --- a/test/python/test_tools_tiger_data.py +++ b/test/python/test_tools_tiger_data.py @@ -4,22 +4,58 @@ Test for tiger data function from pathlib import Path import pytest +import tarfile from nominatim.tools import tiger_data, database_import @pytest.mark.parametrize("threads", (1, 5)) -def test_add_tiger_data(dsn, src_dir, def_config, monkeypatch,tmp_path, - temp_db_cursor, threads, temp_db): - monkeypatch.setenv('NOMINATIM_DATABASE_MODULE_PATH', '.') - temp_db_cursor.execute('CREATE EXTENSION hstore') - temp_db_cursor.execute('CREATE EXTENSION postgis') +def test_add_tiger_data(def_config, tmp_path, sql_preprocessor, + temp_db_cursor, threads, temp_db_with_extensions): temp_db_cursor.execute('CREATE TABLE place (id INT)') + sqlfile = tmp_path / '1010.sql' + sqlfile.write_text("""INSERT INTO place values (1); + INSERT INTO non_existant_table values (1);""") + tiger_data.add_tiger_data(str(tmp_path), def_config, threads) + + assert temp_db_cursor.table_rows('place') == 1 + + +@pytest.mark.parametrize("threads", (1, 5)) +def test_add_tiger_data_bad_file(def_config, tmp_path, sql_preprocessor, + temp_db_cursor, threads, temp_db_with_extensions): + temp_db_cursor.execute('CREATE TABLE place (id INT)') + sqlfile = tmp_path / '1010.txt' + sqlfile.write_text("""Random text""") + tiger_data.add_tiger_data(str(tmp_path), def_config, threads) + + assert temp_db_cursor.table_rows('place') == 0 + - database_import.import_base_data('dbname=' + temp_db, src_dir / 'data', - ignore_partitions=False) +@pytest.mark.parametrize("threads", (1, 5)) +def test_add_tiger_data_tarfile(def_config, tmp_path, temp_db_cursor, + threads, temp_db_with_extensions, sql_preprocessor): + temp_db_cursor.execute('CREATE TABLE place (id INT)') sqlfile = tmp_path / '1010.sql' - sqlfile.write_text("""INSERT INTO place values (1)""") - tiger_data.add_tiger_data(dsn, str(tmp_path), threads, def_config, src_dir / 'lib-sql') + sqlfile.write_text("""INSERT INTO place values (1); + INSERT INTO non_existant_table values (1);""") + tar = tarfile.open(str(tmp_path / 'sample.tar.gz'), "w:gz") + tar.add(sqlfile) + tar.close() + tiger_data.add_tiger_data(str(tmp_path / 'sample.tar.gz'), def_config, threads) + + assert temp_db_cursor.table_rows('place') == 1 + + +@pytest.mark.parametrize("threads", (1, 5)) +def test_add_tiger_data_bad_tarfile(def_config, tmp_path, temp_db_cursor, threads, + temp_db_with_extensions, sql_preprocessor): + temp_db_cursor.execute('CREATE TABLE place (id INT)') + sqlfile = tmp_path / '1010.txt' + sqlfile.write_text("""Random text""") + tar = tarfile.open(str(tmp_path / 'sample.tar.gz'), "w:gz") + tar.add(sqlfile) + tar.close() + tiger_data.add_tiger_data(str(tmp_path / 'sample.tar.gz'), def_config, threads) - assert temp_db_cursor.table_rows('place') == 1 \ No newline at end of file + assert temp_db_cursor.table_rows('place') == 0