Source code for spinetoolbox.spine_db_editor.mvcmodels.item_metadata_table_model

######################################################################################################################
# Copyright (C) 2017-2022 Spine project consortium
# Copyright Spine Toolbox contributors
# This file is part of Spine Toolbox.
# Spine Toolbox is free software: you can redistribute it and/or modify it under the terms of the GNU Lesser 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 Lesser General
# Public License for more details. You should have received a copy of the GNU Lesser General Public License along with
# this program. If not, see <http://www.gnu.org/licenses/>.
######################################################################################################################

"""Contains :class:`ItemMetadataTableModel` and associated functionality."""
from enum import auto, Enum, IntEnum, unique
from spinetoolbox.fetch_parent import FlexibleFetchParent
from .metadata_table_model_base import Column, FLAGS_EDITABLE, FLAGS_FIXED, MetadataTableModelBase


@unique
[docs]class ExtraColumn(IntEnum): """Identifiers for hidden table columns."""
[docs] ITEM_METADATA_ID = Column.max() + 1
[docs] METADATA_ID = Column.max() + 2
@unique
[docs]class ItemType(Enum): """Allowed item types."""
[docs] ENTITY = auto()
[docs] VALUE = auto()
[docs]class ItemMetadataTableModel(MetadataTableModelBase): """Model for entity and parameter value metadata."""
[docs] _ITEM_NAME_KEY = "metadata_name"
[docs] _ITEM_VALUE_KEY = "metadata_value"
def __init__(self, db_mngr, db_maps, db_editor): """ Args: db_mngr (SpineDBManager): database manager db_maps (Iterable of DatabaseMapping): database maps db_editor (SpineDBEditor): DB editor """ super().__init__(db_mngr, db_maps, db_editor) self._item_type = None self._item_ids = {} self._entity_metadata_fetch_parent = FlexibleFetchParent( "entity_metadata", handle_items_added=self.add_item_metadata, handle_items_removed=self.remove_item_metadata, handle_items_updated=self.update_item_metadata, accepts_item=self._accepts_entity_metadata_item, owner=self, ) self._parameter_value_metadata_fetch_parent = FlexibleFetchParent( "parameter_value_metadata", handle_items_added=self.add_item_metadata, handle_items_removed=self.remove_item_metadata, handle_items_updated=self.update_item_metadata, accepts_item=self._accepts_parameter_value_metadata_item, owner=self, )
[docs] def _fetch_parents(self): yield self._entity_metadata_fetch_parent yield self._parameter_value_metadata_fetch_parent
[docs] def clear(self): """Clears the model.""" self.beginResetModel() self._item_ids = {} self._data = [] self._adder_row = self._make_adder_row(None) self.endResetModel()
@staticmethod
[docs] def _make_hidden_adder_columns(): """See base class.""" return [None, None]
[docs] def _accepts_entity_metadata_item(self, item, db_map): if self._item_type != ItemType.ENTITY: return False return item["entity_id"] == self._item_ids.get(db_map)
[docs] def _accepts_parameter_value_metadata_item(self, item, db_map): if self._item_type != ItemType.VALUE: return False return item["parameter_value_id"] == self._item_ids.get(db_map)
[docs] def set_entity_ids(self, db_map_ids): """Sets the model to show metadata from given entity. Args: db_map_ids (dict): mapping from database mapping to entity's id in that database """ self._reset_metadata(ItemType.ENTITY, db_map_ids) self._reset_fetch_parents()
[docs] def set_parameter_value_ids(self, db_map_ids): """Sets the model to show metadata from given parameter value. Args: db_map_ids (dict): mapping from database mapping to value's id in that database """ self._reset_metadata(ItemType.VALUE, db_map_ids) self._reset_fetch_parents()
[docs] def _reset_metadata(self, item_type, db_map_ids): """Resets model. Args: item_type (ItemType): current item type db_map_ids (dict): mapping from database mapping to value's id in that database """ self.beginResetModel() self._item_type = item_type self._item_ids = dict(db_map_ids) self._db_maps = set(db_map_ids) default_db_map = next(iter(self._db_maps)) if self._db_maps else None self._adder_row = self._make_adder_row(default_db_map) self._data = [] self.endResetModel()
[docs] def _reset_fetch_parents(self): for parent in self._fetch_parents(): parent.reset() if self.canFetchMore(None): self.fetchMore(None)
[docs] def _add_data_to_db_mngr(self, name, value, db_map): """See base class.""" item_id = self._item_ids[db_map] if self._item_type == ItemType.ENTITY: self._db_mngr.add_ext_entity_metadata( {db_map: [{"entity_id": item_id, "metadata_name": name, "metadata_value": value}]} ) else: self._db_mngr.add_ext_parameter_value_metadata( {db_map: [{"parameter_value_id": item_id, "metadata_name": name, "metadata_value": value}]} )
[docs] def _update_data_in_db_mngr(self, id_, name, value, db_map): """See base class""" if self._item_type == ItemType.ENTITY: self._db_mngr.update_ext_entity_metadata( {db_map: [{"id": id_, "metadata_name": name, "metadata_value": value}]} ) else: self._db_mngr.update_ext_parameter_value_metadata( {db_map: [{"id": id_, "metadata_name": name, "metadata_value": value}]} )
[docs] def flags(self, index): row = index.row() column = index.column() if column == Column.DB_MAP and row < len(self._data): data_row = self._data[row] if data_row[ExtraColumn.ITEM_METADATA_ID] is not None and data_row[ExtraColumn.METADATA_ID] is not None: return FLAGS_FIXED return FLAGS_EDITABLE
@staticmethod
[docs] def _ids_from_added_item(item): """See base class.""" return item["id"], item["metadata_id"]
@staticmethod
[docs] def _extra_cells_from_added_item(item): """See base class.""" return [item["id"], item["metadata_id"]]
[docs] def _set_extra_columns(self, row, ids): """See base class.""" row[ExtraColumn.ITEM_METADATA_ID] = ids[0] row[ExtraColumn.METADATA_ID] = ids[1]
[docs] def _database_table_name(self): """See base class""" return "entity_metadata" if self._item_type == ItemType.ENTITY else "parameter_value_metadata"
[docs] def _row_id(self, row): """See base class.""" return row[ExtraColumn.ITEM_METADATA_ID]
[docs] def add_item_metadata(self, db_map_data): """Adds new item metadata from database manager to the model. Args: db_map_data (dict): added items keyed by database mapping """ self._add_data(db_map_data)
[docs] def update_item_metadata(self, db_map_data): """Updates item metadata in model after it has been updated in databases. Args: db_map_data (dict): updated metadata records """ self._update_data(db_map_data, ExtraColumn.ITEM_METADATA_ID)
[docs] def remove_item_metadata(self, db_map_data): """Removes item metadata from model after it has been removed from databases. Args: db_map_data (dict): removed items keyed by database mapping """ self._remove_data(db_map_data, ExtraColumn.ITEM_METADATA_ID)