def delete_addr(user_id, _id):
"""删除收货地址"""
conn = ToConn().to_execute()
cur = conn.cursor()
db_conn = ToMongo()
cur.execute(
'update users set address_default=null where id=%s and address_default = %s',
(user_id, _id))
result = db_conn.delete(col='address', doc={
'_id': ObjectId(_id)
}).raw_result
if result['ok'] == 1:
conn.commit()
else:
conn.rollback()
db_conn.close_conn()
def delete_addr_model(user_id, _id):
rel = True
if _id == get_user(user_id)['address_default']:
# 如果是默认地址，删除默认地址
conn = ToConn()
to_exec = conn.to_execute()
cur = to_exec.cursor()
result = cur.execute(
'update users set address_default=null where id=%s', (user_id, ))
if result:
to_exec.commit()
to_exec.close()
else:
to_exec.rollback()
to_exec.close()
return False
# 如果不是默认地址，直接删除默认地址
db = ToMongo()
count = db.delete('address', {'_id': ObjectId(_id)}).deleted_count
if not count:
rel = False
db.close_conn()
return rel
