def CopyBlockchainWithBlocks(): datadir = _lib.CreateTestFolder() _lib.CopyTestData(datadir, "bcwith4blocks") return datadir
def test(testfilter): _lib.StartTestGroup("SQL basic") _lib.CleanTestFolders() datadir = _lib.CreateTestFolder() address = startnode.InitBockchain(datadir) _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") # now add data and make a block _sql.ExecuteSQL(datadir,address,"INSERT INTO test SET b='row1'") _sql.ExecuteSQL(datadir,address,"INSERT INTO test SET b='row2', a=2") _sql.ExecuteSQL(datadir,address,"INSERT INTO test (b) values ('row3')") _sql.ExecuteSQL(datadir,address,"INSERT INTO test (a, b) values (4, 'row4')") _sql.ExecuteSQL(datadir,address,"INSERT INTO test (a, b) values (8, 'row5')") _sql.ExecuteSQL(datadir,address,"UPDATE test SET b='row1_u1' where a=1") _sql.ExecuteSQL(datadir,address,"UPDATE test SET b='row2_u1' where a = '2'") _sql.ExecuteSQL(datadir,address,"UPDATE test SET b='row1_u2' where a= 1") _sql.ExecuteSQL(datadir,address,"delete from test where a=3") rows = _lib.DBGetRows(datadir,"SELECT * FROM test") _lib.FatalAssert(len(rows) == 4, "Must be 4 rows in a table") blockchash = _blocks.MintBlock(datadir,address) transactions.GetUnapprovedTransactionsEmpty(datadir) # test execution when transactions are already in a block _sql.ExecuteSQLFailure(datadir,address,"INSERT INTO test SET b='row2', a=2") _sql.ExecuteSQLFailure(datadir,address,"delete from test where a=3") _sql.ExecuteSQLFailure(datadir,address,"UPDATE test SET b='upd' where a= 3") _sql.ExecuteSQLFailure(datadir,address,"UPDATE test SET b='upd2', a=3 where a= 2")# we don't allow to change key value _sql.ExecuteSQL(datadir,address,"INSERT INTO test (a, b) values (6, 'row6')") _sql.ExecuteSQL(datadir,address,"UPDATE test SET b='row8_u1' where a=8") _sql.ExecuteSQL(datadir,address,"delete from test where a=2") _sql.ExecuteSQL(datadir,address,"UPDATE test SET b='row8_u2' where a=8") _sql.ExecuteSQL(datadir,address,"UPDATE test SET b='row6_u1' where a=6") #_lib.RemoveTestFolder(datadir) _lib.EndTestGroupSuccess()
def MakeBlockchainWithBlocks(port): datadir = _lib.CreateTestFolder("_1_") r = blocksbasic.PrepareBlockchain(datadir, port) address = r[0] # create another 3 addresses address2 = transactions.CreateWallet(datadir) address3 = transactions.CreateWallet(datadir) _lib.StartTestGroup("Do _transfers") 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") txid2 = _transfers.Send(datadir, address, address3, amount2) txlist = transactions.GetUnapprovedTransactions(datadir) _lib.FatalAssert(len(txlist) == 2, "Should be 2 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) == 3, "Should be 3 unapproved transaction") txid4 = _transfers.Send(datadir, address3, address2, amount1) # 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) == 4, "Should be 4 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") if txid3 not in txlist.keys(): _lib.Fatal("Transaction 3 is not in the list of transactions") if txid4 not in txlist.keys(): _lib.Fatal("Transaction 4 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.FatalAssertFloat(amount3, txlist[txid3][3], "Amount of transaction 3 is wrong") _lib.FatalAssertFloat(amount1, txlist[txid4][3], "Amount of transaction 4 is wrong") blockchash = _blocks.MintBlock(datadir, address) transactions.GetUnapprovedTransactionsEmpty(datadir) blockshashes = _blocks.GetBlocks(datadir) _lib.FatalAssert( len(blockshashes) == 2, "Should be 2 blocks in blockchain") _lib.StartTestGroup("Send 3 transactions") microamount = 0.01 txid1 = _transfers.Send(datadir, address, address2, microamount) txid2 = _transfers.Send(datadir, address2, address3, microamount) txid3 = _transfers.Send(datadir, address3, address, microamount) txlist = transactions.GetUnapprovedTransactions(datadir) _lib.FatalAssert(len(txlist) == 3, "Should be 3 unapproved transaction") if txid1 not in txlist.keys(): _lib.Fatal( "Transaction 1 is not in the list of transactions after iteration " + str(i)) if txid2 not in txlist.keys(): _lib.Fatal( "Transaction 2 is not in the list of transactions after iteration " + str(i)) if txid3 not in txlist.keys(): _lib.Fatal( "Transaction 3 is not in the list of transactions after iteration " + str(i)) blockchash = _blocks.MintBlock(datadir, address) transactions.GetUnapprovedTransactionsEmpty(datadir) blockshashes = _blocks.GetBlocks(datadir) _lib.FatalAssert( len(blockshashes) == 3, "Should be 3 blocks in blockchain") _lib.StartTestGroup("Send 3 transactions. Random value") microamountmax = 0.01 microamountmin = 0.0095 a1 = round(random.uniform(microamountmin, microamountmax), 8) a2 = round(random.uniform(microamountmin, microamountmax), 8) a3 = round(random.uniform(microamountmin, microamountmax), 8) txid1 = _transfers.Send(datadir, address, address2, a1) txid2 = _transfers.Send(datadir, address2, address3, a2) txid3 = _transfers.Send(datadir, address3, address, a3) txlist = transactions.GetUnapprovedTransactions(datadir) _lib.FatalAssert(len(txlist) == 3, "Should be 3 unapproved transaction") if txid1 not in txlist.keys(): _lib.Fatal( "Transaction 1 is not in the list of transactions after iteration " + str(i)) if txid2 not in txlist.keys(): _lib.Fatal( "Transaction 2 is not in the list of transactions after iteration " + str(i)) if txid3 not in txlist.keys(): _lib.Fatal( "Transaction 3 is not in the list of transactions after iteration " + str(i)) blockchash = _blocks.MintBlock(datadir, address) transactions.GetUnapprovedTransactionsEmpty(datadir) blockshashes = _blocks.GetBlocks(datadir) _lib.FatalAssert( len(blockshashes) == 4, "Should be 4 blocks in blockchain") return [datadir, address, address2, address3]
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): _lib.StartTestGroup("Blocks making") _lib.CleanTestFolders() datadir = _lib.CreateTestFolder() r = PrepareBlockchain(datadir, '30000') address = r[0] # create another 3 addresses address2 = transactions.CreateWallet(datadir) address3 = transactions.CreateWallet(datadir) _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") time.sleep(1) txid2 = _transfers.Send(datadir, address, address3, amount2) txlist = transactions.GetUnapprovedTransactions(datadir) _lib.FatalAssert(len(txlist) == 2, "Should be 2 unapproved transaction") time.sleep(1) 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) == 3, "Should be 3 unapproved transaction") time.sleep(1) txid4 = _transfers.Send(datadir, address3, address2, amount1) # 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) == 4, "Should be 4 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") if txid3 not in txlist.keys(): _lib.Fatal("Transaction 3 is not in the list of transactions") if txid4 not in txlist.keys(): _lib.Fatal("Transaction 4 is not in the list of transactions") _lib.FatalAssertFloat(amount1, txlist[txid1][2], "Amount of transaction 1 is wrong") _lib.FatalAssertFloat(amount2, txlist[txid2][2], "Amount of transaction 2 is wrong") _lib.FatalAssertFloat(amount3, txlist[txid3][2], "Amount of transaction 3 is wrong") _lib.FatalAssertFloat(amount1, txlist[txid4][2], "Amount of transaction 4 is wrong") blockchash = MintBlock(datadir, address) transactions.GetUnapprovedTransactionsEmpty(datadir) blockshashes = _blocks.GetBlocks(datadir) _lib.FatalAssert( len(blockshashes) == 2, "Should be 2 blocks in blockchain") _lib.StartTestGroup("Send 30 transactions") microamount = 0.01 # send many transactions for i in range(1, 10): _lib.StartTest("Iteration " + str(i)) txid1 = _transfers.Send(datadir, address, address2, microamount) txid2 = _transfers.Send(datadir, address2, address3, microamount) txid3 = _transfers.Send(datadir, address3, address, microamount) txlist = transactions.GetUnapprovedTransactions(datadir) _lib.FatalAssert( len(txlist) == i * 3, "Should be " + str(i * 3) + " unapproved transaction") if txid1 not in txlist.keys(): _lib.Fatal( "Transaction 1 is not in the list of transactions after iteration " + str(i)) if txid2 not in txlist.keys(): _lib.Fatal( "Transaction 2 is not in the list of transactions after iteration " + str(i)) if txid3 not in txlist.keys(): _lib.Fatal( "Transaction 3 is not in the list of transactions after iteration " + str(i)) time.sleep(1) blockchash = MintBlock(datadir, address) transactions.GetUnapprovedTransactionsEmpty(datadir) blockshashes = _blocks.GetBlocks(datadir) _lib.FatalAssert( len(blockshashes) == 3, "Should be 3 blocks in blockchain") _lib.StartTestGroup("Send 30 transactions. Random value") microamountmax = 0.01 microamountmin = 0.0095 # send many transactions for i in range(1, 11): _lib.StartTest("Iteration " + str(i)) a1 = random.uniform(microamountmin, microamountmax) a2 = random.uniform(microamountmin, microamountmax) a3 = random.uniform(microamountmin, microamountmax) txid1 = _transfers.Send(datadir, address, address2, a1) txid2 = _transfers.Send(datadir, address2, address3, a2) txid3 = _transfers.Send(datadir, address3, address, a3) txlist = transactions.GetUnapprovedTransactions(datadir) _lib.FatalAssert( len(txlist) == i * 3, "Should be " + str(i * 3) + " unapproved transaction") if txid1 not in txlist.keys(): _lib.Fatal( "Transaction 1 is not in the list of transactions after iteration " + str(i)) if txid2 not in txlist.keys(): _lib.Fatal( "Transaction 2 is not in the list of transactions after iteration " + str(i)) if txid3 not in txlist.keys(): _lib.Fatal( "Transaction 3 is not in the list of transactions after iteration " + str(i)) time.sleep(1) blockchash = MintBlock(datadir, address) transactions.GetUnapprovedTransactionsEmpty(datadir) blockshashes = _blocks.GetBlocks(datadir) _lib.FatalAssert( len(blockshashes) == 4, "Should be 4 blocks in blockchain") #_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): _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][2], "Amount of transaction 1 is wrong") _lib.FatalAssertFloat(amount2, txlist[txid2][2], "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 _transfers.Send(datadir1, address, address2, '0.01') _transfers.Send(datadir1, address, address2, '0.01') blocks = _blocks.WaitBlocks(datadir1, 3) txid1 = _transfers.Send(datadir1, address, address2, '1') txlist = transactions.GetUnapprovedTransactions(datadir1) _lib.FatalAssert(len(txlist) == 1, "Should be 1 unapproved transaction") # 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") #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') transactions.GetUnapprovedTransactionsEmpty(datadir3) txlist1 = transactions.GetUnapprovedTransactions(datadir1) time.sleep(3) # we need to give a chance to sync all 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') time.sleep(5) # wait while a block is minted and posted to other nodes 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,datadir2 _lib.StartTestGroup("SQL Sync with Proxy") _lib.CleanTestFolders() datadir = _lib.CreateTestFolder('_1_') datadir2 = _lib.CreateTestFolder('_2_') 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(1) _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(1)# 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") 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) # must be 3 rows because delete transaction was not posted to that node rows = _lib.DBGetRows(datadir2,"SELECT * FROM test",True) _lib.FatalAssert(len(rows) == 3, "Must be 3 rows in a table") _sql.ExecuteSQLOnProxy(datadir," DELETE from test where a=2") # 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) == 2, "Must be 2 rows in a table") # insert on second node. check on first _sql.ExecuteSQLOnProxy(datadir2,"INSERT INTO test SET a=2,b='row2'") time.sleep(1)# 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") startnode.StopNode(datadir) datadir = "" startnode.StopNode(datadir2) datadir2 = "" #_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 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 Make5BlocksBC(): datadir = _lib.CreateTestFolder() _lib.StartTest("Create first address") res = _lib.ExecuteNode(['createwallet','-configdir',datadir]) _lib.FatalAssertSubstr(res,"Your new address","Address creation returned wrong result") # get address from this response match = re.search( r'.+: (.+)', res) if not match: _lib.Fatal("Address can not be found in "+res) address = match.group(1) dbconfig = _lib.GetDBCredentials(datadir) _lib.StartTest("Create blockchain") res = _lib.ExecuteNode(['initblockchain','-configdir',datadir, '-minter', address, '-mysqlhost', dbconfig['host'], '-mysqlport', dbconfig['port'], '-mysqluser', dbconfig['user'], '-mysqlpass', dbconfig['password'], '-mysqldb', dbconfig['database'], '-logs','trace']) _lib.FatalAssertSubstr(res,"Done!","Blockchain init failed") # create another 3 addresses address2 = transactions.CreateWallet(datadir) address3 = transactions.CreateWallet(datadir) _lib.StartTestGroup("Do transfers") transactions.GetUnapprovedTransactionsEmpty(datadir) amount1 = '1' amount2 = '2' amount3 = '3' _lib.StartTestGroup("Send 1 transaction") # one TX in first block txid1 = _transfers.Send(datadir,address,address2,amount1) txlist = transactions.GetUnapprovedTransactions(datadir) _lib.FatalAssert(len(txlist) == 1,"Should be 1 unapproved transaction") blockchash = _blocks.MintBlock(datadir,address) blockshashes = _blocks.GetBlocks(datadir) _lib.FatalAssert(len(blockshashes) == 2,"Should be 2 blocks in blockchain") _lib.StartTestGroup("Send 2 transactions") # 2 TX in second block 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) txlist = transactions.GetUnapprovedTransactions(datadir) _lib.FatalAssert(len(txlist) == 2,"Should be 2 unapproved transaction") blockchash = _blocks.MintBlock(datadir,address) blockshashes = _blocks.GetBlocks(datadir) _lib.FatalAssert(len(blockshashes) == 3,"Should be 3 blocks in blockchain") _lib.StartTestGroup("Send 3 transactions") microamount = 0.01 txid1 = _transfers.Send(datadir,address,address2,microamount) txid2 = _transfers.Send(datadir,address2,address3,microamount) txid3 = _transfers.Send(datadir,address3,address,microamount) txlist = transactions.GetUnapprovedTransactions(datadir) _lib.FatalAssert(len(txlist) == 3,"Should be 3 unapproved transaction") blockchash = _blocks.MintBlock(datadir,address) transactions.GetUnapprovedTransactionsEmpty(datadir) blockshashes = _blocks.GetBlocks(datadir) _lib.FatalAssert(len(blockshashes) == 4,"Should be 4 blocks in blockchain") _lib.StartTestGroup("Send 4 transactions. Random value") microamountmax = 0.01 microamountmin = 0.0095 a1 = round(random.uniform(microamountmin, microamountmax),8) a2 = round(random.uniform(microamountmin, microamountmax),8) a3 = round(random.uniform(microamountmin, microamountmax),8) a4 = round(random.uniform(microamountmin, microamountmax),8) txid1 = _transfers.Send(datadir,address,address2,a1) txid2 = _transfers.Send(datadir,address2,address3,a2) txid3 = _transfers.Send(datadir,address3,address,a3) txid3 = _transfers.Send(datadir,address3,address,a4) txlist = transactions.GetUnapprovedTransactions(datadir) _lib.FatalAssert(len(txlist) == 4,"Should be 4 unapproved transaction") if txid1 not in txlist.keys(): _lib.Fatal("Transaction 1 is not in the list of transactions after iteration "+str(i)) if txid2 not in txlist.keys(): _lib.Fatal("Transaction 2 is not in the list of transactions after iteration "+str(i)) if txid3 not in txlist.keys(): _lib.Fatal("Transaction 3 is not in the list of transactions after iteration "+str(i)) blockchash = _blocks.MintBlock(datadir,address) transactions.GetUnapprovedTransactionsEmpty(datadir) blockshashes = _blocks.GetBlocks(datadir) _lib.FatalAssert(len(blockshashes) == 5,"Should be 5 blocks in blockchain") _lib.StartTestGroup("Send 5 transactions. Random value") txid1 = _transfers.Send(datadir,address,address2,a4) txid2 = _transfers.Send(datadir,address2,address3,a3) txid3 = _transfers.Send(datadir,address3,address,a2) txid3 = _transfers.Send(datadir,address3,address,a1) txid1 = _transfers.Send(datadir,address,address2,a1) blockchash = _blocks.MintBlock(datadir,address) transactions.GetUnapprovedTransactionsEmpty(datadir) blockshashes = _blocks.GetBlocks(datadir) _lib.FatalAssert(len(blockshashes) == 6,"Should be 6 blocks in blockchain") dstdir = _lib.getCurrentDir()+"/datafortests/bcwith4blocks/" copyfile(datadir+"/wallet.dat", dstdir+"wallet.t") DumpBCDB(datadir, dstdir+"db.sql") #copyfile(datadir+"/nodeslist.db", dstdir+"nodeslist.t") #copyfile(datadir+"/blockchain.db", dstdir+"blockchain.t") return [datadir, address, address2, address3]
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 datadir _lib.StartTestGroup("SQL Proxy basic") _lib.CleanTestFolders() datadir = _lib.CreateTestFolder() pub_key, pri_key = _lib.MakeWallet() startnode.StartNodeWithoutBlockchain(datadir) address = startnode.InitBockchain(datadir) _complex.AddProxyToConfig(datadir, "localhost:40041") startnode.StartNode(datadir, address, '30000') _lib.StartTestGroup("Do transactions") transactions.GetUnapprovedTransactionsEmpty(datadir) _sql.ExecuteSQLOnProxySign( datadir, "CREATE TABLE test (a INT auto_increment PRIMARY KEY, b VARCHAR(20))", pub_key, pri_key) # 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) _sql.ExecuteSQLOnProxySign(datadir, "INSERT INTO test SET b='row1'", pub_key, pri_key) _sql.ExecuteSQLOnProxySign(datadir, "INSERT INTO test SET a=2,b='row2'", pub_key, pri_key) time.sleep(1) _sql.ExecuteSQLOnProxySign(datadir, "INSERT INTO test (b) VALUES ('row3')", pub_key, pri_key) 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") for row in rows: if row[0] == "1": _lib.FatalAssert(row[1] == "row1", "Wrong value for row1") if row[0] == "2": _lib.FatalAssert(row[1] == "row2", "Wrong value for row2") if row[0] == "3": _lib.FatalAssert(row[1] == "row3", "Wrong value for row3") # update data _sql.ExecuteSQLOnProxySign( datadir, " update test SET b=\"row3 updated\" where a=3", pub_key, pri_key) _sql.ExecuteSQLOnProxySign( datadir, " update test SET b=\"row2 updated\" where a = '2'", pub_key, pri_key) blocks = _blocks.WaitBlocks(datadir, 4) time.sleep(2) # 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.ExecuteSQLOnProxySignFail(datadir, "INSERT INTO test SET a=2,b='row2'", pub_key, pri_key) _sql.ExecuteSQLOnProxySign(datadir, " DELETE from test where a=3", pub_key, pri_key) rows = _lib.DBGetRows(datadir, "SELECT * FROM test", True) _lib.FatalAssert(len(rows) == 2, "Must be 2 rows in a table") txlist = transactions.GetUnapprovedTransactions(datadir) #cancel transaction. rollback should affect transactions.CancelTransaction(datadir, txlist.keys()[0]) # should be 0 unapproved transactions transactions.GetUnapprovedTransactionsEmpty(datadir) # should be 3 rows again rows = _lib.DBGetRows(datadir, "SELECT * FROM test", True) _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") _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 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("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()