Prerequisites:

• Schema DevV5 with copies of tables concept, concept_relationship and concept_synonym from ProdV5, fully indexed.
• SNOMED must be loaded first.
• Working directory is OPS.

Sequence of actions:

1. Download all ClaML files from https://www.dimdi.de/dynamic/de/klassifikationen/downloads/?dir=ops/ for all years

2. Use Python processing script (OPS_convert.py) to extract source files and fill in the source tables. Append resulting tables to ops_src_agg and modifiers_append with version year as last field.

3. Run FastRecreate:

SELECT devv5.FastRecreateSchema(main_schema_name=>'devv5', include_concept_ancestor=> false,
                                include_deprecated_rels=> true, include_synonyms=> true);

4. Run load_stage.sql.

5. Run check_stage_tables function (should retrieve NULL):

SELECT * FROM qa_tests.check_stage_tables();

6. Run generic_update:

DO $_$
BEGIN
	PERFORM devv5.GenericUpdate();
END $_$;

7. Run basic tables check (should retrieve NULL):

SELECT * FROM qa_tests.get_checks();

8. Perform manual work described in the readme.md file in the 'manual_work' folder.

Repeat steps 3-8.

9. Run manual_checks_after_generic.sql, and interpret the results.

10. Run scripts to get summary, and interpret the results:

SELECT * FROM qa_tests.get_summary('concept');

SELECT * FROM qa_tests.get_summary('concept_relationship');

11. Run scripts to collect statistics, and interpret the results:

SELECT * FROM qa_tests.get_domain_changes();

SELECT * FROM qa_tests.get_newly_concepts();

SELECT * FROM qa_tests.get_standard_concept_changes();

SELECT * FROM qa_tests.get_newly_concepts_standard_concept_status();

SELECT * FROM qa_tests.get_changes_concept_mapping();

12. If no problems, enjoy!

Manual tables directory permalink: https://drive.google.com/drive/u/1/folders/1P2dJ9PDMDuu03K-EqzAR8QgmLj72kEB0

TODO: Update scripts to depend on basic tables to extract dates, so that we need only ClaML files for current year.