Here are the examples of the python api sqlalchemy.func.field taken from open source projects. By voting up you can indicate which examples are most useful and appropriate.
2 Examples
3
Source : CGuessGroup.py
with Mozilla Public License 2.0
from haobin12358
with Mozilla Public License 2.0
from haobin12358
def _filter_joined_group():
usid = request.user.id
my_joined = GuessGroup.query.outerjoin(GuessRecord, GuessRecord.GGid == GuessGroup.GGid
).filter(GuessGroup.isdelete == False,
GuessRecord.isdelete == False,
GuessRecord.USid == usid,
# GuessRecord.GRstatus == GuessRecordStatus.valid.value,
# GuessGroup.GGendtime >= now,
# GuessGroup.GGstatus.in_((GuessGroupStatus.pending.value,
# GuessGroupStatus.waiting.value)),
).order_by(func.field(GuessGroup.GGstatus, 0, 10, 20, -10),
GuessGroup.createtime.desc())
return my_joined
@staticmethod
3
Source : CMagicBox.py
with Mozilla Public License 2.0
from haobin12358
with Mozilla Public License 2.0
from haobin12358
def _filter_my_box():
usid = request.user.id
res = MagicBoxJoin.query.filter(MagicBoxJoin.isdelete == False,
MagicBoxJoin.USid == usid
).order_by(func.field(MagicBoxJoin.MBJstatus, 0, 10, -10),
MagicBoxJoin.createtime.desc())
return res
@staticmethod