ENH: Allow insert/update/delete and files in Extern C

Summary

See https://gitlab.indiscale.com/caosdb/customers/lfpb/management/-/issues/412

Focus

Point the reviewer to the core of the code change. Where should they start
reading? What should they focus on (e.g. security, performance,
maintainability, user-friendliness, compliance with the specs, finding more
corner cases, concrete questions)?

Test Environment

How to set up a test environment for manual testing?

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 specifications? Are they satisfied?

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

include/ccaosdb.h

@@ -279,6 +279,8 @@ int caosdb_connection_connection_create_transaction(caosdb_connection_connection
 int caosdb_transaction_delete_transaction(caosdb_transaction_transaction *transaction);
 int caosdb_transaction_transaction_retrieve_by_id(caosdb_transaction_transaction *transaction,
                                                   const char *id);
+int caosdb_transaction_transaction_retrieve_and_download_file_by_id(
+  caosdb_transaction_transaction *transaction, const char *id, const char *path);
 int caosdb_transaction_transaction_retrieve_by_ids(caosdb_transaction_transaction *transaction,
                                                    const char *ids[], int length);
 int caosdb_transaction_transaction_query(caosdb_transaction_transaction *transaction,
@@ -307,6 +309,13 @@ int caosdb_transaction_result_set_at(caosdb_transaction_result_set *result_set,
                                      caosdb_entity_entity *entity, int index);
 int caosdb_transaction_result_set_size(caosdb_transaction_result_set *result_set, int *out);
 
+int caosdb_transaction_transaction_insert_entity(caosdb_transaction_transaction *transaction,
+                                                 caosdb_entity_entity *entity);
+int caosdb_transaction_transaction_update_entity(caosdb_transaction_transaction *transaction,
+                                                 caosdb_entity_entity *entity);
+int caosdb_transaction_transaction_delete_by_id(caosdb_transaction_transaction *transaction,
+                                                const char *id);
+
 typedef struct {
   void *wrapped_property;
   bool _deletable = false;
@@ -325,6 +334,7 @@ int caosdb_entity_entity_get_id(caosdb_entity_entity *entity, char **out);
 int caosdb_entity_entity_get_role(caosdb_entity_entity *entity, char **out);
 int caosdb_entity_entity_get_name(caosdb_entity_entity *entity, char **out);
 int caosdb_entity_entity_get_description(caosdb_entity_entity *entity, char **out);
+int caosdb_entity_entity_get_local_path(caosdb_entity_entity *entity, char **out);
 /**
  * Get the name of the entity's datatype, whether it is a reference, and whether it is a list.
  */
@@ -407,6 +417,8 @@ int caosdb_entity_delete_parent(caosdb_entity_parent *out);
 int caosdb_entity_entity_set_role(caosdb_entity_entity *entity, const char *role);
 int caosdb_entity_entity_set_name(caosdb_entity_entity *entity, const char *name);
 int caosdb_entity_entity_set_description(caosdb_entity_entity *entity, const char *description);
+int caosdb_entity_entity_set_local_path(caosdb_entity_entity *entity, const char *name);
+int caosdb_entity_entity_set_file_path(caosdb_entity_entity *entity, const char *name);
 /**
  * Set the entity's datatype by name, and whether it is a reference or a list.
  */