def update(cls, id, **bankcard_dict): query = Session().query(cls) query = query.filter(cls.id == id) rst_bankcard = query.first() if not rst_bankcard: return '' status = bankcard_dict.get('status') if status == cls.STATUS_VALID \ and rst_bankcard.status == cls.STATUS_VALID: raise_user_exc(BANKCARD_UPDATE_ERR) if rst_bankcard.status == cls.STATUS_HISTORY: raise_user_exc(BANKCARD_STATUS_INVALID) for k, v in bankcard_dict.iteritems(): if hasattr(rst_bankcard, k): setattr(rst_bankcard, k, v) Session().add(rst_bankcard)
def get_trs_query_cfg_by_city(city_id): q = DBSession().query(CityTransactionQueryConfig) q = q.filter(CityTransactionQueryConfig.city_id == city_id) return q.first()
def get_pre(cls, id, status=STATUS_PENDING): query = Session().query(cls) query = query.filter(cls.status == status)\ .filter(cls.id > id).order_by(cls.id) return query.first()
def get_next(cls, id, status=STATUS_PENDING): query = Session().query(cls) query = query.filter(cls.status == status)\ .filter(cls.id < id).order_by(cls.id.desc()) return query.first()
def get(cls, rst_id, id): query = Session().query(cls) query = query.filter(cls.id == id).filter(cls.rst_id == rst_id) return query.first()