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 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()
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()
def get_trs_query_cfg_by_city(city_id):
q = DBSession().query(CityTransactionQueryConfig)
q = q.filter(CityTransactionQueryConfig.city_id == city_id)
return q.first()
