Changeset: 6a7a59f88cd6 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=6a7a59f88cd6
Added Files:
sql/test/BugTracker/Tests/SingleServer
sql/test/BugTracker/Tests/connect_crash.SF-1436626.SQL.py
sql/test/BugTracker/Tests/mdb_starts_with_sql_debug_64.SF-1999354.SQL.py
sql/test/BugTracker/Tests/set_a_new_user_password.SF-1844050.SQL.py
sql/test/BugTracker/Tests/set_sql_debug_64__breaking_the_DB.SF-1906287.SQL.py
Branch: Nov2019
Log Message:
Added Single Server run to BugTracker test directory
diffs (193 lines):
diff --git a/sql/test/BugTracker/Tests/SingleServer
b/sql/test/BugTracker/Tests/SingleServer
new file mode 100644
diff --git a/sql/test/BugTracker/Tests/connect_crash.SF-1436626.SQL.py
b/sql/test/BugTracker/Tests/connect_crash.SF-1436626.SQL.py
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker/Tests/connect_crash.SF-1436626.SQL.py
@@ -0,0 +1,10 @@
+import os, sys
+try:
+ from MonetDBtesting import process
+except ImportError:
+ import process
+
+clt = process.client('sql', stdin = process.PIPE, stdout = process.PIPE,
stderr = process.PIPE)
+out, err = clt.communicate('select 1;\n')
+sys.stdout.write(out)
+sys.stderr.write(err)
diff --git
a/sql/test/BugTracker/Tests/mdb_starts_with_sql_debug_64.SF-1999354.SQL.py
b/sql/test/BugTracker/Tests/mdb_starts_with_sql_debug_64.SF-1999354.SQL.py
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker/Tests/mdb_starts_with_sql_debug_64.SF-1999354.SQL.py
@@ -0,0 +1,44 @@
+import os, socket, sys, tempfile, shutil
+try:
+ from MonetDBtesting import process
+except ImportError:
+ import process
+
+def freeport():
+ sock = socket.socket(socket.AF_INET, socket.SOCK_STREAM)
+ sock.bind(('', 0))
+ port = sock.getsockname()[1]
+ sock.close()
+ return port
+
+farm_dir = tempfile.mkdtemp()
+os.mkdir(os.path.join(farm_dir, 'db1'))
+
+def server_start(args):
+ sys.stderr.write('#mserver: "%s"\n' % ' '.join(args))
+ sys.stderr.flush()
+ srv = process.server(mapiport=freeport(), dbname='db1',
dbfarm=os.path.join(farm_dir, 'db1'), stdin = process.PIPE,
+ stdout = process.PIPE, stderr = process.PIPE)
+ return srv
+
+def client(lang, file):
+ sys.stderr.write('#client: "%s"\n' % file)
+ sys.stderr.flush()
+ clt = process.client(lang.lower(), stdin = open(file),
+ stdout = process.PIPE, stderr = process.PIPE)
+ return clt.communicate()
+
+def main():
+ srv = server_start(["--set", "sql_debug=64"])
+ out, err = client('SQL',
+ os.path.join(os.getenv('RELSRCDIR'),
+
'mdb_starts_with_sql_debug_64.SF-1999354.sql'))
+ sys.stdout.write(out)
+ sys.stderr.write(err)
+ out, err = srv.communicate()
+ sys.stdout.write(out)
+ sys.stderr.write(err)
+
+ shutil.rmtree(farm_dir)
+
+main()
diff --git
a/sql/test/BugTracker/Tests/set_a_new_user_password.SF-1844050.SQL.py
b/sql/test/BugTracker/Tests/set_a_new_user_password.SF-1844050.SQL.py
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker/Tests/set_a_new_user_password.SF-1844050.SQL.py
@@ -0,0 +1,66 @@
+import os, socket, sys, tempfile, shutil
+try:
+ from MonetDBtesting import process
+except ImportError:
+ import process
+
+def freeport():
+ sock = socket.socket(socket.AF_INET, socket.SOCK_STREAM)
+ sock.bind(('', 0))
+ port = sock.getsockname()[1]
+ sock.close()
+ return port
+
+farm_dir = tempfile.mkdtemp()
+os.mkdir(os.path.join(farm_dir, 'db1'))
+
+def server_start():
+ sys.stderr.write('#mserver\n')
+ sys.stderr.flush()
+ srv = process.server(mapiport=freeport(), dbname='db1',
dbfarm=os.path.join(farm_dir, 'db1'), stdin = process.PIPE,
+ stdout = process.PIPE, stderr = process.PIPE)
+ return srv
+
+def client(lang, file, user = 'monetdb', passwd = 'monetdb'):
+ sys.stderr.write('#client\n')
+ sys.stderr.flush()
+ clt = process.client(lang, user = user, passwd = passwd,
+ stdin = open(file),
+ stdout = process.PIPE, stderr = process.PIPE)
+ return clt.communicate()
+
+def main():
+ srv = server_start()
+ out, err = client('sql',
+ os.path.join(os.getenv('RELSRCDIR'),
+
'set_a_new_user_password.SF-1844050_create_user.sql'))
+ sys.stdout.write(out)
+ sys.stderr.write(err)
+ out, err = srv.communicate()
+ sys.stdout.write(out)
+ sys.stderr.write(err)
+
+ srv = server_start()
+ out, err = client('sql',
+ os.path.join(os.getenv('RELSRCDIR'),
+
'set_a_new_user_password.SF-1844050_select.sql'),
+ "voc2", "new")
+ sys.stdout.write(out)
+ sys.stderr.write(err)
+ out, err = srv.communicate()
+ sys.stdout.write(out)
+ sys.stderr.write(err)
+
+ srv = server_start()
+ out, err = client('sql',
+ os.path.join(os.getenv('RELSRCDIR'),
+
'set_a_new_user_password.SF-1844050_drop_user.sql'))
+ sys.stdout.write(out)
+ sys.stderr.write(err)
+ out, err = srv.communicate()
+ sys.stdout.write(out)
+ sys.stderr.write(err)
+
+ shutil.rmtree(farm_dir)
+
+main()
diff --git
a/sql/test/BugTracker/Tests/set_sql_debug_64__breaking_the_DB.SF-1906287.SQL.py
b/sql/test/BugTracker/Tests/set_sql_debug_64__breaking_the_DB.SF-1906287.SQL.py
new file mode 100644
--- /dev/null
+++
b/sql/test/BugTracker/Tests/set_sql_debug_64__breaking_the_DB.SF-1906287.SQL.py
@@ -0,0 +1,51 @@
+import os, socket, sys, tempfile, shutil
+try:
+ from MonetDBtesting import process
+except ImportError:
+ import process
+
+def freeport():
+ sock = socket.socket(socket.AF_INET, socket.SOCK_STREAM)
+ sock.bind(('', 0))
+ port = sock.getsockname()[1]
+ sock.close()
+ return port
+
+farm_dir = tempfile.mkdtemp()
+os.mkdir(os.path.join(farm_dir, 'db1'))
+
+def server_start(args = []):
+ sys.stderr.write('#mserver\n')
+ sys.stderr.flush()
+ srv = process.server(mapiport=freeport(), dbname='db1',
dbfarm=os.path.join(farm_dir, 'db1'), stdin = process.PIPE,
+ stdout = process.PIPE, stderr = process.PIPE)
+ return srv
+
+def client(file):
+ sys.stderr.write('#client\n')
+ sys.stderr.flush()
+ clt = process.client('sql', stdin = open(file),
+ stdout = process.PIPE, stderr = process.PIPE)
+ return clt.communicate()
+
+def main():
+ srv = server_start(["--set", "sql_debug=64"])
+ out, err = client(os.path.join(os.getenv('RELSRCDIR'),
+
'set_sql_debug_64__breaking_the_DB.SF-1906287_create.sql'))
+ sys.stdout.write(out)
+ sys.stderr.write(err)
+ out, err = srv.communicate()
+ sys.stdout.write(out)
+ sys.stderr.write(err)
+ srv = server_start()
+ out, err = client(os.path.join(os.getenv('RELSRCDIR'),
+
'set_sql_debug_64__breaking_the_DB.SF-1906287_drop.sql'))
+ sys.stdout.write(out)
+ sys.stderr.write(err)
+ out, err = srv.communicate()
+ sys.stdout.write(out)
+ sys.stderr.write(err)
+
+ shutil.rmtree(farm_dir)
+
+main()
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
