TST: Add Tests for insert and delete

Integration tests for https://gitlab.indiscale.com/caosdb/customers/lfpb/management/-/issues/394 and caosdb-cpplib!4 (merged).

test/test_transaction.cpp

@@ -79,8 +79,8 @@ TEST(test_transaction, retrieve_non_existing) {
   transaction->ExecuteAsynchronously();
 
   auto status = transaction->WaitForIt();
-  EXPECT_EQ(status.GetCode(), TransactionStatus::SUCCESS().GetCode());
-  ASSERT_EQ(status.GetCode(), StatusCode::SUCCESS);
+  EXPECT_EQ(status.GetCode(), TransactionStatus::TRANSACTION_ERROR().GetCode());
+  ASSERT_EQ(status.GetCode(), StatusCode::GENERIC_TRANSACTION_ERROR);
 
   const auto &result_set =
     dynamic_cast<const UniqueResult &>(transaction->GetResultSet());