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 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 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 _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))
