Hi On Mon, Jul 1, 2019 at 6:31 AM Murtuza Zabuawala < murtuza.zabuaw...@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