# -*- coding: utf8 -*-
# This file is part of PYBOSSA.
#
# Copyright (C) 2015 Scifabric LTD.
#
# PYBOSSA is free software: you can redistribute it and/or modify
# it under the terms of the GNU Affero General Public License as published by
# the Free Software Foundation, either version 3 of the License, or
# (at your option) any later version.
#
# PYBOSSA 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 Affero General Public License for more details.
#
# You should have received a copy of the GNU Affero General Public License
# along with PYBOSSA.  If not, see <http://www.gnu.org/licenses/>.

from sqlalchemy import Integer, Unicode, UnicodeText, Text
from sqlalchemy.schema import Column, ForeignKey

from pybossa.core import db
from pybossa.model import DomainObject, make_timestamp


class Blogpost(db.Model, DomainObject):
    """A blog post associated to a given project"""

    __tablename__ = 'blogpost'

    #: Blogpost ID
    id = Column(Integer, primary_key=True)
    #: UTC timestamp when the blogpost is created
    created = Column(Text, default=make_timestamp)
    #: Project.ID for the Blogpost
    project_id = Column(Integer, ForeignKey('project.id', ondelete='CASCADE'), nullable=False)
    #: User.ID for the Blogpost
    user_id = Column(Integer, ForeignKey('user.id'))
    #: Title of the Blogpost
    title = Column(Unicode(length=255), nullable=False)
    #: Body of the Blogpost
    body = Column(UnicodeText, nullable=False)

    @classmethod
    def public_attributes(self):
        """Return a list of public attributes."""
        return ['created', 'project_id', 'id', 'user_id',
                'title', 'body']

    @classmethod
    def public_info_keys(self):
        """Return a list of public info keys."""
        return []

# -*- coding: utf8 -*-
# This file is part of PYBOSSA.
#
# Copyright (C) 2015 Scifabric LTD.
#
# PYBOSSA is free software: you can redistribute it and/or modify
# it under the terms of the GNU Affero General Public License as published by
# the Free Software Foundation, either version 3 of the License, or
# (at your option) any later version.
#
# PYBOSSA 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 Affero General Public License for more details.
#
# You should have received a copy of the GNU Affero General Public License
# along with PYBOSSA.  If not, see <http://www.gnu.org/licenses/>.

from sqlalchemy import Integer, Unicode, UnicodeText, Text
from sqlalchemy.schema import Column, ForeignKey

from pybossa.core import db
from pybossa.model import DomainObject, make_timestamp


class Blogpost(db.Model, DomainObject):
    """A blog post associated to a given project"""

    __tablename__ = 'blogpost'

    #: Blogpost ID
    id = Column(Integer, primary_key=True)
    #: UTC timestamp when the blogpost is created
    created = Column(Text, default=make_timestamp)
    #: Project.ID for the Blogpost
    project_id = Column(Integer, ForeignKey('project.id', ondelete='CASCADE'), nullable=False)
    #: User.ID for the Blogpost
    user_id = Column(Integer, ForeignKey('user.id'))
    #: Title of the Blogpost
    title = Column(Unicode(length=255), nullable=False)
    #: Body of the Blogpost
    body = Column(UnicodeText, nullable=False)
    #: media_url Heading picture or cover for blogpost
    media_url = Column(Text)

    @classmethod
    def public_attributes(self):
        """Return a list of public attributes."""
        return ['created', 'project_id', 'id', 'user_id',
                'title', 'body', 'media_url']

    @classmethod
    def public_info_keys(self):
        """Return a list of public info keys."""
        return []

Add media_url to blogpost.