# -*- coding: utf-8 -*- # Copyright 2010 - 2017 RhodeCode GmbH and the AppEnlight project authors # # Licensed under the Apache License, Version 2.0 (the "License"); # you may not use this file except in compliance with the License. # You may obtain a copy of the License at # # http://www.apache.org/licenses/LICENSE-2.0 # # Unless required by applicable law or agreed to in writing, software # distributed under the License is distributed on an "AS IS" BASIS, # WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. # See the License for the specific language governing permissions and # limitations under the License. import sqlalchemy as sa from datetime import datetime from appenlight.models import Base from ziggurat_foundations.models.base import BaseModel class ReportComment(Base, BaseModel): __tablename__ = 'reports_comments' comment_id = sa.Column(sa.Integer, nullable=False, primary_key=True) group_id = sa.Column(sa.BigInteger, sa.ForeignKey('reports_groups.id', ondelete='cascade', onupdate='cascade')) body = sa.Column(sa.UnicodeText(), default='') owner_id = sa.Column(sa.Integer, sa.ForeignKey('users.id', onupdate='CASCADE', ondelete='CASCADE')) created_timestamp = sa.Column(sa.DateTime(), default=datetime.utcnow, server_default=sa.func.now()) report_time = sa.Column(sa.DateTime(), nullable=False) owner = sa.orm.relationship('User', lazy='joined') @property def processed_body(self): return self.body def get_dict(self): instance_dict = super(ReportComment, self).get_dict() instance_dict['user_name'] = self.owner.user_name return instance_dict