study_repository.h

Go to the documentation of this file.

// BSD 3-Clause License
// Copyright (c) 2021-2025, 🍀☀🌕🌥 🌊
// See the LICENSE file in the project root for full license information.
 
#pragma once
 
#include "kcenon/pacs/storage/study_record.h"
 
#include <kcenon/common/patterns/result.h>
 
#include <memory>
#include <optional>
#include <string>
#include <string_view>
#include <vector>
 
#ifdef PACS_WITH_DATABASE_SYSTEM
 
#include "kcenon/pacs/storage/base_repository.h"
 
namespace kcenon::pacs::storage {
 
class study_repository : public base_repository<study_record, int64_t> {
public:
    explicit study_repository(std::shared_ptr<pacs_database_adapter> db);
    ~study_repository() override = default;
 
    study_repository(const study_repository&) = delete;
    auto operator=(const study_repository&) -> study_repository& = delete;
    study_repository(study_repository&&) noexcept = default;
    auto operator=(study_repository&&) noexcept -> study_repository& = default;
 
    // =========================================================================
    // Domain-Specific Operations
    // =========================================================================
 
    [[nodiscard]] auto upsert_study(int64_t patient_pk,
                                    std::string_view study_uid,
                                    std::string_view study_id = "",
                                    std::string_view study_date = "",
                                    std::string_view study_time = "",
                                    std::string_view accession_number = "",
                                    std::string_view referring_physician = "",
                                    std::string_view study_description = "")
        -> Result<int64_t>;
 
    [[nodiscard]] auto upsert_study(const study_record& record)
        -> Result<int64_t>;
 
    [[nodiscard]] auto find_study(std::string_view study_uid)
        -> std::optional<study_record>;
 
    [[nodiscard]] auto find_study_by_pk(int64_t pk)
        -> std::optional<study_record>;
 
    [[nodiscard]] auto search_studies(const study_query& query)
        -> Result<std::vector<study_record>>;
 
    [[nodiscard]] auto delete_study(std::string_view study_uid) -> VoidResult;
 
    [[nodiscard]] auto study_count() -> Result<size_t>;
 
    [[nodiscard]] auto study_count_for_patient(int64_t patient_pk)
        -> Result<size_t>;
 
    [[nodiscard]] auto update_modalities_in_study(int64_t study_pk)
        -> VoidResult;
 
protected:
    // =========================================================================
    // base_repository overrides
    // =========================================================================
 
    [[nodiscard]] auto map_row_to_entity(const database_row& row) const
        -> study_record override;
 
    [[nodiscard]] auto entity_to_row(const study_record& entity) const
        -> std::map<std::string, database_value> override;
 
    [[nodiscard]] auto get_pk(const study_record& entity) const
        -> int64_t override;
 
    [[nodiscard]] auto has_pk(const study_record& entity) const
        -> bool override;
 
    [[nodiscard]] auto select_columns() const
        -> std::vector<std::string> override;
 
private:
    [[nodiscard]] static auto to_like_pattern(std::string_view pattern)
        -> std::string;
 
    [[nodiscard]] auto parse_timestamp(const std::string& str) const
        -> std::chrono::system_clock::time_point;
 
    [[nodiscard]] auto format_timestamp(
        std::chrono::system_clock::time_point tp) const -> std::string;
};
 
}  // namespace kcenon::pacs::storage
 
#else  // !PACS_WITH_DATABASE_SYSTEM
 
struct sqlite3;
 
namespace kcenon::pacs::storage {
 
template <typename T>
using Result = kcenon::common::Result<T>;
 
using VoidResult = kcenon::common::VoidResult;
 
class study_repository {
public:
    explicit study_repository(sqlite3* db);
    ~study_repository();
 
    study_repository(const study_repository&) = delete;
    auto operator=(const study_repository&) -> study_repository& = delete;
    study_repository(study_repository&&) noexcept;
    auto operator=(study_repository&&) noexcept -> study_repository&;
 
    [[nodiscard]] auto upsert_study(int64_t patient_pk,
                                    std::string_view study_uid,
                                    std::string_view study_id = "",
                                    std::string_view study_date = "",
                                    std::string_view study_time = "",
                                    std::string_view accession_number = "",
                                    std::string_view referring_physician = "",
                                    std::string_view study_description = "")
        -> Result<int64_t>;
    [[nodiscard]] auto upsert_study(const study_record& record)
        -> Result<int64_t>;
    [[nodiscard]] auto find_study(std::string_view study_uid) const
        -> std::optional<study_record>;
    [[nodiscard]] auto find_study_by_pk(int64_t pk) const
        -> std::optional<study_record>;
    [[nodiscard]] auto search_studies(const study_query& query) const
        -> Result<std::vector<study_record>>;
    [[nodiscard]] auto delete_study(std::string_view study_uid) -> VoidResult;
    [[nodiscard]] auto study_count() const -> Result<size_t>;
    [[nodiscard]] auto study_count_for_patient(int64_t patient_pk) const
        -> Result<size_t>;
    [[nodiscard]] auto update_modalities_in_study(int64_t study_pk)
        -> VoidResult;
 
private:
    [[nodiscard]] auto parse_study_row(void* stmt) const -> study_record;
    [[nodiscard]] static auto to_like_pattern(std::string_view pattern)
        -> std::string;
 
    sqlite3* db_{nullptr};
};
 
}  // namespace kcenon::pacs::storage
 
#endif  // PACS_WITH_DATABASE_SYSTEM