X-Git-Url: http://git.veekun.com/zzz-spline-forum.git/blobdiff_plain/ada04281f0d79218f32415acf570a627dc68bde7..2c8391e2e742e2add7edc0d0cf9cb24680db62af:/splinext/forum/model/__init__.py?ds=sidebyside diff --git a/splinext/forum/model/__init__.py b/splinext/forum/model/__init__.py index 37beb61..6dc6bfd 100644 --- a/splinext/forum/model/__init__.py +++ b/splinext/forum/model/__init__.py @@ -73,6 +73,7 @@ class Post(TableBase): position = Column(Integer, nullable=False) author_user_id = Column(Integer, ForeignKey('users.id'), nullable=False) posted_time = Column(DateTime, nullable=False, index=True, default=datetime.now) + raw_content = Column(Unicode(5120), nullable=False) content = Column(Unicode(5120), nullable=False) Index('thread_position', Post.thread_id, Post.position, unique=True) @@ -83,6 +84,7 @@ Forum.threads = relation(Thread, order_by=Thread.id.desc(), lazy='dynamic', back Thread.posts = relation(Post, order_by=Post.position.asc(), lazy='dynamic', backref='thread') Thread.first_post = relation(Post, primaryjoin=and_(Post.thread_id == Thread.id, Post.position == 1), uselist=False) +# XXX THIS WILL NEED TO CHANGE when posts can be deleted! Or change what 'position' means Thread.last_post = relation(Post, primaryjoin=and_(Post.thread_id == Thread.id, Post.position == Thread.post_count), uselist=False) Post.author = relation(users_model.User, backref='posts')