예제 #1
0
 def by_id(cls, post_id):
     return DBSession.query(Post).filter(cls.id == post_id).first()
예제 #2
0
 def get_recent(cls):
     return DBSession.query(Post).order_by(sa.desc(cls.created))[:5]
예제 #3
0
 def get_posts_by_tag(cls, tag):
     # return DBSession.query(Post).join(Post.tags).filter(sa.func.lower(Tag.name) == tag)
     return DBSession.query(Post).join(Post.tags).filter(Tag.slug == tag)
예제 #4
0
 def all(cls):
     return DBSession.query(Post).order_by(sa.desc(cls.created))
예제 #5
0
 def get_all(cls):
     return DBSession.query(Tag).order_by(sa.asc(cls.name))
예제 #6
0
 def get_by_name(cls, tag):
     return DBSession.query(Tag).filter(cls.name == tag).first()
예제 #7
0
 def get_posts_by_category_slug(cls, category_slug):
     return DBSession.query(Post).join(Category).filter(Category.slug == category_slug)
예제 #8
0
 def get_posts_by_category(cls, category):
     return DBSession.query(Post).join(Category).filter(sa.func.lower(Category.name) == category)
예제 #9
0
 def by_id(cls, category_id):
     return DBSession.query(Category).filter(cls.id == category_id).first()
예제 #10
0
 def by_name(cls, name):
     return DBSession.query(User).filter(User.name == name).first()
예제 #11
0
 def all(cls):
     return DBSession.query(User).order_by(sa.desc(cls.name))