Source code for aiida.orm.implementation.sqlalchemy.comments
# -*- coding: utf-8 -*-
###########################################################################
# Copyright (c), The AiiDA team. All rights reserved. #
# This file is part of the AiiDA code. #
# #
# The code is hosted on GitHub at https://github.com/aiidateam/aiida-core #
# For further information on the license, see the LICENSE.txt file #
# For further information please visit http://www.aiida.net #
###########################################################################
"""SQLA implementations for the Comment entity and collection."""
# pylint: disable=import-error,no-name-in-module
from datetime import datetime
from sqlalchemy.orm.exc import NoResultFound
from aiida.backends.sqlalchemy import get_scoped_session
from aiida.backends.sqlalchemy.models import comment as models
from aiida.common import exceptions
from aiida.common import lang
from ..comments import BackendComment, BackendCommentCollection
from . import entities
from . import users
from . import utils
[docs]class SqlaComment(entities.SqlaModelEntity[models.DbComment], BackendComment):
"""Comment implementation for Sqla."""
MODEL_CLASS = models.DbComment
# pylint: disable=too-many-arguments
[docs] def __init__(self, backend, node, user, content=None, ctime=None, mtime=None):
"""
Construct a SqlaComment.
:param node: a Node instance
:param user: a User instance
:param content: the comment content
:param ctime: The creation time as datetime object
:param mtime: The modification time as datetime object
:return: a Comment object associated to the given node and user
"""
super().__init__(backend)
lang.type_check(user, users.SqlaUser) # pylint: disable=no-member
arguments = {
'dbnode': node.dbmodel,
'user': user.dbmodel,
'content': content,
}
if ctime:
lang.type_check(ctime, datetime, 'the given ctime is of type {}'.format(type(ctime)))
arguments['ctime'] = ctime
if mtime:
lang.type_check(mtime, datetime, 'the given mtime is of type {}'.format(type(mtime)))
arguments['mtime'] = mtime
self._dbmodel = utils.ModelWrapper(models.DbComment(**arguments))
[docs] def store(self):
"""Can only store if both the node and user are stored as well."""
if self._dbmodel.dbnode.id is None or self._dbmodel.user.id is None:
self._dbmodel.dbnode = None
raise exceptions.ModificationNotAllowed('The corresponding node and/or user are not stored')
super().store()
@property
def ctime(self):
return self._dbmodel.ctime
@property
def mtime(self):
return self._dbmodel.mtime
@property
def node(self):
return self.backend.nodes.from_dbmodel(self.dbmodel.dbnode)
@property
def user(self):
return self.backend.users.from_dbmodel(self.dbmodel.user)
@property
def content(self):
return self._dbmodel.content
[docs]class SqlaCommentCollection(BackendCommentCollection):
"""SqlAlchemy implementation for the CommentCollection."""
ENTITY_CLASS = SqlaComment
[docs] def create(self, node, user, content=None, **kwargs):
"""
Create a Comment for a given node and user
:param node: a Node instance
:param user: a User instance
:param content: the comment content
:return: a Comment object associated to the given node and user
"""
return SqlaComment(self.backend, node, user, content, **kwargs)
[docs] def delete(self, comment_id):
"""
Remove a Comment from the collection with the given id
:param comment_id: the id of the comment to delete
:type comment_id: int
:raises TypeError: if ``comment_id`` is not an `int`
:raises `~aiida.common.exceptions.NotExistent`: if Comment with ID ``comment_id`` is not found
"""
if not isinstance(comment_id, int):
raise TypeError('comment_id must be an int')
session = get_scoped_session()
try:
session.query(models.DbComment).filter_by(id=comment_id).one().delete()
session.commit()
except NoResultFound:
session.rollback()
raise exceptions.NotExistent("Comment with id '{}' not found".format(comment_id))
[docs] def delete_all(self):
"""
Delete all Comment entries.
:raises `~aiida.common.exceptions.IntegrityError`: if all Comments could not be deleted
"""
session = get_scoped_session()
try:
session.query(models.DbComment).delete()
session.commit()
except Exception as exc:
session.rollback()
raise exceptions.IntegrityError('Could not delete all Comments. Full exception: {}'.format(exc))
[docs] def delete_many(self, filters):
"""
Delete Comments based on ``filters``
:param filters: similar to QueryBuilder filter
:type filters: dict
:return: (former) ``PK`` s of deleted Comments
:rtype: list
:raises TypeError: if ``filters`` is not a `dict`
:raises `~aiida.common.exceptions.ValidationError`: if ``filters`` is empty
"""
from aiida.orm import Comment, QueryBuilder
# Checks
if not isinstance(filters, dict):
raise TypeError('filters must be a dictionary')
if not filters:
raise exceptions.ValidationError('filters must not be empty')
# Apply filter and delete found entities
builder = QueryBuilder().append(Comment, filters=filters, project='id').all()
entities_to_delete = [_[0] for _ in builder]
for entity in entities_to_delete:
self.delete(entity)
# Return list of deleted entities' (former) PKs for checking
return entities_to_delete