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)
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')