Changeset: 50c296426e4f for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/50c296426e4f
Added Files:
sql/test/BugTracker-2021/Tests/copyinto-copyfrom.Bug-7186.test.in
Removed Files:
sql/test/BugTracker-2021/Tests/copyinto-copyfrom.Bug-7186.SQL.py
Branch: Sep2022
Log Message:
Converted to .test format.
diffs (45 lines):
diff --git a/sql/test/BugTracker-2021/Tests/copyinto-copyfrom.Bug-7186.SQL.py
b/sql/test/BugTracker-2021/Tests/copyinto-copyfrom.Bug-7186.test.in
rename from sql/test/BugTracker-2021/Tests/copyinto-copyfrom.Bug-7186.SQL.py
rename to sql/test/BugTracker-2021/Tests/copyinto-copyfrom.Bug-7186.test.in
--- a/sql/test/BugTracker-2021/Tests/copyinto-copyfrom.Bug-7186.SQL.py
+++ b/sql/test/BugTracker-2021/Tests/copyinto-copyfrom.Bug-7186.test.in
@@ -1,23 +1,18 @@
-import tempfile, os, shutil
-from MonetDBtesting.sqltest import SQLTestCase
-
-nexdir = tempfile.mkdtemp()
+statement ok
+START TRANSACTION
-try:
- temp_name = os.path.join(nexdir, 'myfile.csv').replace("\\", "\\\\")
- with SQLTestCase() as cli:
- cli.connect(username="monetdb", password="monetdb")
+statement ok
+CREATE TABLE "t" ("id" INTEGER,"name" VARCHAR(1024),"schema_id"
INTEGER,"query" VARCHAR(1048576),"type" SMALLINT,"system"
BOOLEAN,"commit_action" SMALLINT,"access" SMALLINT,"temporary" TINYINT)
+
+statement ok
+COPY SELECT
"id","name","schema_id","query","type","system","commit_action","access","temporary"
FROM sys.tables LIMIT 100 INTO '$QTSTTRGDIR/copyinto-copyfrom.csv' USING
DELIMITERS '|',E'\n','"'
- cli.execute("START TRANSACTION;").assertSucceeded()
- cli.execute("""
- CREATE TABLE "t" ("id" INTEGER,"name" VARCHAR(1024),"schema_id"
INTEGER,"query" VARCHAR(1048576),"type" SMALLINT,"system"
BOOLEAN,"commit_action" SMALLINT,"access" SMALLINT,"temporary" TINYINT);
- """).assertSucceeded()
- cli.execute("""
- COPY SELECT
"id","name","schema_id","query","type","system","commit_action","access","temporary"
FROM sys.tables LIMIT 100 INTO '%s' USING DELIMITERS '|',E'\n','"';
- """ % (temp_name)).assertSucceeded()
- cli.execute("COPY INTO t FROM '%s' USING DELIMITERS '|',E'\\n','\"';"
% (temp_name)).assertSucceeded()
- cli.execute("DROP TABLE t;").assertSucceeded()
- cli.execute("ROLLBACK;").assertSucceeded()
-finally:
- if os.path.exists(nexdir):
- shutil.rmtree(nexdir)
+statement ok
+COPY INTO t FROM '$QTSTTRGDIR/copyinto-copyfrom.csv' USING DELIMITERS
'|',E'\n','"'
+
+statement ok
+DROP TABLE t
+
+statement ok
+ROLLBACK
+
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
