pgAdmin 4 commit: The following issues were fixed in Graph Visualiser:

2022-06-23 Thread Akshay Joshi
The following issues were fixed in Graph Visualiser:

1) Allow the user to set the row limit and chart line width.
2) Zoom should only be applied to X-axis, not both.
3) On clicking the 'Generate' button, the chart should return to its original 
zoom level.
4) Negative values are not displayed.

refs #7485

Branch
--
master

Details
---
https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=2556771c326b8705aefd1e1fb02f60932e45b796

Modified Files
--
docs/en_US/images/preferences_dashboard_graphs.png | Bin 131627 -> 136939 bytes
docs/en_US/images/preferences_graph_visualiser.png | Bin 0 -> 103934 bytes
docs/en_US/preferences.rst |  13 +
web/pgadmin/dashboard/__init__.py  |   8 
web/pgadmin/dashboard/static/js/Graphs.jsx |  10 +-
web/pgadmin/static/js/chartjs/index.jsx|   2 --
web/pgadmin/tools/sqleditor/__init__.py|   6 +++---
.../js/components/sections/GraphVisualiser.jsx |  14 +++---
.../sqleditor/utils/query_tool_preferences.py  |  12 +++-
web/pgadmin/utils/constants.py |   1 +
web/regression/javascript/dashboard/graphs_spec.js |   2 ++
.../javascript/dashboard/graphs_wrapper_spec.js|   3 ++-
12 files changed, 60 insertions(+), 11 deletions(-)



Re: Proposal Dashboard design for system of pgadmin

2022-06-23 Thread Dave Page
Hi

On Thu, 23 Jun 2022 at 07:27, Kunal Garg  wrote:

> Thankyou for the feedback, I will incorporate the changes accordingly and
> email the revised version.
>

Please also send it as a plain email, not a PDF. That makes it much easier
to reply and comment inline.

Thanks!


>
> On Thu, 23 Jun, 2022, 10:49 am Ashesh Vashi, <
> ashesh.va...@enterprisedb.com> wrote:
>
>> Hi Kunal,
>>
>> The proposal must include:
>> - Impact on the existing layout (Where would the existing contents of the
>> dashboard go?).
>> - UI impact when the system_stats extension is not present in the
>> PostgreSQL instance.
>> - Introduction of the preferences for enabling/disabling this dashboard
>> and/or the individual charts within this dashboard.
>> - Introduction of the preferences to change the time interval between
>> probing the database server itself for these chart metrics.
>>
>> NOTE:
>> * Please study the existing charts of the existing dashboards.
>> * Dashboards are contextual, they're dependent on the node selection of
>> the 'Browser' tree on the left hand side.
>>
>> --
>>
>> Thanks & Regards,
>>
>> Ashesh Vashi
>> EnterpriseDB INDIA: Enterprise PostgreSQL Company
>> 
>>
>>
>> *http://www.linkedin.com/in/asheshvashi*
>> 
>>
>>
>> On Thu, Jun 23, 2022 at 4:02 AM Kunal Garg  wrote:
>>
>>> Hi,
>>>
>>> Proposing the dashboard design of pgadmin for the system stats.
>>>
>>> Attached is a proposal for incorporating the os details to the pgadmin
>>> dashboard.
>>>
>>>

-- 
Dave Page
Blog: https://pgsnake.blogspot.com
Twitter: @pgsnake

EDB: https://www.enterprisedb.com


[pgAdmin][RM7461]: PgAdmin 4 itself left too many connections idle

2022-06-23 Thread Pradip Parkale
Hi Hackers,
There is an attached patch for #7461. When a user switches to a new
connection in the query tool and closes the query tool, then the new
connection is not closed.
The new connection shows as idle in Dashboard. I have fixed this in the
attached patch.

Additionally, I have fixed the 'Show activity?' issue, which was overlooked
during the initial porting.



*Thanks & Regards,*

*Pradip ParkaleSoftware Engineer | EnterpriseDB Corporation*


RM7461.patch
Description: Binary data


[patch] -Bug #7495 - [Azure PostgreSQL] Users are unable to authenticate azure on Rpm/Debian Linux

2022-06-23 Thread Yogesh Mahajan
Hi,

Please find the attached path which fixes errors on linux platform for
Azure postgresql deployment.
Also added some feature test fixes.

Thanks,
Yogesh Mahajan
EnterpriseDB


RM_7495_v1.patch
Description: Binary data


pgAdmin 4 commit: Fixed an issue where the connection wasn't being clos

2022-06-23 Thread Akshay Joshi
Fixed an issue where the connection wasn't being closed when the user switched
to a new connection and closed the query tool. Fixes #7461

Fixed the 'Show activity?' issue which was missed during Dashboard porting.

Branch
--
master

Details
---
https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=e95eb14651379bce43eb03ec8ca17b783a5f0489
Author: Pradip Parkale 

Modified Files
--
docs/en_US/release_notes_6_11.rst  |  1 +
web/pgadmin/dashboard/static/js/Dashboard.jsx  | 98 +++---
.../tools/sqleditor/static/js/SQLEditorModule.js   | 10 ---
.../static/js/components/QueryToolComponent.jsx| 14 +++-
.../tools/sqleditor/templates/sqleditor/index.html | 15 
5 files changed, 64 insertions(+), 74 deletions(-)



pgAdmin 4 commit: Fixed an issue where users would not be able to authe

2022-06-23 Thread Akshay Joshi
Fixed an issue where users would not be able to authenticate in Azure on Linux 
platforms. Fixes #7495

Branch
--
master

Details
---
https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=23869cd61f965161c989d2cb42986bbc9b26e5fa
Author: Yogesh Mahajan 

Modified Files
--
web/pgacloud/providers/azure.py|   8 +-
web/pgadmin/feature_tests/file_manager_test.py |   4 +-
.../feature_tests/query_tool_journey_test.py   |  18 +-
web/pgadmin/feature_tests/query_tool_tests.py  |  10 +-
.../feature_tests/test_copy_sql_to_query_tool.py   |   2 -
web/pgadmin/feature_tests/view_data_dml_queries.py |  14 +-
.../xss_checks_pgadmin_debugger_test.py|  10 +-
.../feature_tests/xss_checks_roles_control_test.py |   4 +-
web/pgadmin/misc/cloud/azure/__init__.py   |   8 +-
web/regression/feature_utils/pgadmin_page.py   | 195 -
web/regression/python_test_utils/test_utils.py |   5 +-
11 files changed, 86 insertions(+), 192 deletions(-)



Re: [patch] -Bug #7495 - [Azure PostgreSQL] Users are unable to authenticate azure on Rpm/Debian Linux

2022-06-23 Thread Akshay Joshi
Thanks, the patch applied.

On Thu, Jun 23, 2022 at 5:59 PM Yogesh Mahajan <
yogesh.maha...@enterprisedb.com> wrote:

> Hi,
>
> Please find the attached path which fixes errors on linux platform for
> Azure postgresql deployment.
> Also added some feature test fixes.
>
> Thanks,
> Yogesh Mahajan
> EnterpriseDB
>


-- 



Akshay Joshi

Principal Software Architect

+91 9767888246

www.enterprisedb.com







Re: [pgAdmin][RM7461]: PgAdmin 4 itself left too many connections idle

2022-06-23 Thread Akshay Joshi
Thanks, the patch applied.

On Thu, Jun 23, 2022 at 5:41 PM Pradip Parkale <
pradip.park...@enterprisedb.com> wrote:

> Hi Hackers,
> There is an attached patch for #7461. When a user switches to a new
> connection in the query tool and closes the query tool, then the new
> connection is not closed.
> The new connection shows as idle in Dashboard. I have fixed this in the
> attached patch.
>
> Additionally, I have fixed the 'Show activity?' issue, which was
> overlooked during the initial porting.
>
>
>
> *Thanks & Regards,*
>
> *Pradip ParkaleSoftware Engineer | EnterpriseDB Corporation*
>


-- 



Akshay Joshi

Principal Software Architect

+91 9767888246

www.enterprisedb.com