public inbox for [email protected]
help / color / mirror / Atom feedRESQL test cases for view node
2+ messages / 2 participants
[nested] [flat]
* RESQL test cases for view node
@ 2019-07-19 14:56 Usman Muzaffar <[email protected]>
0 siblings, 1 reply; 2+ messages in thread
From: Usman Muzaffar @ 2019-07-19 14:56 UTC (permalink / raw)
To: pgadmin-hackers
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"
+ }
+ }
+ ]
+}
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: RESQL test cases for view node
@ 2019-07-19 15:21 navnath gadakh <[email protected]>
parent: Usman Muzaffar <[email protected]>
0 siblings, 0 replies; 2+ messages in thread
From: navnath gadakh @ 2019-07-19 15:21 UTC (permalink / raw)
To: Usman Muzaffar <[email protected]>; +Cc: pgadmin-hackers
Usman, you used a view name like "testview_12345678", can you please use it
like "testview_$%{}[]()&*^!@""'`\/#" to cover special chars scenarios.
Thanks!
On Fri, Jul 19, 2019 at 8:27 PM Usman Muzaffar <
[email protected]> wrote:
> 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
>
--
*Regards,*
*Navnath Gadakh*
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2019-07-19 15:21 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2019-07-19 14:56 RESQL test cases for view node Usman Muzaffar <[email protected]>
2019-07-19 15:21 ` navnath gadakh <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox