def portalboxes_ln(self):
"""Get Portalboxes ln."""
return db.object_session(self).query(CollectionPortalbox).\
with_parent(self).\
options(db.joinedload_all(CollectionPortalbox.portalbox)).\
filter(CollectionPortalbox.ln == g.ln).\
order_by(db.desc(CollectionPortalbox.score)).all()
def portalboxes_ln(self):
"""Get Portalboxes ln."""
return db.object_session(self).query(CollectionPortalbox).\
with_parent(self).\
options(db.joinedload_all(CollectionPortalbox.portalbox)).\
filter(CollectionPortalbox.ln == g.ln).\
order_by(db.desc(CollectionPortalbox.score)).all()
def get_current(cls, start_date=None):
"""Get the latest featured community."""
start_date = start_date or datetime.now()
return cls.query.options(
db.joinedload_all('community.collection')).filter(
cls.start_date <= start_date).order_by(
cls.start_date.desc()).first()
def get_current(cls, start_date=None):
"""Get the latest featured community."""
start_date = start_date or datetime.now()
return cls.query.options(db.joinedload_all(
'community.collection')).filter(
cls.start_date <= start_date).order_by(
cls.start_date.desc()).first()
def get_message(uid, msgid):
"""
Get a message with its status and sender nickname.
@param uid: user id
@param msgid: message id
@return: exactly one message or raise an exception.
"""
return UserMsgMESSAGE.query.options(\
db.joinedload_all(UserMsgMESSAGE.message, MsgMESSAGE.user_from)).\
options(db.joinedload(UserMsgMESSAGE.user_to)).\
filter(filter_user_message(uid, msgid)).one()
def get_message(uid, msgid):
"""
Get a message with its status and sender nickname.
@param uid: user id
@param msgid: message id
@return: exactly one message or raise an exception.
"""
return UserMsgMESSAGE.query.options(\
db.joinedload_all(UserMsgMESSAGE.message, MsgMESSAGE.user_from)).\
options(db.joinedload(UserMsgMESSAGE.user_to)).\
filter(filter_user_message(uid, msgid)).one()
