sqlalchemy.func.field

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 7

3 Source : CGuessGroup.py
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

    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