Changeset: 205609cd3236 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/205609cd3236
Modified Files:
sql/test/Skyserver/Tests/Skyserver_constraints_v6.test
sql/test/Skyserver/Tests/Skyserver_dropConstraints_v6.test
sql/test/Skyserver/Tests/Skyserver_dropFunctions.test
sql/test/Skyserver/Tests/Skyserver_dropFunctions_v6.test
sql/test/Skyserver/Tests/Skyserver_dropTables_v6.test
sql/test/Skyserver/Tests/Skyserver_dropViews_v6.test
sql/test/Skyserver/Tests/Skyserver_functions.test
sql/test/Skyserver/Tests/Skyserver_functions_v6.test
sql/test/Skyserver/Tests/Skyserver_import.test.in
sql/test/Skyserver/Tests/Skyserver_import_v6.test.in
sql/test/Skyserver/Tests/Skyserver_tables_v6.test
sql/test/Skyserver/Tests/Skyserver_views.test
sql/test/Skyserver/Tests/Skyserver_views_v6.test
Branch: Jan2022
Log Message:
Speed up skyserver tests by running within a single transaction
diffs (208 lines):
diff --git a/sql/test/Skyserver/Tests/Skyserver_constraints_v6.test
b/sql/test/Skyserver/Tests/Skyserver_constraints_v6.test
--- a/sql/test/Skyserver/Tests/Skyserver_constraints_v6.test
+++ b/sql/test/Skyserver/Tests/Skyserver_constraints_v6.test
@@ -1,3 +1,6 @@
+statement ok
+START TRANSACTION
+
statement ok
ALTER TABLE Ap7Mag ADD CONSTRAINT fk_Ap7Mag_objID_PhotoObjAll_objI FOREIGN
KEY(objID)
REFERENCES PhotoObjAll (objID)
@@ -262,3 +265,5 @@ statement ok
ALTER TABLE Zone ADD CONSTRAINT fk_Zone_objID_PhotoObjAll_objID FOREIGN
KEY(objID)
REFERENCES PhotoObjAll (objID)
+statement ok
+COMMIT
diff --git a/sql/test/Skyserver/Tests/Skyserver_dropConstraints_v6.test
b/sql/test/Skyserver/Tests/Skyserver_dropConstraints_v6.test
--- a/sql/test/Skyserver/Tests/Skyserver_dropConstraints_v6.test
+++ b/sql/test/Skyserver/Tests/Skyserver_dropConstraints_v6.test
@@ -1,3 +1,6 @@
+statement ok
+START TRANSACTION
+
statement ok
ALTER TABLE Ap7Mag DROP CONSTRAINT fk_Ap7Mag_objID_PhotoObjAll_objI
@@ -196,3 +199,5 @@ ALTER TABLE XCRedshift DROP CONSTRAINT
statement ok
ALTER TABLE Zone DROP CONSTRAINT fk_Zone_objID_PhotoObjAll_objID
+statement ok
+COMMIT
diff --git a/sql/test/Skyserver/Tests/Skyserver_dropFunctions.test
b/sql/test/Skyserver/Tests/Skyserver_dropFunctions.test
--- a/sql/test/Skyserver/Tests/Skyserver_dropFunctions.test
+++ b/sql/test/Skyserver/Tests/Skyserver_dropFunctions.test
@@ -1,3 +1,6 @@
+statement ok
+START TRANSACTION
+
statement ok
DROP FUNCTION fDocColumnsWithRank
@@ -329,3 +332,5 @@ DROP FUNCTION fIndexName
statement ok
DROP FUNCTION fTileFileName
+statement ok
+COMMIT
diff --git a/sql/test/Skyserver/Tests/Skyserver_dropFunctions_v6.test
b/sql/test/Skyserver/Tests/Skyserver_dropFunctions_v6.test
--- a/sql/test/Skyserver/Tests/Skyserver_dropFunctions_v6.test
+++ b/sql/test/Skyserver/Tests/Skyserver_dropFunctions_v6.test
@@ -1,3 +1,6 @@
+statement ok
+START TRANSACTION
+
statement ok
DROP FUNCTION fGetUrlExpEq
@@ -367,3 +370,5 @@ DROP FUNCTION fField
statement ok
DROP FUNCTION fObj
+statement ok
+COMMIT
diff --git a/sql/test/Skyserver/Tests/Skyserver_dropTables_v6.test
b/sql/test/Skyserver/Tests/Skyserver_dropTables_v6.test
--- a/sql/test/Skyserver/Tests/Skyserver_dropTables_v6.test
+++ b/sql/test/Skyserver/Tests/Skyserver_dropTables_v6.test
@@ -1,3 +1,6 @@
+statement ok
+START TRANSACTION
+
statement ok
DROP TABLE Algorithm
@@ -268,3 +271,5 @@ DROP TABLE XCRedshift
statement ok
DROP TABLE Zone
+statement ok
+COMMIT
diff --git a/sql/test/Skyserver/Tests/Skyserver_dropViews_v6.test
b/sql/test/Skyserver/Tests/Skyserver_dropViews_v6.test
--- a/sql/test/Skyserver/Tests/Skyserver_dropViews_v6.test
+++ b/sql/test/Skyserver/Tests/Skyserver_dropViews_v6.test
@@ -1,3 +1,6 @@
+statement ok
+START TRANSACTION
+
statement ok
DROP VIEW CoordType
@@ -151,3 +154,5 @@ DROP VIEW PhotoPrimary
statement ok
DROP VIEW PhotoTag
+statement ok
+COMMIT
diff --git a/sql/test/Skyserver/Tests/Skyserver_functions.test
b/sql/test/Skyserver/Tests/Skyserver_functions.test
--- a/sql/test/Skyserver/Tests/Skyserver_functions.test
+++ b/sql/test/Skyserver/Tests/Skyserver_functions.test
@@ -1,3 +1,6 @@
+statement ok
+START TRANSACTION
+
statement ok
CREATE FUNCTION fSkyVersion(ObjID bigint)
RETURNS INT
@@ -1945,3 +1948,5 @@ BEGIN
RETURN link || runn || '/' || rerunn ||
'/objcs/'||camcoll||'/fpM-'||run6||'-'||filter||camcoll||'-'||fieldd||'.fit.gz';
END
+statement ok
+COMMIT
diff --git a/sql/test/Skyserver/Tests/Skyserver_functions_v6.test
b/sql/test/Skyserver/Tests/Skyserver_functions_v6.test
--- a/sql/test/Skyserver/Tests/Skyserver_functions_v6.test
+++ b/sql/test/Skyserver/Tests/Skyserver_functions_v6.test
@@ -1,3 +1,6 @@
+statement ok
+START TRANSACTION
+
statement ok
CREATE FUNCTION fSkyVersion(ObjID bigint)
RETURNS INT
@@ -2259,3 +2262,5 @@ begin
|| ltrim(cast (round(ra,6) as varchar(10))) || '&"dec"=' ||
ltrim(cast(round("dec",6) as varchar(10)));
end
+statement ok
+COMMIT
diff --git a/sql/test/Skyserver/Tests/Skyserver_import.test.in
b/sql/test/Skyserver/Tests/Skyserver_import.test.in
--- a/sql/test/Skyserver/Tests/Skyserver_import.test.in
+++ b/sql/test/Skyserver/Tests/Skyserver_import.test.in
@@ -1,3 +1,6 @@
+statement ok
+START TRANSACTION
+
statement ok
SET SCHEMA "skyserver"
@@ -237,3 +240,5 @@ COPY 1000 RECORDS INTO FileGroupMap FROM
statement ok
COPY 1000 RECORDS INTO Chunk FROM '$QTSTSRCDIR/../microsky/Chunk.dat.bz2'
USING DELIMITERS E'\t', E'\n', '"'
+statement ok
+COMMIT
diff --git a/sql/test/Skyserver/Tests/Skyserver_import_v6.test.in
b/sql/test/Skyserver/Tests/Skyserver_import_v6.test.in
--- a/sql/test/Skyserver/Tests/Skyserver_import_v6.test.in
+++ b/sql/test/Skyserver/Tests/Skyserver_import_v6.test.in
@@ -1,3 +1,6 @@
+statement ok
+START TRANSACTION
+
statement ok
SET SCHEMA "skyserver"
@@ -184,3 +187,5 @@ COPY 53 RECORDS INTO XCRedShift FROM '$Q
statement ok
COPY 91 RECORDS INTO Zone FROM '$QTSTSRCDIR/../microsky_v6/Zone.dat.bz2' USING
DELIMITERS E'\t', E'\n','"' NULL as 'NULL'
+statement ok
+COMMIT
diff --git a/sql/test/Skyserver/Tests/Skyserver_tables_v6.test
b/sql/test/Skyserver/Tests/Skyserver_tables_v6.test
--- a/sql/test/Skyserver/Tests/Skyserver_tables_v6.test
+++ b/sql/test/Skyserver/Tests/Skyserver_tables_v6.test
@@ -1,3 +1,6 @@
+statement ok
+START TRANSACTION
+
statement ok
CREATE TABLE Algorithm(
key varchar(128) NOT NULL,
@@ -4154,3 +4157,5 @@ CREATE TABLE spt_datatype_info(
"AUTO_INCREMENT" varchar(100)
)
+statement ok
+COMMIT
diff --git a/sql/test/Skyserver/Tests/Skyserver_views.test
b/sql/test/Skyserver/Tests/Skyserver_views.test
--- a/sql/test/Skyserver/Tests/Skyserver_views.test
+++ b/sql/test/Skyserver/Tests/Skyserver_views.test
@@ -1,3 +1,6 @@
+statement ok
+START TRANSACTION
+
statement ok
CREATE VIEW SpecObj
---------------------------------------------------------------
@@ -491,3 +494,5 @@ SELECT *
FROM PhotoPrimary
WHERE type not in (3,6,8)
+statement ok
+COMMIT
diff --git a/sql/test/Skyserver/Tests/Skyserver_views_v6.test
b/sql/test/Skyserver/Tests/Skyserver_views_v6.test
--- a/sql/test/Skyserver/Tests/Skyserver_views_v6.test
+++ b/sql/test/Skyserver/Tests/Skyserver_views_v6.test
@@ -1,3 +1,6 @@
+statement ok
+START TRANSACTION
+
statement ok
CREATE VIEW CoordType
AS
@@ -489,3 +492,5 @@ SELECT *
FROM PhotoTag g
WHERE type = 3 and mode=1
+statement ok
+COMMIT
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
