Treat dependencies among identifiables

Summary

Allow a CFood to have identifiables that depend on each other. E.g. an identifiable Project and an Experiment that references it.

Focus

Identifiables are now treated one after the other when checking whether they need to be inserted.

Test Environment

Automated tests should suffice. Note that tests where changed slightly such that they fail without this fix: https://gitlab.indiscale.com/caosdb/src/caosdb-advanced-user-tools/-/jobs/37342 Since identifiables are not treated correctly the experiment is inserted a second time which leads to the violation of the unique query.

Check List for the Author

Please, prepare your MR for a review. Be sure to write a summary and a focus and create gitlab comments for the reviewer. They should guide the reviewer through the changes, explain your changes and also point out open questions. For further good practices have a look at our review guidelines

• All automated tests pass
• Reference related Issues
• Up-to-date CHANGELOG.md
• Annotations in code (Gitlab comments)
  • Intent of new code
  • Problems with old code
  • Why this implementation?

Check List for the Reviewer

• I understand the intent of this MR
• All automated tests pass
• Up-to-date CHANGELOG.md
• The test environment setup works and the intended behavior is reproducible in the test environment
• In-code documentation and comments are up-to-date.
• Check: Are there spezifications? Are they satisfied?
• remove the demonstration branch f-make-deps-fail

For further good practices have a look at our review guidelines.

integrationtests/test.sh

@@ -3,6 +3,7 @@ OUT=/tmp/crawler.output
 ls 
 cat pycaosdb.ini
 rm -rf cache.db
+set -e
 echo "Clearing database"
 python3 clear_database.py
 echo "Testing crawler without cfoods"
@@ -29,7 +30,6 @@ echo "run crawler"
 # rename the moved file
 mv extroot/DataAnalysis/2010_TestProject/2019-02-03_something/README.xlsx_back extroot/DataAnalysis/2010_TestProject/2019-02-03_something/README.xlsx
 # check whether there was something UNAUTHORIZED
-set -e
 grep "There where unauthorized changes" $OUT
 # get the id of the run which is the last field of the output string
 RUN_ID=$(grep "run id:" $OUT | awk '{ print $NF }')