public inbox for [email protected]
help / color / mirror / Atom feedFrom: Usman Muzaffar <[email protected]>
To: pgadmin-hackers <[email protected]>
Subject: RESQL test cases for view node
Date: Fri, 19 Jul 2019 19:56:49 +0500
Message-ID: <CAOiUKEOPk=_XYjp0JAoeUb-cwnD9dop0C08+7SL=SdRnH5OL8A@mail.gmail.com> (raw)
Hi Hackers,
Please find here attached patch for reverse engineering test cases for view
node.
Please review it and give your feedback.
--
Thanks,
Usman Muzaffar
QA Team
EnterpriseDB Corporation
Attachments:
[application/octet-stream] view_node_reverse_sql_testcase_v1.patch (12.2K, 3-view_node_reverse_sql_testcase_v1.patch)
download | inline diff:
diff --git a/web/pgadmin/browser/server_groups/servers/databases/schemas/views/tests/pg/9.4_plus/alter_view.sql b/web/pgadmin/browser/server_groups/servers/databases/schemas/views/tests/pg/9.4_plus/alter_view.sql
new file mode 100644
index 00000000..1086b3cf
--- /dev/null
+++ b/web/pgadmin/browser/server_groups/servers/databases/schemas/views/tests/pg/9.4_plus/alter_view.sql
@@ -0,0 +1,10 @@
+-- View: public.testview_12345678
+
+-- DROP VIEW public.testview_12345678;
+
+CREATE OR REPLACE VIEW public.testview_12345678 AS
+ SELECT test_view_table.col1
+ FROM test_view_table;
+
+ALTER TABLE public.testview_12345678
+ OWNER TO postgres;
diff --git a/web/pgadmin/browser/server_groups/servers/databases/schemas/views/tests/pg/9.4_plus/create_table.sql b/web/pgadmin/browser/server_groups/servers/databases/schemas/views/tests/pg/9.4_plus/create_table.sql
new file mode 100644
index 00000000..d6694411
--- /dev/null
+++ b/web/pgadmin/browser/server_groups/servers/databases/schemas/views/tests/pg/9.4_plus/create_table.sql
@@ -0,0 +1,15 @@
+-- Table: public.test_view_table
+
+-- DROP TABLE public.test_view_table;
+
+CREATE TABLE public.test_view_table
+(
+ col1 integer
+)
+WITH (
+ OIDS = FALSE
+)
+TABLESPACE pg_default;
+
+ALTER TABLE public.test_view_table
+ OWNER to postgres;
diff --git a/web/pgadmin/browser/server_groups/servers/databases/schemas/views/tests/pg/9.4_plus/create_view.sql b/web/pgadmin/browser/server_groups/servers/databases/schemas/views/tests/pg/9.4_plus/create_view.sql
new file mode 100644
index 00000000..1086b3cf
--- /dev/null
+++ b/web/pgadmin/browser/server_groups/servers/databases/schemas/views/tests/pg/9.4_plus/create_view.sql
@@ -0,0 +1,10 @@
+-- View: public.testview_12345678
+
+-- DROP VIEW public.testview_12345678;
+
+CREATE OR REPLACE VIEW public.testview_12345678 AS
+ SELECT test_view_table.col1
+ FROM test_view_table;
+
+ALTER TABLE public.testview_12345678
+ OWNER TO postgres;
diff --git a/web/pgadmin/browser/server_groups/servers/databases/schemas/views/tests/pg/9.4_plus/tests.json b/web/pgadmin/browser/server_groups/servers/databases/schemas/views/tests/pg/9.4_plus/tests.json
new file mode 100644
index 00000000..ffa98404
--- /dev/null
+++ b/web/pgadmin/browser/server_groups/servers/databases/schemas/views/tests/pg/9.4_plus/tests.json
@@ -0,0 +1,70 @@
+{
+ "scenarios": [
+ {
+ "type": "create",
+ "name": "Create Table for view",
+ "endpoint": "NODE-table.obj",
+ "sql_endpoint": "NODE-table.sql_id",
+ "data": {
+ "name": "test_view_table",
+ "check_constraint": [],
+ "coll_inherits": "[]",
+ "columns": [
+ {
+ "name": "col1",
+ "cltype": "integer"
+ }
+ ],
+ "name": "test_view_table",
+ "schema": "public"
+ },
+ "expected_sql_file": "create_table.sql"
+ },
+ {
+ "type": "create",
+ "name": "Create View",
+ "endpoint": "NODE-view.obj",
+ "sql_endpoint": "NODE-view.sql_id",
+ "data": {
+ "definition": "select col1 from test_view_table;",
+ "name": "testview_12345678",
+ "owner": "postgres",
+ "schema": "public"
+ },
+ "expected_sql_file": "create_view.sql"
+ },
+ {
+ "type": "alter",
+ "name": "Alter View",
+ "endpoint": "NODE-view.obj_id",
+ "sql_endpoint": "NODE-view.sql_id",
+ "data": {
+ "definition": "select col1 from test_view_table;",
+ "name": "testview_12345678",
+ "owner": "postgres",
+ "schema": "public"
+ },
+ "expected_sql_file": "alter_view.sql"
+ },
+ {
+ "type": "delete",
+ "name": "Drop view",
+ "endpoint": "NODE-view.obj_id",
+ "data": {
+ "name": "testview_12345678",
+ "owner": "postgres",
+ "schema": "public"
+ }
+ },
+ {
+ "type": "delete",
+ "name": "Drop Table for view",
+ "endpoint": "NODE-table.obj_id",
+ "data": {
+ "name": "test_view_table",
+ "owner": "postgres",
+ "schema": "public"
+ }
+ }
+ ]
+}
diff --git a/web/pgadmin/browser/server_groups/servers/databases/schemas/views/tests/pg/9.6_plus/alter_view.sql b/web/pgadmin/browser/server_groups/servers/databases/schemas/views/tests/pg/9.6_plus/alter_view.sql
new file mode 100644
index 00000000..1086b3cf
--- /dev/null
+++ b/web/pgadmin/browser/server_groups/servers/databases/schemas/views/tests/pg/9.6_plus/alter_view.sql
@@ -0,0 +1,10 @@
+-- View: public.testview_12345678
+
+-- DROP VIEW public.testview_12345678;
+
+CREATE OR REPLACE VIEW public.testview_12345678 AS
+ SELECT test_view_table.col1
+ FROM test_view_table;
+
+ALTER TABLE public.testview_12345678
+ OWNER TO postgres;
diff --git a/web/pgadmin/browser/server_groups/servers/databases/schemas/views/tests/pg/9.6_plus/create_table.sql b/web/pgadmin/browser/server_groups/servers/databases/schemas/views/tests/pg/9.6_plus/create_table.sql
new file mode 100644
index 00000000..d6694411
--- /dev/null
+++ b/web/pgadmin/browser/server_groups/servers/databases/schemas/views/tests/pg/9.6_plus/create_table.sql
@@ -0,0 +1,15 @@
+-- Table: public.test_view_table
+
+-- DROP TABLE public.test_view_table;
+
+CREATE TABLE public.test_view_table
+(
+ col1 integer
+)
+WITH (
+ OIDS = FALSE
+)
+TABLESPACE pg_default;
+
+ALTER TABLE public.test_view_table
+ OWNER to postgres;
diff --git a/web/pgadmin/browser/server_groups/servers/databases/schemas/views/tests/pg/9.6_plus/create_view.sql b/web/pgadmin/browser/server_groups/servers/databases/schemas/views/tests/pg/9.6_plus/create_view.sql
new file mode 100644
index 00000000..1086b3cf
--- /dev/null
+++ b/web/pgadmin/browser/server_groups/servers/databases/schemas/views/tests/pg/9.6_plus/create_view.sql
@@ -0,0 +1,10 @@
+-- View: public.testview_12345678
+
+-- DROP VIEW public.testview_12345678;
+
+CREATE OR REPLACE VIEW public.testview_12345678 AS
+ SELECT test_view_table.col1
+ FROM test_view_table;
+
+ALTER TABLE public.testview_12345678
+ OWNER TO postgres;
diff --git a/web/pgadmin/browser/server_groups/servers/databases/schemas/views/tests/pg/9.6_plus/tests.json b/web/pgadmin/browser/server_groups/servers/databases/schemas/views/tests/pg/9.6_plus/tests.json
new file mode 100644
index 00000000..ffa98404
--- /dev/null
+++ b/web/pgadmin/browser/server_groups/servers/databases/schemas/views/tests/pg/9.6_plus/tests.json
@@ -0,0 +1,70 @@
+{
+ "scenarios": [
+ {
+ "type": "create",
+ "name": "Create Table for view",
+ "endpoint": "NODE-table.obj",
+ "sql_endpoint": "NODE-table.sql_id",
+ "data": {
+ "name": "test_view_table",
+ "check_constraint": [],
+ "coll_inherits": "[]",
+ "columns": [
+ {
+ "name": "col1",
+ "cltype": "integer"
+ }
+ ],
+ "name": "test_view_table",
+ "schema": "public"
+ },
+ "expected_sql_file": "create_table.sql"
+ },
+ {
+ "type": "create",
+ "name": "Create View",
+ "endpoint": "NODE-view.obj",
+ "sql_endpoint": "NODE-view.sql_id",
+ "data": {
+ "definition": "select col1 from test_view_table;",
+ "name": "testview_12345678",
+ "owner": "postgres",
+ "schema": "public"
+ },
+ "expected_sql_file": "create_view.sql"
+ },
+ {
+ "type": "alter",
+ "name": "Alter View",
+ "endpoint": "NODE-view.obj_id",
+ "sql_endpoint": "NODE-view.sql_id",
+ "data": {
+ "definition": "select col1 from test_view_table;",
+ "name": "testview_12345678",
+ "owner": "postgres",
+ "schema": "public"
+ },
+ "expected_sql_file": "alter_view.sql"
+ },
+ {
+ "type": "delete",
+ "name": "Drop view",
+ "endpoint": "NODE-view.obj_id",
+ "data": {
+ "name": "testview_12345678",
+ "owner": "postgres",
+ "schema": "public"
+ }
+ },
+ {
+ "type": "delete",
+ "name": "Drop Table for view",
+ "endpoint": "NODE-table.obj_id",
+ "data": {
+ "name": "test_view_table",
+ "owner": "postgres",
+ "schema": "public"
+ }
+ }
+ ]
+}
diff --git a/web/pgadmin/browser/server_groups/servers/databases/schemas/views/tests/ppas/9.4_plus/alter_view.sql b/web/pgadmin/browser/server_groups/servers/databases/schemas/views/tests/ppas/9.4_plus/alter_view.sql
new file mode 100644
index 00000000..65b3a518
--- /dev/null
+++ b/web/pgadmin/browser/server_groups/servers/databases/schemas/views/tests/ppas/9.4_plus/alter_view.sql
@@ -0,0 +1,10 @@
+-- View: public.testview_12345678
+
+-- DROP VIEW public.testview_12345678;
+
+CREATE OR REPLACE VIEW public.testview_12345678 AS
+ SELECT test_view_table.col1
+ FROM test_view_table;
+
+ALTER TABLE public.testview_12345678
+ OWNER TO enterprisedb;
diff --git a/web/pgadmin/browser/server_groups/servers/databases/schemas/views/tests/ppas/9.4_plus/create_table.sql b/web/pgadmin/browser/server_groups/servers/databases/schemas/views/tests/ppas/9.4_plus/create_table.sql
new file mode 100644
index 00000000..13dfdd0d
--- /dev/null
+++ b/web/pgadmin/browser/server_groups/servers/databases/schemas/views/tests/ppas/9.4_plus/create_table.sql
@@ -0,0 +1,15 @@
+-- Table: public.test_view_table
+
+-- DROP TABLE public.test_view_table;
+
+CREATE TABLE public.test_view_table
+(
+ col1 integer
+)
+WITH (
+ OIDS = FALSE
+)
+TABLESPACE pg_default;
+
+ALTER TABLE public.test_view_table
+ OWNER to enterprisedb;
diff --git a/web/pgadmin/browser/server_groups/servers/databases/schemas/views/tests/ppas/9.4_plus/create_view.sql b/web/pgadmin/browser/server_groups/servers/databases/schemas/views/tests/ppas/9.4_plus/create_view.sql
new file mode 100644
index 00000000..65b3a518
--- /dev/null
+++ b/web/pgadmin/browser/server_groups/servers/databases/schemas/views/tests/ppas/9.4_plus/create_view.sql
@@ -0,0 +1,10 @@
+-- View: public.testview_12345678
+
+-- DROP VIEW public.testview_12345678;
+
+CREATE OR REPLACE VIEW public.testview_12345678 AS
+ SELECT test_view_table.col1
+ FROM test_view_table;
+
+ALTER TABLE public.testview_12345678
+ OWNER TO enterprisedb;
diff --git a/web/pgadmin/browser/server_groups/servers/databases/schemas/views/tests/ppas/9.4_plus/tests.json b/web/pgadmin/browser/server_groups/servers/databases/schemas/views/tests/ppas/9.4_plus/tests.json
new file mode 100644
index 00000000..93f027ca
--- /dev/null
+++ b/web/pgadmin/browser/server_groups/servers/databases/schemas/views/tests/ppas/9.4_plus/tests.json
@@ -0,0 +1,70 @@
+{
+ "scenarios": [
+ {
+ "type": "create",
+ "name": "Create Table for view",
+ "endpoint": "NODE-table.obj",
+ "sql_endpoint": "NODE-table.sql_id",
+ "data":{
+ "name":"test_view_table",
+ "check_constraint": [],
+ "coll_inherits": "[]",
+ "columns": [
+ {
+ "name": "col1",
+ "cltype": "integer"
+ }
+ ],
+ "name": "test_view_table",
+ "schema": "public"
+ },
+ "expected_sql_file": "create_table.sql"
+ },
+ {
+ "type": "create",
+ "name": "Create View",
+ "endpoint": "NODE-view.obj",
+ "sql_endpoint": "NODE-view.sql_id",
+ "data": {
+ "definition": "select col1 from test_view_table;",
+ "name": "testview_12345678",
+ "owner": "enterprisedb",
+ "schema": "public"
+ },
+ "expected_sql_file": "create_view.sql"
+ },
+ {
+ "type": "alter",
+ "name": "Alter View",
+ "endpoint": "NODE-view.obj_id",
+ "sql_endpoint": "NODE-view.sql_id",
+ "data": {
+ "definition": "select col1 from test_view_table;",
+ "name": "testview_12345678",
+ "owner": "enterprisedb",
+ "schema": "public"
+ },
+ "expected_sql_file": "alter_view.sql"
+ },
+ {
+ "type": "delete",
+ "name": "Drop view",
+ "endpoint": "NODE-view.obj_id",
+ "data": {
+ "name": "testview_12345678",
+ "owner": "enterprisedb",
+ "schema": "public"
+ }
+ },
+ {
+ "type": "delete",
+ "name": "Drop Table for view",
+ "endpoint": "NODE-view.obj_id",
+ "data": {
+ "name": "testview_123456781",
+ "owner": "enterprisedb",
+ "schema": "public"
+ }
+ }
+ ]
+}
view thread (2+ 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: RESQL test cases for view node
In-Reply-To: <CAOiUKEOPk=_XYjp0JAoeUb-cwnD9dop0C08+7SL=SdRnH5OL8A@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