def test(testfilter):
global datadir, datadir2
_lib.StartTestGroup("SQL Sync with Proxy")
_lib.CleanTestFolders()
datadir = _lib.CreateTestFolder('_1_')
startnode.StartNodeWithoutBlockchain(datadir)
address = startnode.InitBockchain(datadir)
_complex.AddProxyToConfig(datadir, "localhost:40041")
_complex.AddInternalKeyToConfig(datadir, address) # init internal signing
startnode.StartNode(datadir, address, '30000')
_lib.StartTestGroup("Do transactions")
transactions.GetUnapprovedTransactionsEmpty(datadir)
_sql.ExecuteSQLOnProxy(
datadir,
"CREATE TABLE test (a INT auto_increment PRIMARY KEY, b VARCHAR(20))")
# check new table exists
tables = _lib.DBGetRows(datadir, "SHOW TABLES", True)
found = False
for table in tables:
if table[0] == "test":
found = True
break
_lib.FatalAssert(found, "Table not found in the DB")
blocks = _blocks.WaitBlocks(datadir, 2)
time.sleep(2)
_sql.ExecuteSQLOnProxy(datadir, "INSERT INTO test SET b='row1'")
_sql.ExecuteSQLOnProxy(datadir, "INSERT INTO test SET a=2,b='row2'")
time.sleep(1)
_sql.ExecuteSQLOnProxy(datadir, "INSERT INTO test (b) VALUES ('row3')")
rows = _lib.DBGetRows(datadir, "SELECT * FROM test", True)
_lib.FatalAssert(len(rows) == 3, "Must be 3 rows in a table")
blocks = _blocks.WaitBlocks(datadir, 3)
time.sleep(2) # while all caches are cleaned
txlist = transactions.GetUnapprovedTransactions(datadir)
_lib.FatalAssert(len(txlist) == 1, "Should be 1 unapproved transaction")
# update data
_sql.ExecuteSQLOnProxy(datadir,
" update test SET b=\"row3 updated\" where a=3")
_sql.ExecuteSQLOnProxy(
datadir, " update test SET b=\"row2 updated\" where a = '2'")
blocks = _blocks.WaitBlocks(datadir, 4)
time.sleep(1) # while all caches are cleaned
rows = _lib.DBGetRows(datadir, "SELECT * FROM test", True)
for row in rows:
if row[0] == "1":
_lib.FatalAssert(row[1] == "row1",
"Row 1 value is wrong. Got: " + row[1])
if row[0] == "2":
_lib.FatalAssert(row[1] == "row2 updated",
"Row 2 value is wrong. Got: " + row[1])
if row[0] == "3":
_lib.FatalAssert(row[1] == "row3 updated",
"Row 3 value is wrong. Got: " + row[1])
_sql.ExecuteSQLOnProxyFail(datadir, "INSERT INTO test SET a=2,b='row2'")
_sql.ExecuteSQLOnProxy(datadir, " DELETE from test where a=3")
rows = _lib.DBGetRows(datadir, "SELECT * FROM test", True)
_lib.FatalAssert(len(rows) == 2, "Must be 2 rows in a table")
datadir2 = _lib.CreateTestFolder('_2_')
address2 = initblockchain.ImportBockchain(datadir2, "localhost", '30000')
_complex.AddProxyToConfig(datadir2, "localhost:40042")
_complex.AddInternalKeyToConfig(datadir2,
address2) # init internal signing
startnode.StartNode(datadir2, address2, '30001', "Server 2")
blocks = _blocks.WaitBlocks(datadir2, 4)
# Send money to new node address
txid1 = _transfers.Send(datadir, address, address2, 1)
time.sleep(2)
# must be 2 delete transaction should be imported
rows = _lib.DBGetRows(datadir2, "SELECT * FROM test", True)
_lib.FatalAssert(len(rows) == 2, "Must be 2 rows in a table")
_sql.ExecuteSQLOnProxy(datadir, " DELETE from test where a=2")
# send money again
txid2 = _transfers.Send(datadir, address, address2, 1)
# should be 1 row on first node
rows = _lib.DBGetRows(datadir, "SELECT * FROM test", True)
_lib.FatalAssert(len(rows) == 1, "Must be 1 rows in a table")
time.sleep(1) # give time to send transaction
# and 2 row on second
rows = _lib.DBGetRows(datadir2, "SELECT * FROM test", True)
_lib.FatalAssert(len(rows) == 1, "Must be 1 rows in a table")
blocks = _blocks.WaitBlocks(datadir, 5)
blocks = _blocks.WaitBlocks(datadir2, 5)
time.sleep(2)
# send money back
txid3 = _transfers.Send(datadir2, address2, address, 2)
time.sleep(1)
# insert on second node. check on first
_sql.ExecuteSQLOnProxy(datadir2, "INSERT INTO test SET a=2,b='row2'")
time.sleep(3) # give time to send transaction
rows = _lib.DBGetRows(datadir, "SELECT * FROM test", True)
_lib.FatalAssert(len(rows) == 2, "Must be 2 rows in a table")
# check balances
bal1 = _transfers.GetBalance(datadir, address)
bal2 = _transfers.GetBalance(datadir2, address2)
_lib.FatalAssert(bal2[2] == -2,
"Pending balance should be -2 for second address")
_lib.FatalAssert(bal1[2] == 2,
"Pending balance should be 2 for first address")
startnode.StopNode(datadir)
datadir = ""
startnode.StopNode(datadir2)
datadir2 = ""
#_lib.RemoveTestFolder(datadir)
_lib.EndTestGroupSuccess()
def test(testfilter):
global datadir, datadir2
_lib.StartTestGroup("SQL Sync with Proxy. care offline")
_lib.CleanTestFolders()
datadir = _lib.CreateTestFolder('_1_')
startnode.StartNodeWithoutBlockchain(datadir)
address = startnode.InitBockchain(datadir)
_complex.AddProxyToConfig(datadir, "localhost:40041")
_complex.AddInternalKeyToConfig(datadir, address) # init internal signing
startnode.StartNode(datadir, address, '30000')
_lib.StartTestGroup("Do initial transactions")
transactions.GetUnapprovedTransactionsEmpty(datadir)
_sql.ExecuteSQLOnProxy(
datadir,
"CREATE TABLE test (a INT auto_increment PRIMARY KEY, b VARCHAR(20))")
# check new table exists
tables = _lib.DBGetRows(datadir, "SHOW TABLES", True)
found = False
for table in tables:
if table[0] == "test":
found = True
break
_lib.FatalAssert(found, "Table not found in the DB")
blocks = _blocks.WaitBlocks(datadir, 2)
time.sleep(1)
_sql.ExecuteSQLOnProxy(datadir, "INSERT INTO test SET b='row1'")
datadir2 = _lib.CreateTestFolder('_2_')
address2 = initblockchain.ImportBockchain(datadir2, "localhost", '30000')
_complex.AddProxyToConfig(datadir2, "localhost:40042")
_complex.AddInternalKeyToConfig(datadir2,
address2) # init internal signing
startnode.StartNode(datadir2, address2, '30001', "Server 2")
blocks = _blocks.WaitBlocks(datadir2, 2)
_sql.ExecuteSQLOnProxy(datadir2, "INSERT INTO test SET b='row1.2'")
# must be 1 row , because the first row from the first node is not yet in a block and is not synced
rows = _lib.DBGetRows(datadir2, "SELECT * FROM test", True)
_lib.FatalAssert(len(rows) == 1, "Must be 1 row in a table on node 2")
_sql.ExecuteSQLOnProxy(datadir, "INSERT INTO test SET b='row2'")
# should be 1 row on first node
rows = _lib.DBGetRows(datadir, "SELECT * FROM test", True)
_lib.FatalAssert(len(rows) == 2, "Must be 2 rows in a table on node 1")
# wait 3-rd block
blocks = _blocks.WaitBlocks(datadir, 3)
time.sleep(1) # give time to send transaction
# wait 3-rd block on a second node
blocks = _blocks.WaitBlocks(datadir2, 3)
time.sleep(1)
# and 2 row on second
rows2 = _lib.DBGetRows(datadir2, "SELECT * FROM test ORDER BY a", True)
_lib.FatalAssert(len(rows2) == 2, "Must be 2 rows in a table")
rows = _lib.DBGetRows(datadir, "SELECT * FROM test ORDER BY a", True)
_lib.FatalAssert(len(rows) == 2, "Must be 2 rows in a table")
_lib.FatalAssert(
set(rows) == set(rows2),
"COntents of tables on both nodes must be same")
_lib.StartTestGroup("Check cancel of following transactions")
# temporary stop second node
startnode.StopNode(datadir2)
_sql.ExecuteSQLOnProxy(datadir, "INSERT INTO test SET b='row3'")
startnode.StartNode(datadir2, address2, '30001', "Server 2")
_sql.ExecuteSQLOnProxy(datadir2, "INSERT INTO test SET b='row3.2'")
_sql.ExecuteSQLOnProxy(datadir,
"UPDATE test SET b='row3_updated' WHERE a=3")
_sql.ExecuteSQLOnProxy(datadir2,
"UPDATE test SET b='row3_updated_2' WHERE a=3")
_sql.ExecuteSQLOnProxy(datadir,
"UPDATE test SET b='row3_updated_again' WHERE a=3")
blocks = _blocks.WaitBlocks(datadir, 4)
time.sleep(1) # give time to send transaction
blocks = _blocks.WaitBlocks(datadir2, 4)
time.sleep(1) # give time to send transaction
rows = _lib.DBGetRows(datadir, "SELECT * FROM test ORDER BY a", True)
_lib.FatalAssert(len(rows) == 3, "Must be 3 rows in a table")
rows2 = _lib.DBGetRows(datadir2, "SELECT * FROM test ORDER BY a", True)
_lib.FatalAssert(len(rows2) == 3, "Must be 3 rows in a table")
_lib.FatalAssert(
set(rows) == set(rows2),
"COntents of tables on both nodes must be same")
startnode.StopNode(datadir)
datadir = ""
startnode.StopNode(datadir2)
datadir2 = ""
#_lib.RemoveTestFolder(datadir)
_lib.EndTestGroupSuccess()
def test(testfilter):
global datadir
_lib.StartTestGroup("SQL Proxy basic")
_lib.CleanTestFolders()
datadir = _lib.CreateTestFolder()
startnode.StartNodeWithoutBlockchain(datadir)
address2 = transactions.CreateWallet(datadir)
address3 = transactions.CreateWallet(datadir)
_lib.CopyTestConsensusConfig(datadir,"customnumbers", address2)
address = startnode.InitBockchain(datadir)
_complex.AddProxyToConfig(datadir, "localhost:40041")
_complex.AddInternalKeyToConfig(datadir, address3) # init internal signing
startnode.StartNode(datadir, address, '30000')
_lib.StartTestGroup("Do transactions")
transactions.GetUnapprovedTransactionsEmpty(datadir)
# address3 signs proxy transactions. it doesn't have money yet
_transfers.Send(datadir,address, address3 ,5) # needs this to create table
blocks = _blocks.WaitBlocks(datadir, 2)
time.sleep(1)
_sql.ExecuteSQLOnProxy(datadir, "CREATE TABLE test (a INT auto_increment PRIMARY KEY, b VARCHAR(20))")
tables = _lib.DBGetRows(datadir,"SHOW TABLES")
found = False
for table in tables:
if table[0] == "test":
found = True
break
_lib.FatalAssert(found, "Table test not found in the DB")
_sql.ExecuteSQLOnProxy(datadir,"INSERT INTO test SET b='row1'")
blocks = _blocks.WaitBlocks(datadir, 3)
time.sleep(1)
# now try to create paid table. it should fail because no money
_sql.ExecuteSQLOnProxyFail(datadir, "CREATE TABLE members (id INT auto_increment PRIMARY KEY, name VARCHAR(20))")
# send money
_transfers.Send(datadir,address, address3 ,10) # this table creation costs 10
_sql.ExecuteSQLOnProxy(datadir, "CREATE TABLE members (id INT auto_increment PRIMARY KEY, name VARCHAR(20))")
tables = _lib.DBGetRows(datadir,"SHOW TABLES")
found = False
for table in tables:
if table[0] == "members":
found = True
break
_lib.FatalAssert(found, "Table not found in the DB")
_sql.ExecuteSQLOnProxyFail(datadir, "INSERT INTO members SET name='user1'")
# but should be abe to isert to free table
_sql.ExecuteSQLOnProxy(datadir,"INSERT INTO test SET b='row2'")
blocks = _blocks.WaitBlocks(datadir, 4)
time.sleep(2)
_transfers.Send(datadir,address, address3 ,1)
_sql.ExecuteSQLOnProxy(datadir, "INSERT INTO members SET name='user1'")
_sql.ExecuteSQLOnProxy(datadir, "INSERT INTO members SET name='user2'")
_sql.ExecuteSQLOnProxyFail(datadir, "INSERT INTO members SET name='user3'")
bal1 = _transfers.GetBalance(datadir, address)
bal2 = _transfers.GetBalance(datadir, address2)
bal3 = _transfers.GetBalance(datadir, address3)
_lib.FatalAssert(bal1[1] == 45.0, "Balance of a first addres is expected to be 45")
_lib.FatalAssert(bal2[1] == 15.0, "Balance of a second addres is expected to be 15")
_lib.FatalAssert(bal3[1] == 0.0, "Balance of a third addres is expected to be 0")
startnode.StopNode(datadir)
datadir = ""
#_lib.RemoveTestFolder(datadir)
_lib.EndTestGroupSuccess()
def test(testfilter):
global datadir1
global datadir2
global datadir3
_lib.StartTestGroup("Blocks exhange between nodes")
_lib.CleanTestFolders()
inf = MakeBlockchainWithBlocks('30000')
datadir = inf[0]
address1 = inf[1]
address1_2 = inf[2]
address1_3 = inf[3]
#_node.StartNodeInteractive(datadir, address1,'30000', "Server 1")
_complex.AddProxyToConfig(datadir, "localhost:40001")
_complex.AddInternalKeyToConfig(datadir, address1) # init internal signing
startnode.StartNode(datadir, address1, '30000', "Server 1")
datadir1 = datadir
managenodes.RemoveAllNodes(datadir1)
d = blocksnodes.StartNodeAndImport('30001', '30000', "Server 2", 40002,
'_2_')
datadir2 = d[0]
address2 = d[1]
d = blocksnodes.StartNodeAndImport('30002', '30000', "Server 3", 40003,
'_3_')
datadir3 = d[0]
address3 = d[1]
time.sleep(1)
nodes = managenodes.GetNodes(datadir1)
_lib.FatalAssert(len(nodes) == 2, "Should be 2 nodes on server 1")
nodes = managenodes.GetNodes(datadir2)
_lib.FatalAssert(len(nodes) == 2, "Should be 2 nodes on server 2")
nodes = managenodes.GetNodes(datadir3)
_lib.FatalAssert(len(nodes) == 2, "Should be 2 nodes on server 3")
# get balance
_sql.ExecuteSQLOnProxy(
datadir1,
"CREATE TABLE test (a INT auto_increment PRIMARY KEY, b VARCHAR(20))")
_sql.ExecuteSQLOnProxy(datadir1, "INSERT INTO test SET b='row1'")
_sql.ExecuteSQLOnProxy(datadir1, "INSERT INTO test SET a=2,b='row2'")
_sql.ExecuteSQLOnProxy(datadir1, "INSERT INTO test (b) VALUES ('row3')")
blocks = _blocks.WaitBlocks(datadir1, 5)
_lib.FatalAssert(len(blocks) == 5, "Should be 5 blocks on server 1")
blocks = _blocks.WaitBlocks(datadir2, 5)
_lib.FatalAssert(len(blocks) == 5, "Should be 5 blocks on server 2")
blocks = _blocks.WaitBlocks(datadir3, 5)
_lib.FatalAssert(len(blocks) == 5, "Should be 5 blocks on server 3")
time.sleep(1) # while all caches are cleaned
managenodes.RemoveAllNodes(datadir1)
managenodes.RemoveAllNodes(datadir2)
managenodes.RemoveAllNodes(datadir3)
rows = _lib.DBGetRows(datadir1, "SELECT * FROM test", True)
_lib.FatalAssert(len(rows) == 3, "Must be 3 rows in a table on node 1")
rows = _lib.DBGetRows(datadir2, "SELECT * FROM test", True)
_lib.FatalAssert(len(rows) == 3, "Must be 3 rows in a table on node 2")
rows = _lib.DBGetRows(datadir3, "SELECT * FROM test", True)
_lib.FatalAssert(len(rows) == 3, "Must be 3 rows in a table on node 3")
_sql.ExecuteSQLOnProxy(datadir1, "INSERT INTO test (b) VALUES ('row4')")
time.sleep(1) # while all caches are cleaned
rows = _lib.DBGetRows(datadir1, "SELECT * FROM test", True)
_lib.FatalAssert(len(rows) == 4, "Must be 4 rows in a table on node 1")
rows = _lib.DBGetRows(datadir2, "SELECT * FROM test", True)
_lib.FatalAssert(len(rows) == 3, "Must be 3 rows in a table on node 2")
rows = _lib.DBGetRows(datadir3, "SELECT * FROM test", True)
_lib.FatalAssert(len(rows) == 3, "Must be 3 rows in a table on node 3")
startnode.StopNode(datadir1, "Server 1")
datadir1 = ""
startnode.StopNode(datadir2, "Server 2")
datadir2 = ""
startnode.StopNode(datadir3, "Server 3")
datadir3 = ""
#_lib.RemoveTestFolder(datadir)
_lib.EndTestGroupSuccess()
def 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("SQL Consensus rules postponed")
_lib.CleanTestFolders()
datadir = _lib.CreateTestFolder()
startnode.StartNodeWithoutBlockchain(datadir)
address2 = transactions.CreateWallet(datadir)
address3 = transactions.CreateWallet(datadir)
_lib.CopyTestConsensusConfig(datadir,"postponedlimits", address2)
address = startnode.InitBockchain(datadir)
_complex.AddProxyToConfig(datadir, "localhost:40041")
_complex.AddInternalKeyToConfig(datadir, address3) # init internal signing
startnode.StartNode(datadir, address, '30000')
_lib.StartTestGroup("Do transactions")
transactions.GetUnapprovedTransactionsEmpty(datadir)
_sql.ExecuteSQLOnProxy(datadir, "CREATE TABLE test (a INT auto_increment PRIMARY KEY, b VARCHAR(20))")
blocks = _blocks.WaitBlocks(datadir, 2)
time.sleep(1)
_sql.ExecuteSQLOnProxy(datadir,"INSERT INTO test SET b='row1'")
_sql.ExecuteSQLOnProxy(datadir,"INSERT INTO test SET b='row2'")
blocks = _blocks.WaitBlocks(datadir, 3)
time.sleep(1)
_sql.ExecuteSQLOnProxy(datadir, "CREATE TABLE members (id INT auto_increment PRIMARY KEY, name VARCHAR(20))")
tables = _lib.DBGetRows(datadir,"SHOW TABLES")
found = False
for table in tables:
if table[0] == "members":
found = True
break
_lib.FatalAssert(found, "Table not found in the DB")
_sql.ExecuteSQLOnProxy(datadir, "INSERT INTO members SET name='user1'")
_sql.ExecuteSQLOnProxy(datadir, "INSERT INTO members SET name='use2'")
#_sql.ExecuteSQLOnProxy(datadir, "DROP TABLE members")
blocks = _blocks.WaitBlocks(datadir, 4)
time.sleep(1)
_sql.ExecuteSQLOnProxyFail(datadir, "CREATE TABLE test2 (a INT auto_increment PRIMARY KEY, b VARCHAR(20))")
_sql.ExecuteSQLOnProxy(datadir, "DROP TABLE members")
_sql.ExecuteSQLOnProxy(datadir,"INSERT INTO test SET b='row3'")
_sql.ExecuteSQLOnProxy(datadir,"UPDATE test SET b='row3+upd1' WHERE a=3")
_sql.ExecuteSQLOnProxy(datadir,"UPDATE test SET b='row3+upd2' WHERE a=3")
blocks = _blocks.WaitBlocks(datadir, 5)
time.sleep(1)
# now this must be paid
_sql.ExecuteSQLOnProxyFail(datadir,"UPDATE test SET b='row3+upd2' WHERE a=3")
_sql.ExecuteSQLOnProxy(datadir, "CREATE TABLE members (id INT auto_increment PRIMARY KEY, name VARCHAR(20))")
tables = _lib.DBGetRows(datadir,"SHOW TABLES")
found = False
for table in tables:
if table[0] == "members":
found = True
break
_sql.ExecuteSQLOnProxy(datadir, "INSERT INTO members SET name='user1'")
_sql.ExecuteSQLOnProxy(datadir, "INSERT INTO members SET name='user2'")
_sql.ExecuteSQLOnProxy(datadir, "INSERT INTO members SET name='user3'")
_sql.ExecuteSQLOnProxy(datadir,"INSERT INTO test SET b='row4'")
blocks = _blocks.WaitBlocks(datadir, 6)
time.sleep(1)
_sql.ExecuteSQLOnProxyFail(datadir, "INSERT INTO members SET name='user4'")
_sql.ExecuteSQLOnProxyFail(datadir,"INSERT INTO test SET b='row5'")
# send money to be able to execute this
_transfers.Send(datadir,address, address3 ,10) # needs this to create table
_sql.ExecuteSQLOnProxy(datadir, "INSERT INTO members SET name='user4'")
_sql.ExecuteSQLOnProxy(datadir,"INSERT INTO test SET b='row5'")
_sql.ExecuteSQLOnProxy(datadir, "CREATE TABLE test2 (a INT auto_increment PRIMARY KEY, b VARCHAR(20))")
_sql.ExecuteSQLOnProxy(datadir,"INSERT INTO test2 SET b='row1'")
_sql.ExecuteSQLOnProxy(datadir,"INSERT INTO test2 SET b='row2'")
_sql.ExecuteSQLOnProxy(datadir,"INSERT INTO test2 SET b='row3'")
blocks = _blocks.WaitBlocks(datadir, 7)
time.sleep(1)
startnode.StopNode(datadir)
datadir = ""
#_lib.RemoveTestFolder(datadir)
_lib.EndTestGroupSuccess()
def test(testfilter):
global datadirs
_lib.CleanTestFolders()
#return _complex.PrepareNodesWithSQL()
_lib.StartTestGroup("Load ready BC into 6 nodes")
dirs = _complex.Copy6NodesSQL()
nodes = []
i = 1
for d in dirs:
#get address in wallets in this dir
balances = _transfers.GetGroupBalance(d)
address = balances.keys()[0]
port = str(30000 + i)
nodes.append({
'index': i - 1,
'port': port,
'datadir': d,
'address': address,
"title": "Server " + str(i)
})
#_transfers.ReindexUTXO(d)
#txlist = transactions.GetUnapprovedTransactions(d)
#print txlist
#start this node
#print os.path.basename(d)
startnode.StartNodeConfig(d)
i = i + 1
datadirs.append(d)
#check nodes on each node is correct
for node in nodes:
#print os.path.basename(node['datadir'])
nodeslist = managenodes.GetNodes(node['datadir'])
_lib.FatalAssert(
len(nodeslist) == 2, "Should be 2 nodes on " + node["title"])
if node['index'] == 0:
_lib.FatalAssert("localhost:30005" in nodeslist,
"Node 6 should be on the node 0")
_lib.FatalAssert("localhost:30004" in nodeslist,
"Node 5 should be on the node 0")
if node['index'] == 1:
_lib.FatalAssert("localhost:30002" in nodeslist,
"Node 2 should be on the node 1")
_lib.FatalAssert("localhost:30003" in nodeslist,
"Node 3 should be on the node 1")
#raise ValueError('Stop')
# test blocks branches
_lib.StartTestGroup("Check blockchain before updates")
blocks1 = _blocks.GetBlocks(nodes[0]["datadir"])
blocks2 = _blocks.GetBlocks(nodes[1]["datadir"])
_lib.FatalAssert(len(blocks1) == 9, "First branch should have 9 blocks")
_lib.FatalAssert(len(blocks2) == 8, "Second branch should have 8 blocks")
_lib.FatalAssert(blocks1[2] == blocks2[1], "7 block must be same for both")
_lib.FatalAssert(blocks1[1] != blocks2[0], "8 block must be different")
_lib.StartTestGroup("Connect subnetworks")
managenodes.AddNode(nodes[0]["datadir"], "localhost", '30001')
# wait while blocks are exachanged
_blocks.WaitBlocks(nodes[1]["datadir"], 9)
s = 1
time.sleep(2)
while s < 10:
rows1 = _lib.DBGetRows(nodes[1]['datadir'], "SELECT * FROM test", True)
rows2 = _lib.DBGetRows(nodes[2]['datadir'], "SELECT * FROM test", True)
rows3 = _lib.DBGetRows(nodes[3]['datadir'], "SELECT * FROM test", True)
if ((rows1[1][1] == "row2_updated"
or rows1[1][1] == "row2_updated_other")
and (rows2[1][1] == "row2_updated"
or rows2[1][1] == "row2_updated_other")
and (rows3[1][1] == "row2_updated"
or rows3[1][1] == "row2_updated_other")):
break
time.sleep(1)
s = s + 1
# get unapproved transactions (after block cancel)
txlist = _transfers.WaitUnapprovedTransactions(nodes[1]["datadir"], 5, 15)
#print(txlist)
_lib.FatalAssert(
len(txlist) == 5,
"Should be 5 unapproved TXs, but has " + str(len(txlist)))
#send another 2 TXs to have 9 required TXs
balances = _transfers.GetGroupBalance(nodes[1]["datadir"])
mainbalance = _transfers.GetGroupBalance(nodes[0]["datadir"])
addr1 = balances.keys()[0]
amount = "%.8f" % round(balances[addr1][0] / 5, 8)
# add yet mode 4 TXs to complete a block
_transfers.Send(nodes[1]["datadir"], addr1, mainbalance.keys()[0], amount)
# 3 SQL txs
# on another node. should go to the second node too
_sql.ExecuteSQLOnProxy(nodes[0]['datadir'],
"INSERT INTO test SET b='row11', a=11")
_sql.ExecuteSQLOnProxy(nodes[1]['datadir'],
"UPDATE test set b='row5_update_other' WHERE a=5")
time.sleep(2)
txlist = _transfers.WaitUnapprovedTransactions(nodes[0]["datadir"], 1, 10)
# there should be minimum 1 tx, maximum 2. Because currency TX's can be based on other 1 currency TX's that are not yet on other nodes (from canceled block)
_lib.FatalAssert(
len(txlist) >= 1 and len(txlist) <= 2,
"SHould be from 1 to 2 unapproved TXs on node 1")
txlist = _transfers.WaitUnapprovedTransactions(nodes[1]["datadir"], 8, 10)
_lib.FatalAssert(len(txlist) == 8, "SHould be 8 unapproved TXs")
# after this TX new block should be created
_sql.ExecuteSQLOnProxy(
nodes[1]['datadir'],
"UPDATE test set b='row11_update_other' WHERE a=11")
# wait while new block created and posted to all other
b1 = _blocks.WaitBlocks(nodes[1]["datadir"], 10)
b2 = _blocks.WaitBlocks(nodes[0]["datadir"], 10)
_lib.StartTestGroup("Check blockchain after updates")
blocks2_0 = _blocks.GetBlocks(nodes[0]["datadir"])
_lib.FatalAssert(len(blocks2_0) == 10, "10 block must be on node 0")
_lib.FatalAssert(blocks2_0[1] == blocks1[0],
"9 block must be same for both")
blocks2_1 = _blocks.GetBlocks(nodes[1]["datadir"])
_lib.FatalAssert(len(blocks2_1) == 10, "10 block must be on node 1")
_lib.FatalAssert(blocks2_1[1] == blocks1[0],
"9 block must be same for both")
_lib.StartTestGroup("Node 2 " + os.path.basename(nodes[2]["datadir"]))
_blocks.WaitBlocks(nodes[2]["datadir"], 10)
blocks2_2 = _blocks.GetBlocks(nodes[2]["datadir"])
_lib.FatalAssert(len(blocks2_2) == 10, "10 block must be on node 2")
_lib.FatalAssert(blocks2_2[1] == blocks2_1[1],
"2-nd from top blocks on 2 must be same as on 1")
_lib.StartTestGroup("Node 3 " + os.path.basename(nodes[3]["datadir"]))
_blocks.WaitBlocks(nodes[3]["datadir"], 10)
blocks2_3 = _blocks.GetBlocks(nodes[3]["datadir"])
_lib.FatalAssert(len(blocks2_3) == 10, "10 block must be on node 3")
_lib.FatalAssert(blocks2_3[1] == blocks2_1[1],
"2-nd from top blocks on 3 must be same as on 1")
_lib.StartTestGroup("Node 4 " + os.path.basename(nodes[4]["datadir"]))
_blocks.WaitBlocks(nodes[4]["datadir"], 10)
blocks2_4 = _blocks.GetBlocks(nodes[4]["datadir"])
_lib.FatalAssert(len(blocks2_4) == 10, "10 block must be on node 4")
_lib.FatalAssert(blocks2_4[1] == blocks2_1[1],
"2-nd from top blocks on 4 must be same as on 1")
_lib.StartTestGroup("Node 5 " + os.path.basename(nodes[5]["datadir"]))
_blocks.WaitBlocks(nodes[5]["datadir"], 10)
blocks2_5 = _blocks.GetBlocks(nodes[5]["datadir"])
_lib.FatalAssert(len(blocks2_5) == 10, "10 block must be on node 5")
_lib.FatalAssert(blocks2_5[1] == blocks2_1[1],
"2-nd from top blocks on 5 must be same as on 1")
rows1 = _lib.DBGetRows(nodes[0]['datadir'], "SELECT * FROM test", True)
rows2 = _lib.DBGetRows(nodes[1]['datadir'], "SELECT * FROM test", True)
_lib.FatalAssert(rows1 == rows2,
"Table contents on node 1 and 2 must be same")
rows3 = _lib.DBGetRows(nodes[2]['datadir'], "SELECT * FROM test", True)
_lib.FatalAssert(rows1 == rows3,
"Table contents on node 1 and 3 must be same")
rows4 = _lib.DBGetRows(nodes[3]['datadir'], "SELECT * FROM test", True)
_lib.FatalAssert(rows1 == rows4,
"Table contents on node 1 and 4 must be same")
rows5 = _lib.DBGetRows(nodes[4]['datadir'], "SELECT * FROM test", True)
_lib.FatalAssert(rows1 == rows5,
"Table contents on node 1 and 5 must be same")
rows6 = _lib.DBGetRows(nodes[5]['datadir'], "SELECT * FROM test", True)
_lib.FatalAssert(rows1 == rows6,
"Table contents on node 1 and 6 must be same")
_lib.StartTestGroup("Final checks")
# should be empty list of transactions now
transactions.GetUnapprovedTransactionsEmpty(nodes[1]["datadir"])
for node in nodes:
startnode.StopNode(node['datadir'])
datadirs[node['index']] = ""
#_lib.RemoveTestFolder(datadir)
_lib.EndTestGroupSuccess()
def test(testfilter):
global datadir
_lib.StartTestGroup("SQL Proxy basic")
_lib.CleanTestFolders()
datadir = _lib.CreateTestFolder()
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")
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")
_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.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")
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 PrepareNodesWithSQL():
nodeport = '30000'
_lib.StartTestGroup("Prepare 6 nodes with SQL commands in BC")
_lib.CleanTestFolders()
datadir_tmp = CopyBlockchainWithBlocks("_1_")
blocks = _blocks.GetBlocks(datadir_tmp)
balances = _transfers.GetGroupBalance(datadir_tmp)
datadirs = []
address1 = balances.keys()[0]
# address1_3 becomes a minter. we will send money from other 2 and this will receive rewards
AddProxyToConfig(datadir_tmp, "localhost:40040")
AddInternalKeyToConfig(datadir_tmp, address1) # init internal signing
startnode.StartNode(datadir_tmp, address1,nodeport)
datadir = datadir_tmp
datadirs.append(datadir_tmp)
nodes = []
for i in range(1, 6):
port = str(30000+i)
dbproxyport = str(40040+i)
d = blocksnodes.StartNodeAndImport(port, nodeport, "Server "+str(i), int(dbproxyport),"_"+str(i+1)+"_")
datadir_n = d[0]
address_n = d[1]
nodes.append({'number':i, 'port':port, 'datadir':datadir_n,'address':address_n,'proxyport':dbproxyport})
datadirs.append(datadir_n)
_lib.StartTestGroup("Temp Data Dirs")
_lib.StartTest("Node 0 "+os.path.basename(datadir))
for node in nodes:
_lib.StartTest("Node "+str(node['number'])+" "+os.path.basename(node['datadir']))
# commmon transfer of blocks between nodes
_lib.StartTestGroup("Transfer of blocks between nodes")
blocks = _blocks.GetBlocks(datadir)
blockslen = len(blocks)
balance1 = _transfers.GetBalance(datadir, address1)
as1 = "%.8f" % round(balance1[0]/10,8)
# should be 6 transactions. 3 currency and 3 SQL
_transfers.Send(datadir,address1, nodes[0]['address'] ,as1)
_transfers.Send(datadir,address1, nodes[1]['address'] ,as1)
_transfers.Send(datadir,address1, nodes[2]['address'] ,as1)
_sql.ExecuteSQLOnProxy(datadir,"CREATE TABLE test (a INT auto_increment PRIMARY KEY, b VARCHAR(20))")
_sql.ExecuteSQLOnProxy(datadir,"INSERT INTO test SET b='row1'")
_sql.ExecuteSQLOnProxy(datadir,"INSERT INTO test SET a=2,b='row2'")
blocks = _blocks.WaitBlocks(datadir, blockslen + 1)
_lib.FatalAssert(len(blocks) == blockslen + 1, "Expected "+str(blockslen +1)+" blocks")
#wait while block is posted to all other nodes
time.sleep(2)
# check on each node
for node in nodes:
blocks = _blocks.WaitBlocks(node['datadir'], blockslen + 1)
_lib.FatalAssert(len(blocks) == blockslen + 1, "Expected "+str(blockslen +1)+" blocks o node "+str(node['number']))
_lib.StartTestGroup("Create 2 branches of blockchain")
while True:
time.sleep(4)# to complete all operations in progress
# remove connection between subnetworks
managenodes.RemoveAllNodes(nodes[0]['datadir'])
managenodes.RemoveAllNodes(nodes[1]['datadir'])
managenodes.RemoveAllNodes(nodes[2]['datadir'])
managenodes.RemoveAllNodes(nodes[3]['datadir'])
managenodes.RemoveAllNodes(nodes[4]['datadir'])
managenodes.RemoveAllNodes(datadir)
time.sleep(1)
nodes0 = managenodes.GetNodes(datadir)
nodes1 = managenodes.GetNodes(nodes[0]['datadir'])
nodes2 = managenodes.GetNodes(nodes[1]['datadir'])
if len(nodes0) == 0 and len(nodes1) == 0 and len(nodes2) == 0:
break
_lib.StartTestGroup("Nodes addresses are still not clean")
# first group - main and 4,5 nodes
managenodes.AddNode(datadir,"localhost",'30004')
managenodes.AddNode(datadir,"localhost",'30005')
managenodes.AddNode(nodes[3]['datadir'],"localhost",'30005')
#second group 1,2,3
managenodes.AddNode(nodes[0]['datadir'],"localhost",'30002')
managenodes.AddNode(nodes[0]['datadir'],"localhost",'30003')
managenodes.AddNode(nodes[1]['datadir'],"localhost",'30003')
time.sleep(1)
#check nodes
nodes0 = managenodes.GetNodes(datadir)
_lib.FatalAssert("localhost:30005", "Node 5 is not in the list of 0")
_lib.FatalAssert("localhost:30004", "Node 4 is not in the list of 0")
nodes1 = managenodes.GetNodes(nodes[0]['datadir'])
_lib.FatalAssert("localhost:30002", "Node 2 is not in the list of 1")
_lib.FatalAssert("localhost:30003", "Node 3 is not in the list of 1")
nodes2 = managenodes.GetNodes(nodes[1]['datadir'])
_lib.FatalAssert("localhost:30001", "Node 1 is not in the list of 2")
_lib.FatalAssert("localhost:30003", "Node 3 is not in the list of 2")
_lib.StartTestGroup("2 new blocks on first branch")
balance1 = _transfers.GetBalance(datadir, address1)
as1 = "%.8f" % round(balance1[0]/20,8)
# 7 TX for 8-th block
tx = [""] * 15
tx[0] = _transfers.Send(datadir,address1, nodes[3]['address'] ,as1)
tx[1] = _transfers.Send(datadir,address1, nodes[3]['address'] ,as1)
tx[2] = _transfers.Send(datadir,address1, nodes[3]['address'] ,as1)
_sql.ExecuteSQLOnProxy(datadir,"UPDATE test SET b='row2_updated' WHERE a=2")
_sql.ExecuteSQLOnProxy(datadir,"INSERT INTO test SET b='row3'")
_sql.ExecuteSQLOnProxy(datadir,"INSERT INTO test SET b='row4'")
_sql.ExecuteSQLOnProxy(datadir,"UPDATE test SET b='row4_updated' WHERE a=4")
time.sleep(7)
# 8 TX for 9-th block
tx[7] = _transfers.Send(datadir,address1, nodes[4]['address'] ,as1)
tx[8] = _transfers.Send(datadir,address1, nodes[4]['address'] ,as1)
tx[9] = _transfers.Send(datadir,address1, nodes[4]['address'] ,as1)
tx[10] = _transfers.Send(datadir,address1, nodes[4]['address'] ,as1)
_sql.ExecuteSQLOnProxy(datadir,"INSERT INTO test SET b='row7', a=7")
_sql.ExecuteSQLOnProxy(datadir,"INSERT INTO test SET b='row8', a=8")
_sql.ExecuteSQLOnProxy(datadir,"INSERT INTO test SET b='row9', a=9")
_sql.ExecuteSQLOnProxy(datadir,"INSERT INTO test SET b='row10', a=10")
blocks1 = _blocks.WaitBlocks(nodes[4]['datadir'], blockslen + 3)
time.sleep(3)
_lib.FatalAssert(len(blocks1) == blockslen + 3, "Expected "+str(blockslen +3)+" blocks for branch 1")
rows = _lib.DBGetRows(nodes[3]['datadir'],"SELECT * FROM test",True)
_lib.FatalAssert(len(rows) == 8, "Must be 8 rows in a table on 3-th node")
rows = _lib.DBGetRows(nodes[4]['datadir'],"SELECT * FROM test",True)
_lib.FatalAssert(len(rows) == 8, "Must be 8 rows in a table on 4-th node")
_lib.StartTestGroup("1 new block on second branch")
balance2 = _transfers.GetBalance(nodes[0]['datadir'], nodes[0]['address'])
as2 = "%.8f" % round(balance2[0]/10,8)
# 7 new TX
_transfers.Send(nodes[0]['datadir'], nodes[0]['address'], nodes[1]['address'] ,as2)
_transfers.Send(nodes[0]['datadir'], nodes[0]['address'], nodes[2]['address'] ,as2)
# unique row
_sql.ExecuteSQLOnProxy(nodes[0]['datadir'],"INSERT INTO test SET b='row5', a = 5")
# identical as in parallel
_sql.ExecuteSQLOnProxy(nodes[0]['datadir'],"INSERT INTO test SET b='row7', a=7")
# other value and same ID
_sql.ExecuteSQLOnProxy(nodes[0]['datadir'],"INSERT INTO test SET b='row3_other', a=3")
# update same
_sql.ExecuteSQLOnProxy(nodes[0]['datadir'],"UPDATE test SET b='row2_updated_other' WHERE a=2")
# delete
_sql.ExecuteSQLOnProxy(nodes[0]['datadir'],"DELETE FROM test WHERE a=7")
blocks2 = _blocks.WaitBlocks(nodes[0]['datadir'], blockslen + 2)
_lib.FatalAssert(len(blocks2) == blockslen + 2, "Expected "+str(blockslen +2)+" blocks for branch 2. Node 1")
blocks2 = _blocks.WaitBlocks(nodes[1]['datadir'], blockslen + 2)
_lib.FatalAssert(len(blocks2) == blockslen + 2, "Expected "+str(blockslen +2)+" blocks for branch 2. Node 2")
blocks2 = _blocks.WaitBlocks(nodes[2]['datadir'], blockslen + 2)
_lib.FatalAssert(len(blocks2) == blockslen + 2, "Expected "+str(blockslen +2)+" blocks for branch 2. Node 2")
time.sleep(3)# to allow to update all references after block add
#rows = _lib.DBGetRows(datadir,"SELECT * FROM test",True)
#print "0",rows
#rows = _lib.DBGetRows(nodes[0]['datadir'],"SELECT * FROM test",True)
#print "1",rows
#rows = _lib.DBGetRows(nodes[1]['datadir'],"SELECT * FROM test",True)
#print "2",rows
#rows = _lib.DBGetRows(nodes[2]['datadir'],"SELECT * FROM test",True)
#print "3",rows
#rows = _lib.DBGetRows(nodes[3]['datadir'],"SELECT * FROM test",True)
#print "4",rows
#rows = _lib.DBGetRows(nodes[4]['datadir'],"SELECT * FROM test",True)
#print "5",rows
# index 2 is 4-th node (3-rd in second network)
rows = _lib.DBGetRows(nodes[2]['datadir'],"SELECT * FROM test",True)
_lib.FatalAssert(len(rows) == 4, "Must be 4 rows in a table on 4-th node")
dstdir = _lib.getCurrentDir()+"/datafortests/"
#configs for cluster 1
copyConfig(datadir, dstdir+"bc6nodessql_1/config.t", address1, nodeport, nodes[3]['port'], nodes[4]['port'])
copyConfig(nodes[3]['datadir'], dstdir+"bc6nodessql_5/config.t", nodes[3]['address'], nodes[3]['port'], nodeport, nodes[4]['port'])
copyConfig(nodes[4]['datadir'], dstdir+"bc6nodessql_6/config.t", nodes[4]['address'], nodes[4]['port'], nodeport, nodes[3]['port'])
#config for cluster 2
copyConfig(nodes[0]['datadir'], dstdir+"bc6nodessql_2/config.t", nodes[0]['address'], nodes[0]['port'], nodes[1]['port'], nodes[2]['port'])
copyConfig(nodes[1]['datadir'], dstdir+"bc6nodessql_3/config.t", nodes[1]['address'], nodes[1]['port'], nodes[0]['port'], nodes[2]['port'])
copyConfig(nodes[2]['datadir'], dstdir+"bc6nodessql_4/config.t", nodes[2]['address'], nodes[2]['port'], nodes[0]['port'], nodes[1]['port'])
#print os.path.basename(datadir)
startnode.StopNode(datadir)
dstdir = _lib.getCurrentDir()+"/datafortests/bc6nodessql_1/"
#print dstdir
copyfile(datadir+"/wallet.dat", dstdir+"wallet.t")
try:
os.remove(dstdir+"db.sql")
except OSError:
pass
DumpBCDB(datadir, dstdir+"db.sql")
i = 2
for node in nodes:
#print os.path.basename(node['datadir'])
startnode.StopNode(node['datadir'])
dstdir = _lib.getCurrentDir()+"/datafortests/bc6nodessql_"+str(i)+"/"
#print dstdir
copyfile(node['datadir']+"/wallet.dat", dstdir+"wallet.t")
try:
os.remove(dstdir+"db.sql")
except OSError:
pass
DumpBCDB(node['datadir'], dstdir+"db.sql")
i=i+1
return [datadir, address1, nodes, blockslen+1, datadirs]