public inbox for [email protected]
help / color / mirror / Atom feed[pgAdmin4][patch] Reverse engineering sql test cases for FTS configuration
2+ messages / 2 participants
[nested] [flat]
* [pgAdmin4][patch] Reverse engineering sql test cases for FTS configuration
@ 2019-07-09 11:50 Ganesh Jaybhay <[email protected]>
2019-07-09 16:03 ` Re: [pgAdmin4][patch] Reverse engineering sql test cases for FTS configuration Dave Page <[email protected]>
0 siblings, 1 reply; 2+ messages in thread
From: Ganesh Jaybhay @ 2019-07-09 11:50 UTC (permalink / raw)
To: pgadmin-hackers
Hi Hackers,
Please find the attached patch for reverse engineering sql test cases of
FTS configuration.
Kindly review.
Regards,
Ganesh Jaybhay
Attachments:
[application/octet-stream] re_sql_fts_configuration.patch (12.6K, 3-re_sql_fts_configuration.patch)
download | inline diff:
diff --git a/web/pgadmin/browser/server_groups/servers/databases/schemas/fts_configurations/tests/default/alter_fts_conf_add_comment.sql b/web/pgadmin/browser/server_groups/servers/databases/schemas/fts_configurations/tests/default/alter_fts_conf_add_comment.sql
new file mode 100644
index 0000000..8e9081a
--- /dev/null
+++ b/web/pgadmin/browser/server_groups/servers/databases/schemas/fts_configurations/tests/default/alter_fts_conf_add_comment.sql
@@ -0,0 +1,9 @@
+-- Text Search CONFIGURATION: test.test_fts_configuration_def1
+
+-- DROP TEXT SEARCH CONFIGURATION test.test_fts_configuration_def1
+
+CREATE TEXT SEARCH CONFIGURATION test.test_fts_configuration_def1 (
+ PARSER = default
+);
+
+COMMENT ON TEXT SEARCH CONFIGURATION test.test_fts_configuration_def1 IS 'test comment';
diff --git a/web/pgadmin/browser/server_groups/servers/databases/schemas/fts_configurations/tests/default/alter_fts_conf_add_token.sql b/web/pgadmin/browser/server_groups/servers/databases/schemas/fts_configurations/tests/default/alter_fts_conf_add_token.sql
new file mode 100644
index 0000000..fcf1c10
--- /dev/null
+++ b/web/pgadmin/browser/server_groups/servers/databases/schemas/fts_configurations/tests/default/alter_fts_conf_add_token.sql
@@ -0,0 +1,10 @@
+-- Text Search CONFIGURATION: test.test_fts_configuration_def1
+
+-- DROP TEXT SEARCH CONFIGURATION test.test_fts_configuration_def1
+
+CREATE TEXT SEARCH CONFIGURATION test.test_fts_configuration_def1 (
+ PARSER = default
+);
+
+COMMENT ON TEXT SEARCH CONFIGURATION test.test_fts_configuration_def1 IS 'test comment';
+ALTER TEXT SEARCH CONFIGURATION test.test_fts_configuration_def1 ADD MAPPING FOR file WITH english_stem;
diff --git a/web/pgadmin/browser/server_groups/servers/databases/schemas/fts_configurations/tests/default/alter_fts_conf_remove_token.sql b/web/pgadmin/browser/server_groups/servers/databases/schemas/fts_configurations/tests/default/alter_fts_conf_remove_token.sql
new file mode 100644
index 0000000..130488b
--- /dev/null
+++ b/web/pgadmin/browser/server_groups/servers/databases/schemas/fts_configurations/tests/default/alter_fts_conf_remove_token.sql
@@ -0,0 +1,25 @@
+-- Text Search CONFIGURATION: test.test_fts_configuration_def2
+
+-- DROP TEXT SEARCH CONFIGURATION test.test_fts_configuration_def2
+
+CREATE TEXT SEARCH CONFIGURATION test.test_fts_configuration_def2 (
+ PARSER = default
+);
+ALTER TEXT SEARCH CONFIGURATION test.test_fts_configuration_def2 ADD MAPPING FOR asciihword WITH english_stem;
+ALTER TEXT SEARCH CONFIGURATION test.test_fts_configuration_def2 ADD MAPPING FOR asciiword WITH english_stem;
+ALTER TEXT SEARCH CONFIGURATION test.test_fts_configuration_def2 ADD MAPPING FOR email WITH simple;
+ALTER TEXT SEARCH CONFIGURATION test.test_fts_configuration_def2 ADD MAPPING FOR file WITH simple;
+ALTER TEXT SEARCH CONFIGURATION test.test_fts_configuration_def2 ADD MAPPING FOR float WITH simple;
+ALTER TEXT SEARCH CONFIGURATION test.test_fts_configuration_def2 ADD MAPPING FOR host WITH simple;
+ALTER TEXT SEARCH CONFIGURATION test.test_fts_configuration_def2 ADD MAPPING FOR hword WITH english_stem;
+ALTER TEXT SEARCH CONFIGURATION test.test_fts_configuration_def2 ADD MAPPING FOR hword_asciipart WITH english_stem;
+ALTER TEXT SEARCH CONFIGURATION test.test_fts_configuration_def2 ADD MAPPING FOR hword_numpart WITH simple;
+ALTER TEXT SEARCH CONFIGURATION test.test_fts_configuration_def2 ADD MAPPING FOR hword_part WITH english_stem;
+ALTER TEXT SEARCH CONFIGURATION test.test_fts_configuration_def2 ADD MAPPING FOR int WITH simple;
+ALTER TEXT SEARCH CONFIGURATION test.test_fts_configuration_def2 ADD MAPPING FOR numhword WITH simple;
+ALTER TEXT SEARCH CONFIGURATION test.test_fts_configuration_def2 ADD MAPPING FOR numword WITH simple;
+ALTER TEXT SEARCH CONFIGURATION test.test_fts_configuration_def2 ADD MAPPING FOR sfloat WITH simple;
+ALTER TEXT SEARCH CONFIGURATION test.test_fts_configuration_def2 ADD MAPPING FOR uint WITH simple;
+ALTER TEXT SEARCH CONFIGURATION test.test_fts_configuration_def2 ADD MAPPING FOR url WITH simple;
+ALTER TEXT SEARCH CONFIGURATION test.test_fts_configuration_def2 ADD MAPPING FOR url_path WITH simple;
+ALTER TEXT SEARCH CONFIGURATION test.test_fts_configuration_def2 ADD MAPPING FOR version WITH simple;
diff --git a/web/pgadmin/browser/server_groups/servers/databases/schemas/fts_configurations/tests/default/alter_fts_conf_rename.sql b/web/pgadmin/browser/server_groups/servers/databases/schemas/fts_configurations/tests/default/alter_fts_conf_rename.sql
new file mode 100644
index 0000000..6924617
--- /dev/null
+++ b/web/pgadmin/browser/server_groups/servers/databases/schemas/fts_configurations/tests/default/alter_fts_conf_rename.sql
@@ -0,0 +1,10 @@
+-- Text Search CONFIGURATION: test.test_fts_configuration
+
+-- DROP TEXT SEARCH CONFIGURATION test.test_fts_configuration
+
+CREATE TEXT SEARCH CONFIGURATION test.test_fts_configuration (
+ PARSER = default
+);
+
+COMMENT ON TEXT SEARCH CONFIGURATION test.test_fts_configuration IS 'test comment';
+ALTER TEXT SEARCH CONFIGURATION test.test_fts_configuration ADD MAPPING FOR file WITH english_stem;
diff --git a/web/pgadmin/browser/server_groups/servers/databases/schemas/fts_configurations/tests/default/create_fts_conf.sql b/web/pgadmin/browser/server_groups/servers/databases/schemas/fts_configurations/tests/default/create_fts_conf.sql
new file mode 100644
index 0000000..bbcf47d
--- /dev/null
+++ b/web/pgadmin/browser/server_groups/servers/databases/schemas/fts_configurations/tests/default/create_fts_conf.sql
@@ -0,0 +1,7 @@
+-- Text Search CONFIGURATION: test."test_fts_conf_$%{}[]()&*^!@""'`\/#"
+
+-- DROP TEXT SEARCH CONFIGURATION test."test_fts_conf_$%{}[]()&*^!@""'`\/#"
+
+CREATE TEXT SEARCH CONFIGURATION test."test_fts_conf_$%{}[]()&*^!@""'`\/#" (
+ PARSER = default
+);
diff --git a/web/pgadmin/browser/server_groups/servers/databases/schemas/fts_configurations/tests/default/create_fts_conf_def1.sql b/web/pgadmin/browser/server_groups/servers/databases/schemas/fts_configurations/tests/default/create_fts_conf_def1.sql
new file mode 100644
index 0000000..31f6c01
--- /dev/null
+++ b/web/pgadmin/browser/server_groups/servers/databases/schemas/fts_configurations/tests/default/create_fts_conf_def1.sql
@@ -0,0 +1,7 @@
+-- Text Search CONFIGURATION: test.test_fts_configuration_def1
+
+-- DROP TEXT SEARCH CONFIGURATION test.test_fts_configuration_def1
+
+CREATE TEXT SEARCH CONFIGURATION test.test_fts_configuration_def1 (
+ PARSER = default
+);
diff --git a/web/pgadmin/browser/server_groups/servers/databases/schemas/fts_configurations/tests/default/create_fts_conf_def2.sql b/web/pgadmin/browser/server_groups/servers/databases/schemas/fts_configurations/tests/default/create_fts_conf_def2.sql
new file mode 100644
index 0000000..07cd7b9
--- /dev/null
+++ b/web/pgadmin/browser/server_groups/servers/databases/schemas/fts_configurations/tests/default/create_fts_conf_def2.sql
@@ -0,0 +1,26 @@
+-- Text Search CONFIGURATION: test.test_fts_configuration_def2
+
+-- DROP TEXT SEARCH CONFIGURATION test.test_fts_configuration_def2
+
+CREATE TEXT SEARCH CONFIGURATION test.test_fts_configuration_def2 (
+ PARSER = default
+);
+ALTER TEXT SEARCH CONFIGURATION test.test_fts_configuration_def2 ADD MAPPING FOR asciihword WITH english_stem;
+ALTER TEXT SEARCH CONFIGURATION test.test_fts_configuration_def2 ADD MAPPING FOR asciiword WITH english_stem;
+ALTER TEXT SEARCH CONFIGURATION test.test_fts_configuration_def2 ADD MAPPING FOR email WITH simple;
+ALTER TEXT SEARCH CONFIGURATION test.test_fts_configuration_def2 ADD MAPPING FOR file WITH simple;
+ALTER TEXT SEARCH CONFIGURATION test.test_fts_configuration_def2 ADD MAPPING FOR float WITH simple;
+ALTER TEXT SEARCH CONFIGURATION test.test_fts_configuration_def2 ADD MAPPING FOR host WITH simple;
+ALTER TEXT SEARCH CONFIGURATION test.test_fts_configuration_def2 ADD MAPPING FOR hword WITH english_stem;
+ALTER TEXT SEARCH CONFIGURATION test.test_fts_configuration_def2 ADD MAPPING FOR hword_asciipart WITH english_stem;
+ALTER TEXT SEARCH CONFIGURATION test.test_fts_configuration_def2 ADD MAPPING FOR hword_numpart WITH simple;
+ALTER TEXT SEARCH CONFIGURATION test.test_fts_configuration_def2 ADD MAPPING FOR hword_part WITH english_stem;
+ALTER TEXT SEARCH CONFIGURATION test.test_fts_configuration_def2 ADD MAPPING FOR int WITH simple;
+ALTER TEXT SEARCH CONFIGURATION test.test_fts_configuration_def2 ADD MAPPING FOR numhword WITH simple;
+ALTER TEXT SEARCH CONFIGURATION test.test_fts_configuration_def2 ADD MAPPING FOR numword WITH simple;
+ALTER TEXT SEARCH CONFIGURATION test.test_fts_configuration_def2 ADD MAPPING FOR sfloat WITH simple;
+ALTER TEXT SEARCH CONFIGURATION test.test_fts_configuration_def2 ADD MAPPING FOR uint WITH simple;
+ALTER TEXT SEARCH CONFIGURATION test.test_fts_configuration_def2 ADD MAPPING FOR url WITH simple;
+ALTER TEXT SEARCH CONFIGURATION test.test_fts_configuration_def2 ADD MAPPING FOR url_path WITH simple;
+ALTER TEXT SEARCH CONFIGURATION test.test_fts_configuration_def2 ADD MAPPING FOR version WITH simple;
+ALTER TEXT SEARCH CONFIGURATION test.test_fts_configuration_def2 ADD MAPPING FOR word WITH english_stem;
diff --git a/web/pgadmin/browser/server_groups/servers/databases/schemas/fts_configurations/tests/default/test.json b/web/pgadmin/browser/server_groups/servers/databases/schemas/fts_configurations/tests/default/test.json
new file mode 100644
index 0000000..a1b7d38
--- /dev/null
+++ b/web/pgadmin/browser/server_groups/servers/databases/schemas/fts_configurations/tests/default/test.json
@@ -0,0 +1,99 @@
+{
+ "scenarios": [{
+ "type": "create",
+ "name": "Create FTS Configuration",
+ "endpoint": "NODE-fts_configuration.obj",
+ "sql_endpoint": "NODE-fts_configuration.sql_id",
+ "data": {
+ "name": "test_fts_conf_$%{}[]()&*^!@\"'`\\/#",
+ "schema": "test",
+ "schema_id": "<SCHEMA_ID>",
+ "prsname": "default",
+ "tokens": []
+ },
+ "expected_sql_file": "create_fts_conf.sql"
+ }, {
+ "type": "delete",
+ "name": "Drop FTS Configuration",
+ "endpoint": "NODE-fts_configuration.delete_id",
+ "data": {
+ "name": "test_fts_conf_$%{}[]()&*^!@\"'`\\/#"
+ }
+ }, {
+ "type": "create",
+ "name": "Create FTS Configuration with Parser",
+ "endpoint": "NODE-fts_configuration.obj",
+ "sql_endpoint": "NODE-fts_configuration.sql_id",
+ "data": {
+ "name": "test_fts_configuration_def1",
+ "schema": "test",
+ "schema_id": "<SCHEMA_ID>",
+ "prsname": "default",
+ "tokens": []
+ },
+ "expected_sql_file": "create_fts_conf_def1.sql"
+ }, {
+ "type": "alter",
+ "name": "Alter FTS Configuration add comment",
+ "endpoint": "NODE-fts_configuration.obj_id",
+ "sql_endpoint": "NODE-fts_configuration.sql_id",
+ "data": {
+ "description": "test comment"
+ },
+ "expected_sql_file": "alter_fts_conf_add_comment.sql"
+ }, {
+ "type": "alter",
+ "name": "Alter FTS Configuration add token file",
+ "endpoint": "NODE-fts_configuration.obj_id",
+ "sql_endpoint": "NODE-fts_configuration.sql_id",
+ "data": {
+ "tokens": {"added": [{"token": "file", "dictname": ["english_stem"]}]}
+ },
+ "expected_sql_file": "alter_fts_conf_add_token.sql"
+ }, {
+ "type": "alter",
+ "name": "Alter FTS Configuration Rename",
+ "endpoint": "NODE-fts_configuration.obj_id",
+ "sql_endpoint": "NODE-fts_configuration.sql_id",
+ "data": {
+ "name": "test_fts_configuration"
+ },
+ "expected_sql_file": "alter_fts_conf_rename.sql"
+ }, {
+ "type": "delete",
+ "name": "Drop FTS Configuration with parser",
+ "endpoint": "NODE-fts_configuration.delete_id",
+ "data": {
+ "name": "test_fts_configuration_def1"
+ }
+ }, {
+ "type": "create",
+ "name": "Create FTS Configuration with copy config",
+ "endpoint": "NODE-fts_configuration.obj",
+ "sql_endpoint": "NODE-fts_configuration.sql_id",
+ "data": {
+ "name": "test_fts_configuration_def2",
+ "schema": "test",
+ "schema_id": "<SCHEMA_ID>",
+ "copy_config": "english"
+ },
+ "expected_sql_file": "create_fts_conf_def2.sql"
+ }, {
+ "type": "alter",
+ "name": "Alter FTS Configuration remove token file",
+ "endpoint": "NODE-fts_configuration.obj_id",
+ "sql_endpoint": "NODE-fts_configuration.sql_id",
+ "data": {
+ "tokens": {"deleted": [{"token": "word", "dictname": ["english_stem"]}]}
+ },
+ "expected_sql_file": "alter_fts_conf_remove_token.sql"
+ }, {
+ "type": "delete",
+ "name": "Drop FTS Configuration with copy config",
+ "endpoint": "NODE-fts_configuration.delete_id",
+ "data": {
+ "name": "test_fts_configuration_def2"
+ }
+ }
+ ]
+}
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: [pgAdmin4][patch] Reverse engineering sql test cases for FTS configuration
2019-07-09 11:50 [pgAdmin4][patch] Reverse engineering sql test cases for FTS configuration Ganesh Jaybhay <[email protected]>
@ 2019-07-09 16:03 ` Dave Page <[email protected]>
0 siblings, 0 replies; 2+ messages in thread
From: Dave Page @ 2019-07-09 16:03 UTC (permalink / raw)
To: Ganesh Jaybhay <[email protected]>; +Cc: pgadmin-hackers
Thanks, committed.
On Tue, Jul 9, 2019 at 2:29 PM Ganesh Jaybhay <
[email protected]> wrote:
> Hi Hackers,
>
> Please find the attached patch for reverse engineering sql test cases of
> FTS configuration.
> Kindly review.
>
> Regards,
> Ganesh Jaybhay
>
--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2019-07-09 16:03 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2019-07-09 11:50 [pgAdmin4][patch] Reverse engineering sql test cases for FTS configuration Ganesh Jaybhay <[email protected]>
2019-07-09 16:03 ` Dave Page <[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