Re: pgAdmin4 v6.9 candidate builds

2022-05-12 Thread Fahar Abbas
@Akshay Joshi 

One round of testing has been completed on all supported platforms, Can you
please publish v6.9 on the website.

Kind Regards,


On Mon, May 9, 2022 at 4:24 PM Akshay Joshi 
wrote:

> Hi All,
>
> pgAdmin4 v6.9 candidate builds and source code is available at
> https://developer.pgadmin.org/builds/2022-05-09-1/
>
> Fahar, could you please verify this for Thursday's release.
>
> --
> *Thanks & Regards*
> *Akshay Joshi*
> *pgAdmin Hacker | Principal Software Architect*
> *EDB Postgres *
>
> *Mobile: +91 976-788-8246*
>


-- 
Fahar Abbas
pgAdmin4 team
EnterpriseDB Corporation
Mobile: +92-333-5409707
Skype ID: *live:fahar.abbas*
Website: www.enterprisedb.com


pgAdmin 4 v6.9 Released

2022-05-12 Thread Akshay Joshi
The pgAdmin Development Team is pleased to announce pgAdmin 4 version 6.9.

This release of pgAdmin 4 includes 29 bug fixes and new features. For more
details please see the release notes at:

https://www.pgadmin.org/docs/pgadmin4/6.9/release_notes_6_9.html.

pgAdmin is the leading Open Source graphical management tool for
PostgreSQL. For more information, please see:

https://www.pgadmin.org/

Notable changes in this release include:

Features:

   -

   Port query tool to React.


This feature is a major revamp to the query tool in terms of the GUI. Some
other related features have also been added to this. Some major
enhancements are adding a status bar, toolbar buttons shown on the
respective panels, fixing the headers of the slick grid, and many more.


   -

   Added options 'Ignore owner' and 'Ignore whitespace' to the schema diff
   panel.


This feature introduces the ‘ignore owner’ and ‘ignore whitespace’ options
on the schema diff panel itself to provide the ease to the users to change
the setting and compare the databases or schemas.


   -

   Added capability to deploy PostgreSQL servers on EDB BigAnimal.


This feature allows the users to deploy the PostgreSQL and EDB Advanced
Server on the EDB BigAnimal Cloud.


   -

   Added status bar to the Query Tool.
   -

   Ensure that row numbers should be visible in view when scrolling
   horizontally.
   -

   Relocate GIS Viewer Button to the Left Side of the Results Table.
   -

   Added support for Azure AD OAUTH2 authentication.


Bugs/Housekeeping:

   -

   Only set permissions on the storage directory upon creation.
   -

   Improvement to the Geometry Viewer popup to change the size of the
   result tables when column names are quite long.
   -

   Fixed an issue where the downloaded ERD diagram was 0 bytes.
   -

   Don't strip binaries when packaging them in the server RPM as this might
   break cpython modules.
   -

   Ensure that Columns should always be visible in the import/export dialog.
   -

   Fixed an issue where the copy and paste row does not work if the first
   column contains no data.
   -

   Fixed an issue where the Browser panel is not completely viewable.
   -

   Fixed sorting issue in the statistics panel.
   -

   Ensure that sorting should be preserved on refresh for Server Activity.
   -

   Fixed an issue where the drag and drop table in ERD throws an error.



Builds for Windows and macOS are available now, along with a Python Wheel,

Docker Container, RPM, DEB Package, and source code tarball from:

https://www.pgadmin.org/download/

--

Akshay Joshi

pgAdmin Project


[pgAdmin][patch] Query tool GUI test cases

2022-05-12 Thread Aditya Toshniwal
Hi Hackers,

Attached patch fixes:
1. GUI test cases:
view_data_dml_queries, query_tool_tests, query_tool_journey_test,
copy_selected_query_results_feature_test,
xss_checks_panels_and_query_tool_test
2. Query tool panel rename is not persisting.

Will send a patch for the remaining query tool GUI test cases once
preferences GUI test cases are fixed.

Please review.

-- 
Thanks,
Aditya Toshniwal
pgAdmin Hacker | Software Architect | *edbpostgres.com*

"Don't Complain about Heat, Plant a TREE"


RM6131.guitests.patch
Description: Binary data


pgAdmin 4 commit: Tag REL-6_9 has been created.

2022-05-12 Thread Akshay Joshi
Tag REL-6_9 has been created.
View: https://git.postgresql.org/gitweb?p=pgadmin4.git;a=tag;h=refs/tags/REL-6_9

Log Message
---
Tag v6.9

pgAdmin 4 commit: Fixed the following issues:

2022-05-12 Thread Akshay Joshi
Fixed the following issues:
 1. Feature test cases for the new query tool.
 2. Query tool panel rename is not persisting.

Branch
--
master

Details
---
https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=ca8e14455f926b4ed8969789369b7c7179eda58d
Author: Aditya Toshniwal 

Modified Files
--
.../copy_selected_query_results_feature_test.py|  27 ++--
.../feature_tests/query_tool_journey_test.py   | 150 ++---
web/pgadmin/feature_tests/query_tool_tests.py  | 102 +++---
web/pgadmin/feature_tests/view_data_dml_queries.py |  62 -
.../xss_checks_panels_and_query_tool_test.py   |  62 +++--
web/pgadmin/static/js/Explain/Graphical.jsx|   2 +-
web/pgadmin/static/js/components/Buttons.jsx   |  14 +-
web/pgadmin/static/js/components/ExternalIcon.jsx  |  30 ++---
web/pgadmin/static/js/components/Loader.jsx|   4 +-
web/pgadmin/static/js/components/Menu.jsx  |  14 +-
.../static/js/components/QueryToolComponent.jsx|  18 ++-
.../js/components/QueryToolDataGrid/Editors.jsx|   6 +-
.../js/components/QueryToolDataGrid/index.jsx  |  43 --
.../static/js/components/sections/MainToolBar.jsx  |   6 +
.../js/components/sections/Notifications.jsx   |   8 +-
.../static/js/components/sections/QueryHistory.jsx |  10 +-
.../static/js/components/sections/ResultSet.jsx|   2 +-
.../js/components/sections/ResultSetToolbar.jsx|   1 +
web/regression/feature_utils/locators.py   | 129 +-
web/regression/feature_utils/pgadmin_page.py   | 148 ++--
web/regression/runtests.py |   2 +-
21 files changed, 425 insertions(+), 415 deletions(-)



Re: [pgAdmin][patch] Query tool GUI test cases

2022-05-12 Thread Akshay Joshi
Thanks, the patch applied.

On Thu, May 12, 2022 at 5:05 PM Aditya Toshniwal <
aditya.toshni...@enterprisedb.com> wrote:

> Hi Hackers,
>
> Attached patch fixes:
> 1. GUI test cases:
> view_data_dml_queries, query_tool_tests, query_tool_journey_test,
> copy_selected_query_results_feature_test,
> xss_checks_panels_and_query_tool_test
> 2. Query tool panel rename is not persisting.
>
> Will send a patch for the remaining query tool GUI test cases once
> preferences GUI test cases are fixed.
>
> Please review.
>
> --
> Thanks,
> Aditya Toshniwal
> pgAdmin Hacker | Software Architect | *edbpostgres.com*
> 
> "Don't Complain about Heat, Plant a TREE"
>


-- 



Akshay Joshi

Principal Software Architect

+91 9767888246

www.enterprisedb.com