X-Git-Url: http://git.veekun.com/zzz-spline-forum.git/blobdiff_plain/3be1ed06645727c8d66d23a07ead0d09a24b55c6..a81670b58f01338129d951f9bd4bfed5862a84aa:/splinext/forum/model/__init__.py diff --git a/splinext/forum/model/__init__.py b/splinext/forum/model/__init__.py index 444f5b8..a137866 100644 --- a/splinext/forum/model/__init__.py +++ b/splinext/forum/model/__init__.py @@ -50,7 +50,7 @@ Index('thread_position', Post.thread_id, Post.position, unique=True) # XXX sort by time, how? Forum.threads = relation(Thread, order_by=Thread.id.desc(), lazy='dynamic', backref='forum') -Thread.posts = relation(Post, order_by=Post.posted_time.desc(), lazy='dynamic', backref='thread') +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) Thread.last_post = relation(Post, primaryjoin=and_(Post.thread_id == Thread.id, Post.position == Thread.post_count), uselist=False)