Problem launching test database
In this branch we now have a function to write to the data_units
table. The test works well locally but fails in the CI pipeline.
First attempt:
https://git.gfz-potsdam.de/dynamicexposure/globaldynamicexposure/gde-importer/-/jobs/103686
It complains when test_database_data_unit_tiles.sql
tells it to DROP TYPE IF EXISTS occupancycase;
because column occupancy_case of table data_units depends on type occupancycase
. However, test_database_data_unit_tiles.sql
is executed before test_database_data_units.sql
(see here), i.e. the database should not "know" of data_units yet. How is this happening?
Second attempt:
https://git.gfz-potsdam.de/dynamicexposure/globaldynamicexposure/gde-importer/-/jobs/103691
I erased DROP TYPE IF EXISTS occupancycase;
from test_database_data_unit_tiles.sql
and got psycopg2.errors.DuplicateObject: type "occupancycase" already exists
.
\rfc @fd