public inbox for [email protected]  

help / color / mirror / Atom feed

From: Shubham Agarwal <[email protected]>
To: pgadmin-hackers <[email protected]>
Subject: Re: RE-SQL tests patch for FTS parsers node
Date: Mon, 2 Sep 2019 17:30:10 +0530
Message-ID: <CAKbCA9R0FKedXOVD8pUy6OkmbEyYH6dcfYrUxZenqMwvidVOtA@mail.gmail.com> (raw)
In-Reply-To: <CA+OCxowRhLXd3LdN+Q=4cgn-bOhJfN+s9SSe04E+RCJ=Vick3g@mail.gmail.com>
References: <CAKbCA9TAZb+zS78yt=NU0W3oyd7btbE5yiE4M1vq=AcNY6=qqA@mail.gmail.com>
	<CA+OCxowRhLXd3LdN+Q=4cgn-bOhJfN+s9SSe04E+RCJ=Vick3g@mail.gmail.com>

Hi Team,
PFA patch for  M-SQL test cases for FTS parsers.

Thanks & Regards,
Shubham Agarwal

On Mon, Jul 15, 2019 at 4:33 PM Dave Page <[email protected]> wrote:

> Thanks, applied.
>
> On Mon, Jul 15, 2019 at 11:42 AM Shubham Agarwal <
> [email protected]> wrote:
>
>> Hi Team,
>>
>> PFA patch for RE-SQL tests cases for FTS parsers node.
>>
>> --
>> Thanks & Regards,
>> Shubham Agarwal
>> EnterpriseDB Corporation
>>
>> The Postgres Database Company
>>
>
>
> --
> Dave Page
> Blog: http://pgsnake.blogspot.com
> Twitter: @pgsnake
>
> EnterpriseDB UK: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>


-- 
Thanks & Regards,
Shubham Agarwal
EnterpriseDB Corporation

The Postgres Database Company


Attachments:

  [application/octet-stream] fts_parser_msql.patch (3.0K, 3-fts_parser_msql.patch)
  download | inline diff:
diff --git a/web/pgadmin/browser/server_groups/servers/databases/schemas/fts_parsers/tests/default/alter_fts_parser_msql.sql b/web/pgadmin/browser/server_groups/servers/databases/schemas/fts_parsers/tests/default/alter_fts_parser_msql.sql
new file mode 100644
index 000000000..28dc5a225
--- /dev/null
+++ b/web/pgadmin/browser/server_groups/servers/databases/schemas/fts_parsers/tests/default/alter_fts_parser_msql.sql
@@ -0,0 +1,5 @@
+ALTER TEXT SEARCH PARSER public."test_fts_parser_$%{}[]()&*^!@""'`\/#"
+    RENAME TO "test_fts_parser_updated_$%{}[]()&*^!@""'`\/#";
+
+COMMENT ON TEXT SEARCH PARSER public."test_fts_parser_updated_$%{}[]()&*^!@""'`\/#"
+    IS 'Updating test fts parser';
diff --git a/web/pgadmin/browser/server_groups/servers/databases/schemas/fts_parsers/tests/default/create_fts_parser_msql.sql b/web/pgadmin/browser/server_groups/servers/databases/schemas/fts_parsers/tests/default/create_fts_parser_msql.sql
new file mode 100644
index 000000000..292d71d76
--- /dev/null
+++ b/web/pgadmin/browser/server_groups/servers/databases/schemas/fts_parsers/tests/default/create_fts_parser_msql.sql
@@ -0,0 +1,9 @@
+CREATE TEXT SEARCH PARSER public."test_fts_parser_$%{}[]()&*^!@""'`\/#" (
+    START = prsd_start,
+    GETTOKEN = prsd_nexttoken,
+    END = void_recv,
+    LEXTYPES = dispell_init,
+    HEADLINE = prsd_headline);
+
+COMMENT ON TEXT SEARCH PARSER public."test_fts_parser_$%{}[]()&*^!@""'`\/#"
+      IS 'Creating test fts parser';
diff --git a/web/pgadmin/browser/server_groups/servers/databases/schemas/fts_parsers/tests/default/test.json b/web/pgadmin/browser/server_groups/servers/databases/schemas/fts_parsers/tests/default/test.json
index d4de910de..fd8be86c6 100644
--- a/web/pgadmin/browser/server_groups/servers/databases/schemas/fts_parsers/tests/default/test.json
+++ b/web/pgadmin/browser/server_groups/servers/databases/schemas/fts_parsers/tests/default/test.json
@@ -5,6 +5,7 @@
       "name": "Create FTS parser",
       "endpoint": "NODE-fts_parser.obj",
       "sql_endpoint": "NODE-fts_parser.sql_id",
+      "msql_endpoint": "NODE-fts_parser.msql",
       "data": {
         "name": "test_fts_parser_$%{}[]()&*^!@\"'`\\/#",
         "description": "Creating test fts parser",
@@ -16,17 +17,20 @@
         "prslextype": "dispell_init",
         "prsheadline": "prsd_headline"
       },
-      "expected_sql_file": "create_fts_parser.sql"
+      "expected_sql_file": "create_fts_parser.sql",
+      "expected_msql_file": "create_fts_parser_msql.sql"
     },
     {
       "type": "alter",
       "name": "Alter FTS parser",
       "endpoint": "NODE-fts_parser.obj_id",
       "sql_endpoint": "NODE-fts_parser.sql_id",
+      "msql_endpoint": "NODE-fts_parser.msql_id",
       "data":{
         "name": "test_fts_parser_updated_$%{}[]()&*^!@\"'`\\/#",
         "description":"Updating test fts parser"},
-      "expected_sql_file": "alter_fts_parser.sql"
+      "expected_sql_file": "alter_fts_parser.sql",
+      "expected_msql_file": "alter_fts_parser_msql.sql"
     },
     {
       "type": "delete",

view thread (4+ 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 tests patch for FTS parsers node
  In-Reply-To: <CAKbCA9R0FKedXOVD8pUy6OkmbEyYH6dcfYrUxZenqMwvidVOtA@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