public inbox for [email protected]  

help / color / mirror / Atom feed

From: Nagesh Dhope <[email protected]>
To: [email protected]
Subject: RE-SQL test patch for extension node
Date: Fri, 5 Jul 2019 19:44:56 +0530
Message-ID: <CAA3zdZo_bNe=140wpy4tLkR3qHWY9xL--ymf=yKaab6-Z98OMw@mail.gmail.com> (raw)

Hi Hackers,
Please review attached patch for RE-SQL test cases for *extension* node.

Thanks,
Nagesh Dhope


Attachments:

  [application/octet-stream] extension_resql_tests.patch (4.1K, 3-extension_resql_tests.patch)
  download | inline diff:
diff --git a/web/pgadmin/browser/server_groups/servers/databases/extensions/tests/default/alter_extension_schema.sql b/web/pgadmin/browser/server_groups/servers/databases/extensions/tests/default/alter_extension_schema.sql
new file mode 100644
index 0000000..28fb182
--- /dev/null
+++ b/web/pgadmin/browser/server_groups/servers/databases/extensions/tests/default/alter_extension_schema.sql
@@ -0,0 +1,7 @@
+-- Extension: timetravel
+
+-- DROP EXTENSION timetravel;
+
+CREATE EXTENSION timetravel
+    SCHEMA test_extension_schema
+    VERSION "1.0";
diff --git a/web/pgadmin/browser/server_groups/servers/databases/extensions/tests/default/alter_extension_version.sql b/web/pgadmin/browser/server_groups/servers/databases/extensions/tests/default/alter_extension_version.sql
new file mode 100644
index 0000000..6d193fb
--- /dev/null
+++ b/web/pgadmin/browser/server_groups/servers/databases/extensions/tests/default/alter_extension_version.sql
@@ -0,0 +1,7 @@
+-- Extension: adminpack
+
+-- DROP EXTENSION adminpack;
+
+CREATE EXTENSION adminpack
+    SCHEMA pg_catalog
+    VERSION "1.1";
diff --git a/web/pgadmin/browser/server_groups/servers/databases/extensions/tests/default/create_extension_with_all_options.sql b/web/pgadmin/browser/server_groups/servers/databases/extensions/tests/default/create_extension_with_all_options.sql
new file mode 100644
index 0000000..0617532
--- /dev/null
+++ b/web/pgadmin/browser/server_groups/servers/databases/extensions/tests/default/create_extension_with_all_options.sql
@@ -0,0 +1,7 @@
+-- Extension: timetravel
+
+-- DROP EXTENSION timetravel;
+
+CREATE EXTENSION timetravel
+    SCHEMA public
+    VERSION "1.0";
diff --git a/web/pgadmin/browser/server_groups/servers/databases/extensions/tests/default/create_extension_with_default_schema.sql b/web/pgadmin/browser/server_groups/servers/databases/extensions/tests/default/create_extension_with_default_schema.sql
new file mode 100644
index 0000000..a9a61d4
--- /dev/null
+++ b/web/pgadmin/browser/server_groups/servers/databases/extensions/tests/default/create_extension_with_default_schema.sql
@@ -0,0 +1,7 @@
+-- Extension: adminpack
+
+-- DROP EXTENSION adminpack;
+
+CREATE EXTENSION adminpack
+    SCHEMA pg_catalog
+    VERSION "1.0";
diff --git a/web/pgadmin/browser/server_groups/servers/databases/extensions/tests/default/tests.json b/web/pgadmin/browser/server_groups/servers/databases/extensions/tests/default/tests.json
new file mode 100644
index 0000000..fff75f8
--- /dev/null
+++ b/web/pgadmin/browser/server_groups/servers/databases/extensions/tests/default/tests.json
@@ -0,0 +1,59 @@
+{
+  "scenarios": [
+    {
+      "type": "create",
+      "name": "Create Extension with all options",
+      "endpoint": "NODE-extension.obj",
+      "sql_endpoint": "NODE-extension.sql_id",
+      "data": {
+        "name": "timetravel",
+        "schema": "public",
+        "version": "1.0"
+      },
+      "expected_sql_file": "create_extension_with_all_options.sql"
+    },
+    {
+      "type": "alter",
+      "name": "Alter Extension version",
+      "endpoint": "NODE-extension.obj_id",
+      "sql_endpoint": "NODE-extension.sql_id",
+      "data": {
+        "schema": "test_extension_schema"
+      },
+      "expected_sql_file": "alter_extension_schema.sql"
+    },
+    {
+      "type": "delete",
+      "name": "Drop Extension with all options",
+      "endpoint": "NODE-extension.obj_id",
+      "data": {}
+    },
+    {
+      "type": "create",
+      "name": "Create Extension with default(pg_catalog) schema",
+      "endpoint": "NODE-extension.obj",
+      "sql_endpoint": "NODE-extension.sql_id",
+      "data": {
+        "name": "adminpack",
+        "version": "1.0"
+      },
+      "expected_sql_file": "create_extension_with_default_schema.sql"
+    },
+    {
+      "type": "alter",
+      "name": "Alter Extension version",
+      "endpoint": "NODE-extension.obj_id",
+      "sql_endpoint": "NODE-extension.sql_id",
+      "data": {
+        "version": "1.1"
+      },
+      "expected_sql_file": "alter_extension_version.sql"
+    },
+    {
+      "type": "delete",
+      "name": "Drop Extension default(pg_catalog) schema",
+      "endpoint": "NODE-extension.obj_id",
+      "data": {}
+    }
+  ]
+}

view thread (7+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected]
  Subject: Re: RE-SQL test patch for extension node
  In-Reply-To: <CAA3zdZo_bNe=140wpy4tLkR3qHWY9xL--ymf=yKaab6-Z98OMw@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox