# 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 . 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]