def add_restaurant_recruitment(data): s = DBSession() obj = RestaurantRecruitment.from_tobj(data) s.add(obj) s.flush() obj_id = obj.id return obj_id
def add(cls, restaurant_id=None, call_status=None, created_at=datetime.now(), phone=None, flush=False): session = DBSession() voice_call = cls(restaurant_id=restaurant_id, call_status=call_status, created_at=created_at, phone=phone) session.add(voice_call) if flush: session.flush() return voice_call
def add_change_record(user_id, from_type, to_type): session = DBSession() new_record = CSProcessTypeChangeRecord( user_id=user_id, from_type=from_type, to_type=to_type ) session.add(new_record) session.flush() return new_record.id
def add(cls, restaurant_id, ban_type, flush=False): session = DBSession() exist_ban = cls.get_by_restaurant(restaurant_id) if not exist_ban: ban = cls(restaurant_id=restaurant_id, ban_type=ban_type) session.add(ban) if flush: session.flush() return ban return None
def _diff_bankcard(walis_bankcard_dict, zeus_bankcard_dict, user_dict, user_profile_dict): add_num = 0 change_num = 0 same_num = 0 not_admin_num = 0 session = DBSession() for zb_rst_id, zb in zeus_bankcard_dict.iteritems(): wb = walis_bankcard_dict.get(zb_rst_id) rst_admin = user_profile_dict.get(zb.user_id) if rst_admin is None: not_admin_num += 1 continue if wb is not None: if zb.card_id.strip() == wb.card_id.strip(): same_num += 1 continue else: change_num += 1 print('walis_bankcard({}) is not same with zeus({}):{}=>{}'. format(wb.id, zb.id, model2dict(wb), ttype2dict(zb))) _current_to_history(wb) session.add(wb) new_wb = _force_add_rst_bankcard( rst_id=zb_rst_id, username=user_dict[zb.user_id]['username'], cardholder_name=zb.cardholder_name, card_id=zb.card_id, bank_id=zb.bank_id, mobile=rst_admin.mobile, status=RstBankCard.STATUS_VALID) session.add(new_wb) else: add_num += 1 print('zeus_bankcard({}) does not exist in walis:{}'.format( zb.id, ttype2dict(zb))) new_wb = _force_add_rst_bankcard( rst_id=zb_rst_id, username=user_dict[zb.user_id]['username'], cardholder_name=zb.cardholder_name, card_id=zb.card_id, bank_id=zb.bank_id, mobile=rst_admin.mobile, status=RstBankCard.STATUS_VALID) session.add(new_wb) print( '(add_num:{add_num}, change_num:{change_num}, same_num:{same_num}, not_admin_num:{not_admin_num})' .format(add_num=add_num, change_num=change_num, same_num=same_num, not_admin_num=not_admin_num))
def _diff_bankcard(walis_bankcard_dict, zeus_bankcard_dict, user_dict, user_profile_dict): add_num = 0 change_num = 0 same_num = 0 not_admin_num = 0 session = DBSession() for zb_rst_id, zb in zeus_bankcard_dict.iteritems(): wb = walis_bankcard_dict.get(zb_rst_id) rst_admin = user_profile_dict.get(zb.user_id) if rst_admin is None: not_admin_num += 1 continue if wb is not None: if zb.card_id.strip() == wb.card_id.strip(): same_num += 1 continue else: change_num += 1 print('walis_bankcard({}) is not same with zeus({}):{}=>{}' .format(wb.id, zb.id, model2dict(wb), ttype2dict(zb))) _current_to_history(wb) session.add(wb) new_wb = _force_add_rst_bankcard(rst_id=zb_rst_id, username=user_dict[zb.user_id]['username'], cardholder_name=zb.cardholder_name, card_id=zb.card_id, bank_id=zb.bank_id, mobile=rst_admin.mobile, status=RstBankCard.STATUS_VALID) session.add(new_wb) else: add_num += 1 print('zeus_bankcard({}) does not exist in walis:{}'.format(zb.id, ttype2dict(zb))) new_wb = _force_add_rst_bankcard(rst_id=zb_rst_id, username=user_dict[zb.user_id]['username'], cardholder_name=zb.cardholder_name, card_id=zb.card_id, bank_id=zb.bank_id, mobile=rst_admin.mobile, status=RstBankCard.STATUS_VALID) session.add(new_wb) print('(add_num:{add_num}, change_num:{change_num}, same_num:{same_num}, not_admin_num:{not_admin_num})' .format(add_num=add_num, change_num=change_num, same_num=same_num, not_admin_num=not_admin_num))