Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hhxFP-0008Dv-6a for pgadmin-hackers@arkaria.postgresql.org; Mon, 01 Jul 2019 14:25:35 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hhxFM-0002oo-10 for pgadmin-hackers@arkaria.postgresql.org; Mon, 01 Jul 2019 14:25:32 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hhxFL-0002mc-ET for pgadmin-hackers@lists.postgresql.org; Mon, 01 Jul 2019 14:25:31 +0000 Received: from mail-wm1-x344.google.com ([2a00:1450:4864:20::344]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hhxFH-000692-SK for pgadmin-hackers@postgresql.org; Mon, 01 Jul 2019 14:25:29 +0000 Received: by mail-wm1-x344.google.com with SMTP id u8so16155474wmm.1 for ; Mon, 01 Jul 2019 07:25:27 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=pgadmin.org; s=google; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=eLxnhMC/sDZl1ZrrNK50kY6ukzAfCPEnxErFBGjqc6o=; b=XOGoiLlM2gMHBR+0xZ7E7PV/ozBhR1W1WCeg60sRNRbrsxhxRNKviy7gpRM7hBEJ5a BxiJoVTU1TU4QXZh6HoQMbkkd9/poY0J5SEU0gnrup/k7ogYxKbPtvoMj7OhN+x/tLQ4 wYEyEx4/LNpIQG9JOHmbn+It/lTWQhVeGTX/fdmCe+gTjs+BbTSYGMm2UdSS4/oIRNM7 nEbC4SBAzCZcB87rRnO+7CGzPc9A0TYj89OeDavdviVezbhf88jaD5V2eqqEiw2N+fbF EgkKj/T9rXsDMlIlr+sI3RWF8BZXsr3hxesudpHJkvCm26XpG3Jh/q8zvxMAOoSHqQsE tFUQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=eLxnhMC/sDZl1ZrrNK50kY6ukzAfCPEnxErFBGjqc6o=; b=Tx+38UVAMPaWEd4u27uBqxjIUUSCKhflBjWZi70Y/16Tssaen7tf0rK1/U3uU+quEI 79Z0vlaza+xKkRYOx7n/WJnUd95PFYd9IdQxYSoXuBP3HRbg2+LTJRchP8eyRXDTpy1B 4/NIqrEh0ABAbk1pFEYgT4GXESSBze79JxwhmmWqIOUDR/W9e1Npv7eWzALOoK+BemSe 3QrQnFTyfNs0v8kjQcbqLpUmOMPOoIJd+5NmlLeOVDAzpKLw6tHBIA0NUUnTnqV+Cqms uVln1YyJKZzq9KNHW02Z87Kx2cz5jdup2PHzJ53g9DT1jYuNHYzFFIYqDOgLVz/AKFQ+ 1/KQ== X-Gm-Message-State: APjAAAWgSd8PpbVGJEcV7ZSiC5tLdPwWvFzd/tIxxh1fd5yGOBKnNYOp vKK+bKSpX9WQDszLMxOY6F7UFOEyOpFexhoLelBx8Q== X-Google-Smtp-Source: APXvYqwIdu+r4WW7DVUcBl1wk0aYK1s3v6MYo0ExF6GEfiuQJQTLxLqls1pRPOfZ6vvqjb3BE4ILJChngyYyVLWDQfM= X-Received: by 2002:a1c:f018:: with SMTP id a24mr16757468wmb.66.1561991125244; Mon, 01 Jul 2019 07:25:25 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Dave Page Date: Mon, 1 Jul 2019 15:25:14 +0100 Message-ID: Subject: Re: RE-SQL tests for Roles & Resource Group nodes To: Murtuza Zabuawala Cc: pgadmin-hackers Content-Type: multipart/alternative; boundary="00000000000029aaaf058c9f664f" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --00000000000029aaaf058c9f664f Content-Type: text/plain; charset="UTF-8" Hi On Mon, Jul 1, 2019 at 6:31 AM Murtuza Zabuawala < murtuza.zabuawala@enterprisedb.com> wrote: > Hi, > > PFA patch to add RE-SQL tests for Roles & Resource Group nodes. > Resource Groups don't exist in PG.... =============Running the test cases for 'Regression - PG 11'============= runTest (regression.re_sql.tests.test_resql.ReverseEngineeredSQLTestCases) Reverse Engineered SQL Test Cases Create IMPLICIT Cast Alter IMPLICIT Cast Drop IMPLICIT Cast Create EXPLICIT Cast Alter EXPLICIT Cast Drop EXPLICIT Cast Create Resource groups ... 2019-07-01 15:24:16,930: ERROR flask.app: Failed to execute query (execute_scalar) for the server #2 - DB:postgres (Query-id: 1562639): Error Message:ERROR: syntax error at or near "RESOURCE" LINE 1: CREATE RESOURCE GROUP test_resql_resource_group; ^ FAIL ====================================================================== FAIL: runTest (regression.re_sql.tests.test_resql.ReverseEngineeredSQLTestCases) Reverse Engineered SQL Test Cases ---------------------------------------------------------------------- Traceback (most recent call last): File "/Users/dpage/git/pgadmin4/web/regression/re_sql/tests/test_resql.py", line 88, in runTest self.execute_test_case(scenarios) File "/Users/dpage/git/pgadmin4/web/regression/re_sql/tests/test_resql.py", line 145, in execute_test_case self.assertEquals(response.status_code, 200) AssertionError: 500 != 200 ---------------------------------------------------------------------- Ran 1 test in 0.767s FAILED (failures=1) ====================================================================== Test Result Summary ====================================================================== Regression - PG 11: 0 tests passed 1 test failed: ReverseEngineeredSQLTestCases (Reverse Engineered SQL Test Cases) 0 tests skipped ====================================================================== -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company --00000000000029aaaf058c9f664f Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi

On Mon, Jul 1, 2019 at 6:31 AM Murtuza = Zabuawala <murtuza= .zabuawala@enterprisedb.com> wrote:
Hi,

PFA patch to add=C2= =A0RE-SQL tests for Roles & Resource Group nodes.

Resource Groups don't exist in PG....
=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3DRunning the test cases for= 'Regression - PG 11'=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
run= Test (regression.re_sql.tests.test_resql.ReverseEngineeredSQLTestCases)
= Reverse Engineered SQL Test Cases

Create IMPLICIT Cast
Alter IMPL= ICIT Cast
Drop IMPLICIT Cast
Create EXPLICIT Cast
Alter EXPLICIT C= ast
Drop EXPLICIT Cast


Create Resource groups
=C2=A0... 20= 19-07-01 15:24:16,930: ERROR flask.app: Failed to execute query (execute_sc= alar) for the server #2 - DB:postgres (Query-id: 1562639):
Error Message= :ERROR: =C2=A0syntax error at or near "RESOURCE"
LINE 1: CREAT= E RESOURCE GROUP test_resql_resource_group;
=C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0^

FAIL

=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
FAIL: runTest (regression.re_sql.tests= .test_resql.ReverseEngineeredSQLTestCases)
Reverse Engineered SQL Test C= ases
-------------------------------------------------------------------= ---
Traceback (most recent call last):
=C2=A0 File "/Users/dpage= /git/pgadmin4/web/regression/re_sql/tests/test_resql.py", line 88, in = runTest
=C2=A0 =C2=A0 self.execute_test_case(scenarios)
=C2=A0 File &= quot;/Users/dpage/git/pgadmin4/web/regression/re_sql/tests/test_resql.py&qu= ot;, line 145, in execute_test_case
=C2=A0 =C2=A0 self.assertEquals(resp= onse.status_code, 200)
AssertionError: 500 !=3D 200

-------------= ---------------------------------------------------------
Ran 1 test in = 0.767s

FAILED (failures=3D1)

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
Test Result Summary
=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

Regression - PG 11:
0 tests passed
1 test failed:
ReverseEngineeredSQLTestCases (Re= verse Engineered SQL Test Cases)
0 tests skipped

=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
=C2=A0
<= /div>--
Dave Page
Blog: <= a href=3D"http://pgsnake.blogspot.com" target=3D"_blank">http://pgsnake.blo= gspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.comThe Enterprise PostgreSQL Company
--00000000000029aaaf058c9f664f--