Re: Build failed in Jenkins: pgadmin4-master-python27-feature #11

[Harshal Dhumal]

Hi Dave,

Please attached patch to fixed Querytool feature test cases (RM2681
).


-- 
*Harshal Dhumal*
*Sr. Software Engineer*

EnterpriseDB India: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

On Mon, Sep 4, 2017 at 9:02 PM, pgAdmin 4 Jenkins 
wrote:

> See  feature/11/display/redirect?page=changes>
>
> Changes:
>
> [Dave Page] Allow queries to be cancelled from the dashboard, and display
> additional
>
> [Ashesh Vashi] Define the utility path lable, and help message for the
> Greenplum
>
> [Ashesh Vashi] Using the proper python syntax to fetch the default binary
> path for
>
> [akshay.joshi] Fixed issue where 'backend_type' column is exist for
> database server
>
> [Dave Page] Cleanup feature tests. Fixes #2586
>
> [Dave Page] Allow pgAdmin to run with config database versions from the
> future.
>
> [Dave Page] Rename the debugger XSS test function to 'a_test_function' to
> ensure it
>
> [Dave Page] GPDB compatibility fixes:
>
> [Dave Page] Fix RE-SQL for triggers with a single arg. Fixes #2668
>
> [Dave Page] Improve datamodel validations for default Validator if user
> (developer)
>
> [Dave Page] Fix display of types in GPDB.
>
> [Ashesh Vashi] Define the proper NODE_ENV environment during running the
> webpack. Using
>
> [akshay.joshi] 1) Fixed error in alertify.pgNotifier when server
> connection is lost. 2)
>
> [Dave Page] Fix Copy so it still works after query results have been
> copied. Fixes
>
> --
> [...truncated 79.49 KB...]
>   File " feature/ws/pgadmin-venv/lib/python2.7/site-packages/
> selenium/webdriver/remote/errorhandler.py",> line 193, in check_response
> raise exception_class(message, screen, stacktrace)
> NoSuchElementException: Message: no such element: Unable to locate
> element: {"method":"xpath","selector":"//*[contains(string(),'Total
> Cost')]"}
>   (Session info: chrome=59.0.3071.115)
>   (Driver info: chromedriver=2.29.461571 
> (8a88bbe0775e2a23afda0ceaf2ef7ee74e822cc5),platform=Linux
> 3.10.0-514.16.1.el7.x86_64 x86_64)
>
>
> --
> Ran 9 tests in 154.798s
>
> FAILED (errors=1)
>
> =Running the test cases for 'EDB Postgres AS 9.4'=
> runTest (pgadmin.feature_tests.copy_selected_query_results_feature_test.
> CopySelectedQueryResultsFeatureTest)
> Copy rows, column using button and keyboard shortcut ... ok
> runTest (pgadmin.feature_tests.pg_datatype_validation_test.
> PGDataypeFeatureTest)
> Test checks for PG data-types output ... ok
> runTest (pgadmin.feature_tests.query_tool_journey_test.
> QueryToolJourneyTest)
> Tests the path through the query tool ... ok
> runTest (pgadmin.feature_tests.query_tool_tests.QueryToolFeatureTest)
> Query tool feature test ...
> On demand query result...
> On demand result set on scrolling... OK.
> On demand result set on grid select all... OK.
> On demand result set on column select all... OK.
> Explain query with verbose and cost... OK.
> Explain analyze query with buffers and timing... OK.
> Auto commit disabled... OK.
> Auto commit enabled... OK.
> Auto rollback enabled... OK.
> Cancel query... OK.
> ok
> runTest (pgadmin.feature_tests.table_ddl_feature_test.TableDdlFeatureTest)
> Test table DDL generation ... ok
> runTest (pgadmin.feature_tests.view_data_dml_queries.CheckForViewDataTest)
> Validate Insert, Update operations in View/Edit data with given test data
> ... ok
> runTest (pgadmin.feature_tests.xss_checks_panels_and_query_tool_
> test.CheckForXssFeatureTest)
> Test XSS check for panels and query tool ... ok
> runTest (pgadmin.feature_tests.xss_checks_pgadmin_debugger_test.
> CheckDebuggerForXssFeatureTest)
> Tests to check if Debugger is vulnerable to XSS ... ok
> runTest (pgadmin.feature_tests.xss_checks_roles_control_test.
> CheckRoleMembershipControlFeatureTest)
> Tests to check if Role membership control is vulnerable to XSS ... ok
>
> --
> Ran 9 tests in 225.902s
>
> OK
>
> =Running the test cases for 'EDB Postgres AS 9.5'=
> runTest (pgadmin.feature_tests.copy_selected_query_results_feature_test.
> CopySelectedQueryResultsFeatureTest)
> Copy rows, column using button and keyboard shortcut ... ok
> runTest (pgadmin.feature_tests.pg_datatype_validation_test.
> PGDataypeFeatureTest)
> Test checks for PG data-types output ... ok
> runTest (pgadmin.feature_tests.query_tool_journey_test.
> QueryToolJourneyTest)
> Tests the path through the query tool ... ok
> runTest (pgadmin.feature_tests.query_tool_tests.QueryToolFeatureTest)
> Query tool feature test ...
> On demand query result...
> On demand result set on scrolling... OK.
> On demand result set on grid select all... OK.
> On demand result set on column select all... OK.
> 

pgAdmin 4 commit: Reset query tool options before running tests. Fixes

[Dave Page]

Reset query tool options before running tests. Fixes #2681

Branch
--
master

Details
---
https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=263aa42725964aa8cb66aae44aabd1e13152f338
Author: Harshal Dhumal 

Modified Files
--
web/pgadmin/feature_tests/query_tool_tests.py | 28 +++
1 file changed, 28 insertions(+)

Re: Build failed in Jenkins: pgadmin4-master-python27-feature #11

[Dave Page]

Thanks, applied. Good sleuthing!

On Tue, Sep 5, 2017 at 2:47 PM, Harshal Dhumal <
harshal.dhu...@enterprisedb.com> wrote:

> Hi Dave,
>
> Please attached patch to fixed Querytool feature test cases (RM2681
> ).
>
>
> --
> *Harshal Dhumal*
> *Sr. Software Engineer*
>
> EnterpriseDB India: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>
> On Mon, Sep 4, 2017 at 9:02 PM, pgAdmin 4 Jenkins 
> wrote:
>
>> See > ature/11/display/redirect?page=changes>
>>
>> Changes:
>>
>> [Dave Page] Allow queries to be cancelled from the dashboard, and display
>> additional
>>
>> [Ashesh Vashi] Define the utility path lable, and help message for the
>> Greenplum
>>
>> [Ashesh Vashi] Using the proper python syntax to fetch the default binary
>> path for
>>
>> [akshay.joshi] Fixed issue where 'backend_type' column is exist for
>> database server
>>
>> [Dave Page] Cleanup feature tests. Fixes #2586
>>
>> [Dave Page] Allow pgAdmin to run with config database versions from the
>> future.
>>
>> [Dave Page] Rename the debugger XSS test function to 'a_test_function' to
>> ensure it
>>
>> [Dave Page] GPDB compatibility fixes:
>>
>> [Dave Page] Fix RE-SQL for triggers with a single arg. Fixes #2668
>>
>> [Dave Page] Improve datamodel validations for default Validator if user
>> (developer)
>>
>> [Dave Page] Fix display of types in GPDB.
>>
>> [Ashesh Vashi] Define the proper NODE_ENV environment during running the
>> webpack. Using
>>
>> [akshay.joshi] 1) Fixed error in alertify.pgNotifier when server
>> connection is lost. 2)
>>
>> [Dave Page] Fix Copy so it still works after query results have been
>> copied. Fixes
>>
>> --
>> [...truncated 79.49 KB...]
>>   File "> eature/ws/pgadmin-venv/lib/python2.7/site-packages/selenium/
>> webdriver/remote/errorhandler.py",> line 193, in check_response
>> raise exception_class(message, screen, stacktrace)
>> NoSuchElementException: Message: no such element: Unable to locate
>> element: {"method":"xpath","selector":"//*[contains(string(),'Total
>> Cost')]"}
>>   (Session info: chrome=59.0.3071.115)
>>   (Driver info: chromedriver=2.29.461571 
>> (8a88bbe0775e2a23afda0ceaf2ef7ee74e822cc5),platform=Linux
>> 3.10.0-514.16.1.el7.x86_64 x86_64)
>>
>>
>> --
>> Ran 9 tests in 154.798s
>>
>> FAILED (errors=1)
>>
>> =Running the test cases for 'EDB Postgres AS 9.4'=
>> runTest (pgadmin.feature_tests.copy_selected_query_results_feature_
>> test.CopySelectedQueryResultsFeatureTest)
>> Copy rows, column using button and keyboard shortcut ... ok
>> runTest (pgadmin.feature_tests.pg_datatype_validation_test.PGDataype
>> FeatureTest)
>> Test checks for PG data-types output ... ok
>> runTest (pgadmin.feature_tests.query_tool_journey_test.QueryToolJour
>> neyTest)
>> Tests the path through the query tool ... ok
>> runTest (pgadmin.feature_tests.query_tool_tests.QueryToolFeatureTest)
>> Query tool feature test ...
>> On demand query result...
>> On demand result set on scrolling... OK.
>> On demand result set on grid select all... OK.
>> On demand result set on column select all... OK.
>> Explain query with verbose and cost... OK.
>> Explain analyze query with buffers and timing... OK.
>> Auto commit disabled... OK.
>> Auto commit enabled... OK.
>> Auto rollback enabled... OK.
>> Cancel query... OK.
>> ok
>> runTest (pgadmin.feature_tests.table_ddl_feature_test.TableDdlFeatur
>> eTest)
>> Test table DDL generation ... ok
>> runTest (pgadmin.feature_tests.view_data_dml_queries.CheckForViewDat
>> aTest)
>> Validate Insert, Update operations in View/Edit data with given test data
>> ... ok
>> runTest (pgadmin.feature_tests.xss_checks_panels_and_query_tool_test
>> .CheckForXssFeatureTest)
>> Test XSS check for panels and query tool ... ok
>> runTest (pgadmin.feature_tests.xss_checks_pgadmin_debugger_test.Chec
>> kDebuggerForXssFeatureTest)
>> Tests to check if Debugger is vulnerable to XSS ... ok
>> runTest (pgadmin.feature_tests.xss_checks_roles_control_test.CheckRo
>> leMembershipControlFeatureTest)
>> Tests to check if Role membership control is vulnerable to XSS ... ok
>>
>> --
>> Ran 9 tests in 225.902s
>>
>> OK
>>
>> =Running the test cases for 'EDB Postgres AS 9.5'=
>> runTest (pgadmin.feature_tests.copy_selected_query_results_feature_
>> test.CopySelectedQueryResultsFeatureTest)
>> Copy rows, column using button and keyboard shortcut ... ok
>> runTest (pgadmin.feature_tests.pg_datatype_validation_test.PGDataype
>> FeatureTest)
>> Test checks for PG data-types output ... ok
>> runTest (pgadmin.feature_tests.query_tool_journey_test.QueryToolJour
>> neyTest)
>> Tests the path through the query tool ... ok
>>

Build failed in Jenkins: pgadmin4-master-python27-feature #12

[pgAdmin 4 Jenkins]

See 


Changes:

[Dave Page] Reset query tool options before running tests. Fixes #2681

--
[...truncated 67.40 KB...]
runTest 
(pgadmin.feature_tests.copy_selected_query_results_feature_test.CopySelectedQueryResultsFeatureTest)
Copy rows, column using button and keyboard shortcut ... ERROR
runTest (pgadmin.feature_tests.pg_datatype_validation_test.PGDataypeFeatureTest)
Test checks for PG data-types output ... ok
runTest (pgadmin.feature_tests.query_tool_journey_test.QueryToolJourneyTest)
Tests the path through the query tool ... ok
runTest (pgadmin.feature_tests.query_tool_tests.QueryToolFeatureTest)
Query tool feature test ... 
On demand query result... 
On demand result set on scrolling... OK.
On demand result set on grid select all... OK.
On demand result set on column select all... OK.
Explain query with verbose and cost... OK.
Explain analyze query with buffers and timing... OK.
Auto commit disabled... OK.
Auto commit enabled... OK.
Auto rollback enabled... OK.
Cancel query... OK.
ok
runTest (pgadmin.feature_tests.table_ddl_feature_test.TableDdlFeatureTest)
Test table DDL generation ... ok
runTest (pgadmin.feature_tests.view_data_dml_queries.CheckForViewDataTest)
Validate Insert, Update operations in View/Edit data with given test data ... ok
runTest 
(pgadmin.feature_tests.xss_checks_panels_and_query_tool_test.CheckForXssFeatureTest)
Test XSS check for panels and query tool ... ok
runTest 
(pgadmin.feature_tests.xss_checks_pgadmin_debugger_test.CheckDebuggerForXssFeatureTest)
Tests to check if Debugger is vulnerable to XSS ... ok
runTest 
(pgadmin.feature_tests.xss_checks_roles_control_test.CheckRoleMembershipControlFeatureTest)
Tests to check if Role membership control is vulnerable to XSS ... ok

==
ERROR: runTest 
(pgadmin.feature_tests.copy_selected_query_results_feature_test.CopySelectedQueryResultsFeatureTest)
Copy rows, column using button and keyboard shortcut
--
Traceback (most recent call last):
  File 
"
 line 54, in runTest
self._copies_rows()
  File 
"
 line 65, in _copies_rows
self.page.find_by_xpath("//*[contains(@class, 'slick-row')]/*[1]").click()
  File 
"
 line 147, in find_by_xpath
return self.wait_for_element(lambda driver: 
driver.find_element_by_xpath(xpath))
  File 
"
 line 226, in wait_for_element
return self._wait_for("element to exist", element_if_it_exists)
  File 
"
 line 276, in _wait_for
"Timed out waiting for " + waiting_for_message)
  File 
"
 line 80, in until
raise TimeoutException(message, screen, stacktrace)
TimeoutException: Message: Timed out waiting for element to exist


--
Ran 9 tests in 257.541s

FAILED (errors=1)

=Running the test cases for 'EDB Postgres AS 9.4'=
runTest 
(pgadmin.feature_tests.copy_selected_query_results_feature_test.CopySelectedQueryResultsFeatureTest)
Copy rows, column using button and keyboard shortcut ... ok
runTest (pgadmin.feature_tests.pg_datatype_validation_test.PGDataypeFeatureTest)
Test checks for PG data-types output ... ok
runTest (pgadmin.feature_tests.query_tool_journey_test.QueryToolJourneyTest)
Tests the path through the query tool ... ok
runTest (pgadmin.feature_tests.query_tool_tests.QueryToolFeatureTest)
Query tool feature test ... 
On demand query result... 
On demand result set on scrolling... OK.
On demand result set on grid select all... OK.
On demand result set on column select all... OK.
Explain query with verbose and cost... OK.
Explain analyze query with buffers and timing... OK.
Auto commit disabled... OK.
Auto commit enabled... OK.
Auto rollback enabled... OK.
Cancel query... OK.
ok
runTest (pgadmin.feature_tests.table_ddl_feature_test.TableDdlFeatureTest)
Test table DDL generation ... ok
runTest (pgadmin.feature_tests.view_data_dml_queries.CheckForViewDataTest)
Validate Insert, Update operations in View/Edit data with given test data ... ok
runTest 
(pgadmi