Source code for spinetoolbox.widgets.manage_db_items_dialog

######################################################################################################################
# Copyright (C) 2017-2020 Spine project consortium
# 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/>.
######################################################################################################################

"""
Classes for custom QDialogs to add edit and remove database items.

:author: M. Marin (KTH)
:date:   13.5.2018
"""

from functools import reduce
from PySide2.QtWidgets import QDialog, QVBoxLayout, QPlainTextEdit, QDialogButtonBox, QHeaderView, QAction, QApplication
from PySide2.QtCore import Slot, Qt
from .custom_editors import IconColorEditor
from .custom_qtableview import CopyPasteTableView
from ..helpers import busy_effect


[docs]class ManageItemsDialog(QDialog): """A dialog with a CopyPasteTableView and a QDialogButtonBox. Base class for all dialogs to query user's preferences for adding/editing/managing data items. Attributes: parent (DataStoreForm): data store widget db_mngr (SpineDBManager) """ def __init__(self, parent, db_mngr): super().__init__(parent) self.db_mngr = db_mngr self.model = None self.table_view = CopyPasteTableView(self) self.table_view.horizontalHeader().setSectionResizeMode(QHeaderView.Interactive) self.table_view.horizontalHeader().setStretchLastSection(True) self.table_view.verticalHeader().setDefaultSectionSize(parent.default_row_height) self.button_box = QDialogButtonBox(self) self.button_box.setStandardButtons(QDialogButtonBox.Cancel | QDialogButtonBox.Ok) layout = QVBoxLayout(self) layout.addWidget(self.table_view) layout.addWidget(self.button_box) self.setAttribute(Qt.WA_DeleteOnClose)
[docs] def connect_signals(self): """Connect signals to slots.""" self.button_box.accepted.connect(self.accept) self.button_box.rejected.connect(self.reject) self.table_view.itemDelegate().data_committed.connect(self.set_model_data) self.model.dataChanged.connect(self._handle_model_data_changed) self.model.modelReset.connect(self._handle_model_reset)
[docs] def resize_window_to_columns(self, height=None): if height is None: height = self.sizeHint().height() margins = self.layout().contentsMargins() self.resize( margins.left() + margins.right() + self.table_view.frameWidth() * 2 + self.table_view.verticalHeader().width() + self.table_view.horizontalHeader().length(), height,
) @Slot("QModelIndex", "QModelIndex", "QVector", name="_handle_model_data_changed")
[docs] def _handle_model_data_changed(self, top_left, bottom_right, roles):
"""Reimplement in subclasses to handle changes in model data.""" @Slot("QModelIndex", "QVariant", name='set_model_data')
[docs] def set_model_data(self, index, data): """Update model data.""" if data is None: return self.model.setData(index, data, Qt.EditRole)
@Slot(name="_handle_model_reset")
[docs] def _handle_model_reset(self): """Resize columns and form.""" self.table_view.resizeColumnsToContents() self.resize_window_to_columns()
[docs]class GetObjectClassesMixin: """Provides a method to retrieve object classes for AddObjectsDialog and AddRelationshipClassesDialog. """
[docs] def make_db_map_obj_cls_lookup(self): return {db_map: {x["name"]: x for x in self.db_mngr.get_object_classes(db_map)} for db_map in self.db_maps}
[docs] def object_class_name_list(self, row): """Return a list of object class names present in all databases selected for given row. Used by `ManageObjectsDelegate`. """ db_column = self.model.header.index('databases') db_names = self.model._main_data[row][db_column] db_maps = iter(self.keyed_db_maps[x] for x in db_names.split(",") if x in self.keyed_db_maps) db_map = next(db_maps, None) if not db_map: return [] # Initalize list from first db_map object_class_name_list = list(self.db_map_obj_cls_lookup[db_map]) # Update list from remaining db_maps for db_map in db_maps: object_class_name_list = [x for x in self.db_map_obj_cls_lookup[db_map] if x in object_class_name_list] return object_class_name_list
[docs]class GetObjectsMixin: """Provides a method to retrieve objects for AddRelationshipsDialog and EditRelationshipsDialog. """
[docs] def make_db_map_obj_lookup(self): return { db_map: {(x["class_id"], x["name"]): x for x in self.db_mngr.get_objects(db_map)} for db_map in self.db_maps
}
[docs] def make_db_map_rel_cls_lookup(self): return { db_map: {(x["name"], x["object_class_name_list"]): x for x in self.db_mngr.get_relationship_classes(db_map)} for db_map in self.db_maps
}
[docs] def object_name_list(self, row, column): """Return a list of object names present in all databases selected for given row. Used by `ManageRelationshipsDelegate`. """ db_column = self.model.header.index('databases') db_names = self.model._main_data[row][db_column] db_maps = [self.keyed_db_maps[x] for x in db_names.split(",") if x in self.keyed_db_maps] rel_cls_key = (self.class_name, self.object_class_name_list) object_name_lists = [] for db_map in db_maps: relationship_classes = self.db_map_rel_cls_lookup[db_map] if rel_cls_key not in relationship_classes: continue rel_cls = relationship_classes[rel_cls_key] object_class_id_list = rel_cls["object_class_id_list"] object_class_id_list = [int(x) for x in object_class_id_list.split(",")] object_class_id = object_class_id_list[column] objects = self.db_map_obj_lookup[db_map] object_name_lists.append([name for (class_id, name) in objects if class_id == object_class_id]) if not object_name_lists: return [] return list(reduce(lambda x, y: set(x) & set(y), object_name_lists))
[docs]class ShowIconColorEditorMixin: """Provides methods to show an `IconColorEditor` upon request. """ @busy_effect
[docs] def show_icon_color_editor(self, index): editor = IconColorEditor(self) editor.set_data(index.data(Qt.DisplayRole)) editor.accepted.connect(lambda index=index, editor=editor: self.set_model_data(index, editor.data())) editor.show()
[docs] def create_object_pixmap(self, object_class_name): # TODO: create a better method in db_mngr so we don't need to access the icon_mngr attribute return self.db_mngr.icon_mngr.create_object_pixmap(object_class_name)
[docs]class CommitDialog(QDialog): """A dialog to query user's preferences for new commit. Attributes: db_names (Iterable): database names """ def __init__(self, parent, *db_names): """Initialize class""" super().__init__(parent) self.setWindowModality(Qt.ApplicationModal) self.commit_msg = None self.setWindowTitle('Commit changes to {}'.format(",".join(db_names))) form = QVBoxLayout(self) form.setContentsMargins(0, 0, 0, 0) inner_layout = QVBoxLayout() inner_layout.setContentsMargins(4, 4, 4, 4) self.action_accept = QAction(self) self.action_accept.setShortcut(QApplication.translate("Dialog", "Ctrl+Return", None, -1)) self.action_accept.triggered.connect(self.accept) self.action_accept.setEnabled(False) self.commit_msg_edit = QPlainTextEdit(self) self.commit_msg_edit.setPlaceholderText('Commit message \t(press Ctrl+Enter to commit)') self.commit_msg_edit.addAction(self.action_accept) button_box = QDialogButtonBox() button_box.addButton(QDialogButtonBox.Cancel) self.commit_button = button_box.addButton('Commit', QDialogButtonBox.AcceptRole) button_box.accepted.connect(self.accept) button_box.rejected.connect(self.reject) inner_layout.addWidget(self.commit_msg_edit) inner_layout.addWidget(button_box) # Add status bar to form form.addLayout(inner_layout) self.setAttribute(Qt.WA_DeleteOnClose) self.commit_msg_edit.textChanged.connect(self.receive_text_changed) self.receive_text_changed() @Slot(name="receive_text_changed")
[docs] def receive_text_changed(self): """Called when text changes in the commit msg text edit. Enable/disable commit button accordingly.""" self.commit_msg = self.commit_msg_edit.toPlainText() cond = self.commit_msg.strip() != "" self.commit_button.setEnabled(cond) self.action_accept.setEnabled(cond)