def updategrand(cur,group_id,node_id):#更新节点上溯祖先的余额
grparry=readgrpmem(cur,group_id) #获取二叉树
grandlist=grparry.get_grand(str(node_id)) #获取其祖先节点
addmoney=200
for node in grandlist:
updsql="update cust_info set money=money+%d where cust_id = %d"%(addmoney,int(node.key))
sta=exeUpdate(cur,updsql)
print('update cust_id ',node.key)
if sta!=1 :
return(False)
else:
return(True)
def updategrand(cur, group_id, node_id): #更新节点上溯祖先的余额
grparry = readgrpmem(cur, group_id) #获取二叉树
grandlist = grparry.get_grand(str(node_id)) #获取其祖先节点
addmoney = 200
for node in grandlist:
updsql = "update cust_info set money=money+%d where cust_id = %d" % (
addmoney, int(node.key))
sta = exeUpdate(cur, updsql)
print('update cust_id ', node.key)
if sta != 1:
return (False)
else:
return (True)
def divgrp(cur,grp_id):
grouparry=readgrpmem(cur,grp_id) #读取被拆分成员二叉树，返回Binpile类型
#tierkeylist=grouparry.show_keydelta() #各层级的key列表
oldmaster,lnewmaster,rnewmaster=grouparry.pop_top() #弹出群主节点，左分支二叉树binpile，右分支二叉树Binpile
old_custid=oldmaster.key
lnew_custid=lnewmaster.key
rnew_custid=rnewmaster.key
print("old,lnew,rnew==",old_custid,lnew_custid,rnew_custid)
#更新group_info表，移走老群名称，增加新分裂后的2个新群
lgrp_id,rgrp_id=credivgrp(cur,old_custid,lnew_custid,rnew_custid) #返回2个新组的组id
#推出群主，进行返现等操作，更新cust_info表等
popmaster(cur,old_custid)
print("pop mater over")
#group_member oldgrp_id记录历史插入一份，删除oldgrp群主记录，更新左分支群主组号，更新右分支群主组号
upgrpmem(cur,grp_id,lgrp_id,rgrp_id,lnewmaster,rnewmaster)
def divgrp(cur, grp_id):
grouparry = readgrpmem(cur, grp_id) #读取被拆分成员二叉树，返回Binpile类型
#tierkeylist=grouparry.show_keydelta() #各层级的key列表
oldmaster, lnewmaster, rnewmaster = grouparry.pop_top(
) #弹出群主节点，左分支二叉树binpile，右分支二叉树Binpile
old_custid = oldmaster.key
lnew_custid = lnewmaster.key
rnew_custid = rnewmaster.key
print("old,lnew,rnew==", old_custid, lnew_custid, rnew_custid)
#更新group_info表，移走老群名称，增加新分裂后的2个新群
lgrp_id, rgrp_id = credivgrp(cur, old_custid, lnew_custid,
rnew_custid) #返回2个新组的组id
#推出群主，进行返现等操作，更新cust_info表等
popmaster(cur, old_custid)
print("pop mater over")
#group_member oldgrp_id记录历史插入一份，删除oldgrp群主记录，更新左分支群主组号，更新右分支群主组号
upgrpmem(cur, grp_id, lgrp_id, rgrp_id, lnewmaster, rnewmaster)
