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)