internal_tables_access.h

Go to the documentation of this file.

// Copyright (c) Microsoft Corporation. All rights reserved.
// Licensed under the Apache 2.0 License.
#pragma once
 
#include "ccf/crypto/verifier.h"
#include "ccf/ds/hex.h"
#include "ccf/pal/attestation_sev_snp.h"
#include "ccf/pal/sev_snp_cpuid.h"
#include "ccf/service/tables/code_id.h"
#include "ccf/service/tables/constitution.h"
#include "ccf/service/tables/members.h"
#include "ccf/service/tables/nodes.h"
#include "ccf/service/tables/snp_measurements.h"
#include "ccf/service/tables/tcb_verification.h"
#include "ccf/service/tables/users.h"
#include "ccf/service/tables/virtual_measurements.h"
#include "ccf/tx.h"
#include "consensus/aft/raft_types.h"
#include "crypto/openssl/cose_sign.h"
#include "node/ledger_secrets.h"
#include "node/uvm_endorsements.h"
#include "service/tables/governance_history.h"
#include "service/tables/previous_service_identity.h"
 
#include <algorithm>
#include <ostream>
#include <stdexcept>
 
namespace ccf
{
  /* We can't query the past epochs' TXs if the service hasn't been opened
   * yet. We do guess values based on epoch value and seqno changing rules. */
  inline ccf::TxID previous_tx_if_recovery(ccf::TxID txid)
  {
    return ccf::TxID{
      .view = txid.view - aft::starting_view_change, .seqno = txid.seqno - 1};
  }
  inline ccf::TxID next_tx_if_recovery(ccf::TxID txid)
  {
    return ccf::TxID{
      .view = txid.view + aft::starting_view_change, .seqno = txid.seqno + 1};
  }
 
  // This class provides functions for interacting with various internal
  // service-governance tables. Specifically, it aims to maintain some
  // invariants amongst these tables (eg - keys being present in multiple
  // tables) despite access by distinct callers. These tables may be accessed
  // directly with a Tx object, but it is recommended to use these methods where
  // available.
  class InternalTablesAccess
  {
  public:
    // This class is purely a container for static methods, should not be
    // instantiated
    InternalTablesAccess() = delete;
 
    static void retire_active_nodes(ccf::kv::Tx& tx)
    {
      auto* nodes = tx.rw<ccf::Nodes>(Tables::NODES);
 
      std::map<NodeId, NodeInfo> nodes_to_delete;
      nodes->foreach([&nodes_to_delete](const NodeId& nid, const NodeInfo& ni) {
        // Only retire nodes that have not already been retired
        if (ni.status != NodeStatus::RETIRED)
        {
          nodes_to_delete[nid] = ni;
        }
        return true;
      });
 
      for (auto [nid, ni] : nodes_to_delete)
      {
        ni.status = NodeStatus::RETIRED;
        nodes->put(nid, ni);
      }
    }
 
    static bool is_recovery_participant_or_owner(
      ccf::kv::ReadOnlyTx& tx, const MemberId& member_id)
    {
      auto* member_encryption_public_keys =
        tx.ro<ccf::MemberPublicEncryptionKeys>(
          Tables::MEMBER_ENCRYPTION_PUBLIC_KEYS);
 
      return member_encryption_public_keys->get(member_id).has_value();
    }
 
    static bool is_recovery_participant(
      ccf::kv::ReadOnlyTx& tx, const MemberId& member_id)
    {
      return is_recovery_participant_or_owner(tx, member_id) &&
        !is_recovery_owner(tx, member_id);
    }
 
    static bool is_recovery_owner(
      ccf::kv::ReadOnlyTx& tx, const MemberId& member_id)
    {
      auto* member_info = tx.ro<ccf::MemberInfo>(Tables::MEMBER_INFO);
      auto mi = member_info->get(member_id);
      if (!mi.has_value())
      {
        return false;
      }
 
      return mi->recovery_role.has_value() &&
        mi->recovery_role.value() == MemberRecoveryRole::Owner;
    }
 
    static bool is_active_member(
      ccf::kv::ReadOnlyTx& tx, const MemberId& member_id)
    {
      auto* member_info = tx.ro<ccf::MemberInfo>(Tables::MEMBER_INFO);
      auto mi = member_info->get(member_id);
      if (!mi.has_value())
      {
        return false;
      }
 
      return mi->status == MemberStatus::ACTIVE;
    }
 
    static std::map<MemberId, ccf::crypto::Pem>
    get_active_recovery_participants(ccf::kv::ReadOnlyTx& tx)
    {
      auto* member_info = tx.ro<ccf::MemberInfo>(Tables::MEMBER_INFO);
      auto* member_encryption_public_keys =
        tx.ro<ccf::MemberPublicEncryptionKeys>(
          Tables::MEMBER_ENCRYPTION_PUBLIC_KEYS);
 
      std::map<MemberId, ccf::crypto::Pem> active_recovery_participants;
 
      member_encryption_public_keys->foreach(
        [&active_recovery_participants,
         &member_info](const auto& mid, const auto& pem) {
          auto info = member_info->get(mid);
          if (!info.has_value())
          {
            throw std::logic_error(
              fmt::format("Recovery member {} has no member info", mid));
          }
 
          if (
            info->status == MemberStatus::ACTIVE &&
            info->recovery_role.value_or(MemberRecoveryRole::Participant) ==
              MemberRecoveryRole::Participant)
          {
            active_recovery_participants[mid] = pem;
          }
          return true;
        });
      return active_recovery_participants;
    }
 
    static std::map<MemberId, ccf::crypto::Pem> get_active_recovery_owners(
      ccf::kv::ReadOnlyTx& tx)
    {
      auto* member_info = tx.ro<ccf::MemberInfo>(Tables::MEMBER_INFO);
      auto* member_encryption_public_keys =
        tx.ro<ccf::MemberPublicEncryptionKeys>(
          Tables::MEMBER_ENCRYPTION_PUBLIC_KEYS);
 
      std::map<MemberId, ccf::crypto::Pem> active_recovery_owners;
 
      member_encryption_public_keys->foreach(
        [&active_recovery_owners,
         &member_info](const auto& mid, const auto& pem) {
          auto info = member_info->get(mid);
          if (!info.has_value())
          {
            throw std::logic_error(
              fmt::format("Recovery member {} has no member info", mid));
          }
 
          if (
            info->status == MemberStatus::ACTIVE &&
            info->recovery_role.value_or(MemberRecoveryRole::Participant) ==
              MemberRecoveryRole::Owner)
          {
            active_recovery_owners[mid] = pem;
          }
          return true;
        });
      return active_recovery_owners;
    }
 
    static MemberId add_member(
      ccf::kv::Tx& tx, const NewMember& member_pub_info)
    {
      auto* member_certs = tx.rw<ccf::MemberCerts>(Tables::MEMBER_CERTS);
      auto* member_info = tx.rw<ccf::MemberInfo>(Tables::MEMBER_INFO);
      auto* member_acks = tx.rw<ccf::MemberAcks>(Tables::MEMBER_ACKS);
      auto* signatures = tx.ro<ccf::Signatures>(Tables::SIGNATURES);
 
      auto member_cert_der =
        ccf::crypto::make_verifier(member_pub_info.cert)->cert_der();
      auto id = ccf::crypto::Sha256Hash(member_cert_der).hex_str();
 
      auto member = member_certs->get(id);
      if (member.has_value())
      {
        // No effect if member already exists
        return id;
      }
 
      if (member_pub_info.recovery_role.has_value())
      {
        auto member_recovery_role = member_pub_info.recovery_role.value();
        if (!member_pub_info.encryption_pub_key.has_value())
        {
          if (member_recovery_role != ccf::MemberRecoveryRole::NonParticipant)
          {
            throw std::logic_error(fmt::format(
              "Member {} cannot be added as recovery_role has a value set but "
              "no "
              "encryption public key is specified",
              id));
          }
        }
        else
        {
          if (
            member_recovery_role != ccf::MemberRecoveryRole::Participant &&
            member_recovery_role != ccf::MemberRecoveryRole::Owner)
          {
            throw std::logic_error(fmt::format(
              "Recovery member {} cannot be added as with recovery role value "
              "of "
              "{}",
              id,
              member_recovery_role));
          }
        }
      }
 
      member_certs->put(id, member_pub_info.cert);
      member_info->put(
        id,
        {MemberStatus::ACCEPTED,
         member_pub_info.member_data,
         member_pub_info.recovery_role});
 
      if (member_pub_info.encryption_pub_key.has_value())
      {
        auto* member_encryption_public_keys =
          tx.rw<ccf::MemberPublicEncryptionKeys>(
            Tables::MEMBER_ENCRYPTION_PUBLIC_KEYS);
        member_encryption_public_keys->put(
          id, member_pub_info.encryption_pub_key.value());
      }
 
      auto s = signatures->get();
      if (!s)
      {
        member_acks->put(id, MemberAck());
      }
      else
      {
        member_acks->put(id, MemberAck(s->root));
      }
      return id;
    }
 
    static bool activate_member(ccf::kv::Tx& tx, const MemberId& member_id)
    {
      auto* member_info = tx.rw<ccf::MemberInfo>(Tables::MEMBER_INFO);
 
      auto member = member_info->get(member_id);
      if (!member.has_value())
      {
        throw std::logic_error(fmt::format(
          "Member {} cannot be activated as they do not exist", member_id));
      }
 
      const auto newly_active = member->status != MemberStatus::ACTIVE;
 
      member->status = MemberStatus::ACTIVE;
      member_info->put(member_id, member.value());
 
      return newly_active;
    }
 
    static bool remove_member(ccf::kv::Tx& tx, const MemberId& member_id)
    {
      auto* member_certs = tx.rw<ccf::MemberCerts>(Tables::MEMBER_CERTS);
      auto* member_encryption_public_keys =
        tx.rw<ccf::MemberPublicEncryptionKeys>(
          Tables::MEMBER_ENCRYPTION_PUBLIC_KEYS);
      auto* member_info = tx.rw<ccf::MemberInfo>(Tables::MEMBER_INFO);
      auto* member_acks = tx.rw<ccf::MemberAcks>(Tables::MEMBER_ACKS);
      auto* member_gov_history =
        tx.rw<ccf::GovernanceHistory>(Tables::GOV_HISTORY);
 
      auto member_to_remove = member_info->get(member_id);
      if (!member_to_remove.has_value())
      {
        // The remove member proposal is idempotent so if the member does not
        // exist, the proposal should succeed with no effect
        LOG_FAIL_FMT(
          "Could not remove member {}: member does not exist", member_id);
        return true;
      }
 
      // If the member was active and had a recovery share, check that
      // the new number of active members is still sufficient for
      // recovery
      if (member_to_remove->status == MemberStatus::ACTIVE)
      {
        if (is_recovery_participant(tx, member_id))
        {
          size_t active_recovery_participants_count_after =
            get_active_recovery_participants(tx).size() - 1;
          auto recovery_threshold = get_recovery_threshold(tx);
          auto active_recovery_owners_count =
            get_active_recovery_owners(tx).size();
          if (
            active_recovery_participants_count_after == 0 &&
            active_recovery_owners_count > 0 && recovery_threshold == 1)
          {
            // Its fine to remove all active recovery particiants as long as
            // recover owner(s) exist with a threshold of 1.
            LOG_INFO_FMT(
              "Allowing last active recovery participant member {}: to "
              "be removed as active recovery owner members ({}) are present "
              "with recovery threshold ({}).",
              member_id,
              active_recovery_owners_count,
              recovery_threshold);
          }
          else if (
            active_recovery_participants_count_after < recovery_threshold)
          {
            // Because the member to remove is active, there is at least one
            // active member (i.e. active_recovery_participants_count_after >=
            // 0)
            LOG_FAIL_FMT(
              "Failed to remove recovery member {}: number of active recovery "
              "participant members ({}) would be less than recovery threshold "
              "({})",
              member_id,
              active_recovery_participants_count_after,
              recovery_threshold);
            return false;
          }
        }
        else if (is_recovery_owner(tx, member_id))
        {
          size_t active_recovery_owners_count_after =
            get_active_recovery_owners(tx).size() - 1;
          auto recovery_threshold = get_recovery_threshold(tx);
          auto active_recovery_participants_count =
            get_active_recovery_participants(tx).size();
          if (active_recovery_owners_count_after == 0)
          {
            if (active_recovery_participants_count > 0)
            {
              LOG_INFO_FMT(
                "Allowing last active recovery owner member {}: to "
                "be removed as active recovery owner participants ({}) are "
                "present with recovery threshold ({}).",
                member_id,
                active_recovery_participants_count,
                recovery_threshold);
            }
            else
            {
              LOG_FAIL_FMT(
                "Failed to remove last active recovery owner member {}: number "
                "of active recovery participant members ({}) would be less "
                "than recovery threshold ({})",
                member_id,
                active_recovery_participants_count,
                recovery_threshold);
              return false;
            }
          }
        }
      }
 
      member_info->remove(member_id);
      member_encryption_public_keys->remove(member_id);
      member_certs->remove(member_id);
      member_acks->remove(member_id);
      member_gov_history->remove(member_id);
 
      return true;
    }
 
    static UserId add_user(ccf::kv::Tx& tx, const NewUser& new_user)
    {
      auto* user_certs = tx.rw<ccf::UserCerts>(Tables::USER_CERTS);
 
      auto user_cert_der =
        ccf::crypto::make_verifier(new_user.cert)->cert_der();
      auto id = ccf::crypto::Sha256Hash(user_cert_der).hex_str();
 
      auto user_cert = user_certs->get(id);
      if (user_cert.has_value())
      {
        throw std::logic_error(
          fmt::format("Certificate already exists for user {}", id));
      }
 
      user_certs->put(id, new_user.cert);
 
      if (new_user.user_data != nullptr)
      {
        auto* user_info = tx.rw<ccf::UserInfo>(Tables::USER_INFO);
        auto ui = user_info->get(id);
        if (ui.has_value())
        {
          throw std::logic_error(
            fmt::format("User data already exists for user {}", id));
        }
 
        user_info->put(id, {new_user.user_data});
      }
 
      return id;
    }
 
    static void remove_user(ccf::kv::Tx& tx, const UserId& user_id)
    {
      // Has no effect if the user does not exist
      auto* user_certs = tx.rw<ccf::UserCerts>(Tables::USER_CERTS);
      auto* user_info = tx.rw<ccf::UserInfo>(Tables::USER_INFO);
 
      user_certs->remove(user_id);
      user_info->remove(user_id);
    }
 
    static void add_node(
      ccf::kv::Tx& tx, const NodeId& id, const NodeInfo& node_info)
    {
      auto* node = tx.rw<ccf::Nodes>(Tables::NODES);
      node->put(id, node_info);
    }
 
    static std::map<NodeId, NodeInfo> get_trusted_nodes(ccf::kv::ReadOnlyTx& tx)
    {
      std::map<NodeId, NodeInfo> active_nodes;
 
      auto* nodes = tx.ro<ccf::Nodes>(Tables::NODES);
 
      nodes->foreach(
        [&active_nodes, &nodes](const NodeId& nid, const NodeInfo& ni) {
          if (ni.status == ccf::NodeStatus::TRUSTED)
          {
            active_nodes[nid] = ni;
          }
          else if (ni.status == ccf::NodeStatus::RETIRED)
          {
            // If a node is retired, but knowledge of their retirement has not
            // yet been globally committed, they are still considered active.
            auto cni = nodes->get_globally_committed(nid);
            if (cni.has_value() && !cni->retired_committed)
            {
              active_nodes[nid] = ni;
            }
          }
          return true;
        });
 
      return active_nodes;
    }
 
    // Service status should use a state machine, very much like NodeState.
    static void create_service(
      ccf::kv::Tx& tx,
      const ccf::crypto::Pem& service_cert,
      ccf::TxID create_txid,
      nlohmann::json service_data = nullptr,
      bool recovering = false)
    {
      auto* service = tx.rw<ccf::Service>(Tables::SERVICE);
 
      size_t recovery_count = 0;
      std::optional<ccf::kv::Version> prev_service_created_at = std::nullopt;
 
      if (service->has())
      {
        const auto prev_service_info = service->get();
        if (!prev_service_info.has_value())
        {
          throw std::logic_error("Failed to get previous service info");
        }
 
        if (!prev_service_info->current_service_create_txid.has_value())
        {
          throw std::logic_error(
            "Starting TX for the previous service doesn't have "
            "current_service_create_txid recorded");
        }
        prev_service_created_at =
          prev_service_info->current_service_create_txid.value().seqno;
 
        auto* previous_service_identity = tx.wo<ccf::PreviousServiceIdentity>(
          ccf::Tables::PREVIOUS_SERVICE_IDENTITY);
        previous_service_identity->put(prev_service_info->cert);
 
        auto* last_signed_root = tx.wo<ccf::PreviousServiceLastSignedRoot>(
          ccf::Tables::PREVIOUS_SERVICE_LAST_SIGNED_ROOT);
        auto* sigs = tx.ro<ccf::Signatures>(ccf::Tables::SIGNATURES);
        if (!sigs->has())
        {
          throw std::logic_error(
            "Previous service doesn't have any signed transactions");
        }
        auto sig_opt = sigs->get();
        if (!sig_opt.has_value())
        {
          throw std::logic_error(
            "Previous service doesn't have signature value");
        }
        last_signed_root->put(sig_opt->root);
 
        // Record number of recoveries for service. If the value does
        // not exist in the table (i.e. pre 2.x ledger), assume it is the
        // first recovery.
        recovery_count = prev_service_info->recovery_count.value_or(0) + 1;
      }
 
      service->put(
        {service_cert,
         recovering ? ServiceStatus::RECOVERING : ServiceStatus::OPENING,
         prev_service_created_at,
         recovery_count,
         service_data,
         create_txid});
    }
 
    static bool is_service_created(
      ccf::kv::ReadOnlyTx& tx, const ccf::crypto::Pem& expected_service_cert)
    {
      auto* service = tx.ro<ccf::Service>(Tables::SERVICE);
      auto service_info = service->get();
      return service_info.has_value() &&
        service_info->cert == expected_service_cert;
    }
 
    static bool endorse_previous_identity(
      ccf::kv::Tx& tx, const ccf::crypto::ECKeyPair_OpenSSL& service_key)
    {
      auto* service = tx.ro<ccf::Service>(Tables::SERVICE);
      auto active_service = service->get();
 
      auto* previous_identity_endorsement =
        tx.rw<ccf::PreviousServiceIdentityEndorsement>(
          ccf::Tables::PREVIOUS_SERVICE_IDENTITY_ENDORSEMENT);
 
      ccf::CoseEndorsement endorsement{};
      std::vector<uint8_t> key_to_endorse{};
      std::vector<uint8_t> previous_root{};
 
      endorsement.endorsing_key = service_key.public_key_der();
 
      if (previous_identity_endorsement->has())
      {
        const auto prev_endorsement = previous_identity_endorsement->get();
        if (!prev_endorsement.has_value())
        {
          throw std::logic_error("Failed to get previous endorsement");
        }
 
        if (
          !active_service.has_value() ||
          !active_service->current_service_create_txid.has_value())
        {
          throw std::logic_error(
            "Active service or current_service_create_txid is not set");
        }
 
        endorsement.endorsement_epoch_begin =
          prev_endorsement->endorsement_epoch_end.has_value() ?
          next_tx_if_recovery(prev_endorsement->endorsement_epoch_end.value()) :
          prev_endorsement->endorsement_epoch_begin;
 
        endorsement.endorsement_epoch_end = previous_tx_if_recovery(
          active_service->current_service_create_txid.value());
 
        endorsement.previous_version =
          previous_identity_endorsement->get_version_of_previous_write();
 
        key_to_endorse = prev_endorsement->endorsing_key;
 
        auto* previous_service_last_signed_root =
          tx.ro<ccf::PreviousServiceLastSignedRoot>(
            ccf::Tables::PREVIOUS_SERVICE_LAST_SIGNED_ROOT);
        if (!previous_service_last_signed_root->has())
        {
          LOG_FAIL_FMT(
            "Failed to sign previous service identity: no last signed root");
          return false;
        }
 
        auto root_opt = previous_service_last_signed_root->get();
        if (!root_opt.has_value())
        {
          LOG_FAIL_FMT(
            "Failed to sign previous service identity: no last signed root "
            "value");
          return false;
        }
        const auto root = root_opt.value();
        previous_root.assign(root.h.begin(), root.h.end());
      }
      else
      {
        // There's no `epoch_end` for the a self-endorsement, leave it
        // open-ranged and sign the current service key.
 
        if (
          !active_service.has_value() ||
          !active_service->current_service_create_txid.has_value())
        {
          throw std::logic_error(
            "Active service or current_service_create_txid is not set");
        }
 
        endorsement.endorsement_epoch_begin =
          active_service->current_service_create_txid.value();
 
        key_to_endorse = endorsement.endorsing_key;
      }
 
      std::vector<std::shared_ptr<ccf::crypto::COSEParametersFactory>>
        ccf_headers_arr{};
      ccf_headers_arr.push_back(ccf::crypto::cose_params_string_string(
        ccf::crypto::COSE_PHEADER_KEY_RANGE_BEGIN,
        endorsement.endorsement_epoch_begin.to_str()));
      if (endorsement.endorsement_epoch_end)
      {
        ccf_headers_arr.push_back(ccf::crypto::cose_params_string_string(
          ccf::crypto::COSE_PHEADER_KEY_RANGE_END,
          endorsement.endorsement_epoch_end->to_str()));
      }
      if (!previous_root.empty())
      {
        ccf_headers_arr.push_back(ccf::crypto::cose_params_string_bytes(
          ccf::crypto::COSE_PHEADER_KEY_EPOCH_LAST_MERKLE_ROOT, previous_root));
      }
 
      const auto time_since_epoch =
        std::chrono::duration_cast<std::chrono::seconds>(
          std::chrono::system_clock::now().time_since_epoch())
          .count();
 
      auto cwt_headers =
        std::static_pointer_cast<ccf::crypto::COSEParametersFactory>(
          std::make_shared<ccf::crypto::COSEParametersMap>(
            std::make_shared<ccf::crypto::COSEMapIntKey>(
              ccf::crypto::COSE_PHEADER_KEY_CWT),
            ccf::crypto::COSEHeadersArray{ccf::crypto::cose_params_int_int(
              ccf::crypto::COSE_PHEADER_KEY_IAT, time_since_epoch)}));
 
      auto ccf_headers =
        std::static_pointer_cast<ccf::crypto::COSEParametersFactory>(
          std::make_shared<ccf::crypto::COSEParametersMap>(
            std::make_shared<ccf::crypto::COSEMapStringKey>(
              ccf::crypto::COSE_PHEADER_KEY_CCF),
            ccf_headers_arr));
 
      ccf::crypto::COSEHeadersArray pheaders{cwt_headers, ccf_headers};
 
      try
      {
        endorsement.endorsement = cose_sign1(
          service_key,
          pheaders,
          key_to_endorse,
          false // detached payload
        );
      }
      catch (const ccf::crypto::COSESignError& e)
      {
        LOG_FAIL_FMT("Failed to sign previous service identity: {}", e.what());
        return false;
      }
 
      previous_identity_endorsement->put(endorsement);
      return true;
    }
 
    static bool open_service(ccf::kv::Tx& tx)
    {
      auto* service = tx.rw<ccf::Service>(Tables::SERVICE);
 
      auto active_recovery_participants_count =
        get_active_recovery_participants(tx).size();
      auto active_recovery_owners_count = get_active_recovery_owners(tx).size();
      if (
        active_recovery_participants_count == 0 &&
        active_recovery_owners_count != 0)
      {
        if (get_recovery_threshold(tx) > 1)
        {
          LOG_FAIL_FMT(
            "Cannot open network as a network with only active recovery owners "
            "({}) can have "
            "a recovery threshold of 1 but current recovery threshold value is "
            "({})",
            active_recovery_owners_count,
            get_recovery_threshold(tx));
        }
      }
      else if (active_recovery_participants_count < get_recovery_threshold(tx))
      {
        LOG_FAIL_FMT(
          "Cannot open network as number of active recovery members ({}) is "
          "less than recovery threshold ({})",
          active_recovery_participants_count,
          get_recovery_threshold(tx));
        return false;
      }
 
      auto active_service = service->get();
      if (!active_service.has_value())
      {
        LOG_FAIL_FMT("Failed to get active service");
        return false;
      }
 
      if (active_service->status == ServiceStatus::OPEN)
      {
        // If the service is already open, return with no effect
        return true;
      }
 
      if (
        active_service->status != ServiceStatus::OPENING &&
        active_service->status != ServiceStatus::WAITING_FOR_RECOVERY_SHARES)
      {
        LOG_FAIL_FMT(
          "Could not open current service: status is not OPENING or "
          "WAITING_FOR_RECOVERY_SHARES");
        return false;
      }
 
      active_service->status = ServiceStatus::OPEN;
      service->put(active_service.value());
 
      return true;
    }
 
    static std::optional<ServiceStatus> get_service_status(
      ccf::kv::ReadOnlyTx& tx)
    {
      auto* service = tx.ro<ccf::Service>(Tables::SERVICE);
      auto active_service = service->get();
      if (!active_service.has_value())
      {
        LOG_FAIL_FMT("Failed to get active service");
        return {};
      }
 
      return active_service->status;
    }
 
    static void trust_node(
      ccf::kv::Tx& tx,
      const NodeId& node_id,
      ccf::kv::Version latest_ledger_secret_seqno)
    {
      auto* nodes = tx.rw<ccf::Nodes>(Tables::NODES);
      auto node_info = nodes->get(node_id);
 
      if (!node_info.has_value())
      {
        throw std::logic_error(fmt::format("Node {} does not exist", node_id));
      }
 
      if (node_info->status == NodeStatus::RETIRED)
      {
        throw std::logic_error(fmt::format("Node {} is retired", node_id));
      }
 
      node_info->status = NodeStatus::TRUSTED;
      node_info->ledger_secret_seqno = latest_ledger_secret_seqno;
      nodes->put(node_id, node_info.value());
 
      LOG_INFO_FMT("Node {} is now {}", node_id, node_info->status);
    }
 
    static void set_constitution(
      ccf::kv::Tx& tx, const std::string& constitution)
    {
      tx.rw<ccf::Constitution>(Tables::CONSTITUTION)->put(constitution);
    }
 
    static void trust_node_measurement(
      ccf::kv::Tx& tx,
      const pal::PlatformAttestationMeasurement& node_measurement,
      const QuoteFormat& platform)
    {
      switch (platform)
      {
        case QuoteFormat::insecure_virtual:
        {
          tx.wo<VirtualMeasurements>(Tables::NODE_VIRTUAL_MEASUREMENTS)
            ->put(
              pal::VirtualAttestationMeasurement(
                node_measurement.data.begin(), node_measurement.data.end()),
              CodeStatus::ALLOWED_TO_JOIN);
          break;
        }
        case QuoteFormat::oe_sgx_v1:
        {
          tx.wo<CodeIDs>(Tables::NODE_CODE_IDS)
            ->put(
              pal::SgxAttestationMeasurement(node_measurement),
              CodeStatus::ALLOWED_TO_JOIN);
          break;
        }
        case QuoteFormat::amd_sev_snp_v1:
        {
          tx.wo<SnpMeasurements>(Tables::NODE_SNP_MEASUREMENTS)
            ->put(
              pal::SnpAttestationMeasurement(node_measurement),
              CodeStatus::ALLOWED_TO_JOIN);
          break;
        }
        default:
        {
          throw std::logic_error(fmt::format(
            "Unexpected quote format {} when trusting node code id", platform));
        }
      }
    }
 
    static void trust_node_virtual_host_data(
      ccf::kv::Tx& tx, const HostData& host_data)
    {
      auto* host_data_table =
        tx.wo<ccf::VirtualHostDataMap>(Tables::VIRTUAL_HOST_DATA);
      host_data_table->insert(host_data);
    }
 
    static void trust_node_snp_host_data(
      ccf::kv::Tx& tx,
      const HostData& host_data,
      const std::optional<HostDataMetadata>& security_policy = std::nullopt)
    {
      auto* host_data_table = tx.wo<ccf::SnpHostDataMap>(Tables::HOST_DATA);
      if (security_policy.has_value())
      {
        auto raw_security_policy =
          ccf::crypto::raw_from_b64(security_policy.value());
        host_data_table->put(
          host_data, {raw_security_policy.begin(), raw_security_policy.end()});
      }
      else
      {
        LOG_TRACE_FMT("Trusting node with unset policy");
        host_data_table->put(host_data, pal::snp::NO_SECURITY_POLICY);
      }
    }
 
    static void trust_node_uvm_endorsements(
      ccf::kv::Tx& tx,
      const std::optional<pal::UVMEndorsements>& uvm_endorsements)
    {
      if (!uvm_endorsements.has_value())
      {
        // UVM endorsements are optional
        return;
      }
 
      auto* uvme =
        tx.rw<ccf::SNPUVMEndorsements>(Tables::NODE_SNP_UVM_ENDORSEMENTS);
      uvme->put(
        uvm_endorsements->did,
        {{uvm_endorsements->feed, {uvm_endorsements->svn}}});
    }
 
    static void trust_node_snp_tcb_version(
      ccf::kv::Tx& tx, pal::snp::Attestation& attestation)
    {
      if (attestation.version < pal::snp::minimum_attestation_version)
      {
        throw std::logic_error(fmt::format(
          "SEV-SNP: attestation version {} is not supported. Minimum "
          "supported version is {}",
          attestation.version,
          pal::snp::minimum_attestation_version));
      }
      // As cpuid -> attestation cpuid is surjective, we must use the local
      // cpuid and validate it against the attestation's cpuid
      auto cpuid = pal::snp::get_cpuid_untrusted();
      if (
        cpuid.get_family_id() != attestation.cpuid_fam_id ||
        cpuid.get_model_id() != attestation.cpuid_mod_id ||
        cpuid.stepping != attestation.cpuid_step)
      {
        throw std::runtime_error(fmt::format(
          "CPU-sourced cpuid does not match attestation cpuid ({} != {}, {}, "
          "{})",
          cpuid.hex_str(),
          attestation.cpuid_fam_id,
          attestation.cpuid_mod_id,
          attestation.cpuid_step));
      }
      auto* h = tx.wo<ccf::SnpTcbVersionMap>(Tables::SNP_TCB_VERSIONS);
      auto product = pal::snp::get_sev_snp_product(cpuid);
      h->put(cpuid.hex_str(), attestation.reported_tcb.to_policy(product));
    }
 
    static void init_configuration(
      ccf::kv::Tx& tx, const ServiceConfiguration& configuration)
    {
      auto* config = tx.rw<ccf::Configuration>(Tables::CONFIGURATION);
      if (config->has())
      {
        throw std::logic_error(
          "Cannot initialise service configuration: configuration already "
          "exists");
      }
 
      config->put(configuration);
    }
 
    static bool set_recovery_threshold(ccf::kv::Tx& tx, size_t threshold)
    {
      auto* config = tx.rw<ccf::Configuration>(Tables::CONFIGURATION);
 
      if (threshold == 0)
      {
        LOG_FAIL_FMT("Cannot set recovery threshold to 0");
        return false;
      }
 
      auto service_status = get_service_status(tx);
      if (!service_status.has_value())
      {
        LOG_FAIL_FMT("Failed to get active service");
        return false;
      }
 
      if (service_status.value() == ServiceStatus::WAITING_FOR_RECOVERY_SHARES)
      {
        // While waiting for recovery shares, the recovery threshold cannot be
        // modified. Otherwise, the threshold could be passed without triggering
        // the end of recovery procedure
        LOG_FAIL_FMT(
          "Cannot set recovery threshold: service is currently waiting for "
          "recovery shares");
        return false;
      }
      if (service_status.value() == ServiceStatus::OPEN)
      {
        auto active_recovery_participants_count =
          get_active_recovery_participants(tx).size();
        auto active_recovery_owners_count =
          get_active_recovery_owners(tx).size();
 
        if (
          active_recovery_owners_count != 0 &&
          active_recovery_participants_count == 0)
        {
          if (threshold > 1)
          {
            LOG_FAIL_FMT(
              "Cannot set recovery threshold to {} when only "
              "active consortium members ({}) that are of type recovery owner "
              "exist.",
              threshold,
              active_recovery_owners_count);
            return false;
          }
        }
        else if (threshold > active_recovery_participants_count)
        {
          LOG_FAIL_FMT(
            "Cannot set recovery threshold to {} as it is greater than the "
            "number of active recovery participant members ({})",
            threshold,
            active_recovery_participants_count);
          return false;
        }
      }
 
      auto current_config = config->get();
      if (!current_config.has_value())
      {
        throw std::logic_error("Configuration should already be set");
      }
 
      current_config->recovery_threshold = threshold;
      config->put(current_config.value());
      return true;
    }
 
    static size_t get_recovery_threshold(ccf::kv::ReadOnlyTx& tx)
    {
      auto* config = tx.ro<ccf::Configuration>(Tables::CONFIGURATION);
      auto current_config = config->get();
      if (!current_config.has_value())
      {
        throw std::logic_error(
          "Failed to get recovery threshold: No active configuration found");
      }
      return current_config->recovery_threshold;
    }
  };
}