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()
