view Resources/Orthanc/Sdk-1.12.0/orthanc/OrthancDatabasePlugin.proto @ 536:4ecf50a4521c find-refactoring

sync ISqlLookupFormatter from Orthanc + fix bug 224: LIMIT shall not be used with MSSQL
author Alain Mazy <am@orthanc.team>
date Fri, 06 Sep 2024 16:56:37 +0200
parents 1938ba8fba35
children
line wrap: on
line source

/**
 * Orthanc - A Lightweight, RESTful DICOM Store
 * Copyright (C) 2012-2016 Sebastien Jodogne, Medical Physics
 * Department, University Hospital of Liege, Belgium
 * Copyright (C) 2017-2023 Osimis S.A., Belgium
 * Copyright (C) 2021-2023 Sebastien Jodogne, ICTEAM UCLouvain, Belgium
 *
 * This program is free software: you can redistribute it and/or
 * modify it under the terms of the GNU General Public License as
 * published by the Free Software Foundation, either version 3 of the
 * License, or (at your option) any later version.
 * 
 * This program is distributed in the hope that it will be useful, but
 * WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
 * General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with this program. If not, see <http://www.gnu.org/licenses/>.
 **/


/**
 * This Protocol Buffers prototype describes the exchanges between the
 * Orthanc core and its database plugins. The various calls correspond
 * to the "IDatabaseWrapper" interface in the source code of Orthanc.
 *
 * WARNING: *NEVER* modify or remove existing entries. It is only
 * allowed to *add* new stuff.
 **/

syntax = "proto3";

/**
 * Turn off protobuf reflection to avoid clashes between the Orthanc
 * core and the database plugin, otherwise both will try to register
 * the same messages in the process-wide descriptor pool, which would
 * result in protobuf error "File already exists in database".
 **/
option optimize_for = LITE_RUNTIME;

package Orthanc.DatabasePluginMessages;


/**
 * Data structures that are common with the Orthanc core.
 **/

message FileInfo {
  string  uuid = 1;
  int32   content_type = 2;      // opaque "FileContentType" in Orthanc
  uint64  uncompressed_size = 3;
  string  uncompressed_hash = 4;
  int32   compression_type = 5;  // opaque "CompressionType" in Orthanc
  uint64  compressed_size = 6;
  string  compressed_hash = 7;
}

enum ResourceType {
  RESOURCE_PATIENT = 0;
  RESOURCE_STUDY = 1;
  RESOURCE_SERIES = 2;
  RESOURCE_INSTANCE = 3;
}

enum ConstraintType {
  CONSTRAINT_EQUAL = 0;
  CONSTRAINT_SMALLER_OR_EQUAL = 1;
  CONSTRAINT_GREATER_OR_EQUAL = 2;
  CONSTRAINT_WILDCARD = 3;
  CONSTRAINT_LIST = 4;
}

enum LabelsConstraintType {
  LABELS_CONSTRAINT_ALL = 0;
  LABELS_CONSTRAINT_ANY = 1;
  LABELS_CONSTRAINT_NONE = 2;
}

message ServerIndexChange {
  int64         seq = 1;
  int32         change_type = 2;   // opaque "ChangeType" in Orthanc
  ResourceType  resource_type = 3;
  string        public_id = 4;
  string        date = 5;
}

message ExportedResource {
  int64         seq = 1;
  ResourceType  resource_type = 2;
  string        public_id = 3;
  string        modality = 4;
  string        date = 5;
  string        patient_id = 6;
  string        study_instance_uid = 7;
  string        series_instance_uid = 8;
  string        sop_instance_uid = 9;
}

message DatabaseConstraint {
  ResourceType     level = 1;
  uint32           tag_group = 2;
  uint32           tag_element = 3;
  bool             is_identifier_tag = 4;
  bool             is_case_sensitive = 5;
  bool             is_mandatory = 6;
  ConstraintType   type = 7;
  repeated string  values = 8;
}


/**
 * Database-level operations.
 **/

enum DatabaseOperation {
  OPERATION_GET_SYSTEM_INFORMATION = 0;
  OPERATION_OPEN = 1;
  OPERATION_CLOSE = 2;
  OPERATION_FLUSH_TO_DISK = 3;
  OPERATION_START_TRANSACTION = 4;
  OPERATION_UPGRADE = 5;
  OPERATION_FINALIZE_TRANSACTION = 6;
}

enum TransactionType {
  TRANSACTION_READ_ONLY = 0;
  TRANSACTION_READ_WRITE = 1;
}

message GetSystemInformation {
  message Request {
  }
  message Response {
    uint32 database_version = 1;
    bool supports_flush_to_disk = 2;
    bool supports_revisions = 3;
    bool supports_labels = 4;
  }
}

message Open {
  message Request {
    message IdentifierTag {
      ResourceType level = 1;
      uint32 group = 2;
      uint32 element = 3;
      string name = 4;
    }
    repeated IdentifierTag identifier_tags = 1;
  }
  message Response {
  }
}

message Close {
  message Request {
  }
  message Response {
  }
}

message FlushToDisk {
  message Request {
  }
  message Response {
  }
}

message StartTransaction {
  message Request {
    TransactionType type = 1;
  }
  message Response {
    sfixed64 transaction = 1;
  }
}

message Upgrade {
  /**
   * It is guaranteed that a read-write transaction is created by the
   * Orthanc core before executing this operation.
   **/
  message Request {
    uint32 target_version = 1;
    sfixed64 storage_area = 2;
    sfixed64 transaction = 3;
  }
  message Response {
  }
}

message FinalizeTransaction {
  message Request {
    sfixed64 transaction = 1;
  }
  message Response {
  }
}

message DatabaseRequest {
  sfixed64           database = 1;
  DatabaseOperation  operation = 2;

  GetSystemInformation.Request  get_system_information = 100;
  Open.Request                  open = 101;
  Close.Request                 close = 102;
  FlushToDisk.Request           flush_to_disk = 103;
  StartTransaction.Request      start_transaction = 104;
  Upgrade.Request               upgrade = 105;
  FinalizeTransaction.Request   finalize_transaction = 106;
}

message DatabaseResponse {
  GetSystemInformation.Response  get_system_information = 100;
  Open.Response                  open = 101;
  Close.Response                 close = 102;
  FlushToDisk.Response           flush_to_disk = 103;
  StartTransaction.Response      start_transaction = 104;
  Upgrade.Response               upgrade = 105;
  FinalizeTransaction.Response   finalize_transaction = 106;
}


/**
 * Transaction-level operations.
 **/

enum TransactionOperation {
  OPERATION_ROLLBACK = 0;
  OPERATION_COMMIT = 1;
  OPERATION_ADD_ATTACHMENT = 2;
  OPERATION_CLEAR_CHANGES = 3;
  OPERATION_CLEAR_EXPORTED_RESOURCES = 4;
  OPERATION_DELETE_ATTACHMENT = 5;
  OPERATION_DELETE_METADATA = 6;
  OPERATION_DELETE_RESOURCE = 7;
  OPERATION_GET_ALL_METADATA = 8;
  OPERATION_GET_ALL_PUBLIC_IDS = 9;
  OPERATION_GET_ALL_PUBLIC_IDS_WITH_LIMITS = 10;
  OPERATION_GET_CHANGES = 11;
  OPERATION_GET_CHILDREN_INTERNAL_ID = 12;
  OPERATION_GET_CHILDREN_PUBLIC_ID = 13;
  OPERATION_GET_EXPORTED_RESOURCES = 14;
  OPERATION_GET_LAST_CHANGE = 15;
  OPERATION_GET_LAST_EXPORTED_RESOURCE = 16;
  OPERATION_GET_MAIN_DICOM_TAGS = 17;
  OPERATION_GET_PUBLIC_ID = 18;
  OPERATION_GET_RESOURCES_COUNT = 19;
  OPERATION_GET_RESOURCE_TYPE = 20;
  OPERATION_GET_TOTAL_COMPRESSED_SIZE = 21;
  OPERATION_GET_TOTAL_UNCOMPRESSED_SIZE = 22;
  OPERATION_IS_PROTECTED_PATIENT = 23;
  OPERATION_LIST_AVAILABLE_ATTACHMENTS = 24;
  OPERATION_LOG_CHANGE = 25;
  OPERATION_LOG_EXPORTED_RESOURCE = 26;
  OPERATION_LOOKUP_ATTACHMENT = 27;
  OPERATION_LOOKUP_GLOBAL_PROPERTY = 28;
  OPERATION_LOOKUP_METADATA = 29;
  OPERATION_LOOKUP_PARENT = 30;
  OPERATION_LOOKUP_RESOURCE = 31;
  OPERATION_SELECT_PATIENT_TO_RECYCLE = 32;
  OPERATION_SELECT_PATIENT_TO_RECYCLE_WITH_AVOID = 33;
  OPERATION_SET_GLOBAL_PROPERTY = 34;
  OPERATION_CLEAR_MAIN_DICOM_TAGS = 35;
  OPERATION_SET_METADATA = 36;
  OPERATION_SET_PROTECTED_PATIENT = 37;
  OPERATION_IS_DISK_SIZE_ABOVE = 38;
  OPERATION_LOOKUP_RESOURCES = 39;
  OPERATION_CREATE_INSTANCE = 40;
  OPERATION_SET_RESOURCES_CONTENT = 41;
  OPERATION_GET_CHILDREN_METADATA = 42;
  OPERATION_GET_LAST_CHANGE_INDEX = 43;
  OPERATION_LOOKUP_RESOURCE_AND_PARENT = 44;
  OPERATION_ADD_LABEL = 45;        // New in Orthanc 1.12.0
  OPERATION_REMOVE_LABEL = 46;     // New in Orthanc 1.12.0
  OPERATION_LIST_LABELS = 47;      // New in Orthanc 1.12.0
}

message Rollback {
  message Request {
  }
  message Response {
  }
}

message Commit {
  message Request {
    int64 file_size_delta = 1;
  }
  message Response {
  }
}

message AddAttachment {
  message Request {
    int64 id = 1;
    FileInfo attachment = 2;
    int64 revision = 3;
  }
  message Response {
  }
}

message ClearChanges {
  message Request {
  }
  message Response {
  }
}

message ClearExportedResources {
  message Request {
  }
  message Response {
  }
}

message DeleteAttachment {
  message Request {
    int64 id = 1;
    int32 type = 2;
  }
  message Response {
    FileInfo deleted_attachment = 1;
  }
}

message DeleteMetadata {
  message Request {
    int64 id = 1;
    int32 type = 2;
  }
  message Response {
  }
}

message DeleteResource {
  message Request {
    int64 id = 1;
  }
  message Response {
    message Resource {
      ResourceType level = 1;
      string public_id = 2;
    }
    repeated FileInfo deleted_attachments = 1;
    repeated Resource deleted_resources = 2;
    bool is_remaining_ancestor = 3;
    Resource remaining_ancestor = 4;
  }
}

message GetAllMetadata {
  message Request {
    int64 id = 1;
  }
  message Response {
    message Metadata {
      int32 type = 1;
      string value = 2;
    }
    repeated Metadata metadata = 1;
  }
}

message GetAllPublicIds {
  message Request {
    ResourceType resource_type = 1;
  }
  message Response {
    repeated string ids = 1;
  }
}

message GetAllPublicIdsWithLimits {
  message Request {
    ResourceType resource_type = 1;
    int64 since = 2;
    uint32 limit = 3;
  }
  message Response {
    repeated string ids = 1;
  }
}

message GetChanges {
  message Request {
    int64 since = 1;
    uint32 limit = 2;
  }
  message Response {
    repeated ServerIndexChange changes = 1;
    bool done = 2;
  }
}

message GetChildrenInternalId {
  message Request {
    int64 id = 1;
  }
  message Response {
    repeated int64 ids = 1;
  }
}

message GetChildrenPublicId {
  message Request {
    int64 id = 1;
  }
  message Response {
    repeated string ids = 1;
  }
}

message GetExportedResources {
  message Request {
    int64 since = 1;
    uint32 limit = 2;
  }
  message Response {
    repeated ExportedResource resources = 1;
    bool done = 2;
  }
}

message GetLastChange {
  message Request {
  }
  message Response {
    bool found = 1;
    ServerIndexChange change = 2;
  }
}

message GetLastExportedResource {
  message Request {
  }
  message Response {
    bool found = 1;
    ExportedResource resource = 2;
  }
}

message GetMainDicomTags {
  message Request {
    int64 id = 1;
  }
  message Response {
    message Tag {
      uint32 group = 1;
      uint32 element = 2;
      string value = 3;
    }
    repeated Tag tags = 1;
  }
}

message GetPublicId {
  message Request {
    int64 id = 1;
  }
  message Response {
    string id = 1;
  }
}

message GetResourcesCount {
  message Request {
    ResourceType type = 1;
  }
  message Response {
    uint64 count = 1;
  }
}

message GetResourceType {
  message Request {
    int64 id = 1;
  }
  message Response {
    ResourceType type = 1;
  }
}

message GetTotalCompressedSize {
  message Request {
  }
  message Response {
    uint64 size = 1;
  }
}

message GetTotalUncompressedSize {
  message Request {
  }
  message Response {
    uint64 size = 1;
  }
}

message IsProtectedPatient {
  message Request {
    int64 patient_id = 1;
  }
  message Response {
    bool protected_patient = 1;
  }
}

message ListAvailableAttachments {
  message Request {
    int64 id = 1;
  }
  message Response {
    repeated int32 attachments = 1;
  }
}

message LogChange {
  message Request {
    int32         change_type = 1;
    ResourceType  resource_type = 2;
    int64         resource_id = 3;
    string        date = 4;
  }
  message Response {
  }
}

message LogExportedResource {
  message Request {
    ResourceType  resource_type = 1;
    string        public_id = 2;
    string        modality = 3;
    string        date = 4;
    string        patient_id = 5;
    string        study_instance_uid = 6;
    string        series_instance_uid = 7;
    string        sop_instance_uid = 8;
  }
  message Response {
  }
}

message LookupAttachment {
  message Request {
    int64 id = 1;
    int32 content_type = 2;
  }
  message Response {
    bool found = 1;
    FileInfo attachment = 2;
    int64 revision = 3;
  }
}

message LookupGlobalProperty {
  message Request {
    string server_id = 1;
    int32 property = 2;
  }
  message Response {
    bool found = 1;
    string value = 2;
  }
}

message LookupMetadata {
  message Request {
    int64 id = 1;
    int32 metadata_type = 2;
  }
  message Response {
    bool found = 1;
    string value = 2;
    int64 revision = 3;
  }
}

message LookupParent {
  message Request {
    int64 id = 1;
  }
  message Response {
    bool found = 1;
    int64 parent = 2;
  }
}

message LookupResource {
  message Request {
    string public_id = 1;
  }
  message Response {
    bool found = 1;
    int64 internal_id = 2;
    ResourceType type = 3;
  }
}

message SelectPatientToRecycle {
  message Request {
  }
  message Response {
    bool found = 1;
    int64 patient_id = 2;
  }
}

message SelectPatientToRecycleWithAvoid {
  message Request {
    int64 patient_id_to_avoid = 1;
  }
  message Response {
    bool found = 1;
    int64 patient_id = 2;
  }
}

message SetGlobalProperty {
  message Request {
    string server_id = 1;
    int32 property = 2;
    string value = 3;
  }
  message Response {
  }
}

message ClearMainDicomTags {
  message Request {
    int64 id = 1;
  }
  message Response {
  }
}

message SetMetadata {
  message Request {
    int64 id = 1;
    int32 metadata_type = 2;
    string value = 3;
    int64 revision = 4;
  }
  message Response {
  }
}

message SetProtectedPatient {
  message Request {
    int64 patient_id = 1;
    bool protected_patient = 2;
  }
  message Response {
  }
}

message IsDiskSizeAbove {
  message Request {
    uint64 threshold = 1;
  }
  message Response {
    bool result = 1;
  }
}

message LookupResources {
  message Request {
    repeated DatabaseConstraint lookup = 1;
    ResourceType query_level = 2;
    uint32 limit = 3;
    bool retrieve_instances_ids = 4;
    repeated string labels = 5;                  // New in Orthanc 1.12.0
    LabelsConstraintType labels_constraint = 6;  // New in Orthanc 1.12.0
  }
  message Response {
    repeated string resources_ids = 1;
    repeated string instances_ids = 2;  // Only filled if "retrieve_instances" is true
  }
}

message CreateInstance {
  message Request {
    string patient = 1;
    string study = 2;
    string series = 3;
    string instance = 4;
  }
  message Response {
    bool is_new_instance = 1;
    int64 instance_id = 2;

    // The fields below are only set if "is_new_instance" is true
    bool is_new_patient = 3;
    bool is_new_study = 4;
    bool is_new_series = 5;
    int64 patient_id = 6;
    int64 study_id = 7;
    int64 series_id = 8;
  }
}

message SetResourcesContent {
  message Request {
    message Tag {
      int64 resource_id = 1;
      bool is_identifier = 2;
      uint32 group = 3;
      uint32 element = 4;
      string value = 5;
    }

    message Metadata {
      int64 resource_id = 1;
      int32 metadata = 2;
      string value = 3;
    }

    repeated Tag tags = 1;
    repeated Metadata metadata = 2;
  }
  message Response {
  }
}

message GetChildrenMetadata {
  message Request {
    int64 id = 1;
    int32 metadata = 2;
  }
  message Response {
    repeated string values = 1;
  }
}

message GetLastChangeIndex {
  message Request {
  }
  message Response {
    int64 result = 1;
  }
}

message LookupResourceAndParent {
  message Request {
    string public_id = 1;
  }
  message Response {
    bool found = 1;
    int64 id = 2;
    ResourceType type = 3;
    string parent_public_id = 4;  // Only for study, series, or instance
  }
}

message AddLabel {
  message Request {
    int64 id = 1;
    string label = 2;
  }
  message Response {
  }
}

message RemoveLabel {
  message Request {
    int64 id = 1;
    string label = 2;
  }
  message Response {
  }
}

message ListLabels {
  message Request {
    bool single_resource = 1;
    int64 id = 2;  // Only if "single_resource" is "true"
  }
  message Response {
    repeated string labels = 1;
  }
}

message TransactionRequest {
  sfixed64              transaction = 1;
  TransactionOperation  operation = 2;

  Rollback.Request                        rollback = 100;
  Commit.Request                          commit = 101;
  AddAttachment.Request                   add_attachment = 102;
  ClearChanges.Request                    clear_changes = 103;
  ClearExportedResources.Request          clear_exported_resources = 104;
  DeleteAttachment.Request                delete_attachment = 105;
  DeleteMetadata.Request                  delete_metadata = 106;
  DeleteResource.Request                  delete_resource = 107;
  GetAllMetadata.Request                  get_all_metadata = 108;
  GetAllPublicIds.Request                 get_all_public_ids = 109;
  GetAllPublicIdsWithLimits.Request       get_all_public_ids_with_limits = 110;
  GetChanges.Request                      get_changes = 111;
  GetChildrenInternalId.Request           get_children_internal_id = 112;
  GetChildrenPublicId.Request             get_children_public_id = 113;
  GetExportedResources.Request            get_exported_resources = 114;
  GetLastChange.Request                   get_last_change = 115;
  GetLastExportedResource.Request         get_last_exported_resource = 116;
  GetMainDicomTags.Request                get_main_dicom_tags = 117;
  GetPublicId.Request                     get_public_id = 118;
  GetResourcesCount.Request               get_resources_count = 119;
  GetResourceType.Request                 get_resource_type = 120;
  GetTotalCompressedSize.Request          get_total_compressed_size = 121;
  GetTotalUncompressedSize.Request        get_total_uncompressed_size = 122;
  IsProtectedPatient.Request              is_protected_patient = 123;
  ListAvailableAttachments.Request        list_available_attachments = 124;
  LogChange.Request                       log_change = 125;
  LogExportedResource.Request             log_exported_resource = 126;
  LookupAttachment.Request                lookup_attachment = 127;
  LookupGlobalProperty.Request            lookup_global_property = 128;
  LookupMetadata.Request                  lookup_metadata = 129;
  LookupParent.Request                    lookup_parent = 130;
  LookupResource.Request                  lookup_resource = 131;
  SelectPatientToRecycle.Request          select_patient_to_recycle = 132;
  SelectPatientToRecycleWithAvoid.Request select_patient_to_recycle_with_avoid = 133;
  SetGlobalProperty.Request               set_global_property = 134;
  ClearMainDicomTags.Request              clear_main_dicom_tags = 135;
  SetMetadata.Request                     set_metadata = 136;
  SetProtectedPatient.Request             set_protected_patient = 137;
  IsDiskSizeAbove.Request                 is_disk_size_above = 138;
  LookupResources.Request                 lookup_resources = 139;
  CreateInstance.Request                  create_instance = 140;
  SetResourcesContent.Request             set_resources_content = 141;
  GetChildrenMetadata.Request             get_children_metadata = 142;
  GetLastChangeIndex.Request              get_last_change_index = 143;
  LookupResourceAndParent.Request         lookup_resource_and_parent = 144;
  AddLabel.Request                        add_label = 145;
  RemoveLabel.Request                     remove_label = 146;
  ListLabels.Request                      list_labels = 147;
}

message TransactionResponse {
  Rollback.Response                        rollback = 100;
  Commit.Response                          commit = 101;
  AddAttachment.Response                   add_attachment = 102;
  ClearChanges.Response                    clear_changes = 103;
  ClearExportedResources.Response          clear_exported_resources = 104;
  DeleteAttachment.Response                delete_attachment = 105;
  DeleteMetadata.Response                  delete_metadata = 106;
  DeleteResource.Response                  delete_resource = 107;
  GetAllMetadata.Response                  get_all_metadata = 108;
  GetAllPublicIds.Response                 get_all_public_ids = 109;
  GetAllPublicIdsWithLimits.Response       get_all_public_ids_with_limits = 110;
  GetChanges.Response                      get_changes = 111;
  GetChildrenInternalId.Response           get_children_internal_id = 112;
  GetChildrenPublicId.Response             get_children_public_id = 113;
  GetExportedResources.Response            get_exported_resources = 114;
  GetLastChange.Response                   get_last_change = 115;
  GetLastExportedResource.Response         get_last_exported_resource = 116;
  GetMainDicomTags.Response                get_main_dicom_tags = 117;
  GetPublicId.Response                     get_public_id = 118;
  GetResourcesCount.Response               get_resources_count = 119;
  GetResourceType.Response                 get_resource_type = 120;
  GetTotalCompressedSize.Response          get_total_compressed_size = 121;
  GetTotalUncompressedSize.Response        get_total_uncompressed_size = 122;
  IsProtectedPatient.Response              is_protected_patient = 123;
  ListAvailableAttachments.Response        list_available_attachments = 124;
  LogChange.Response                       log_change = 125;
  LogExportedResource.Response             log_exported_resource = 126;
  LookupAttachment.Response                lookup_attachment = 127;
  LookupGlobalProperty.Response            lookup_global_property = 128;
  LookupMetadata.Response                  lookup_metadata = 129;
  LookupParent.Response                    lookup_parent = 130;
  LookupResource.Response                  lookup_resource = 131;
  SelectPatientToRecycle.Response          select_patient_to_recycle = 132;
  SelectPatientToRecycleWithAvoid.Response select_patient_to_recycle_with_avoid = 133;
  SetGlobalProperty.Response               set_global_property = 134;
  ClearMainDicomTags.Response              clear_main_dicom_tags = 135;
  SetMetadata.Response                     set_metadata = 136;
  SetProtectedPatient.Response             set_protected_patient = 137;
  IsDiskSizeAbove.Response                 is_disk_size_above = 138;
  LookupResources.Response                 lookup_resources = 139;
  CreateInstance.Response                  create_instance = 140;
  SetResourcesContent.Response             set_resources_content = 141;
  GetChildrenMetadata.Response             get_children_metadata = 142;
  GetLastChangeIndex.Response              get_last_change_index = 143;
  LookupResourceAndParent.Response         lookup_resource_and_parent = 144;
  AddLabel.Response                        add_label = 145;
  RemoveLabel.Response                     remove_label = 146;
  ListLabels.Response                      list_labels = 147;
}

enum RequestType {
  REQUEST_DATABASE = 0;
  REQUEST_TRANSACTION = 1;
}

message Request {
  RequestType         type = 1;
  DatabaseRequest     database_request = 2;
  TransactionRequest  transaction_request = 3;
}

message Response {
  DatabaseResponse     database_response = 2;
  TransactionResponse  transaction_response = 3;
}