Changeset: 5b1ba81837cb for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/5b1ba81837cb
Removed Files:
sql/test/wlcr/Tests/All
sql/test/wlcr/Tests/wlc01.py
sql/test/wlcr/Tests/wlc100.py
sql/test/wlcr/Tests/wlc20.py
sql/test/wlcr/Tests/wlc21.py
sql/test/wlcr/Tests/wlc30.py
sql/test/wlcr/Tests/wlc40.py
sql/test/wlcr/Tests/wlc50.py
sql/test/wlcr/Tests/wlc70.py
sql/test/wlcr/Tests/wlc80.py
sql/test/wlcr/Tests/wlcr00.py
sql/test/wlcr/Tests/wlr01.py
sql/test/wlcr/Tests/wlr01.reqtests
sql/test/wlcr/Tests/wlr10.py
sql/test/wlcr/Tests/wlr100.py
sql/test/wlcr/Tests/wlr110.py
sql/test/wlcr/Tests/wlr20.py
sql/test/wlcr/Tests/wlr20.reqtests
sql/test/wlcr/Tests/wlr30.py
sql/test/wlcr/Tests/wlr30.reqtests
sql/test/wlcr/Tests/wlr35.py
sql/test/wlcr/Tests/wlr40.py
sql/test/wlcr/Tests/wlr40.reqtests
sql/test/wlcr/Tests/wlr50.py
sql/test/wlcr/Tests/wlr70.py
sql/test/wlcr/Tests/wlr80.py
Branch: default
Log Message:
Removed (already disabled) tests for Workload Capture and Replace.
diffs (truncated from 1434 to 300 lines):
diff --git a/sql/test/wlcr/Tests/All b/sql/test/wlcr/Tests/All
deleted file mode 100644
--- a/sql/test/wlcr/Tests/All
+++ /dev/null
@@ -1,41 +0,0 @@
-# This is a scenario for continual replication
-# first create a master with some sample data
-#wlcr00
-#wlc01
-#
-### check the log records without replication
-#wlr01
-#
-### create the first replica synchronized with the master
-#wlr10
-#
-### add two sets of tuples to the master
-#wlc20
-#wlc21
-#
-### and automatically roll forward the clone in 2 steps
-#wlr20
-#
-### prepare an update to the master
-#wlc30
-#
-### roll forward to clone
-#wlr30
-#
-### delete some tupples
-#wlc40
-#wlr35
-#wlr40
-#
-### clear the complete table
-#wlc50
-#wlr50
-
-## restart for timing based roll forward
-#wlc70
-#wlr70
-
-## stop the master
-#wlc100
-#wlr100
-#wlr110
diff --git a/sql/test/wlcr/Tests/wlc01.py b/sql/test/wlcr/Tests/wlc01.py
deleted file mode 100644
--- a/sql/test/wlcr/Tests/wlc01.py
+++ /dev/null
@@ -1,78 +0,0 @@
-from MonetDBtesting.sqltest import SQLTestCase
-try:
- from MonetDBtesting import process
-except ImportError:
- import process
-import os, sys
-
-DBFARM = os.getenv('GDK_DBFARM')
-TSTDB = os.getenv('TSTDB')
-MAPIPORT = os.getenv('MAPIPORT')
-
-if not TSTDB or not DBFARM:
- print('No TSTDB or GDK_DBFARM in environment')
- sys.exit(1)
-
-with process.server(mapiport=MAPIPORT, dbname=TSTDB, stdout=process.PIPE,
stderr=process.PIPE) as s:
- with SQLTestCase() as tc:
- tc.connect(database=TSTDB, port=MAPIPORT)
- tc.execute("""
- call wlc.beat(0);
- call wlc.master();""").assertSucceeded()
- tc.execute("create table tmp0(i int, s
string);""").assertSucceeded()
- tc.execute("insert into tmp0 values(1,'gaap'), (2,'sleep');")\
- .assertSucceeded()\
- .assertRowCount(2)
- tc.execute("drop table tmp0;").assertSucceeded()
- tc.execute("create table tmp(i int, s string);").assertSucceeded()
- tc.execute("insert into tmp values(1,'hello'), (2,'world');")\
- .assertSucceeded()\
- .assertRowCount(2)
- tc.execute("select * from tmp;")\
- .assertSucceeded()\
- .assertRowCount(2)\
- .assertDataResultMatch(data=[(1, 'hello'), (2, 'world')])
-
- sout, serr = s.communicate()
-
-#with process.server(dbname=dbname, stdin=process.PIPE, stdout=process.PIPE,
stderr=process.PIPE) as s, \
-# process.client('sql', server=s, stdin=process.PIPE, stdout=process.PIPE,
stderr=process.PIPE) as c:
-#
-# cout, cerr = c.communicate('''\
-#call wlc.beat(0);
-#call wlc.master();
-#
-#create table tmp0(i int, s string);
-#insert into tmp0 values(1,'gaap'), (2,'sleep');
-#drop table tmp0;
-#create table tmp(i int, s string);
-#insert into tmp values(1,'hello'), (2,'world');
-#select * from tmp;
-#''')
-#
-# sout, serr = s.communicate()
-#
-# sys.stdout.write(sout)
-# sys.stdout.write(cout)
-# sys.stderr.write(serr)
-# sys.stderr.write(cerr)
-
-def listfiles(path):
- sys.stdout.write("#LISTING OF THE LOG FILES\n")
- for f in sorted(os.listdir(path)):
- if (f.find('wlc') >= 0 or f.find('wlr') >=0 ) and f != 'wlc_logs':
- file = path + os.path.sep + f
- sys.stdout.write('#' + file + "\n")
- try:
- x = open(file)
- s = x.read()
- lines = s.split('\n')
- for l in lines:
- sys.stdout.write('#' + l + '\n')
- x.close()
- except IOError:
- sys.stderr.write('Failure to read file ' + file + '\n')
-
-listfiles(os.path.join(DBFARM, TSTDB))
-listfiles(os.path.join(DBFARM, TSTDB, 'wlc_logs'))
-
diff --git a/sql/test/wlcr/Tests/wlc100.py b/sql/test/wlcr/Tests/wlc100.py
deleted file mode 100644
--- a/sql/test/wlcr/Tests/wlc100.py
+++ /dev/null
@@ -1,49 +0,0 @@
-try:
- from MonetDBtesting import process
-except ImportError:
- import process
-import os, sys
-
-dbfarm = os.getenv('GDK_DBFARM')
-tstdb = os.getenv('TSTDB')
-
-if not tstdb or not dbfarm:
- print('No TSTDB or GDK_DBFARM in environment')
- sys.exit(1)
-
-dbname = tstdb
-
-with process.server(dbname=dbname, stdin=process.PIPE, stdout=process.PIPE,
stderr=process.PIPE) as s, \
- process.client('sql', server=s, stdin=process.PIPE, stdout=process.PIPE,
stderr=process.PIPE) as c:
-
- cout, cerr = c.communicate('''\
-call wlc.stop();
-insert into tmp values(40,'after being stopped');
-select * from tmp;
-''')
-
- sout, serr = s.communicate()
-
- sys.stdout.write(sout)
- sys.stdout.write(cout)
- sys.stderr.write(serr)
- sys.stderr.write(cerr)
-
-def listfiles(path):
- sys.stdout.write("#LISTING OF THE LOG FILES\n")
- for f in sorted(os.listdir(path)):
- if (f.find('wlc') >= 0 or f.find('wlr') >=0 ) and f != 'wlc_logs':
- file = path + os.path.sep + f
- sys.stdout.write('#' + file + "\n")
- try:
- x = open(file)
- s = x.read()
- lines = s.split('\n')
- for l in lines:
- sys.stdout.write('#' + l + '\n')
- x.close()
- except IOError:
- sys.stderr.write('Failure to read file ' + file + '\n')
-
-listfiles(os.path.join(dbfarm, tstdb))
-listfiles(os.path.join(dbfarm, tstdb, 'wlc_logs'))
diff --git a/sql/test/wlcr/Tests/wlc20.py b/sql/test/wlcr/Tests/wlc20.py
deleted file mode 100644
--- a/sql/test/wlcr/Tests/wlc20.py
+++ /dev/null
@@ -1,62 +0,0 @@
-try:
- from MonetDBtesting import process
-except ImportError:
- import process
-import os, sys
-from MonetDBtesting.sqltest import SQLTestCase
-
-dbfarm = os.getenv('GDK_DBFARM')
-tstdb = os.getenv('TSTDB')
-
-if not tstdb or not dbfarm:
- print('No TSTDB or GDK_DBFARM in environment')
- sys.exit(1)
-
-dbname = tstdb
-
-with process.server(dbname=dbname, stdin=process.PIPE, stdout=process.PIPE,
stderr=process.PIPE) as s, \
- SQLTestCase() as tc:
- tc.connect(database=dbname)
- tc.execute("insert into tmp values(3,'blah'),(4,'bloh');")\
- .assertSucceeded()\
- .assertRowCount(2)
- tc.execute("select * from tmp;")\
- .assertSucceeded()\
- .assertDataResultMatch([(1, 'hello'), (2, 'world'), (3, 'blah'), (4,
'bloh')])
-
- sout, serr = s.communicate()
-
-
-#with process.server(dbname=dbname, stdin=process.PIPE, stdout=process.PIPE,
stderr=process.PIPE) as s, \
-# process.client('sql', server = s, stdin = process.PIPE, stdout =
process.PIPE, stderr = process.PIPE) as c:
-#
-# cout, cerr = c.communicate('''\
-#insert into tmp values(3,'blah'),(4,'bloh');
-#select * from tmp;
-#''')
-#
-# sout, serr = s.communicate()
-#
-# sys.stdout.write(sout)
-# sys.stdout.write(cout)
-# sys.stderr.write(serr)
-# sys.stderr.write(cerr)
-
-def listfiles(path):
- sys.stdout.write("#LISTING OF THE LOG FILES\n")
- for f in sorted(os.listdir(path)):
- if (f.find('wlc') >= 0 or f.find('wlr') >=0 ) and f != 'wlc_logs':
- file = path + os.path.sep + f
- sys.stdout.write('#' + file + "\n")
- try:
- x = open(file)
- s = x.read()
- lines = s.split('\n')
- for l in lines:
- sys.stdout.write('#' + l + '\n')
- x.close()
- except IOError:
- sys.stderr.write('Failure to read file ' + file + '\n')
-
-listfiles(dbfarm + os.path.sep + tstdb)
-listfiles(dbfarm + os.path.sep + tstdb + os.path.sep + 'wlc_logs')
diff --git a/sql/test/wlcr/Tests/wlc21.py b/sql/test/wlcr/Tests/wlc21.py
deleted file mode 100644
--- a/sql/test/wlcr/Tests/wlc21.py
+++ /dev/null
@@ -1,63 +0,0 @@
-try:
- from MonetDBtesting import process
-except ImportError:
- import process
-import os, sys
-from MonetDBtesting.sqltest import SQLTestCase
-
-dbfarm = os.getenv('GDK_DBFARM')
-tstdb = os.getenv('TSTDB')
-
-if not tstdb or not dbfarm:
- print('No TSTDB or GDK_DBFARM in environment')
- sys.exit(1)
-
-dbname = tstdb
-
-
-with process.server(dbname=dbname, stdin=process.PIPE, stdout=process.PIPE,
stderr=process.PIPE) as s, \
- SQLTestCase() as tc:
- tc.connect(database=dbname)
- tc.execute("insert into tmp values(5,'red'),(6,'fox');")\
- .assertSucceeded()\
- .assertRowCount(2)
- tc.execute("select * from tmp;")\
- .assertSucceeded()\
- .assertDataResultMatch([(1, 'hello'), (2, 'world'), (3, 'blah'), (4,
'bloh'), (5, 'red'), (6, 'fox')])
-
- sout, serr = s.communicate()
-
-
-#with process.server(dbname=dbname, stdin=process.PIPE, stdout=process.PIPE,
stderr=process.PIPE) as s, \
-# process.client('sql', server=s, stdin=process.PIPE, stdout=process.PIPE,
stderr=process.PIPE) as c:
-#
-# cout, cerr = c.communicate('''\
-#insert into tmp values(5,'red'),(6,'fox');
-#select * from tmp;
-#''')
-#
-# sout, serr = s.communicate()
-#
-# sys.stdout.write(sout)
-# sys.stdout.write(cout)
-# sys.stderr.write(serr)
-# sys.stderr.write(cerr)
-
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
