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 1hiD27-0003qy-5X for pgadmin-hackers@arkaria.postgresql.org; Tue, 02 Jul 2019 07:16:55 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hiD26-00035d-0l for pgadmin-hackers@arkaria.postgresql.org; Tue, 02 Jul 2019 07:16:54 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hiD25-00035W-Mq for pgadmin-hackers@lists.postgresql.org; Tue, 02 Jul 2019 07:16:53 +0000 Received: from mail-oi1-x233.google.com ([2607:f8b0:4864:20::233]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hiD21-0000R0-Ux for pgadmin-hackers@postgresql.org; Tue, 02 Jul 2019 07:16:53 +0000 Received: by mail-oi1-x233.google.com with SMTP id g7so12208912oia.8 for ; Tue, 02 Jul 2019 00:16:49 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb-com.20150623.gappssmtp.com; s=20150623; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=0+VE4lRqtirk9jkeZVeuxQu2F6Ox0RwhiJTmHy8P2/0=; b=B3TCTwYQl/IF5m2hcg4n0cB+YsPQGf983K9r9Z/vG9nsZ+5EdYQuV0liYzw2Elo5nE 3UDqlNWXx2vnVL7QayF/dDnzptZhpyffapMh67ezxaiAkqMvbjf7nZldZs4Vqv+DIrde m6lr/8eR60UXluHV/s08OARZqxZE6KlmnXOJsrMXUS7L9sUM0pirFRZDcPKMkjXyqYk1 ddj+RNiN0KvpxfDEooBF42V+t83GXxo+Ifaxu802bi3Zt0mCCTC6Z2wwwfwgqx3ReHcC +35zds1lXqTFeS7ix1UcOLrBb99X9mJFfA7Rdpsqot4Tj9nb2gbngS2kH9o8RKFE9nq5 Uztg== 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=0+VE4lRqtirk9jkeZVeuxQu2F6Ox0RwhiJTmHy8P2/0=; b=bWiN2K9Cfd0wkEgB/S1+JrCC+5hwh2Zj84sCpJu3PPfzAjkiHDJI/gLUwQB1TGseL0 uwcfFONKaLPnD2Zt9dwW7GaOk++LjsOIVvoYu/F0PELPdmolcf4jEVtUpkhHQEXBA8qS jawwwTkYPB2vrUvZofXepSf35AmtXUCh+xMvTGWu0AkKHxxbrG5vJz6zTW1/TFZehG2x r1F+E9KVW1xOgxeKphPIOIi4nGq6QyL3OdURqsIMqlkIik3pXIQBEyTsYUz3LHkkf+9C Ny1PGxG698erXFyWZvlKGKPgT/sde5Dd9ngQYvbnOhM4Tg7S6p4jDozWcDq38PSAYViO JJUw== X-Gm-Message-State: APjAAAWx2kRiSBlG/1evS/B8D4Mh/+wnSd9tk/U65jtRiWnM5S+qMKNf LXh/rNbX8znGd7WsJtAzZooBTzKCaDNgrnKuFhS4Nw== X-Google-Smtp-Source: APXvYqx0jlYbf3XtGy98WVjhYd582Bo2GarV1nOZFTFRTQV3hUjhAXYwLCGZDqlQpHB26vXNA1W/y1K0LUOMHTrem0g= X-Received: by 2002:aca:f084:: with SMTP id o126mr1899280oih.37.1562051806867; Tue, 02 Jul 2019 00:16:46 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Murtuza Zabuawala Date: Tue, 2 Jul 2019 12:46:35 +0530 Message-ID: Subject: Re: RE-SQL tests for Roles & Resource Group nodes To: Dave Page Cc: pgadmin-hackers Content-Type: multipart/alternative; boundary="00000000000011dde9058cad8739" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --00000000000011dde9058cad8739 Content-Type: text/plain; charset="UTF-8" Hi Dave, Please find the updated patch, - Added a mechanism to check for supported minimum/maximum version and a server type in the framework. Please review. Thanks, Murtuza On Mon, Jul 1, 2019 at 7:55 PM Dave Page wrote: > 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 > --00000000000011dde9058cad8739 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi Dave,

Please find the updated patch,

- Added a mechanism to check for supported minimum/maximum version and a= server type in the framework.

Please revi= ew.


Thanks,=
Murtuza

On Mon, Jul 1, 2019 at 7:55 PM Dave Page <= dpage@pgadmin.org> wrote:
Hi

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

PFA patch to add=C2=A0R= E-SQL tests for Roles & Resource Group nodes.
<= div>
Resource Groups don't exist in PG....

=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3DRunning the test cases for = 9;Regression - PG 11'=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
runTest= (regression.re_sql.tests.test_resql.ReverseEngineeredSQLTestCases)
Reve= rse Engineered SQL Test Cases

Create IMPLICIT Cast
Alter IMPLICIT= Cast
Drop IMPLICIT Cast
Create EXPLICIT Cast
Alter EXPLICIT Cast<= br>Drop EXPLICIT Cast


Create Resource groups
=C2=A0... 2019-0= 7-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:ERR= OR: =C2=A0syntax error at or near "RESOURCE"
LINE 1: CREATE RE= SOURCE 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.te= st_resql.ReverseEngineeredSQLTestCases)
Reverse Engineered SQL Test Case= s
----------------------------------------------------------------------=
Traceback (most recent call last):
=C2=A0 File "/Users/dpage/gi= t/pgadmin4/web/regression/re_sql/tests/test_resql.py", line 88, in run= Test
=C2=A0 =C2=A0 self.execute_test_case(scenarios)
=C2=A0 File &quo= t;/Users/dpage/git/pgadmin4/web/regression/re_sql/tests/test_resql.py"= , line 145, in execute_test_case
=C2=A0 =C2=A0 self.assertEquals(respons= e.status_code, 200)
AssertionError: 500 !=3D 200

----------------= ------------------------------------------------------
Ran 1 test in 0.7= 67s

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 (Rever= se 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
--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

Enterpri= seDB UK: http://w= ww.enterprisedb.com
The Enterprise PostgreSQL Company
--00000000000011dde9058cad8739--