def aftertest(testfilter): global datadir, datadir2 if datadir != "": startnode.StopNode(datadir) if datadir2 != "": startnode.StopNode(datadir2)
def aftertest(testfilter): global datadir1 global datadir2 if datadir1 != "" or datadir2 != "": _lib.StartTestGroup("Ending After failure of the test") if datadir1 != "": startnode.StopNode(datadir1, "Server 1") if datadir2 != "": startnode.StopNode(datadir2, "Server 2")
def test(testfilter): global datadir1 global datadir2 _lib.StartTestGroup("Run node with 30 blocks and test import from second node") _lib.CleanTestFolders() inf = blocksnodes.MakeBlockchainWithBlocks('30000') datadir = inf[0] address1 = inf[1] address1_2 = inf[2] address1_3 = inf[3] for x in range(5, 31): _lib.StartTestGroup("Create block #"+str(x)) for y in range(0, x-1): tx=_transfers.Send(datadir,address1,address1_2,0.001) txlist = transactions.GetUnapprovedTransactions(datadir) _lib.FatalAssert(len(txlist) == x-1,"Should be "+str(x-1)+" unapproved transaction") blockchash = _blocks.MintBlock(datadir,address1) blocks = _blocks.WaitBlocks(datadir, x) _lib.FatalAssert(len(blocks) == x,"Should be "+str(x)+" blocks on server 1") #_node.StartNodeInteractive(datadir, address1,'30000', "Server 1") startnode.StartNode(datadir, address1,'30000', "Server 1") datadir1 = datadir managenodes.RemoveAllNodes(datadir1) d = pullsync.StartNodeAndImport('30001', '30000', "Server 2", 0, "_2_", "xxx.com" ) datadir2 = d[0] address2 = d[1] blocks = _blocks.GetBlocks(datadir2) # wait when all 30 bocks are on node 2 blocks = _blocks.WaitBlocks(datadir2, 30, 100)# 100 sec _lib.FatalAssert(len(blocks) == 30,"Should be 17 blocks on server 2") startnode.StopNode(datadir1,"Server 1") datadir1 = "" time.sleep(4)# allow to complete blocks adding startnode.StopNode(datadir2,"Server 2") datadir2 = "" #_lib.RemoveTestFolder(datadir) _lib.EndTestGroupSuccess()
def test(testfilter): global datadir1 global datadir2 _lib.StartTestGroup("Import long blockchain") _lib.CleanTestFolders() _lib.StartTestGroup("Copy blockchain from dataset") datadir1 = _lib.CreateTestFolder() datadir2 = _lib.CreateTestFolder() _lib.CopyTestData(datadir1, "bigchain") balances = _transfers.GetGroupBalance(datadir1) address = balances.keys()[0] startnode.StartNode(datadir1, address, '30000', "Server 1") address2 = initblockchain.ImportBockchain(datadir2, "localhost", '30000') #managenodes.RemoveAllNodes(datadir1) startnode.StartNode(datadir2, address2, '30001', "Server 2") #managenodes.RemoveAllNodes(datadir2) #managenodes.AddNode(datadir1, "localhost",'30001') blocks1 = _blocks.GetBlocks(datadir1) state = _node.NodeState(datadir1) _node.WaitBlocksInState(datadir2, len(blocks1), 120) blocks2 = _blocks.WaitBlocks(datadir2, len(blocks1), 120) #print len(blocks1), len(blocks2) _lib.FatalAssert( len(blocks1) == len(blocks2), "Number of bocks must be same on both servers") startnode.StopNode(datadir1, "Server 1") startnode.StopNode(datadir2, "Server 2") datadir1 = "" datadir2 = "" _lib.EndTestGroupSuccess()
def test(testfilter): global datadir1 global datadir2 global datadir3 _lib.StartTestGroup("Blocks exhange between nodes") _lib.CleanTestFolders() inf = MakeBlockchainWithBlocks('30000') datadir = inf[0] address1 = inf[1] address1_2 = inf[2] address1_3 = inf[3] #_node.StartNodeInteractive(datadir, address1,'30000', "Server 1") startnode.StartNode(datadir, address1, '30000', "Server 1") datadir1 = datadir managenodes.RemoveAllNodes(datadir1) d = StartNodeAndImport('30001', '30000', "Server 2") datadir2 = d[0] address2 = d[1] d = StartNodeAndImport('30002', '30000', "Server 3") datadir3 = d[0] address3 = d[1] time.sleep(1) nodes = managenodes.GetNodes(datadir1) _lib.FatalAssert(len(nodes) == 2, "Should be 2 nodes on server 1") nodes = managenodes.GetNodes(datadir2) _lib.FatalAssert(len(nodes) == 2, "Should be 2 nodes on server 2") nodes = managenodes.GetNodes(datadir3) _lib.FatalAssert(len(nodes) == 2, "Should be 2 nodes on server 3") # get balance startnode.StopNode(datadir1, "Server 1") datadir1 = "" startnode.StopNode(datadir2, "Server 2") datadir2 = "" startnode.StopNode(datadir3, "Server 3") datadir3 = "" #_lib.RemoveTestFolder(datadir) _lib.EndTestGroupSuccess()
def test(testfilter): _lib.StartTestGroup("Start/Stop node") _lib.CleanTestFolders() datadir1 = _lib.CreateTestFolder() datadir2 = _lib.CreateTestFolder() startnode.StartNodeWithoutBlockchain(datadir1) address = startnode.InitBockchain(datadir1) #this starts on a port 30000 startnode.StartNode(datadir1, address, '30000', "Server 1") #start second node. should fail startnode.StartNodeWithoutBlockchain(datadir2) address = ImportBockchain(datadir2, "localhost", '30000') startnode.StartNode(datadir2, address, '30001', "Server 2") startnode.StopNode(datadir1, "Server 1") startnode.StopNode(datadir2, "Server 2") _lib.RemoveTestFolder(datadir1) _lib.RemoveTestFolder(datadir2) _lib.EndTestGroupSuccess()
def aftertest(testfilter): global datadirs for datadir in datadirs: if datadir != "": startnode.StopNode(datadir)
def test(testfilter): global datadir1 global datadir2 global datadir3 _lib.StartTestGroup("Blocks exhange between nodes") _lib.CleanTestFolders() inf = MakeBlockchainWithBlocks('30000') datadir = inf[0] address1 = inf[1] address1_2 = inf[2] address1_3 = inf[3] #_node.StartNodeInteractive(datadir, address1,'30000', "Server 1") _complex.AddProxyToConfig(datadir, "localhost:40001") _complex.AddInternalKeyToConfig(datadir, address1) # init internal signing startnode.StartNode(datadir, address1, '30000', "Server 1") datadir1 = datadir managenodes.RemoveAllNodes(datadir1) d = blocksnodes.StartNodeAndImport('30001', '30000', "Server 2", 40002, '_2_') datadir2 = d[0] address2 = d[1] d = blocksnodes.StartNodeAndImport('30002', '30000', "Server 3", 40003, '_3_') datadir3 = d[0] address3 = d[1] time.sleep(1) nodes = managenodes.GetNodes(datadir1) _lib.FatalAssert(len(nodes) == 2, "Should be 2 nodes on server 1") nodes = managenodes.GetNodes(datadir2) _lib.FatalAssert(len(nodes) == 2, "Should be 2 nodes on server 2") nodes = managenodes.GetNodes(datadir3) _lib.FatalAssert(len(nodes) == 2, "Should be 2 nodes on server 3") # get balance _sql.ExecuteSQLOnProxy( datadir1, "CREATE TABLE test (a INT auto_increment PRIMARY KEY, b VARCHAR(20))") _sql.ExecuteSQLOnProxy(datadir1, "INSERT INTO test SET b='row1'") _sql.ExecuteSQLOnProxy(datadir1, "INSERT INTO test SET a=2,b='row2'") _sql.ExecuteSQLOnProxy(datadir1, "INSERT INTO test (b) VALUES ('row3')") blocks = _blocks.WaitBlocks(datadir1, 5) _lib.FatalAssert(len(blocks) == 5, "Should be 5 blocks on server 1") blocks = _blocks.WaitBlocks(datadir2, 5) _lib.FatalAssert(len(blocks) == 5, "Should be 5 blocks on server 2") blocks = _blocks.WaitBlocks(datadir3, 5) _lib.FatalAssert(len(blocks) == 5, "Should be 5 blocks on server 3") time.sleep(1) # while all caches are cleaned managenodes.RemoveAllNodes(datadir1) managenodes.RemoveAllNodes(datadir2) managenodes.RemoveAllNodes(datadir3) rows = _lib.DBGetRows(datadir1, "SELECT * FROM test", True) _lib.FatalAssert(len(rows) == 3, "Must be 3 rows in a table on node 1") rows = _lib.DBGetRows(datadir2, "SELECT * FROM test", True) _lib.FatalAssert(len(rows) == 3, "Must be 3 rows in a table on node 2") rows = _lib.DBGetRows(datadir3, "SELECT * FROM test", True) _lib.FatalAssert(len(rows) == 3, "Must be 3 rows in a table on node 3") _sql.ExecuteSQLOnProxy(datadir1, "INSERT INTO test (b) VALUES ('row4')") time.sleep(1) # while all caches are cleaned rows = _lib.DBGetRows(datadir1, "SELECT * FROM test", True) _lib.FatalAssert(len(rows) == 4, "Must be 4 rows in a table on node 1") rows = _lib.DBGetRows(datadir2, "SELECT * FROM test", True) _lib.FatalAssert(len(rows) == 3, "Must be 3 rows in a table on node 2") rows = _lib.DBGetRows(datadir3, "SELECT * FROM test", True) _lib.FatalAssert(len(rows) == 3, "Must be 3 rows in a table on node 3") startnode.StopNode(datadir1, "Server 1") datadir1 = "" startnode.StopNode(datadir2, "Server 2") datadir2 = "" startnode.StopNode(datadir3, "Server 3") datadir3 = "" #_lib.RemoveTestFolder(datadir) _lib.EndTestGroupSuccess()
def PrepareNodesWithSQL(): nodeport = '30000' _lib.StartTestGroup("Prepare 6 nodes with SQL commands in BC") _lib.CleanTestFolders() datadir_tmp = CopyBlockchainWithBlocks("_1_") blocks = _blocks.GetBlocks(datadir_tmp) balances = _transfers.GetGroupBalance(datadir_tmp) datadirs = [] address1 = balances.keys()[0] # address1_3 becomes a minter. we will send money from other 2 and this will receive rewards AddProxyToConfig(datadir_tmp, "localhost:40040") AddInternalKeyToConfig(datadir_tmp, address1) # init internal signing startnode.StartNode(datadir_tmp, address1,nodeport) datadir = datadir_tmp datadirs.append(datadir_tmp) nodes = [] for i in range(1, 6): port = str(30000+i) dbproxyport = str(40040+i) d = blocksnodes.StartNodeAndImport(port, nodeport, "Server "+str(i), int(dbproxyport),"_"+str(i+1)+"_") datadir_n = d[0] address_n = d[1] nodes.append({'number':i, 'port':port, 'datadir':datadir_n,'address':address_n,'proxyport':dbproxyport}) datadirs.append(datadir_n) _lib.StartTestGroup("Temp Data Dirs") _lib.StartTest("Node 0 "+os.path.basename(datadir)) for node in nodes: _lib.StartTest("Node "+str(node['number'])+" "+os.path.basename(node['datadir'])) # commmon transfer of blocks between nodes _lib.StartTestGroup("Transfer of blocks between nodes") blocks = _blocks.GetBlocks(datadir) blockslen = len(blocks) balance1 = _transfers.GetBalance(datadir, address1) as1 = "%.8f" % round(balance1[0]/10,8) # should be 6 transactions. 3 currency and 3 SQL _transfers.Send(datadir,address1, nodes[0]['address'] ,as1) _transfers.Send(datadir,address1, nodes[1]['address'] ,as1) _transfers.Send(datadir,address1, nodes[2]['address'] ,as1) _sql.ExecuteSQLOnProxy(datadir,"CREATE TABLE test (a INT auto_increment PRIMARY KEY, b VARCHAR(20))") _sql.ExecuteSQLOnProxy(datadir,"INSERT INTO test SET b='row1'") _sql.ExecuteSQLOnProxy(datadir,"INSERT INTO test SET a=2,b='row2'") blocks = _blocks.WaitBlocks(datadir, blockslen + 1) _lib.FatalAssert(len(blocks) == blockslen + 1, "Expected "+str(blockslen +1)+" blocks") #wait while block is posted to all other nodes time.sleep(2) # check on each node for node in nodes: blocks = _blocks.WaitBlocks(node['datadir'], blockslen + 1) _lib.FatalAssert(len(blocks) == blockslen + 1, "Expected "+str(blockslen +1)+" blocks o node "+str(node['number'])) _lib.StartTestGroup("Create 2 branches of blockchain") while True: time.sleep(4)# to complete all operations in progress # remove connection between subnetworks managenodes.RemoveAllNodes(nodes[0]['datadir']) managenodes.RemoveAllNodes(nodes[1]['datadir']) managenodes.RemoveAllNodes(nodes[2]['datadir']) managenodes.RemoveAllNodes(nodes[3]['datadir']) managenodes.RemoveAllNodes(nodes[4]['datadir']) managenodes.RemoveAllNodes(datadir) time.sleep(1) nodes0 = managenodes.GetNodes(datadir) nodes1 = managenodes.GetNodes(nodes[0]['datadir']) nodes2 = managenodes.GetNodes(nodes[1]['datadir']) if len(nodes0) == 0 and len(nodes1) == 0 and len(nodes2) == 0: break _lib.StartTestGroup("Nodes addresses are still not clean") # first group - main and 4,5 nodes managenodes.AddNode(datadir,"localhost",'30004') managenodes.AddNode(datadir,"localhost",'30005') managenodes.AddNode(nodes[3]['datadir'],"localhost",'30005') #second group 1,2,3 managenodes.AddNode(nodes[0]['datadir'],"localhost",'30002') managenodes.AddNode(nodes[0]['datadir'],"localhost",'30003') managenodes.AddNode(nodes[1]['datadir'],"localhost",'30003') time.sleep(1) #check nodes nodes0 = managenodes.GetNodes(datadir) _lib.FatalAssert("localhost:30005", "Node 5 is not in the list of 0") _lib.FatalAssert("localhost:30004", "Node 4 is not in the list of 0") nodes1 = managenodes.GetNodes(nodes[0]['datadir']) _lib.FatalAssert("localhost:30002", "Node 2 is not in the list of 1") _lib.FatalAssert("localhost:30003", "Node 3 is not in the list of 1") nodes2 = managenodes.GetNodes(nodes[1]['datadir']) _lib.FatalAssert("localhost:30001", "Node 1 is not in the list of 2") _lib.FatalAssert("localhost:30003", "Node 3 is not in the list of 2") _lib.StartTestGroup("2 new blocks on first branch") balance1 = _transfers.GetBalance(datadir, address1) as1 = "%.8f" % round(balance1[0]/20,8) # 7 TX for 8-th block tx = [""] * 15 tx[0] = _transfers.Send(datadir,address1, nodes[3]['address'] ,as1) tx[1] = _transfers.Send(datadir,address1, nodes[3]['address'] ,as1) tx[2] = _transfers.Send(datadir,address1, nodes[3]['address'] ,as1) _sql.ExecuteSQLOnProxy(datadir,"UPDATE test SET b='row2_updated' WHERE a=2") _sql.ExecuteSQLOnProxy(datadir,"INSERT INTO test SET b='row3'") _sql.ExecuteSQLOnProxy(datadir,"INSERT INTO test SET b='row4'") _sql.ExecuteSQLOnProxy(datadir,"UPDATE test SET b='row4_updated' WHERE a=4") time.sleep(7) # 8 TX for 9-th block tx[7] = _transfers.Send(datadir,address1, nodes[4]['address'] ,as1) tx[8] = _transfers.Send(datadir,address1, nodes[4]['address'] ,as1) tx[9] = _transfers.Send(datadir,address1, nodes[4]['address'] ,as1) tx[10] = _transfers.Send(datadir,address1, nodes[4]['address'] ,as1) _sql.ExecuteSQLOnProxy(datadir,"INSERT INTO test SET b='row7', a=7") _sql.ExecuteSQLOnProxy(datadir,"INSERT INTO test SET b='row8', a=8") _sql.ExecuteSQLOnProxy(datadir,"INSERT INTO test SET b='row9', a=9") _sql.ExecuteSQLOnProxy(datadir,"INSERT INTO test SET b='row10', a=10") blocks1 = _blocks.WaitBlocks(nodes[4]['datadir'], blockslen + 3) time.sleep(3) _lib.FatalAssert(len(blocks1) == blockslen + 3, "Expected "+str(blockslen +3)+" blocks for branch 1") rows = _lib.DBGetRows(nodes[3]['datadir'],"SELECT * FROM test",True) _lib.FatalAssert(len(rows) == 8, "Must be 8 rows in a table on 3-th node") rows = _lib.DBGetRows(nodes[4]['datadir'],"SELECT * FROM test",True) _lib.FatalAssert(len(rows) == 8, "Must be 8 rows in a table on 4-th node") _lib.StartTestGroup("1 new block on second branch") balance2 = _transfers.GetBalance(nodes[0]['datadir'], nodes[0]['address']) as2 = "%.8f" % round(balance2[0]/10,8) # 7 new TX _transfers.Send(nodes[0]['datadir'], nodes[0]['address'], nodes[1]['address'] ,as2) _transfers.Send(nodes[0]['datadir'], nodes[0]['address'], nodes[2]['address'] ,as2) # unique row _sql.ExecuteSQLOnProxy(nodes[0]['datadir'],"INSERT INTO test SET b='row5', a = 5") # identical as in parallel _sql.ExecuteSQLOnProxy(nodes[0]['datadir'],"INSERT INTO test SET b='row7', a=7") # other value and same ID _sql.ExecuteSQLOnProxy(nodes[0]['datadir'],"INSERT INTO test SET b='row3_other', a=3") # update same _sql.ExecuteSQLOnProxy(nodes[0]['datadir'],"UPDATE test SET b='row2_updated_other' WHERE a=2") # delete _sql.ExecuteSQLOnProxy(nodes[0]['datadir'],"DELETE FROM test WHERE a=7") blocks2 = _blocks.WaitBlocks(nodes[0]['datadir'], blockslen + 2) _lib.FatalAssert(len(blocks2) == blockslen + 2, "Expected "+str(blockslen +2)+" blocks for branch 2. Node 1") blocks2 = _blocks.WaitBlocks(nodes[1]['datadir'], blockslen + 2) _lib.FatalAssert(len(blocks2) == blockslen + 2, "Expected "+str(blockslen +2)+" blocks for branch 2. Node 2") blocks2 = _blocks.WaitBlocks(nodes[2]['datadir'], blockslen + 2) _lib.FatalAssert(len(blocks2) == blockslen + 2, "Expected "+str(blockslen +2)+" blocks for branch 2. Node 2") time.sleep(3)# to allow to update all references after block add #rows = _lib.DBGetRows(datadir,"SELECT * FROM test",True) #print "0",rows #rows = _lib.DBGetRows(nodes[0]['datadir'],"SELECT * FROM test",True) #print "1",rows #rows = _lib.DBGetRows(nodes[1]['datadir'],"SELECT * FROM test",True) #print "2",rows #rows = _lib.DBGetRows(nodes[2]['datadir'],"SELECT * FROM test",True) #print "3",rows #rows = _lib.DBGetRows(nodes[3]['datadir'],"SELECT * FROM test",True) #print "4",rows #rows = _lib.DBGetRows(nodes[4]['datadir'],"SELECT * FROM test",True) #print "5",rows # index 2 is 4-th node (3-rd in second network) rows = _lib.DBGetRows(nodes[2]['datadir'],"SELECT * FROM test",True) _lib.FatalAssert(len(rows) == 4, "Must be 4 rows in a table on 4-th node") dstdir = _lib.getCurrentDir()+"/datafortests/" #configs for cluster 1 copyConfig(datadir, dstdir+"bc6nodessql_1/config.t", address1, nodeport, nodes[3]['port'], nodes[4]['port']) copyConfig(nodes[3]['datadir'], dstdir+"bc6nodessql_5/config.t", nodes[3]['address'], nodes[3]['port'], nodeport, nodes[4]['port']) copyConfig(nodes[4]['datadir'], dstdir+"bc6nodessql_6/config.t", nodes[4]['address'], nodes[4]['port'], nodeport, nodes[3]['port']) #config for cluster 2 copyConfig(nodes[0]['datadir'], dstdir+"bc6nodessql_2/config.t", nodes[0]['address'], nodes[0]['port'], nodes[1]['port'], nodes[2]['port']) copyConfig(nodes[1]['datadir'], dstdir+"bc6nodessql_3/config.t", nodes[1]['address'], nodes[1]['port'], nodes[0]['port'], nodes[2]['port']) copyConfig(nodes[2]['datadir'], dstdir+"bc6nodessql_4/config.t", nodes[2]['address'], nodes[2]['port'], nodes[0]['port'], nodes[1]['port']) #print os.path.basename(datadir) startnode.StopNode(datadir) dstdir = _lib.getCurrentDir()+"/datafortests/bc6nodessql_1/" #print dstdir copyfile(datadir+"/wallet.dat", dstdir+"wallet.t") try: os.remove(dstdir+"db.sql") except OSError: pass DumpBCDB(datadir, dstdir+"db.sql") i = 2 for node in nodes: #print os.path.basename(node['datadir']) startnode.StopNode(node['datadir']) dstdir = _lib.getCurrentDir()+"/datafortests/bc6nodessql_"+str(i)+"/" #print dstdir copyfile(node['datadir']+"/wallet.dat", dstdir+"wallet.t") try: os.remove(dstdir+"db.sql") except OSError: pass DumpBCDB(node['datadir'], dstdir+"db.sql") i=i+1 return [datadir, address1, nodes, blockslen+1, datadirs]
def PrepareNodes(): nodeport = '30000' _lib.StartTestGroup("Wallet Balance") _lib.CleanTestFolders() datadir_tmp = CopyBlockchainWithBlocks("_1_") blocks = _blocks.GetBlocks(datadir_tmp) balances = _transfers.GetGroupBalance(datadir_tmp) datadirs = [] address1 = balances.keys()[0] # address1_3 becomes a minter. we will send money from other 2 and this will receive rewards startnode.StartNode(datadir_tmp, address1,nodeport) datadir = datadir_tmp datadirs.append(datadir_tmp) nodes = [] for i in range(1, 6): port = str(30000+i) d = blocksnodes.StartNodeAndImport(port, nodeport, "Server "+str(i),"_"+str(i+1)+"_") datadir_n = d[0] address_n = d[1] nodes.append({'number':i, 'port':port, 'datadir':datadir_n,'address':address_n}) datadirs.append(datadir_n) _lib.StartTestGroup("Temp Data Dirs") _lib.StartTest("Node 0 "+os.path.basename(datadir)) for node in nodes: _lib.StartTest("Node "+str(node['number'])+" "+os.path.basename(node['datadir'])) # commmon transfer of blocks between nodes _lib.StartTestGroup("Transfer of blocks between nodes") blocks = _blocks.GetBlocks(datadir) blockslen = len(blocks) balance1 = _transfers.GetBalance(datadir, address1) as1 = "%.8f" % round(balance1[0]/10,8) # should be 6 transactions _transfers.Send(datadir,address1, nodes[0]['address'] ,as1) _transfers.Send(datadir,address1, nodes[1]['address'] ,as1) _transfers.Send(datadir,address1, nodes[2]['address'] ,as1) _transfers.Send(datadir,address1, nodes[0]['address'] ,as1) _transfers.Send(datadir,address1, nodes[1]['address'] ,as1) _transfers.Send(datadir,address1, nodes[2]['address'] ,as1) blocks = _blocks.WaitBlocks(datadir, blockslen + 1) _lib.FatalAssert(len(blocks) == blockslen + 1, "Expected "+str(blockslen +1)+" blocks") #wait while block is posted to all other nodes time.sleep(1) # check on each node for node in nodes: blocks = _blocks.WaitBlocks(node['datadir'], blockslen + 1) _lib.FatalAssert(len(blocks) == blockslen + 1, "Expected "+str(blockslen +1)+" blocks o node "+str(node['number'])) _lib.StartTestGroup("Create 2 branches of blockchain") # remove connection between subnetworks managenodes.RemoveAllNodes(nodes[0]['datadir']) managenodes.RemoveAllNodes(nodes[1]['datadir']) managenodes.RemoveAllNodes(nodes[2]['datadir']) managenodes.RemoveAllNodes(nodes[3]['datadir']) managenodes.RemoveAllNodes(nodes[4]['datadir']) managenodes.RemoveAllNodes(datadir) # first group - main and 4,5 nodes managenodes.AddNode(datadir,"localhost",'30004') managenodes.AddNode(datadir,"localhost",'30005') managenodes.AddNode(nodes[3]['datadir'],"localhost",'30005') #second group 1,2,3 managenodes.AddNode(nodes[0]['datadir'],"localhost",'30002') managenodes.AddNode(nodes[0]['datadir'],"localhost",'30003') managenodes.AddNode(nodes[1]['datadir'],"localhost",'30003') time.sleep(1) #check nodes nodes0 = managenodes.GetNodes(datadir) _lib.FatalAssert("localhost:30005", "Node 5 is not in the list of 0") _lib.FatalAssert("localhost:30004", "Node 4 is not in the list of 0") nodes1 = managenodes.GetNodes(nodes[0]['datadir']) _lib.FatalAssert("localhost:30002", "Node 2 is not in the list of 1") _lib.FatalAssert("localhost:30003", "Node 3 is not in the list of 1") nodes2 = managenodes.GetNodes(nodes[1]['datadir']) _lib.FatalAssert("localhost:30001", "Node 1 is not in the list of 2") _lib.FatalAssert("localhost:30003", "Node 3 is not in the list of 2") _lib.StartTestGroup("2 new blocks on first branch") balance1 = _transfers.GetBalance(datadir, address1) as1 = "%.8f" % round(balance1[0]/20,8) # 7 TX for 8-th block tx = [""] * 15 tx[0] = _transfers.Send(datadir,address1, nodes[3]['address'] ,as1) print tx[0] tx[1] = _transfers.Send(datadir,address1, nodes[3]['address'] ,as1) print tx[1] tx[2] = _transfers.Send(datadir,address1, nodes[3]['address'] ,as1) print tx[2] tx[3] = _transfers.Send(datadir,address1, nodes[3]['address'] ,as1) print tx[3] tx[4] = _transfers.Send(datadir,address1, nodes[3]['address'] ,as1) print tx[4] tx[5] = _transfers.Send(datadir,address1, nodes[3]['address'] ,as1) print tx[5] tx[6] = _transfers.Send(datadir,address1, nodes[3]['address'] ,as1) print tx[6] time.sleep(7) # 8 TX for 9-th block tx[7] = _transfers.Send(datadir,address1, nodes[4]['address'] ,as1) print tx[7] tx[8] = _transfers.Send(datadir,address1, nodes[4]['address'] ,as1) print tx[8] tx[9] = _transfers.Send(datadir,address1, nodes[4]['address'] ,as1) print tx[9] tx[10] = _transfers.Send(datadir,address1, nodes[4]['address'] ,as1) print tx[10] tx[11] = _transfers.Send(datadir,address1, nodes[4]['address'] ,as1) print tx[11] tx[12] = _transfers.Send(datadir,address1, nodes[4]['address'] ,as1) print tx[12] tx[13] = _transfers.Send(datadir,address1, nodes[4]['address'] ,as1) print tx[13] tx[14] = _transfers.Send(datadir,address1, nodes[4]['address'] ,as1) print tx[14] blocks1 = _blocks.WaitBlocks(nodes[4]['datadir'], blockslen + 3) time.sleep(3) _lib.FatalAssert(len(blocks1) == blockslen + 3, "Expected "+str(blockslen +3)+" blocks for branch 1") _lib.StartTestGroup("1 new block on second branch") balance2 = _transfers.GetBalance(nodes[0]['datadir'], nodes[0]['address']) as2 = "%.8f" % round(balance2[0]/10,8) # 7 new TX tx1 = _transfers.Send(nodes[0]['datadir'], nodes[0]['address'], nodes[1]['address'] ,as2) tx2 = _transfers.Send(nodes[0]['datadir'], nodes[0]['address'], nodes[2]['address'] ,as2) tx3 = _transfers.Send(nodes[0]['datadir'], nodes[0]['address'], nodes[2]['address'] ,as2) _transfers.Send(nodes[0]['datadir'], nodes[0]['address'], nodes[2]['address'] ,as2) _transfers.Send(nodes[0]['datadir'], nodes[0]['address'], nodes[2]['address'] ,as2) _transfers.Send(nodes[0]['datadir'], nodes[0]['address'], nodes[2]['address'] ,as2) _transfers.Send(nodes[0]['datadir'], nodes[0]['address'], nodes[2]['address'] ,as2) blocks2 = _blocks.WaitBlocks(nodes[2]['datadir'], blockslen + 2) _lib.FatalAssert(len(blocks2) == blockslen + 2, "Expected "+str(blockslen +2)+" blocks for branch 2") dstdir = _lib.getCurrentDir()+"/datafortests/" #configs for cluster 1 copyConfig(datadir, dstdir+"bc6nodes_1/config.t", address1, nodeport, nodes[3]['port'], nodes[4]['port']) copyConfig(nodes[3]['datadir'], dstdir+"bc6nodes_5/config.t", nodes[3]['address'], nodes[3]['port'], nodeport, nodes[4]['port']) copyConfig(nodes[4]['datadir'], dstdir+"bc6nodes_6/config.t", nodes[4]['address'], nodes[4]['port'], nodeport, nodes[3]['port']) #config for cluster 2 copyConfig(nodes[0]['datadir'], dstdir+"bc6nodes_2/config.t", nodes[0]['address'], nodes[0]['port'], nodes[1]['port'], nodes[2]['port']) copyConfig(nodes[1]['datadir'], dstdir+"bc6nodes_3/config.t", nodes[1]['address'], nodes[1]['port'], nodes[0]['port'], nodes[2]['port']) copyConfig(nodes[2]['datadir'], dstdir+"bc6nodes_4/config.t", nodes[2]['address'], nodes[2]['port'], nodes[0]['port'], nodes[1]['port']) #print os.path.basename(datadir) startnode.StopNode(datadir) dstdir = _lib.getCurrentDir()+"/datafortests/bc6nodes_1/" #print dstdir copyfile(datadir+"/wallet.dat", dstdir+"wallet.t") try: os.remove(dstdir+"db.sql") except OSError: pass DumpBCDB(datadir, dstdir+"db.sql") i = 2 for node in nodes: #print os.path.basename(node['datadir']) startnode.StopNode(node['datadir']) dstdir = _lib.getCurrentDir()+"/datafortests/bc6nodes_"+str(i)+"/" #print dstdir copyfile(node['datadir']+"/wallet.dat", dstdir+"wallet.t") try: os.remove(dstdir+"db.sql") except OSError: pass DumpBCDB(node['datadir'], dstdir+"db.sql") i=i+1 return [datadir, address1, nodes, blockslen+1, datadirs]
def test(testfilter): global datadir, datadir2 _lib.StartTestGroup("SQL Sync with Proxy. care offline") _lib.CleanTestFolders() datadir = _lib.CreateTestFolder('_1_') startnode.StartNodeWithoutBlockchain(datadir) address = startnode.InitBockchain(datadir) _complex.AddProxyToConfig(datadir, "localhost:40041") _complex.AddInternalKeyToConfig(datadir, address) # init internal signing startnode.StartNode(datadir, address, '30000') _lib.StartTestGroup("Do initial transactions") transactions.GetUnapprovedTransactionsEmpty(datadir) _sql.ExecuteSQLOnProxy( datadir, "CREATE TABLE test (a INT auto_increment PRIMARY KEY, b VARCHAR(20))") # check new table exists tables = _lib.DBGetRows(datadir, "SHOW TABLES", True) found = False for table in tables: if table[0] == "test": found = True break _lib.FatalAssert(found, "Table not found in the DB") blocks = _blocks.WaitBlocks(datadir, 2) time.sleep(1) _sql.ExecuteSQLOnProxy(datadir, "INSERT INTO test SET b='row1'") datadir2 = _lib.CreateTestFolder('_2_') address2 = initblockchain.ImportBockchain(datadir2, "localhost", '30000') _complex.AddProxyToConfig(datadir2, "localhost:40042") _complex.AddInternalKeyToConfig(datadir2, address2) # init internal signing startnode.StartNode(datadir2, address2, '30001', "Server 2") blocks = _blocks.WaitBlocks(datadir2, 2) _sql.ExecuteSQLOnProxy(datadir2, "INSERT INTO test SET b='row1.2'") # must be 1 row , because the first row from the first node is not yet in a block and is not synced rows = _lib.DBGetRows(datadir2, "SELECT * FROM test", True) _lib.FatalAssert(len(rows) == 1, "Must be 1 row in a table on node 2") _sql.ExecuteSQLOnProxy(datadir, "INSERT INTO test SET b='row2'") # should be 1 row on first node rows = _lib.DBGetRows(datadir, "SELECT * FROM test", True) _lib.FatalAssert(len(rows) == 2, "Must be 2 rows in a table on node 1") # wait 3-rd block blocks = _blocks.WaitBlocks(datadir, 3) time.sleep(1) # give time to send transaction # wait 3-rd block on a second node blocks = _blocks.WaitBlocks(datadir2, 3) time.sleep(1) # and 2 row on second rows2 = _lib.DBGetRows(datadir2, "SELECT * FROM test ORDER BY a", True) _lib.FatalAssert(len(rows2) == 2, "Must be 2 rows in a table") rows = _lib.DBGetRows(datadir, "SELECT * FROM test ORDER BY a", True) _lib.FatalAssert(len(rows) == 2, "Must be 2 rows in a table") _lib.FatalAssert( set(rows) == set(rows2), "COntents of tables on both nodes must be same") _lib.StartTestGroup("Check cancel of following transactions") # temporary stop second node startnode.StopNode(datadir2) _sql.ExecuteSQLOnProxy(datadir, "INSERT INTO test SET b='row3'") startnode.StartNode(datadir2, address2, '30001', "Server 2") _sql.ExecuteSQLOnProxy(datadir2, "INSERT INTO test SET b='row3.2'") _sql.ExecuteSQLOnProxy(datadir, "UPDATE test SET b='row3_updated' WHERE a=3") _sql.ExecuteSQLOnProxy(datadir2, "UPDATE test SET b='row3_updated_2' WHERE a=3") _sql.ExecuteSQLOnProxy(datadir, "UPDATE test SET b='row3_updated_again' WHERE a=3") blocks = _blocks.WaitBlocks(datadir, 4) time.sleep(1) # give time to send transaction blocks = _blocks.WaitBlocks(datadir2, 4) time.sleep(1) # give time to send transaction rows = _lib.DBGetRows(datadir, "SELECT * FROM test ORDER BY a", True) _lib.FatalAssert(len(rows) == 3, "Must be 3 rows in a table") rows2 = _lib.DBGetRows(datadir2, "SELECT * FROM test ORDER BY a", True) _lib.FatalAssert(len(rows2) == 3, "Must be 3 rows in a table") _lib.FatalAssert( set(rows) == set(rows2), "COntents of tables on both nodes must be same") startnode.StopNode(datadir) datadir = "" startnode.StopNode(datadir2) datadir2 = "" #_lib.RemoveTestFolder(datadir) _lib.EndTestGroupSuccess()
def test(testfilter): global datadir _lib.StartTestGroup("Init Blockchain on non empty DB") _lib.CleanTestFolders() datadir = _lib.CreateTestFolder() address2 = transactions.CreateWallet(datadir) address3 = transactions.CreateWallet(datadir) _lib.CopyTestConsensusConfig(datadir, "disabledcreate", address2) # add some data to the DB _lib.DBExecute( datadir, "create table test (a int unsigned auto_increment primary key, b varchar(10))" ) _lib.DBExecute(datadir, "insert into test SET b='row1'") _lib.DBExecute(datadir, "insert into test SET b='row2'") _lib.DBExecute( datadir, "create table members (a int unsigned auto_increment primary key, b varchar(10))" ) _lib.DBExecute(datadir, "insert into members SET b='row1'") _lib.DBExecute(datadir, "insert into members SET b='row2'") address = startnode.InitBockchain(datadir) _complex.AddProxyToConfig(datadir, "localhost:40041") _complex.AddInternalKeyToConfig(datadir, address3) # init internal signing startnode.StartNode(datadir, address, '30000') _lib.StartTestGroup("Do transactions") transactions.GetUnapprovedTransactionsEmpty(datadir) blocks = _blocks.GetBlocks(datadir) _lib.FatalAssert(len(blocks) == 2, "Should be 2 blocks in blockchain") _sql.ExecuteSQLOnProxy(datadir, "INSERT INTO members SET b='row3'") _sql.ExecuteSQLOnProxy(datadir, "INSERT INTO members SET b='row4'") blocks = _blocks.WaitBlocks(datadir, 3) _lib.FatalAssert(len(blocks) == 3, "Should be 3 blocks in blockchain") time.sleep(1) _sql.ExecuteSQLOnProxyFail(datadir, "INSERT INTO test SET b='row3'") _transfers.Send(datadir, address, address3, 1) _sql.ExecuteSQLOnProxy(datadir, "INSERT INTO test SET b='row3'") _sql.ExecuteSQLOnProxy(datadir, "INSERT INTO test SET b='row4'") _sql.ExecuteSQLOnProxy(datadir, "INSERT INTO members SET b='row5'") startnode.StopNode(datadir) datadir = "" #_lib.RemoveTestFolder(datadir) _lib.EndTestGroupSuccess()
def test(testfilter): global datadirs _lib.CleanTestFolders() #return _complex.Make5BlocksBC() #return _complex.PrepareNodes() dirs = _complex.Copy6Nodes() nodes = [] i = 1 for d in dirs: #get address in wallets in this dir balances = _transfers.GetGroupBalance(d) address = balances.keys()[0] port = str(30000 + i ) nodes.append({'index':i - 1, 'port':port, 'datadir':d,'address':address,"title":"Server "+str(i)}) #_transfers.ReindexUTXO(d) #txlist = transactions.GetUnapprovedTransactions(d) #print txlist #start this node #print os.path.basename(d) startnode.StartNodeConfig(d) i = i + 1 datadirs.append(d) #check nodes on each node is correct for node in nodes: #print os.path.basename(node['datadir']) nodeslist = managenodes.GetNodes(node['datadir']) _lib.FatalAssert(len(nodeslist) == 2,"Should be 2 nodes on "+node["title"]) if node['index'] == 0: _lib.FatalAssert("localhost:30005" in nodeslist,"Node 6 should be on the node 0") _lib.FatalAssert("localhost:30004" in nodeslist,"Node 5 should be on the node 0") if node['index'] == 1: _lib.FatalAssert("localhost:30002" in nodeslist,"Node 2 should be on the node 1") _lib.FatalAssert("localhost:30003" in nodeslist,"Node 3 should be on the node 1") #raise ValueError('Stop') # test blocks branches _lib.StartTestGroup("Check blockchain before updates") blocks1 = _blocks.GetBlocks(nodes[0]["datadir"]) blocks2 = _blocks.GetBlocks(nodes[1]["datadir"]) _lib.FatalAssert(len(blocks1) == 9,"First branch should have 9 blocks") _lib.FatalAssert(len(blocks2) == 8,"Second branch should have 8 blocks") _lib.FatalAssert(blocks1[2] == blocks2[1],"7 block must be same for both") _lib.FatalAssert(blocks1[1] != blocks2[0],"8 block must be different") _lib.StartTestGroup("Connect subnetworks") managenodes.AddNode(nodes[0]["datadir"],"localhost",'30001') # wait whle blocks are exachanged _blocks.WaitBlocks(nodes[1]["datadir"],9) # get unapproved transactions (after block cancel) txlist = _transfers.WaitUnapprovedTransactions(nodes[1]["datadir"], 7) _lib.FatalAssert(len(txlist) == 7,"SHould be 7 unapproved TXs") #send another 2 TXs to have 9 required TXs balances = _transfers.GetGroupBalance(nodes[1]["datadir"]) mainbalance = _transfers.GetGroupBalance(nodes[0]["datadir"]) addr1 = balances.keys()[0] amount = "%.8f" % round(balances[addr1][0]/5,8) _transfers.Send(nodes[1]["datadir"],addr1,mainbalance.keys()[0],amount) _transfers.Send(nodes[1]["datadir"],addr1,mainbalance.keys()[0],amount) # wait while new block created and posted to all other b1 = _blocks.WaitBlocks(nodes[1]["datadir"],10) b2 = _blocks.WaitBlocks(nodes[0]["datadir"],10) _lib.StartTestGroup("Check blockchain after updates") blocks2_0 = _blocks.GetBlocks(nodes[0]["datadir"]) _lib.FatalAssert(len(blocks2_0) == 10,"10 block must be on node 0") _lib.FatalAssert(blocks2_0[1] == blocks1[0],"9 block must be same for both") blocks2_1 = _blocks.GetBlocks(nodes[1]["datadir"]) _lib.FatalAssert(len(blocks2_1) == 10,"10 block must be on node 1") _lib.FatalAssert(blocks2_1[1] == blocks1[0],"9 block must be same for both") _lib.StartTestGroup("Node 2 "+os.path.basename(nodes[2]["datadir"])) _blocks.WaitBlocks(nodes[2]["datadir"],10) blocks2_2 = _blocks.GetBlocks(nodes[2]["datadir"]) _lib.FatalAssert(len(blocks2_2) == 10,"10 block must be on node 2") _lib.FatalAssert(blocks2_2[1] == blocks2_1[1],"2-nd from top blocks on 2 must be same as on 1") _lib.StartTestGroup("Node 3 "+os.path.basename(nodes[3]["datadir"])) _blocks.WaitBlocks(nodes[3]["datadir"],10) blocks2_3 = _blocks.GetBlocks(nodes[3]["datadir"]) _lib.FatalAssert(len(blocks2_3) == 10,"10 block must be on node 3") _lib.FatalAssert(blocks2_3[1] == blocks2_1[1],"2-nd from top blocks on 3 must be same as on 1") _lib.StartTestGroup("Node 4 "+os.path.basename(nodes[4]["datadir"])) _blocks.WaitBlocks(nodes[4]["datadir"],10) blocks2_4 = _blocks.GetBlocks(nodes[4]["datadir"]) _lib.FatalAssert(len(blocks2_4) == 10,"10 block must be on node 4") _lib.FatalAssert(blocks2_4[1] == blocks2_1[1],"2-nd from top blocks on 4 must be same as on 1") _lib.StartTestGroup("Node 5 "+os.path.basename(nodes[5]["datadir"])) _blocks.WaitBlocks(nodes[5]["datadir"],10) blocks2_5 = _blocks.GetBlocks(nodes[5]["datadir"]) _lib.FatalAssert(len(blocks2_5) == 10,"10 block must be on node 5") _lib.FatalAssert(blocks2_5[1] == blocks2_1[1],"2-nd from top blocks on 5 must be same as on 1") _lib.StartTestGroup("Final checks") # should be empty list of transactions now transactions.GetUnapprovedTransactionsEmpty(nodes[1]["datadir"]) for node in nodes: startnode.StopNode(node['datadir']) datadirs[node['index']] = "" #_lib.RemoveTestFolder(datadir) _lib.EndTestGroupSuccess()
def test(testfilter): global datadir _lib.StartTestGroup("SQL Consensus rules postponed") _lib.CleanTestFolders() datadir = _lib.CreateTestFolder() startnode.StartNodeWithoutBlockchain(datadir) address2 = transactions.CreateWallet(datadir) address3 = transactions.CreateWallet(datadir) _lib.CopyTestConsensusConfig(datadir,"postponedlimits", address2) address = startnode.InitBockchain(datadir) _complex.AddProxyToConfig(datadir, "localhost:40041") _complex.AddInternalKeyToConfig(datadir, address3) # init internal signing startnode.StartNode(datadir, address, '30000') _lib.StartTestGroup("Do transactions") transactions.GetUnapprovedTransactionsEmpty(datadir) _sql.ExecuteSQLOnProxy(datadir, "CREATE TABLE test (a INT auto_increment PRIMARY KEY, b VARCHAR(20))") blocks = _blocks.WaitBlocks(datadir, 2) time.sleep(1) _sql.ExecuteSQLOnProxy(datadir,"INSERT INTO test SET b='row1'") _sql.ExecuteSQLOnProxy(datadir,"INSERT INTO test SET b='row2'") blocks = _blocks.WaitBlocks(datadir, 3) time.sleep(1) _sql.ExecuteSQLOnProxy(datadir, "CREATE TABLE members (id INT auto_increment PRIMARY KEY, name VARCHAR(20))") tables = _lib.DBGetRows(datadir,"SHOW TABLES") found = False for table in tables: if table[0] == "members": found = True break _lib.FatalAssert(found, "Table not found in the DB") _sql.ExecuteSQLOnProxy(datadir, "INSERT INTO members SET name='user1'") _sql.ExecuteSQLOnProxy(datadir, "INSERT INTO members SET name='use2'") #_sql.ExecuteSQLOnProxy(datadir, "DROP TABLE members") blocks = _blocks.WaitBlocks(datadir, 4) time.sleep(1) _sql.ExecuteSQLOnProxyFail(datadir, "CREATE TABLE test2 (a INT auto_increment PRIMARY KEY, b VARCHAR(20))") _sql.ExecuteSQLOnProxy(datadir, "DROP TABLE members") _sql.ExecuteSQLOnProxy(datadir,"INSERT INTO test SET b='row3'") _sql.ExecuteSQLOnProxy(datadir,"UPDATE test SET b='row3+upd1' WHERE a=3") _sql.ExecuteSQLOnProxy(datadir,"UPDATE test SET b='row3+upd2' WHERE a=3") blocks = _blocks.WaitBlocks(datadir, 5) time.sleep(1) # now this must be paid _sql.ExecuteSQLOnProxyFail(datadir,"UPDATE test SET b='row3+upd2' WHERE a=3") _sql.ExecuteSQLOnProxy(datadir, "CREATE TABLE members (id INT auto_increment PRIMARY KEY, name VARCHAR(20))") tables = _lib.DBGetRows(datadir,"SHOW TABLES") found = False for table in tables: if table[0] == "members": found = True break _sql.ExecuteSQLOnProxy(datadir, "INSERT INTO members SET name='user1'") _sql.ExecuteSQLOnProxy(datadir, "INSERT INTO members SET name='user2'") _sql.ExecuteSQLOnProxy(datadir, "INSERT INTO members SET name='user3'") _sql.ExecuteSQLOnProxy(datadir,"INSERT INTO test SET b='row4'") blocks = _blocks.WaitBlocks(datadir, 6) time.sleep(1) _sql.ExecuteSQLOnProxyFail(datadir, "INSERT INTO members SET name='user4'") _sql.ExecuteSQLOnProxyFail(datadir,"INSERT INTO test SET b='row5'") # send money to be able to execute this _transfers.Send(datadir,address, address3 ,10) # needs this to create table _sql.ExecuteSQLOnProxy(datadir, "INSERT INTO members SET name='user4'") _sql.ExecuteSQLOnProxy(datadir,"INSERT INTO test SET b='row5'") _sql.ExecuteSQLOnProxy(datadir, "CREATE TABLE test2 (a INT auto_increment PRIMARY KEY, b VARCHAR(20))") _sql.ExecuteSQLOnProxy(datadir,"INSERT INTO test2 SET b='row1'") _sql.ExecuteSQLOnProxy(datadir,"INSERT INTO test2 SET b='row2'") _sql.ExecuteSQLOnProxy(datadir,"INSERT INTO test2 SET b='row3'") blocks = _blocks.WaitBlocks(datadir, 7) time.sleep(1) startnode.StopNode(datadir) datadir = "" #_lib.RemoveTestFolder(datadir) _lib.EndTestGroupSuccess()
def test(testfilter): global datadirs _lib.CleanTestFolders() #return _complex.PrepareNodesWithSQL() _lib.StartTestGroup("Load ready BC into 6 nodes") dirs = _complex.Copy6NodesSQL() nodes = [] i = 1 for d in dirs: #get address in wallets in this dir balances = _transfers.GetGroupBalance(d) address = balances.keys()[0] port = str(30000 + i) nodes.append({ 'index': i - 1, 'port': port, 'datadir': d, 'address': address, "title": "Server " + str(i) }) #_transfers.ReindexUTXO(d) #txlist = transactions.GetUnapprovedTransactions(d) #print txlist #start this node #print os.path.basename(d) startnode.StartNodeConfig(d) i = i + 1 datadirs.append(d) #check nodes on each node is correct for node in nodes: #print os.path.basename(node['datadir']) nodeslist = managenodes.GetNodes(node['datadir']) _lib.FatalAssert( len(nodeslist) == 2, "Should be 2 nodes on " + node["title"]) if node['index'] == 0: _lib.FatalAssert("localhost:30005" in nodeslist, "Node 6 should be on the node 0") _lib.FatalAssert("localhost:30004" in nodeslist, "Node 5 should be on the node 0") if node['index'] == 1: _lib.FatalAssert("localhost:30002" in nodeslist, "Node 2 should be on the node 1") _lib.FatalAssert("localhost:30003" in nodeslist, "Node 3 should be on the node 1") #raise ValueError('Stop') # test blocks branches _lib.StartTestGroup("Check blockchain before updates") blocks1 = _blocks.GetBlocks(nodes[0]["datadir"]) blocks2 = _blocks.GetBlocks(nodes[1]["datadir"]) _lib.FatalAssert(len(blocks1) == 9, "First branch should have 9 blocks") _lib.FatalAssert(len(blocks2) == 8, "Second branch should have 8 blocks") _lib.FatalAssert(blocks1[2] == blocks2[1], "7 block must be same for both") _lib.FatalAssert(blocks1[1] != blocks2[0], "8 block must be different") _lib.StartTestGroup("Connect subnetworks") managenodes.AddNode(nodes[0]["datadir"], "localhost", '30001') # wait while blocks are exachanged _blocks.WaitBlocks(nodes[1]["datadir"], 9) s = 1 time.sleep(2) while s < 10: rows1 = _lib.DBGetRows(nodes[1]['datadir'], "SELECT * FROM test", True) rows2 = _lib.DBGetRows(nodes[2]['datadir'], "SELECT * FROM test", True) rows3 = _lib.DBGetRows(nodes[3]['datadir'], "SELECT * FROM test", True) if ((rows1[1][1] == "row2_updated" or rows1[1][1] == "row2_updated_other") and (rows2[1][1] == "row2_updated" or rows2[1][1] == "row2_updated_other") and (rows3[1][1] == "row2_updated" or rows3[1][1] == "row2_updated_other")): break time.sleep(1) s = s + 1 # get unapproved transactions (after block cancel) txlist = _transfers.WaitUnapprovedTransactions(nodes[1]["datadir"], 5, 15) #print(txlist) _lib.FatalAssert( len(txlist) == 5, "Should be 5 unapproved TXs, but has " + str(len(txlist))) #send another 2 TXs to have 9 required TXs balances = _transfers.GetGroupBalance(nodes[1]["datadir"]) mainbalance = _transfers.GetGroupBalance(nodes[0]["datadir"]) addr1 = balances.keys()[0] amount = "%.8f" % round(balances[addr1][0] / 5, 8) # add yet mode 4 TXs to complete a block _transfers.Send(nodes[1]["datadir"], addr1, mainbalance.keys()[0], amount) # 3 SQL txs # on another node. should go to the second node too _sql.ExecuteSQLOnProxy(nodes[0]['datadir'], "INSERT INTO test SET b='row11', a=11") _sql.ExecuteSQLOnProxy(nodes[1]['datadir'], "UPDATE test set b='row5_update_other' WHERE a=5") time.sleep(2) txlist = _transfers.WaitUnapprovedTransactions(nodes[0]["datadir"], 1, 10) # there should be minimum 1 tx, maximum 2. Because currency TX's can be based on other 1 currency TX's that are not yet on other nodes (from canceled block) _lib.FatalAssert( len(txlist) >= 1 and len(txlist) <= 2, "SHould be from 1 to 2 unapproved TXs on node 1") txlist = _transfers.WaitUnapprovedTransactions(nodes[1]["datadir"], 8, 10) _lib.FatalAssert(len(txlist) == 8, "SHould be 8 unapproved TXs") # after this TX new block should be created _sql.ExecuteSQLOnProxy( nodes[1]['datadir'], "UPDATE test set b='row11_update_other' WHERE a=11") # wait while new block created and posted to all other b1 = _blocks.WaitBlocks(nodes[1]["datadir"], 10) b2 = _blocks.WaitBlocks(nodes[0]["datadir"], 10) _lib.StartTestGroup("Check blockchain after updates") blocks2_0 = _blocks.GetBlocks(nodes[0]["datadir"]) _lib.FatalAssert(len(blocks2_0) == 10, "10 block must be on node 0") _lib.FatalAssert(blocks2_0[1] == blocks1[0], "9 block must be same for both") blocks2_1 = _blocks.GetBlocks(nodes[1]["datadir"]) _lib.FatalAssert(len(blocks2_1) == 10, "10 block must be on node 1") _lib.FatalAssert(blocks2_1[1] == blocks1[0], "9 block must be same for both") _lib.StartTestGroup("Node 2 " + os.path.basename(nodes[2]["datadir"])) _blocks.WaitBlocks(nodes[2]["datadir"], 10) blocks2_2 = _blocks.GetBlocks(nodes[2]["datadir"]) _lib.FatalAssert(len(blocks2_2) == 10, "10 block must be on node 2") _lib.FatalAssert(blocks2_2[1] == blocks2_1[1], "2-nd from top blocks on 2 must be same as on 1") _lib.StartTestGroup("Node 3 " + os.path.basename(nodes[3]["datadir"])) _blocks.WaitBlocks(nodes[3]["datadir"], 10) blocks2_3 = _blocks.GetBlocks(nodes[3]["datadir"]) _lib.FatalAssert(len(blocks2_3) == 10, "10 block must be on node 3") _lib.FatalAssert(blocks2_3[1] == blocks2_1[1], "2-nd from top blocks on 3 must be same as on 1") _lib.StartTestGroup("Node 4 " + os.path.basename(nodes[4]["datadir"])) _blocks.WaitBlocks(nodes[4]["datadir"], 10) blocks2_4 = _blocks.GetBlocks(nodes[4]["datadir"]) _lib.FatalAssert(len(blocks2_4) == 10, "10 block must be on node 4") _lib.FatalAssert(blocks2_4[1] == blocks2_1[1], "2-nd from top blocks on 4 must be same as on 1") _lib.StartTestGroup("Node 5 " + os.path.basename(nodes[5]["datadir"])) _blocks.WaitBlocks(nodes[5]["datadir"], 10) blocks2_5 = _blocks.GetBlocks(nodes[5]["datadir"]) _lib.FatalAssert(len(blocks2_5) == 10, "10 block must be on node 5") _lib.FatalAssert(blocks2_5[1] == blocks2_1[1], "2-nd from top blocks on 5 must be same as on 1") rows1 = _lib.DBGetRows(nodes[0]['datadir'], "SELECT * FROM test", True) rows2 = _lib.DBGetRows(nodes[1]['datadir'], "SELECT * FROM test", True) _lib.FatalAssert(rows1 == rows2, "Table contents on node 1 and 2 must be same") rows3 = _lib.DBGetRows(nodes[2]['datadir'], "SELECT * FROM test", True) _lib.FatalAssert(rows1 == rows3, "Table contents on node 1 and 3 must be same") rows4 = _lib.DBGetRows(nodes[3]['datadir'], "SELECT * FROM test", True) _lib.FatalAssert(rows1 == rows4, "Table contents on node 1 and 4 must be same") rows5 = _lib.DBGetRows(nodes[4]['datadir'], "SELECT * FROM test", True) _lib.FatalAssert(rows1 == rows5, "Table contents on node 1 and 5 must be same") rows6 = _lib.DBGetRows(nodes[5]['datadir'], "SELECT * FROM test", True) _lib.FatalAssert(rows1 == rows6, "Table contents on node 1 and 6 must be same") _lib.StartTestGroup("Final checks") # should be empty list of transactions now transactions.GetUnapprovedTransactionsEmpty(nodes[1]["datadir"]) for node in nodes: startnode.StopNode(node['datadir']) datadirs[node['index']] = "" #_lib.RemoveTestFolder(datadir) _lib.EndTestGroupSuccess()
def test(testfilter): global datadir nodeport = '30000' _lib.CleanTestFolders() _lib.StartTestGroup("Init Blockchain") datadir_tmp = _lib.CreateTestFolder() r = blocksbasic.PrepareBlockchain(datadir_tmp, nodeport) mainaddress = r[0] startnode.StartNode(datadir_tmp, mainaddress, nodeport) datadir = datadir_tmp walletdatadir = _lib.CreateTestFolder("wallet") #create 100 wallets for i in range(1, 101): _wallet.CreateWallet(walletdatadir) addresses = _wallet.GetWallets(walletdatadir) #send first TX balances = _transfers.GetGroupBalance(datadir) _transfers.Send(datadir, mainaddress, addresses[0], balances[mainaddress][0]) _blocks.WaitBlocks(datadir, 2) blocks = _blocks.GetBlocksExt(datadir) _lib.FatalAssert(len(blocks) == 2, "2 blocks are expected") initialbalance = _wallet.GetBalanceWallet(walletdatadir, addresses[0], "localhost", nodeport) _lib.FatalAssert( initialbalance[0] == balances[mainaddress][0], "Balance of the first wallet should be same as posted to it") _lib.StartTestGroup("Do transactions") for i in range(1, 100): _lib.StartTestGroup("Iteration " + str(i)) addresses = _wallet.GetGroupBalanceWallet(walletdatadir, "localhost", nodeport) for address in addresses.keys(): bal = addresses[address][0] if bal <= 0: continue to = random.choice(addresses.keys()) amount = "%.8f" % round(bal / 2, 8) tx = _wallet.Send(walletdatadir, address, to, amount, "localhost", nodeport) blocks = _blocks.GetBlocksExt(datadir) print "\t\tNumer of blocks %d" % (len(blocks)) startnode.StopNode(datadir) datadir = "" #_lib.RemoveTestFolder(datadir) _lib.EndTestGroupSuccess()
def test(testfilter): global datadirs _lib.CleanTestFolders() #return _complex.Make5BlocksBC() #return _complex.PrepareNodes() dirs = _complex.Copy6Nodes() nodes = [] i = 1 for d in dirs: #get address in wallets in this dir balances = _transfers.GetGroupBalance(d) address = balances.keys()[0] port = str(30000 + i ) nodes.append({'index':i - 1, 'port':port, 'datadir':d,'address':address,"title":"Server "+str(i)}) #_transfers.ReindexUTXO(d) #txlist = transactions.GetUnapprovedTransactions(d) #print txlist #start this node #print os.path.basename(d) startnode.StartNodeConfig(d) i = i + 1 datadirs.append(d) #check nodes on each node is correct for node in nodes: #print os.path.basename(node['datadir']) nodeslist = managenodes.GetNodes(node['datadir']) _lib.FatalAssert(len(nodeslist) == 2,"Should be 2 nodes on "+node["title"]) if node['index'] == 0: _lib.FatalAssert("localhost:30005" in nodeslist,"Node 6 should be on the node 0") _lib.FatalAssert("localhost:30004" in nodeslist,"Node 5 should be on the node 0") if node['index'] == 1: _lib.FatalAssert("localhost:30002" in nodeslist,"Node 2 should be on the node 1") _lib.FatalAssert("localhost:30003" in nodeslist,"Node 3 should be on the node 1") #raise ValueError('Stop') # test blocks branches # ensure subnetworks are fine managenodes.AddNode(nodes[2]["datadir"],"localhost",'30003') managenodes.AddNode(nodes[4]["datadir"],"localhost",'30005') _lib.StartTestGroup("Check blockchain before updates") blocks1 = _blocks.GetBlocks(nodes[0]["datadir"]) blocks2 = _blocks.GetBlocks(nodes[1]["datadir"]) _lib.FatalAssert(len(blocks1) == 9,"First branch should have 9 blocks") _lib.FatalAssert(len(blocks2) == 8,"Second branch should have 8 blocks") _lib.FatalAssert(blocks1[2] == blocks2[1],"7 block must be same for both") _lib.FatalAssert(blocks1[1] != blocks2[0],"8 block must be different") #====================================================================================== # remove node 6 from the first branch managenodes.RemoveAllNodes(nodes[5]["datadir"]) nodeslist = managenodes.GetNodes(nodes[5]["datadir"]) _lib.FatalAssert(len(nodeslist) == 0,"Should be 0 nodes on the node 6") # remove this node from 2 other nodes where it is known managenodes.RemoveNode(nodes[0]["datadir"], "localhost" ,"30005") managenodes.RemoveNode(nodes[4]["datadir"], "localhost" ,"30005") nodeslist = managenodes.GetNodes(nodes[0]["datadir"]) _lib.FatalAssert(len(nodeslist) == 1,"Should be 1 nodes on the node 1") nodeslist = managenodes.GetNodes(nodes[4]["datadir"]) _lib.FatalAssert(len(nodeslist) == 1,"Should be 1 nodes on the node 5") # add one more blockon the first node balances = _transfers.GetGroupBalance(nodes[0]["datadir"]) addr1 = balances.keys()[0] addr2 = balances.keys()[1] amount = "%.8f" % round(balances[addr1][0]/10,8) for x in range(1, 11): _transfers.Send(nodes[0]["datadir"],addr1,addr2,amount) _blocks.WaitBlocks(nodes[0]["datadir"],10) # and again new block. balances = _transfers.GetGroupBalance(nodes[0]["datadir"]) addr1 = balances.keys()[1] addr2 = balances.keys()[0] amount = "%.8f" % round(balances[addr1][0]/12,8) for x in range(1, 12): _transfers.Send(nodes[0]["datadir"],addr1,addr2,amount) _blocks.WaitBlocks(nodes[0]["datadir"],11) # create 2 more blocks on branch 2 balances = _transfers.GetGroupBalance(nodes[1]["datadir"]) addr3 = balances.keys()[0] amount = "%.8f" % round(balances[addr3][0]/30,8) for x in range(1, 10): # send to address on the firs node _transfers.Send(nodes[1]["datadir"],addr3,addr1,amount) _blocks.WaitBlocks(nodes[1]["datadir"],9) for x in range(1, 11): # send to address on the firs node _transfers.Send(nodes[1]["datadir"],addr3,addr1,amount) _blocks.WaitBlocks(nodes[1]["datadir"],10) # now branch 2 has more blocks than the node 6. # connect node 6 with the branch 2 _lib.StartTestGroup("Connect network 2 with the node 6") managenodes.AddNode(nodes[1]["datadir"],"localhost",'30005') managenodes.AddNode(nodes[4]["datadir"],"localhost",'30002') managenodes.AddNode(nodes[4]["datadir"],"localhost",'30003') managenodes.AddNode(nodes[4]["datadir"],"localhost",'30005') managenodes.WaitNodes(nodes[1]["datadir"],3) managenodes.WaitNodes(nodes[2]["datadir"],3) managenodes.WaitNodes(nodes[3]["datadir"],3) # should be 10 blocks after sync _blocks.WaitBlocks(nodes[5]["datadir"],10) # must be unapproved transactions from previous block 8 #txlist = transactions.GetUnapprovedTransactions(nodes[5]["datadir"]) _lib.StartTestGroup("Wait 11 blocks on every node of net 2") # new block is created from free transaction after reset of some blocks _blocks.WaitBlocks(nodes[5]["datadir"],11) _blocks.WaitBlocks(nodes[1]["datadir"],11) _blocks.WaitBlocks(nodes[2]["datadir"],11) _blocks.WaitBlocks(nodes[3]["datadir"],11) transactions.GetUnapprovedTransactionsEmpty(nodes[5]["datadir"]) #at this point branch 2 + node 6 have 11 blocks. #branch 1 has also 11 _lib.StartTestGroup("Connect all nodes") managenodes.AddNode(nodes[1]["datadir"],"localhost",'30000') #wait while all nodes know about other nodes netnodes = managenodes.WaitNodes(nodes[0]["datadir"],5) netnodes = managenodes.WaitNodes(nodes[1]["datadir"],5) netnodes = managenodes.WaitNodes(nodes[2]["datadir"],5) netnodes = managenodes.WaitNodes(nodes[3]["datadir"],5) netnodes = managenodes.WaitNodes(nodes[4]["datadir"],5) netnodes = managenodes.WaitNodes(nodes[5]["datadir"],5) nodeslist = managenodes.GetNodes(nodes[1]["datadir"]) _lib.FatalAssert(len(nodeslist) == 5,"Should be 5 nodes on the node 2") # add more transactions on the node 0 to get 12-th block balances = _transfers.GetGroupBalance(nodes[0]["datadir"]) addr1 = balances.keys()[0] addr2 = balances.keys()[2] amount = "%.8f" % round(balances[addr1][0]/14,8) # here a node can have some already prepared transactions . we will add 12. but total can be more for x in range(1, 13): tx = _transfers.Send(nodes[0]["datadir"],addr1,addr2,amount) _blocks.WaitBlocks(nodes[0]["datadir"],12) # now sync should start. branch 2 will change branch _blocks.WaitBlocks(nodes[1]["datadir"],12) _lib.StartTestGroup("Wait final blocks") # after some time new block should be created from all unconfirmed transactions _blocks.WaitBlocks(nodes[1]["datadir"],13) _blocks.WaitBlocks(nodes[0]["datadir"],13) _lib.StartTestGroup("Check blockchain after updates") blocks2_0 = _blocks.GetBlocks(nodes[0]["datadir"]) _lib.FatalAssert(len(blocks2_0) == 13,"13 block must be on node 0") blocks2_1 = _blocks.GetBlocks(nodes[1]["datadir"]) _lib.FatalAssert(len(blocks2_1) == 13,"13 block must be on node 1") _lib.StartTestGroup("Node 2 "+os.path.basename(nodes[2]["datadir"])) _blocks.WaitBlocks(nodes[2]["datadir"],13) blocks2_2 = _blocks.GetBlocks(nodes[2]["datadir"]) _lib.FatalAssert(len(blocks2_2) == 13,"13 block must be on node 2") #_lib.FatalAssert(blocks2_2[1] == blocks2_1[1],"2-nd from top blocks on 2 must be same as on 1") _lib.StartTestGroup("Node 3 "+os.path.basename(nodes[3]["datadir"])) _blocks.WaitBlocks(nodes[3]["datadir"],13) blocks2_3 = _blocks.GetBlocks(nodes[3]["datadir"]) _lib.FatalAssert(len(blocks2_3) == 13,"13 block must be on node 3") #_lib.FatalAssert(blocks2_3[1] == blocks2_1[1],"2-nd from top blocks on 3 must be same as on 1") _lib.StartTestGroup("Node 4 "+os.path.basename(nodes[4]["datadir"])) _blocks.WaitBlocks(nodes[4]["datadir"],13) blocks2_4 = _blocks.GetBlocks(nodes[4]["datadir"]) _lib.FatalAssert(len(blocks2_4) == 13,"13 block must be on node 4") #_lib.FatalAssert(blocks2_4[1] == blocks2_1[1],"2-nd from top blocks on 4 must be same as on 1") _lib.StartTestGroup("Node 5 "+os.path.basename(nodes[5]["datadir"])) _blocks.WaitBlocks(nodes[5]["datadir"],13) blocks2_5 = _blocks.GetBlocks(nodes[5]["datadir"]) _lib.FatalAssert(len(blocks2_5) == 13,"13 block must be on node 5") #_lib.FatalAssert(blocks2_5[1] == blocks2_1[1],"2-nd from top blocks on 5 must be same as on 1") _lib.StartTestGroup("Final checks") # should be empty list of transactions now # we commented because it is not always empty and it is not bad #transactions.GetUnapprovedTransactionsEmpty(nodes[1]["datadir"]) for node in nodes: startnode.StopNode(node['datadir']) datadirs[node['index']] = "" #_lib.RemoveTestFolder(datadir) _lib.EndTestGroupSuccess()
def test(testfilter): global datadir, datadir2 _lib.StartTestGroup("SQL Sync with Proxy") _lib.CleanTestFolders() datadir = _lib.CreateTestFolder('_1_') startnode.StartNodeWithoutBlockchain(datadir) address = startnode.InitBockchain(datadir) _complex.AddProxyToConfig(datadir, "localhost:40041") _complex.AddInternalKeyToConfig(datadir, address) # init internal signing startnode.StartNode(datadir, address, '30000') _lib.StartTestGroup("Do transactions") transactions.GetUnapprovedTransactionsEmpty(datadir) _sql.ExecuteSQLOnProxy( datadir, "CREATE TABLE test (a INT auto_increment PRIMARY KEY, b VARCHAR(20))") # check new table exists tables = _lib.DBGetRows(datadir, "SHOW TABLES", True) found = False for table in tables: if table[0] == "test": found = True break _lib.FatalAssert(found, "Table not found in the DB") blocks = _blocks.WaitBlocks(datadir, 2) time.sleep(2) _sql.ExecuteSQLOnProxy(datadir, "INSERT INTO test SET b='row1'") _sql.ExecuteSQLOnProxy(datadir, "INSERT INTO test SET a=2,b='row2'") time.sleep(1) _sql.ExecuteSQLOnProxy(datadir, "INSERT INTO test (b) VALUES ('row3')") rows = _lib.DBGetRows(datadir, "SELECT * FROM test", True) _lib.FatalAssert(len(rows) == 3, "Must be 3 rows in a table") blocks = _blocks.WaitBlocks(datadir, 3) time.sleep(2) # while all caches are cleaned txlist = transactions.GetUnapprovedTransactions(datadir) _lib.FatalAssert(len(txlist) == 1, "Should be 1 unapproved transaction") # update data _sql.ExecuteSQLOnProxy(datadir, " update test SET b=\"row3 updated\" where a=3") _sql.ExecuteSQLOnProxy( datadir, " update test SET b=\"row2 updated\" where a = '2'") blocks = _blocks.WaitBlocks(datadir, 4) time.sleep(1) # while all caches are cleaned rows = _lib.DBGetRows(datadir, "SELECT * FROM test", True) for row in rows: if row[0] == "1": _lib.FatalAssert(row[1] == "row1", "Row 1 value is wrong. Got: " + row[1]) if row[0] == "2": _lib.FatalAssert(row[1] == "row2 updated", "Row 2 value is wrong. Got: " + row[1]) if row[0] == "3": _lib.FatalAssert(row[1] == "row3 updated", "Row 3 value is wrong. Got: " + row[1]) _sql.ExecuteSQLOnProxyFail(datadir, "INSERT INTO test SET a=2,b='row2'") _sql.ExecuteSQLOnProxy(datadir, " DELETE from test where a=3") rows = _lib.DBGetRows(datadir, "SELECT * FROM test", True) _lib.FatalAssert(len(rows) == 2, "Must be 2 rows in a table") datadir2 = _lib.CreateTestFolder('_2_') address2 = initblockchain.ImportBockchain(datadir2, "localhost", '30000') _complex.AddProxyToConfig(datadir2, "localhost:40042") _complex.AddInternalKeyToConfig(datadir2, address2) # init internal signing startnode.StartNode(datadir2, address2, '30001', "Server 2") blocks = _blocks.WaitBlocks(datadir2, 4) # Send money to new node address txid1 = _transfers.Send(datadir, address, address2, 1) time.sleep(2) # must be 2 delete transaction should be imported rows = _lib.DBGetRows(datadir2, "SELECT * FROM test", True) _lib.FatalAssert(len(rows) == 2, "Must be 2 rows in a table") _sql.ExecuteSQLOnProxy(datadir, " DELETE from test where a=2") # send money again txid2 = _transfers.Send(datadir, address, address2, 1) # should be 1 row on first node rows = _lib.DBGetRows(datadir, "SELECT * FROM test", True) _lib.FatalAssert(len(rows) == 1, "Must be 1 rows in a table") time.sleep(1) # give time to send transaction # and 2 row on second rows = _lib.DBGetRows(datadir2, "SELECT * FROM test", True) _lib.FatalAssert(len(rows) == 1, "Must be 1 rows in a table") blocks = _blocks.WaitBlocks(datadir, 5) blocks = _blocks.WaitBlocks(datadir2, 5) time.sleep(2) # send money back txid3 = _transfers.Send(datadir2, address2, address, 2) time.sleep(1) # insert on second node. check on first _sql.ExecuteSQLOnProxy(datadir2, "INSERT INTO test SET a=2,b='row2'") time.sleep(3) # give time to send transaction rows = _lib.DBGetRows(datadir, "SELECT * FROM test", True) _lib.FatalAssert(len(rows) == 2, "Must be 2 rows in a table") # check balances bal1 = _transfers.GetBalance(datadir, address) bal2 = _transfers.GetBalance(datadir2, address2) _lib.FatalAssert(bal2[2] == -2, "Pending balance should be -2 for second address") _lib.FatalAssert(bal1[2] == 2, "Pending balance should be 2 for first address") startnode.StopNode(datadir) datadir = "" startnode.StopNode(datadir2) datadir2 = "" #_lib.RemoveTestFolder(datadir) _lib.EndTestGroupSuccess()
def test(testfilter): global datadir _lib.StartTestGroup("SQL Proxy basic") _lib.CleanTestFolders() datadir = _lib.CreateTestFolder() startnode.StartNodeWithoutBlockchain(datadir) address2 = transactions.CreateWallet(datadir) address3 = transactions.CreateWallet(datadir) _lib.CopyTestConsensusConfig(datadir,"customnumbers", address2) address = startnode.InitBockchain(datadir) _complex.AddProxyToConfig(datadir, "localhost:40041") _complex.AddInternalKeyToConfig(datadir, address3) # init internal signing startnode.StartNode(datadir, address, '30000') _lib.StartTestGroup("Do transactions") transactions.GetUnapprovedTransactionsEmpty(datadir) # address3 signs proxy transactions. it doesn't have money yet _transfers.Send(datadir,address, address3 ,5) # needs this to create table blocks = _blocks.WaitBlocks(datadir, 2) time.sleep(1) _sql.ExecuteSQLOnProxy(datadir, "CREATE TABLE test (a INT auto_increment PRIMARY KEY, b VARCHAR(20))") tables = _lib.DBGetRows(datadir,"SHOW TABLES") found = False for table in tables: if table[0] == "test": found = True break _lib.FatalAssert(found, "Table test not found in the DB") _sql.ExecuteSQLOnProxy(datadir,"INSERT INTO test SET b='row1'") blocks = _blocks.WaitBlocks(datadir, 3) time.sleep(1) # now try to create paid table. it should fail because no money _sql.ExecuteSQLOnProxyFail(datadir, "CREATE TABLE members (id INT auto_increment PRIMARY KEY, name VARCHAR(20))") # send money _transfers.Send(datadir,address, address3 ,10) # this table creation costs 10 _sql.ExecuteSQLOnProxy(datadir, "CREATE TABLE members (id INT auto_increment PRIMARY KEY, name VARCHAR(20))") tables = _lib.DBGetRows(datadir,"SHOW TABLES") found = False for table in tables: if table[0] == "members": found = True break _lib.FatalAssert(found, "Table not found in the DB") _sql.ExecuteSQLOnProxyFail(datadir, "INSERT INTO members SET name='user1'") # but should be abe to isert to free table _sql.ExecuteSQLOnProxy(datadir,"INSERT INTO test SET b='row2'") blocks = _blocks.WaitBlocks(datadir, 4) time.sleep(2) _transfers.Send(datadir,address, address3 ,1) _sql.ExecuteSQLOnProxy(datadir, "INSERT INTO members SET name='user1'") _sql.ExecuteSQLOnProxy(datadir, "INSERT INTO members SET name='user2'") _sql.ExecuteSQLOnProxyFail(datadir, "INSERT INTO members SET name='user3'") bal1 = _transfers.GetBalance(datadir, address) bal2 = _transfers.GetBalance(datadir, address2) bal3 = _transfers.GetBalance(datadir, address3) _lib.FatalAssert(bal1[1] == 45.0, "Balance of a first addres is expected to be 45") _lib.FatalAssert(bal2[1] == 15.0, "Balance of a second addres is expected to be 15") _lib.FatalAssert(bal3[1] == 0.0, "Balance of a third addres is expected to be 0") startnode.StopNode(datadir) datadir = "" #_lib.RemoveTestFolder(datadir) _lib.EndTestGroupSuccess()
def test(testfilter): global datadir, datadir2 _lib.StartTestGroup("SQL basic") _lib.CleanTestFolders() datadir = _lib.CreateTestFolder('_1_') datadir2 = _lib.CreateTestFolder('_2_') startnode.StartNodeWithoutBlockchain(datadir) address = startnode.InitBockchain(datadir) startnode.StartNode(datadir, address, '30000') _lib.StartTestGroup("Do transactions") transactions.GetUnapprovedTransactionsEmpty(datadir) tx1 = _sql.ExecuteSQL( datadir, address, "CREATE TABLE test (a INT auto_increment PRIMARY KEY, b VARCHAR(20))") # check new table exists tables = _lib.DBGetRows(datadir, "SHOW TABLES") found = False for table in tables: if table[0] == "test": found = True break _lib.FatalAssert(found, "Table not found in the DB") blocks = _blocks.WaitBlocks(datadir, 2) tx2 = _sql.ExecuteSQL(datadir, address, "INSERT INTO test SET b='row1'") tx3 = _sql.ExecuteSQL(datadir, address, "INSERT INTO test SET a=2,b='row2'") time.sleep(1) tx4 = _sql.ExecuteSQL(datadir, address, "INSERT INTO test (b) VALUES ('row3')") rows = _lib.DBGetRows(datadir, "SELECT * FROM test") _lib.FatalAssert(len(rows) == 3, "Must be 3 rows in a table") blocks = _blocks.WaitBlocks(datadir, 3) time.sleep(1) # while all caches are cleaned txlist = transactions.GetUnapprovedTransactions(datadir) _lib.FatalAssert(len(txlist) == 1, "Should be 1 unapproved transaction") # update data _sql.ExecuteSQL(datadir, address, " update test SET b=\"row3 updated\" where a=3") _sql.ExecuteSQL(datadir, address, " update test SET b=\"row2 updated\" where a = '2'") blocks = _blocks.WaitBlocks(datadir, 4) time.sleep(1) # while all caches are cleaned rows = _lib.DBGetRows(datadir, "SELECT * FROM test") for row in rows: if row[0] == "1": _lib.FatalAssert(row[1] == "row1", "Row 1 value is wrong. Got: " + row[1]) if row[0] == "2": _lib.FatalAssert(row[1] == "row2 updated", "Row 2 value is wrong. Got: " + row[1]) if row[0] == "3": _lib.FatalAssert(row[1] == "row3 updated", "Row 3 value is wrong. Got: " + row[1]) error = _sql.ExecuteSQLFailure(datadir, address, "INSERT INTO test SET a=2,b='row2'") txid = _sql.ExecuteSQL(datadir, address, " DELETE from test where a=3") rows = _lib.DBGetRows(datadir, "SELECT * FROM test") _lib.FatalAssert(len(rows) == 2, "Must be 2 rows in a table") address2 = initblockchain.ImportBockchain(datadir2, "localhost", '30000') startnode.StartNode(datadir2, address2, '30001', "Server 2") blocks = _blocks.WaitBlocks(datadir2, 4) # must be 3 rows because delete transaction was not posted to that node # but this will be changed in 3 seconds. we do this check less 3 seconds after server start rows = _lib.DBGetRows(datadir2, "SELECT * FROM test") _lib.FatalAssert(len(rows) == 3, "Must be 3 rows in a table") txid = _sql.ExecuteSQL(datadir, address, " DELETE from test where a=2") time.sleep(2) # should be 1 row on first node rows = _lib.DBGetRows(datadir, "SELECT * FROM test") _lib.FatalAssert(len(rows) == 1, "Must be 1 rows in a table") time.sleep(1) # give time to send transaction # and 2 row on second rows = _lib.DBGetRows(datadir2, "SELECT * FROM test") _lib.FatalAssert(len(rows) == 1, "Must be 1 rows in a table") startnode.StopNode(datadir) datadir = "" startnode.StopNode(datadir2) datadir2 = "" #_lib.RemoveTestFolder(datadir) _lib.EndTestGroupSuccess()
def test(testfilter): global datadir1 global datadir2 _lib.StartTestGroup( "Test data exahcnge with non-public address node and long minting") _lib.CleanTestFolders() datadir = _lib.CreateTestFolder() address1_2 = transactions.CreateWallet(datadir) address1_3 = transactions.CreateWallet(datadir) _lib.CopyTestConsensusConfig(datadir, "hardpow", address1_3) address1_1 = startnode.InitBockchain(datadir) _complex.AddProxyToConfig(datadir, "localhost:40041") _complex.AddInternalKeyToConfig(datadir, address1_2) # init internal signing startnode.StartNode(datadir, address1_1, '30000') datadir1 = datadir tx = _transfers.Send(datadir, address1_1, address1_2, 2) # node 1 should start minting now d = pullsync.StartNodeAndImport('30001', '30000', "Server 2", 0, "_2_", "xxx.com") datadir2 = d[0] address2 = d[1] # list of transactions must be emoty on 2-nd node transactions.GetUnapprovedTransactionsEmpty(datadir2) time.sleep(1) transactions.GetUnapprovedTransactionsEmpty(datadir2) time.sleep(1) transactions.GetUnapprovedTransactionsEmpty(datadir2) time.sleep(1) # wait 2-nd block blocks = _blocks.WaitBlocks(datadir2, 2) _lib.FatalAssert(len(blocks) == 2, "Should be 2 blocks on server 2") # 2 new TX to make next block tx = _transfers.Send(datadir, address1_1, address1_2, 1) tx = _transfers.Send(datadir, address1_1, address1_2, 1) time.sleep(1) tx = _transfers.Send(datadir, address1_1, address1_2, 1) # on second node only the last TX should appear soon txlist = _transfers.WaitUnapprovedTransactions(datadir2, 1, 6) # there can be 2 cases. this TX can be based on other TX which is currently under building of a block # in this case TX will fail on pull if (len(txlist) == 0): # wait while 3-rd block appears, after this TX should be added blocks = _blocks.WaitBlocks(datadir2, 3) _lib.FatalAssert(len(blocks) == 3, "Should be 3 blocks on server 2") txlist = _transfers.WaitUnapprovedTransactions(datadir2, 1, 6) _lib.FatalAssert(len(txlist) == 1, "Should be 1 transaction on server 2") _lib.FatalAssert(tx in txlist.keys(), "3-rd TX shoul be in keys") startnode.StopNode(datadir1, "Server 1") datadir1 = "" startnode.StopNode(datadir2, "Server 2") datadir2 = "" #_lib.RemoveTestFolder(datadir) _lib.EndTestGroupSuccess()
def test(testfilter): _lib.StartTestGroup("Start/Stop node") _lib.CleanTestFolders() datadir = _lib.CreateTestFolder() startnode.StartNodeWithoutBlockchain(datadir) address = startnode.InitBockchain(datadir) startnode.StartNode(datadir, address, '30000') startnode.StopNode(datadir) # create another 3 addresses address2 = CreateWallet(datadir) address3 = CreateWallet(datadir) _lib.StartTestGroup("Do transactions") GetUnapprovedTransactionsEmpty(datadir) amount1 = '1' amount2 = '2' txid1 = _transfers.Send(datadir, address, address2, amount1) txlist = GetUnapprovedTransactions(datadir) _lib.FatalAssert(len(txlist) == 1, "Should be 1 unapproved transaction") txid2 = _transfers.Send(datadir, address, address3, amount2) txlist = GetUnapprovedTransactions(datadir) _lib.FatalAssert(len(txlist) == 2, "Should be 2 unapproved transaction") if txid1 not in txlist.keys(): _lib.Fatal("Transaction 1 is not in the list of transactions") if txid2 not in txlist.keys(): _lib.Fatal("Transaction 2 is not in the list of transactions") _lib.FatalAssertFloat(amount1, txlist[txid1][3], "Amount of transaction 1 is wrong") _lib.FatalAssertFloat(amount2, txlist[txid2][3], "Amount of transaction 2 is wrong") _lib.StartTestGroup("Cancel transaction") txid3 = _transfers.Send(datadir, address, address2, float(amount1) + float(amount2)) txlist = GetUnapprovedTransactions(datadir) _lib.FatalAssert(len(txlist) == 3, "Should be 3 unapproved transaction") CancelTransaction(datadir, txid3) txlist = GetUnapprovedTransactions(datadir) _lib.FatalAssert(len(txlist) == 2, "Should be 2 unapproved transaction") #previous 2 transactions still must be in the list if txid1 not in txlist.keys(): _lib.Fatal("Transaction 1 is not in the list of transactions") if txid2 not in txlist.keys(): _lib.Fatal("Transaction 2 is not in the list of transactions") _transfers.SendTooMuch(datadir, address, address2, 15) # the account should have only 10 # cancel all transactions CancelTransaction(datadir, txid1) CancelTransaction(datadir, txid2) GetUnapprovedTransactionsEmpty(datadir) #========================================================================== # send when node server is running startnode.StartNode(datadir, address, '30000') txid1 = _transfers.Send(datadir, address, address2, amount1) txlist = GetUnapprovedTransactions(datadir) _lib.FatalAssert(len(txlist) == 1, "Should be 1 unapproved transaction") txid2 = _transfers.Send(datadir, address, address3, amount2) txlist = GetUnapprovedTransactions(datadir) _lib.FatalAssert(len(txlist) == 2, "Should be 2 unapproved transaction") if txid1 not in txlist.keys(): _lib.Fatal("Transaction 1 is not in the list of transactions") if txid2 not in txlist.keys(): _lib.Fatal("Transaction 2 is not in the list of transactions") startnode.StopNode(datadir) #_lib.RemoveTestFolder(datadir) _lib.EndTestGroupSuccess()
def test(testfilter): global datadir1 global datadir2 global datadir3 _lib.StartTestGroup("Manage nodes list") _lib.CleanTestFolders() datadir1 = _lib.CreateTestFolder('_1_') datadir2 = _lib.CreateTestFolder('_2_') _lib.StartTestGroup("Create blockchain and run node 1") r = blocksbasic.PrepareBlockchain(datadir1, '30000') address = r[0] startnode.StartNode(datadir1, address, '30000', "Server 1") address2 = initblockchain.ImportBockchain(datadir2, "localhost", '30000') #RemoveAllNodes(datadir1) nodes = GetNodes(datadir1) _lib.FatalAssert(len(nodes) == 0, "Should be 0 nodes in output") AddNode(datadir1, "localhost", '30001') nodes = GetNodes(datadir1) _lib.FatalAssert(len(nodes) == 1, "Should be 1 nodes in output") RemoveNode(datadir1, "localhost", '30001') nodes = GetNodes(datadir1) _lib.FatalAssert(len(nodes) == 0, "Should be 0 nodes in output") startnode.StartNode(datadir2, address2, '30001', "Server 2") #RemoveAllNodes(datadir2) #AddNode(datadir1, "localhost",'30001') nodes = GetNodes(datadir1) _lib.FatalAssert(len(nodes) == 1, "Should be 1 nodes in output") startnode.StopNode(datadir2, "Server 2") startnode.StartNode(datadir2, address2, '30001', "Server 2") nodes = GetNodes(datadir1) _lib.FatalAssert(len(nodes) == 1, "Should be 1 nodes in output") _lib.FatalAssert( nodes.keys()[0] == "localhost:30001" or nodes.keys()[0] == "127.0.0.1:30001", "Wrong node in the list") # check transactions work fine between nodes _transfers.Send(datadir1, address, address2, '3') txlist = transactions.GetUnapprovedTransactions(datadir1) _lib.FatalAssert(len(txlist) == 1, "Should be 1 unapproved transaction") blocks = _blocks.WaitBlocks(datadir1, 2) # send another 2 TX to make a block tx = _transfers.Send(datadir1, address, address2, '0.01') tx = _transfers.Send(datadir1, address, address2, '0.01') blocks = _blocks.WaitBlocks(datadir1, 3) time.sleep(2) tx = txid1 = _transfers.Send(datadir1, address, address2, '1') time.sleep(1) txlist = transactions.GetUnapprovedTransactions(datadir1) _lib.FatalAssert( len(txlist) == 1, "Should be 1 unapproved transaction. Got " + str(len(txlist))) time.sleep(3) # and now get transactions from second node txlist = _transfers.WaitUnapprovedTransactions(datadir2, 1) _lib.FatalAssert( len(txlist) == 1, "Should be 1 unapproved transaction on second node. Got " + str(len(txlist)) + " " + str(txlist)) #print txid1 #print txlist if txid1 not in txlist.keys(): _lib.Fatal( "Transaction 1 is not in the list of transactions on second node") # start one more node datadir3 = _lib.CreateTestFolder('_3_') address3 = initblockchain.ImportBockchain(datadir3, "localhost", '30000') startnode.StartNode(datadir3, address3, '30002', "Server 3") #RemoveAllNodes(datadir3) #AddNode(datadir3, "localhost",'30001') time.sleep(2) # wait while nodes exchange addresses nodes = GetNodes(datadir1) _lib.FatalAssert(len(nodes) == 2, "Should be 2 nodes in output of 1") nodes = GetNodes(datadir2) _lib.FatalAssert(len(nodes) == 2, "Should be 2 nodes in output of 2") nodes = GetNodes(datadir3) _lib.FatalAssert(len(nodes) == 2, "Should be 2 nodes in output of 3") txid1 = _transfers.Send(datadir1, address, address3, '4') # unapproved TX is pulled from node 1 on start txlist3 = transactions.GetUnapprovedTransactions(datadir3) _lib.FatalAssert( len(txlist3) == 1, "Should be 1 unapproved transactions on 3") time.sleep(3) # we need to give a chance to sync all txlist1 = transactions.GetUnapprovedTransactions(datadir1) txlist2 = transactions.GetUnapprovedTransactions(datadir2) _lib.FatalAssert( len(txlist1) == 2, "Should be 2 unapproved transactions on 1") _lib.FatalAssert( len(txlist2) == 2, "Should be 2 unapproved transactions on 2") if txid1 not in txlist1.keys(): _lib.Fatal( "Transaction 2 is not in the list of transactions on node 1") if txid1 not in txlist2.keys(): _lib.Fatal( "Transaction 2 is not in the list of transactions on node 2") # send one more TX. Block must be created txid3 = _transfers.Send(datadir1, address, address2, '1') blocks = _blocks.WaitBlocks(datadir3, 4) blocks = _blocks.WaitBlocks(datadir2, 4) blocks = _blocks.WaitBlocks(datadir1, 4) time.sleep(1) transactions.GetUnapprovedTransactionsEmpty(datadir1) transactions.GetUnapprovedTransactionsEmpty(datadir2) transactions.GetUnapprovedTransactionsEmpty(datadir3) # check if a block is present on all nodes. it must be 2 block on every node blockshashes = _blocks.GetBlocks(datadir1) _lib.FatalAssert( len(blockshashes) == 4, "Should be 4 blocks in blockchain on 1") blockshashes = _blocks.GetBlocks(datadir2) _lib.FatalAssert( len(blockshashes) == 4, "Should be 4 blocks in blockchain on 2") blockshashes = _blocks.GetBlocks(datadir3) _lib.FatalAssert( len(blockshashes) == 4, "Should be 4 blocks in blockchain on 3") startnode.StopNode(datadir1, "Server 1") startnode.StopNode(datadir2, "Server 2") startnode.StopNode(datadir3, "Server 3") #_lib.RemoveTestFolder(datadir1) #_lib.RemoveTestFolder(datadir2) datadir1 = "" datadir2 = "" datadir3 = "" _lib.EndTestGroupSuccess()
def test(testfilter): global datadir nodeport = '30000' _lib.StartTestGroup("Wallet Balance") _lib.CleanTestFolders() datadir_tmp = CopyBlockchainWithBlocks() balances = _transfers.GetGroupBalance(datadir_tmp) address1 = balances.keys()[0] address1_2 = balances.keys()[1] address1_3 = balances.keys()[2] balance = _transfers.GetBalance(datadir_tmp, address1) _lib.FatalAssert(balance[0] == balances[address1][0], "Balance is different from group result") # address1_3 becomes a minter. we will send money from other 2 and this will receive rewards startnode.StartNode(datadir_tmp, address1_3, nodeport) datadir = datadir_tmp blocks = _blocks.GetBlocks(datadir) blockslen = len(blocks) #create 2 wallet locations and 2 wallets in each of them walletdatadir1 = _lib.CreateTestFolder("wallet") walletdatadir2 = _lib.CreateTestFolder("wallet") addresses = _wallet.GetWallets(walletdatadir2) _lib.FatalAssert(len(addresses) == 0, "Expected 0 wallets") waddress1_1 = _wallet.CreateWallet(walletdatadir1) waddress1_2 = _wallet.CreateWallet(walletdatadir1) waddress2_1 = _wallet.CreateWallet(walletdatadir2) waddress2_2 = _wallet.CreateWallet(walletdatadir2) addresses = _wallet.GetWallets(walletdatadir2) _lib.FatalAssert(len(addresses) == 2, "Expected 2 wallets") addresses = _wallet.GetWallets(walletdatadir1) _lib.FatalAssert( len(addresses) == 2, "Expected 2 wallets for second folder") #send some funds to all that wallets amounttosend = "%.8f" % round(balances[address1][0] / 8, 8) # for next block minimum 6 TXt are required _transfers.Send(datadir, address1, waddress1_1, amounttosend) tx2_1 = _transfers.Send(datadir, address1, waddress1_2, amounttosend) _transfers.Send(datadir, address1, waddress2_1, amounttosend) _transfers.Send(datadir, address1, waddress1_1, amounttosend) _transfers.Send(datadir, address1, waddress1_1, amounttosend) _transfers.Send(datadir, address1, waddress1_1, amounttosend) # we control how blocks are created. here we wait on a block started and then send another 3 TX # we will get 2 more blocks here #blocks = _blocks.WaitBlocks(datadir, blockslen + 1) time.sleep(3) #_lib.FatalAssert(len(blocks) == blockslen + 1, "Expected "+str(blockslen + 1)+" blocks") # 7 TX are required for next block _transfers.Send(datadir, address1, waddress2_2, amounttosend) amounttosend2 = "%.8f" % round(balances[address1_2][0] / 8, 8) _transfers.Send(datadir, address1_2, waddress1_1, amounttosend2) tx2_2 = _transfers.Send(datadir, address1_2, waddress1_2, amounttosend2) _transfers.Send(datadir, address1_2, waddress1_2, amounttosend2) _transfers.Send(datadir, address1_2, waddress1_2, amounttosend2) _transfers.Send(datadir, address1_2, waddress1_2, amounttosend2) _transfers.Send(datadir, address1_2, waddress1_2, amounttosend2) # wait to complete blocks blocks = _blocks.WaitBlocks(datadir, blockslen + 2) time.sleep(5) _lib.FatalAssert( len(blocks) == blockslen + 2, "Expected " + str(blockslen + 2) + " blocks") #get balances on wallets am1 = _wallet.GetBalanceWallet(walletdatadir1, waddress1_1, "localhost", nodeport) am2 = _wallet.GetBalanceWallet(walletdatadir1, waddress1_2, "localhost", nodeport) am3 = _wallet.GetBalanceWallet(walletdatadir2, waddress2_1, "localhost", nodeport) am4 = _wallet.GetBalanceWallet(walletdatadir2, waddress2_2, "localhost", nodeport) _lib.FatalAssert( am1[1] == round(float(amounttosend) * 4 + float(amounttosend2), 8), "Expected balance is different for wallet 1_1") _lib.FatalAssert( am2[1] == round(float(amounttosend) + float(amounttosend2) * 5, 8), "Expected balance is different for wallet 1_2") _lib.FatalAssert(am3[1] == float(amounttosend), "Expected balance is different for wallet 2_1") _lib.FatalAssert(am4[1] == float(amounttosend), "Expected balance is different for wallet 2_2") #get group blances on a wallet loc balances_new = _transfers.GetGroupBalance(datadir) #get balances on node wallets balances1 = _wallet.GetGroupBalanceWallet(walletdatadir1, "localhost", nodeport) balances2 = _wallet.GetGroupBalanceWallet(walletdatadir2, "localhost", nodeport) _lib.FatalAssert( am1[1] == balances1[waddress1_1][1], "Expected balance is different from group listing for 1_1") _lib.FatalAssert( am2[1] == balances1[waddress1_2][1], "Expected balance is different from group listing for 1_2") _lib.FatalAssert( am3[1] == balances2[waddress2_1][1], "Expected balance is different from group listing for 2_1") _lib.FatalAssert( am4[1] == balances2[waddress2_2][1], "Expected balance is different from group listing for 2_2") newbalance1 = round(balances[address1][0] - float(amounttosend) * 7, 8) _lib.FatalAssert(newbalance1 == balances_new[address1][1], "Expected balance is different after spending") #send from wallets . 8 TXs _wallet.Send(walletdatadir1, waddress1_1, address1, amounttosend, "localhost", nodeport) _wallet.Send(walletdatadir1, waddress1_1, address1_2, amounttosend2, "localhost", nodeport) _wallet.Send(walletdatadir1, waddress1_2, address1, amounttosend, "localhost", nodeport) amounttosend3 = "%.8f" % round(float(amounttosend2) / 8, 8) _wallet.Send(walletdatadir1, waddress1_2, address1_2, amounttosend3, "localhost", nodeport) _wallet.Send(walletdatadir1, waddress1_2, address1_2, amounttosend3, "localhost", nodeport) _wallet.Send(walletdatadir1, waddress1_2, address1_2, amounttosend3, "localhost", nodeport) _wallet.Send(walletdatadir1, waddress1_2, address1_2, amounttosend3, "localhost", nodeport) tx2_3 = _wallet.Send(walletdatadir1, waddress1_2, address1_2, amounttosend3, "localhost", nodeport) blocks = _blocks.WaitBlocks(datadir, blockslen + 3) _lib.FatalAssert( len(blocks) == blockslen + 3, "Expected " + str(blockslen + 3) + " blocks") time.sleep(3) am1_back = _wallet.GetBalanceWallet(walletdatadir1, waddress1_1, "localhost", nodeport) am1_expected = round(am1[1] - float(amounttosend) - float(amounttosend2), 8) _lib.FatalAssert( am1_back[1] == am1_expected, "Expected balance after sending from wallet 1_1 is wrong: " + str(am1_back) + ", expected " + str(am1_expected)) am2_back = _wallet.GetBalanceWallet(walletdatadir1, waddress1_2, "localhost", nodeport) sa = '%0.8f' % (am2_back[1] + 0.00000001) _wallet.SendTooMuch(walletdatadir1, waddress1_2, address1, sa, "localhost", nodeport) _lib.StartTestGroup("Node in config") _wallet.SetNodeConfig(walletdatadir1, "localhost", nodeport) balances1 = _wallet.GetGroupBalanceWalletNoNode(walletdatadir1) am1 = _wallet.GetBalanceWalletNoNode(walletdatadir1, waddress1_1) am2 = _wallet.GetBalanceWalletNoNode(walletdatadir1, waddress1_2) _lib.FatalAssert( am1[1] == balances1[waddress1_1][1], "Expected balance is different from group listing for 1_1 " + str(am1) + " " + str(balances1)) _lib.FatalAssert( am2[1] == balances1[waddress1_2][1], "Expected balance is different from group listing for 1_2 " + str(am2) + " " + str(balances1)) tx4 = _wallet.SendNoNode(walletdatadir1, waddress1_2, address1_2, '%0.8f' % (am2[1] / 2)) _lib.StartTestGroup("Unspent transactions") unspent = _wallet.GetUnspentNoNode(walletdatadir1, waddress1_2) txunspent = [] for i in unspent: txunspent.append(i[2]) _lib.FatalAssert( tx2_3 in txunspent, "Unspent TX in not in array of expected " + str(txunspent) + " " + str(tx2_3)) unspent2 = _wallet.GetUnspent(walletdatadir2, waddress1_2, "localhost", nodeport) _lib.FatalAssert( len(unspent) == len(unspent2), "NNNumber of unspent TXs should be same. No config") txunspent = [] for i in unspent2: txunspent.append(i[2]) _lib.FatalAssert(tx2_3 in txunspent, "Unspent TX in not in array of expected. No config") _lib.StartTestGroup("Get wallet history") history = _wallet.GetHistoryNoNode(walletdatadir1, waddress1_2) _lib.FatalAssert(len(history) == 12, "Expected 3 records in a history") history = _wallet.GetHistory(walletdatadir2, waddress2_2, "localhost", nodeport) _lib.FatalAssert(len(history) == 1, "Expected 1 record in a history") _lib.StartTestGroup("Pending balance") # we cancel. we don't need it anymore. for next tests we need 0 TXs #transactions.CancelTransaction(datadir,tx4) am3 = _wallet.GetBalanceWallet(walletdatadir2, waddress2_1, "localhost", nodeport) addb1_2 = _transfers.GetBalance(datadir, address1_2) amounttosend2 = "%.8f" % round(am3[0] / 2 - 0.00000001, 8) _wallet.Send(walletdatadir2, waddress2_1, address1_2, amounttosend2, "localhost", nodeport) am3_2 = _wallet.GetBalanceWallet(walletdatadir2, waddress2_1, "localhost", nodeport) addb1_2_2 = _transfers.GetBalance(datadir, address1_2) _lib.FatalAssert(am3[1] == am3_2[1], "Approved balance should be unchanged") _lib.FatalAssert( round(am3[0] - float(amounttosend2), 8) == am3_2[0], "Total balance should be changed") _lib.FatalAssert( round(am3[2] - float(amounttosend2), 8) == am3_2[2], "Pending balance should be changed") _lib.FatalAssert( round(addb1_2_2[2] - addb1_2[2], 8) == round(am3[2] - am3_2[2], 8), "Pending difference should be same") txlist = transactions.GetUnapprovedTransactions(datadir) amounttosend2 = "%.8f" % round(am3[1] / 2, 8) _wallet.Send(walletdatadir2, waddress2_1, address1_2, amounttosend2, "localhost", nodeport) am3_3 = _wallet.GetBalanceWallet(walletdatadir2, waddress2_1, "localhost", nodeport) addb1_2_3 = _transfers.GetBalance(datadir, address1_2) _lib.FatalAssert(am3[1] == am3_3[1], "Approved balance should be unchanged") _lib.FatalAssert( math.fabs(round(am3_2[0] - float(amounttosend2), 8) - am3_3[0]) <= 0.00000001, "Total balance should be changed") _lib.FatalAssert( math.fabs(round(am3_2[2] - float(amounttosend2) - am3_3[2], 8)) <= 0.00000001, "Pending balance should be changed") _lib.FatalAssert( math.fabs( round(addb1_2_3[2] - addb1_2[2], 8) - round(am3[2] - am3_3[2], 8)) <= 0.00000002, "Pending difference should be same after 2 sends") startnode.StopNode(datadir) datadir = "" #_lib.RemoveTestFolder(datadir) _lib.EndTestGroupSuccess()
def test(testfilter): global datadir nodeport = '30000' _lib.StartTestGroup("Wallet Balance") _lib.CleanTestFolders() inf = blocksnodes.MakeBlockchainWithBlocks(nodeport) datadir_tmp = inf[0] address1 = inf[1] address1_2 = inf[2] address1_3 = inf[3] balances = _transfers.GetGroupBalance(datadir_tmp) #get balance when a node is not run bal1 = _transfers.GetBalance(datadir_tmp, address1) bal1_2 = _transfers.GetBalance(datadir_tmp, address1_2) bal1_3 = _transfers.GetBalance(datadir_tmp, address1_3) _lib.FatalAssert(bal1 == balances[address1], "Balance is different from group rec for 1") _lib.FatalAssert(bal1_2 == balances[address1_2], "Balance is different from group rec for 2") _lib.FatalAssert(bal1_3 == balances[address1_3], "Balance is different from group rec for 3") s1 = bal1 + bal1_2 + bal1_3 startnode.StartNode(datadir_tmp, address1, nodeport) datadir = datadir_tmp #get balaces on nodes wallets bal1 = _transfers.GetBalance(datadir, address1) bal1_2 = _transfers.GetBalance(datadir, address1_2) bal1_3 = _transfers.GetBalance(datadir, address1_3) s2 = bal1 + bal1_2 + bal1_3 _lib.FatalAssert(s1 == s2, "Balances shoul be equal when a node is On and Off") #get group balance on a node balances = _transfers.GetGroupBalance(datadir) _lib.FatalAssert(bal1 == balances[address1], "Balance is different from group rec for 1") _lib.FatalAssert(bal1_2 == balances[address1_2], "Balance is different from group rec for 2") _lib.FatalAssert(bal1_3 == balances[address1_3], "Balance is different from group rec for 3") #create 2 wallet locations and 2 wallets in each of them walletdatadir1 = _lib.CreateTestFolder("wallet") walletdatadir2 = _lib.CreateTestFolder("wallet") waddress1_1 = _wallet.CreateWallet(walletdatadir1) waddress1_2 = _wallet.CreateWallet(walletdatadir1) waddress1_3 = _wallet.CreateWallet(walletdatadir1) waddress2_1 = _wallet.CreateWallet(walletdatadir2) waddress2_2 = _wallet.CreateWallet(walletdatadir2) #send some funds to all that wallets amounttosend = "%.8f" % round(bal1[0] / 5, 8) amounttosend3 = "%.8f" % round(bal1_3[0] / 5, 8) _transfers.Send(datadir, address1, waddress1_1, amounttosend) _transfers.Send(datadir, address1, waddress1_2, amounttosend) _transfers.Send(datadir, address1, waddress2_1, amounttosend) _transfers.Send(datadir, address1_3, waddress1_3, amounttosend3) # we control how blocks are created. here we wait on a block started and then send another 3 TX # we will get 2 more blocks here time.sleep(1) _transfers.Send(datadir, address1, waddress2_2, amounttosend) amounttosend2 = "%.8f" % round(bal1_2[0] / 5, 8) _transfers.Send(datadir, address1_2, waddress1_1, amounttosend2) _transfers.Send(datadir, address1_2, waddress1_2, amounttosend2) _transfers.Send(datadir, address1_3, waddress1_3, amounttosend3) _transfers.Send(datadir, address1_3, waddress1_3, amounttosend3) # wait to complete blocks blocks = _blocks.WaitBlocks(datadir, 6) time.sleep(2) _lib.FatalAssert(len(blocks) == 6, "Expected 6 blocks") #get balances on wallets am1 = _wallet.GetBalanceWallet(walletdatadir1, waddress1_1, "localhost", nodeport) am2 = _wallet.GetBalanceWallet(walletdatadir1, waddress1_2, "localhost", nodeport) am3 = _wallet.GetBalanceWallet(walletdatadir2, waddress2_1, "localhost", nodeport) am4 = _wallet.GetBalanceWallet(walletdatadir2, waddress2_2, "localhost", nodeport) _lib.FatalAssert( am1[1] == round(float(amounttosend) + float(amounttosend2), 8), "Expected balance is different for wallet 1_1") _lib.FatalAssert( am2[1] == round(float(amounttosend) + float(amounttosend2), 8), "Expected balance is different for wallet 1_2") _lib.FatalAssert(am3[1] == float(amounttosend), "Expected balance is different for wallet 2_1") _lib.FatalAssert(am4[1] == float(amounttosend), "Expected balance is different for wallet 2_2") #get group blances on a wallet loc balances = _transfers.GetGroupBalance(datadir) #get balances on node wallets balances1 = _wallet.GetGroupBalanceWallet(walletdatadir1, "localhost", nodeport) balances2 = _wallet.GetGroupBalanceWallet(walletdatadir2, "localhost", nodeport) _lib.FatalAssert( am1[1] == balances1[waddress1_1][1], "Expected balance is different from group listing for 1_1") _lib.FatalAssert( am2[1] == balances1[waddress1_2][1], "Expected balance is different from group listing for 1_2") _lib.FatalAssert( am3[1] == balances2[waddress2_1][1], "Expected balance is different from group listing for 2_1") _lib.FatalAssert( am4[1] == balances2[waddress2_2][1], "Expected balance is different from group listing for 2_2") startnode.StopNode(datadir) datadir = "" #_lib.RemoveTestFolder(datadir) _lib.EndTestGroupSuccess()
def test(testfilter): global datadir1 global datadir2 global datadir3 _lib.StartTestGroup("Test data exahcnge with non-public address node") _lib.CleanTestFolders() inf = blocksnodes.MakeBlockchainWithBlocks('30000') datadir = inf[0] address1 = inf[1] address1_2 = inf[2] address1_3 = inf[3] #_node.StartNodeInteractive(datadir, address1,'30000', "Server 1") startnode.StartNode(datadir, address1, '30000', "Server 1") datadir1 = datadir managenodes.RemoveAllNodes(datadir1) d = StartNodeAndImport('30001', '30000', "Server 2", 0, "_2_", "xxx.com") datadir2 = d[0] address2 = d[1] d = StartNodeAndImport('30002', '30000', "Server 3", 0, "_3_") datadir3 = d[0] address3 = d[1] time.sleep(2) nodes = managenodes.GetNodes(datadir1) _lib.FatalAssert(len(nodes) == 2, "Should be 2 nodes on server 1") nodes = managenodes.GetNodes(datadir2) _lib.FatalAssert(len(nodes) == 2, "Should be 2 nodes on server 2") nodes = managenodes.GetNodes(datadir3) _lib.FatalAssert(len(nodes) == 2, "Should be 2 nodes on server 3") # make transaction on first node tx = _transfers.Send(datadir, address1, address2, 0.1) time.sleep(5) # this TX should appear on second node too txlist = transactions.GetUnapprovedTransactions(datadir2) _lib.FatalAssert(len(txlist) == 1, "Should be 1 unapproved transaction") tx = _transfers.Send(datadir2, address2, address1, 0.01) txlist = transactions.GetUnapprovedTransactions(datadir2) _lib.FatalAssert( len(txlist) == 2, "Should be 2 unapproved transactions on second node") time.sleep(1) txlist = transactions.GetUnapprovedTransactions(datadir) _lib.FatalAssert( len(txlist) == 2, "Should be 2 unapproved transactions on first node") # make block on a secod node tx = _transfers.Send(datadir2, address2, address1, 0.01) tx = _transfers.Send(datadir2, address2, address1, 0.01) blocks = _blocks.WaitBlocks(datadir2, 5) _lib.FatalAssert(len(blocks) == 5, "Should be 5 blocks on server 2") time.sleep(1) blocks = _blocks.WaitBlocks(datadir1, 5) _lib.FatalAssert(len(blocks) == 5, "Should be 5 blocks on server 1") blocks = _blocks.WaitBlocks(datadir3, 5) _lib.FatalAssert(len(blocks) == 5, "Should be 5 blocks on server 3") time.sleep(1) # create block on the first node and check it appears on first for x in range(5): tx = _transfers.Send(datadir, address1, address2, 0.1) blocks = _blocks.WaitBlocks(datadir1, 6) _lib.FatalAssert(len(blocks) == 6, "Should be 5 blocks on server 1") # extra transaction to pull tx = _transfers.Send(datadir, address1, address2, 0.1) time.sleep(7) # new block should be pulled blocks = _blocks.WaitBlocks(datadir2, 6) _lib.FatalAssert(len(blocks) == 6, "Should be 6 blocks on server 2") txlist = transactions.GetUnapprovedTransactions(datadir1) time.sleep(2) txlist = transactions.GetUnapprovedTransactions(datadir2) _lib.FatalAssert( len(txlist) == 1, "Should be 1 unapproved transactions on second node") startnode.StopNode(datadir1, "Server 1") datadir1 = "" startnode.StopNode(datadir2, "Server 2") datadir2 = "" startnode.StopNode(datadir3, "Server 3") datadir3 = "" #_lib.RemoveTestFolder(datadir) _lib.EndTestGroupSuccess()
def test(testfilter): global datadir _lib.StartTestGroup("Blocks making") nodeport = '30010' _lib.CleanTestFolders() datadir = _lib.CreateTestFolder() startnode.StartNodeWithoutBlockchain(datadir) address = startnode.InitBockchain(datadir) startnode.StartNode(datadir, address, nodeport) startnode.StopNode(datadir) # create another 3 addresses address2 = transactions.CreateWallet(datadir) address3 = transactions.CreateWallet(datadir) startnode.StartNode(datadir, address, nodeport) _lib.StartTestGroup("Do transactions") transactions.GetUnapprovedTransactionsEmpty(datadir) amount1 = '1' amount2 = '2' amount3 = '3' txid1 = _transfers.Send(datadir, address, address2, amount1) txlist = transactions.GetUnapprovedTransactions(datadir) _lib.FatalAssert(len(txlist) == 1, "Should be 1 unapproved transaction") #block making will be started now time.sleep(5) txid2 = _transfers.Send(datadir, address, address3, amount2) txlist = transactions.GetUnapprovedTransactions(datadir) _lib.FatalAssert(len(txlist) == 1, "Should be 1 unapproved transaction") txid3 = _transfers.Send(datadir, address, address3, amount3) # node needs some time to make a block, so transaction still will be in list of unapproved txlist = transactions.GetUnapprovedTransactions(datadir) _lib.FatalAssert(len(txlist) == 2, "Should be 2 unapproved transaction") if txid2 not in txlist.keys(): _lib.Fatal("Transaction 2 is not in the list of transactions") if txid3 not in txlist.keys(): _lib.Fatal("Transaction 3 is not in the list of transactions") _lib.FatalAssertFloat(amount2, txlist[txid2][3], "Amount of transaction 2 is wrong") _lib.FatalAssertFloat(amount3, txlist[txid3][3], "Amount of transaction 3 is wrong") time.sleep(5) transactions.GetUnapprovedTransactionsEmpty(datadir) startnode.StopNode(datadir) datadir = "" #_lib.RemoveTestFolder(datadir) _lib.EndTestGroupSuccess()
def test(testfilter): global datadir _lib.StartTestGroup("SQL basic") _lib.CleanTestFolders() datadir = _lib.CreateTestFolder() startnode.StartNodeWithoutBlockchain(datadir) address = startnode.InitBockchain(datadir) startnode.StartNode(datadir, address, '30000') _lib.StartTestGroup("Do transactions") transactions.GetUnapprovedTransactionsEmpty(datadir) tx1 = _sql.ExecuteSQL( datadir, address, "CREATE TABLE test (a INT auto_increment PRIMARY KEY, b VARCHAR(20))") # check new table exists tables = _lib.DBGetRows(datadir, "SHOW TABLES") found = False for table in tables: if table[0] == "test": found = True break _lib.FatalAssert(found, "Table not found in the DB") blocks = _blocks.WaitBlocks(datadir, 2) time.sleep(1) tx2 = _sql.ExecuteSQL(datadir, address, "INSERT INTO test SET b='row1'") tx3 = _sql.ExecuteSQL(datadir, address, "INSERT INTO test SET a=2,b='row2'") time.sleep(1) tx4 = _sql.ExecuteSQL(datadir, address, "INSERT INTO test (b) VALUES ('row3')") rows = _lib.DBGetRows(datadir, "SELECT * FROM test") _lib.FatalAssert(len(rows) == 3, "Must be 3 rows in a table") blocks = _blocks.WaitBlocks(datadir, 3) time.sleep(1) # while all caches are cleaned txlist = transactions.GetUnapprovedTransactions(datadir) _lib.FatalAssert(len(txlist) == 1, "Should be 1 unapproved transaction") # update data _sql.ExecuteSQL(datadir, address, " update test SET b=\"row3 updated\" where a=3") _sql.ExecuteSQL(datadir, address, " update test SET b=\"row2 updated\" where a = '2'") blocks = _blocks.WaitBlocks(datadir, 4) time.sleep(1) # while all caches are cleaned rows = _lib.DBGetRows(datadir, "SELECT * FROM test") for row in rows: if row[0] == "1": _lib.FatalAssert(row[1] == "row1", "Row 1 value is wrong. Got: " + row[1]) if row[0] == "2": _lib.FatalAssert(row[1] == "row2 updated", "Row 2 value is wrong. Got: " + row[1]) if row[0] == "3": _lib.FatalAssert(row[1] == "row3 updated", "Row 3 value is wrong. Got: " + row[1]) error = _sql.ExecuteSQLFailure(datadir, address, "INSERT INTO test SET a=2,b='row2'") txid = _sql.ExecuteSQL(datadir, address, " DELETE from test where a=3") rows = _lib.DBGetRows(datadir, "SELECT * FROM test") _lib.FatalAssert(len(rows) == 2, "Must be 2 rows in a table") #cancel transaction. rollback should affect transactions.CancelTransaction(datadir, txid) # should be 0 unapproved transactions transactions.GetUnapprovedTransactionsEmpty(datadir) # should be 3 rows again rows = _lib.DBGetRows(datadir, "SELECT * FROM test") _lib.FatalAssert(len(rows) == 3, "Must be 3 rows in a table") startnode.StopNode(datadir) datadir = "" #_lib.RemoveTestFolder(datadir) _lib.EndTestGroupSuccess()
def test(testfilter): global datadir _lib.StartTestGroup("Init Blockchain on non empty DB. Add 4000 records") _lib.CleanTestFolders() datadir = _lib.CreateTestFolder() address2 = transactions.CreateWallet(datadir) address3 = transactions.CreateWallet(datadir) _lib.CopyTestConsensusConfig(datadir, "disabledcreate", address2) # add some data to the DB _lib.DBExecute( datadir, "create table test (a int unsigned auto_increment primary key, b varchar(10))" ) # add 2k records sys.stdout.write("\t\t") for x in range(600): _lib.DBExecute(datadir, "insert into test SET b='row" + str(x) + "'") if x % 20 == 0: sys.stdout.write('.') if x % 200 == 0 and x > 0: sys.stdout.write(str(x)) print("") sys.stdout.write("\t\t") _lib.DBExecute( datadir, "create table members (a int unsigned auto_increment primary key, b varchar(10))" ) for x in range(600): _lib.DBExecute(datadir, "insert into members SET b='row" + str(x) + "'") if x % 20 == 0: sys.stdout.write('.') if x % 200 == 0 and x > 0: sys.stdout.write(str(x)) print("") _lib.StartTestGroup("Data added. Init BC") address = startnode.InitBockchain(datadir) _complex.AddProxyToConfig(datadir, "localhost:40041") _complex.AddInternalKeyToConfig(datadir, address3) # init internal signing startnode.StartNode(datadir, address, '30000') _lib.StartTestGroup("Do transactions") transactions.GetUnapprovedTransactionsEmpty(datadir) blocks = _blocks.GetBlocks(datadir) #print(blocks) #_lib.FatalAssert(len(blocks) == 4,"Should be 4 blocks in blockchain") _lib.FatalAssert(len(blocks) == 3, "Should be 3 blocks in blockchain") startnode.StopNode(datadir) datadir = "" #_lib.RemoveTestFolder(datadir) _lib.EndTestGroupSuccess()