Merge remote-tracking branch 'gsoc2016/Subtitle-1'

[mediagoblin.git] / mediagoblin / media_types / blog / models.py

# GNU MediaGoblin -- federated, autonomous media hosting
# Copyright (C) 2011, 2012 MediaGoblin contributors. See AUTHORS.
#
# This program 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.
#
# 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 Affero General Public License for more details.
#
# You should have received a copy of the GNU Affero General Public License
# along with this program.  If not, see <http://www.gnu.org/licenses/>.

import datetime

from mediagoblin.db.base import Base
from mediagoblin.db.base import Session
from mediagoblin.db.models import Collection, User, MediaEntry
from mediagoblin.db.mixin import GenerateSlugMixin

from mediagoblin.media_types.blog.lib import check_blog_slug_used

from mediagoblin.tools.text import cleaned_markdown_conversion

from sqlalchemy import (
    Column, Integer, ForeignKey, Unicode, UnicodeText, DateTime)
from sqlalchemy.orm import relationship, backref


class BlogMixin(GenerateSlugMixin):
    def check_slug_used(self, slug):
        return check_blog_slug_used(self.author, slug, self.id)

BLOG_BACKREF_NAME = "mediatype__blogs"

class Blog(Base, BlogMixin):
    __tablename__ = "mediatype__blogs"
    id = Column(Integer, primary_key=True)
    title = Column(Unicode)
    description = Column(UnicodeText)
    author = Column(Integer, ForeignKey(User.id), nullable=False, index=True) #similar to uploader
    created = Column(DateTime, nullable=False, default=datetime.datetime.now, index=True)
    slug = Column(Unicode)
    get_author = relationship("User", backref=backref(BLOG_BACKREF_NAME, cascade="all, delete-orphan"))

    @property
    def slug_or_id(self):
        return (self.slug or u'blog_{0}'.format(self.id))
 
    def get_all_blog_posts(self, state=None):
        blog_posts = Session.query(MediaEntry).join(BlogPostData)\
        .filter(BlogPostData.blog == self.id)
        if state is not None:
            blog_posts = blog_posts.filter(MediaEntry.state==state)
        return blog_posts
    
    def delete(self, **kwargs):
        all_posts = self.get_all_blog_posts()
        for post in all_posts:
            post.delete(del_orphan_tags=False, commit=False)
        from mediagoblin.db.util import clean_orphan_tags
        clean_orphan_tags(commit=False)
        super(Blog, self).delete(**kwargs)
        
        
    
    
BLOG_POST_BACKREF_NAME = "blogpost__media_data"

class BlogPostData(Base):
    __tablename__ = "blogpost__mediadata"

    # The primary key *and* reference to the main media_entry
    media_entry = Column(Integer, ForeignKey('core__media_entries.id'), primary_key=True)
    blog = Column(Integer, ForeignKey('mediatype__blogs.id'), nullable=False)
    get_media_entry = relationship("MediaEntry",
        backref=backref(BLOG_POST_BACKREF_NAME, uselist=False,
                        cascade="all, delete-orphan"))


DATA_MODEL = BlogPostData
MODELS = [BlogPostData, Blog]