def getposts(basequery=None, sticky=False):
if basequery is None:
basequery = JobPost.query
query = basequery.filter(
JobPost.status.in_([POSTSTATUS.CONFIRMED, POSTSTATUS.REVIEWED])).filter(
JobPost.datetime > datetime.utcnow() - agelimit)
if sticky:
query = query.order_by(db.desc(JobPost.sticky))
return query.order_by(db.desc(JobPost.datetime))
def getposts(basequery=None, sticky=False):
if basequery is None:
basequery = JobPost.query
query = basequery.filter(
JobPost.status.in_([
POSTSTATUS.CONFIRMED, POSTSTATUS.REVIEWED
])).filter(JobPost.datetime > datetime.utcnow() - agelimit)
if sticky:
query = query.order_by(db.desc(JobPost.sticky))
return query.order_by(db.desc(JobPost.datetime))
def getposts(basequery=None, sticky=False, showall=False):
if g.user or showall:
useagelimit = agelimit
else:
useagelimit = newlimit
if basequery is None:
basequery = JobPost.query
query = basequery.filter(
JobPost.status.in_([POSTSTATUS.CONFIRMED, POSTSTATUS.REVIEWED])).filter(
db.or_(
db.and_(JobPost.sticky == True, JobPost.datetime > datetime.utcnow() - agelimit),
db.and_(JobPost.sticky == False, JobPost.datetime > datetime.utcnow() - useagelimit)))
if sticky:
query = query.order_by(db.desc(JobPost.sticky))
return query.order_by(db.desc(JobPost.datetime))
def getallposts(order_by=None, desc=False, start=None, limit=None):
if order_by is None:
order_by = JobPost.datetime
filt = JobPost.query.filter(JobPost.status.in_([POSTSTATUS.CONFIRMED, POSTSTATUS.REVIEWED]))
count = filt.count()
if desc:
filt = filt.order_by(db.desc(order_by))
else:
filt = filt.order_by(order_by)
if start is not None:
filt = filt.offset(start)
if limit is not None:
filt = filt.limit(limit)
return count, filt
def getallposts(order_by=None, desc=False, start=None, limit=None):
if order_by is None:
order_by = JobPost.datetime
filt = JobPost.query.filter(
JobPost.status.in_([POSTSTATUS.CONFIRMED, POSTSTATUS.REVIEWED]))
count = filt.count()
if desc:
filt = filt.order_by(db.desc(order_by))
else:
filt = filt.order_by(order_by)
if start is not None:
filt = filt.offset(start)
if limit is not None:
filt = filt.limit(limit)
return count, filt
