def query(cls, rst_id, bankcard_id, limit=DEFAULT_RECORD_LIMIT):
query = Session().query(cls)
query = query.filter(cls.bankcard_id == bankcard_id)\
.filter(cls.rst_id == rst_id)\
.order_by(cls.created_at.desc())
query = query.limit(limit)
return query.all()
def query(cls, rst_id, bankcard_id, limit=DEFAULT_RECORD_LIMIT):
query = Session().query(cls)
query = query.filter(cls.bankcard_id == bankcard_id)\
.filter(cls.rst_id == rst_id)\
.order_by(cls.created_at.desc())
query = query.limit(limit)
return query.all()
def query_trs_query_cfg(city_id=None,
offset=DEFALUT_CITY_TRS_CFG_OFFSET,
limit=DEFALUT_CITY_TRS_CFG_LIMIT):
if city_id is not None:
return get_trs_query_cfg_by_city(city_id)
q = DBSession().query(CityTransactionQueryConfig)
q = q.offset(offset).limit(limit)
return q.all()
def query_trs_query_cfg(city_id=None,
offset=DEFALUT_CITY_TRS_CFG_OFFSET,
limit=DEFALUT_CITY_TRS_CFG_LIMIT):
if city_id is not None:
return get_trs_query_cfg_by_city(city_id)
q = DBSession().query(CityTransactionQueryConfig)
q = q.offset(offset).limit(limit)
return q.all()
def query_bankcard_by_rst_ids(rst_ids, status=None):
query = DBSession().query(RstBankCard)
query = query.filter(RstBankCard.rst_id.in_(rst_ids))
if status is not None:
query = query.filter(RstBankCard.status == status)
return query.all()
def query_by_rst(cls, rst_id, status=None, offset=0, limit=None):
query = Session().query(cls)
query = query.filter(cls.rst_id == rst_id)
if status is not None:
query = query.filter(cls.status == status)
query = query.order_by(cls.updated_at.desc()).order_by(cls.status.desc())
if offset:
query = query.offset(offset)
if limit:
query = query.limit(limit)
return query.all()
def query_by_rst(cls, rst_id, status=None, offset=0, limit=None):
query = Session().query(cls)
query = query.filter(cls.rst_id == rst_id)
if status is not None:
query = query.filter(cls.status == status)
query = query.order_by(cls.updated_at.desc()).order_by(
cls.status.desc())
if offset:
query = query.offset(offset)
if limit:
query = query.limit(limit)
return query.all()
def query(cls, city_id=None, offset=None, limit=DEFAULT_QUERY_LIMIT):
rb = DBSession().query(cls)
if city_id is not None:
rb = rb.filter(cls.city_id == city_id)
if offset is not None:
rb = rb.offset(offset)
if limit is not None:
rb = rb.limit(min(limit, MAX_QUERY_LIMIT))
return rb.all()
def query(cls, city_id=None, offset=None, limit=DEFAULT_QUERY_LIMIT):
rb = DBSession().query(cls)
if city_id is not None:
rb = rb.filter(cls.city_id == city_id)
if offset is not None:
rb = rb.offset(offset)
if limit is not None:
rb = rb.limit(min(limit, MAX_QUERY_LIMIT))
return rb.all()
def query_by_status(cls, rst_ids=None, status=None, type_code=None, offset=0, limit=None,):
query = Session().query(cls)
if rst_ids is not None:
query = query.filter(cls.rst_id.in_(rst_ids))
if status is not None:
query = query.filter(cls.status == status)
if type_code is not None:
query = query.filter(cls.type_code == type_code)
query = query.order_by(cls.created_at.desc(), cls.rst_id)
if offset:
query = query.offset(offset)
if limit:
query = query.limit(limit)
return query.all()
def query_by_status(
cls,
rst_ids=None,
status=None,
type_code=None,
offset=0,
limit=None,
):
query = Session().query(cls)
if rst_ids is not None:
query = query.filter(cls.rst_id.in_(rst_ids))
if status is not None:
query = query.filter(cls.status == status)
if type_code is not None:
query = query.filter(cls.type_code == type_code)
query = query.order_by(cls.created_at.desc(), cls.rst_id)
if offset:
query = query.offset(offset)
if limit:
query = query.limit(limit)
return query.all()
