|
|
# -*- 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
|
|
|
|