finished UBA NRT with the new database structure using the REST API (also added minor fixes to REST API and NRT changelog behaviour)

found matching radius for merging stations, completed translation tables for controlled vocabulary (type_of_environment and type_of_area)

found matching radius for merging stations, completed translation tables for controlled vocabulary (type_of_environment and type_of_area)

added all entries that are found in the old database to the translation table of type_of_environment and type_of_area

#17: after re-adding coordinate_validation_status to table stationmeta_core, it has also to be readded to the model/schema/docu

#3: update of TOAR extension now also takes care for kind of annotation (erroneously inserted into version 0.1 (but not into version 0.2))

#3: added update mechanism for TOAR extension

See merge request toar/toardb_fastapi!1

Sabine Schröder authored 4 years ago and Sabine Schröder committed 4 years ago

(cherry picked from commit 2e8d1730)

#9, #14: API for patching data (measurements) have been installed; data is not overwritten, but saved to table data_archive, a changelog entry is created

#17, #9: patch API produces changelog entries for 'SingleValue' and 'Comprehensive' (also additions for #7 to be found in this commit)

#7: controlled vocabulary for kind of annotation was introduced (changes in crud.py and schemas.py to be found in commit for #17)

#17: REST APIs to changelog tables are build; #9: patch API for stationmeta creates a separate changelog entry for every field changed in the metadata

#17: delete coordinate_validation_status, coordinate_validation_date, and coordinate_validator_id from fixtures for pytest

#17 and #9: stationmeta patch API writes (one) entry to changelog table; schema shows changelog table when requesting stationmeta from database

#11 and #3: added more readable REST API for controlled_vocabulary (and also for requests of only one entry))

#4: bug fix done for nested stationmeta (inside timeseries record); still left to do: clean up of code and adapting pytests