pgAdmin 4 commit: [Accessibility] Use semantic markup to mark emphasize

2020-04-08 Thread Ashesh Vashi
[Accessibility] Use semantic markup to mark emphasized or special text.

Reference: https://www.w3.org/TR/WCAG20-TECHS/H49.html

Branch
--
master

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

Modified Files
--
web/pgadmin/about/templates/about/index.html | 12 ++--
.../pgagent/schedules/static/js/pga_schedule.js  |  4 ++--
.../servers/pgagent/steps/static/js/pga_jobstep.js   |  2 +-
.../browser/templates/browser/master_password.html   |  2 +-
web/pgadmin/misc/static/explain/js/explain.js| 20 ++--
.../tools/grant_wizard/static/js/grant_wizard.js |  2 +-
.../tools/schema_diff/static/js/schema_diff_ui.js|  2 +-
7 files changed, 22 insertions(+), 22 deletions(-)



pgAdmin 4 commit: Using the 'gettext' as oppose to '_', which is not de

2020-04-08 Thread Ashesh Vashi
Using the 'gettext' as oppose to '_', which is not defined in the file

Branch
--
master

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

Modified Files
--
web/pgadmin/browser/server_groups/servers/__init__.py | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)



Re: [pgAdmin4][Patch] - RM 5270 - [EPAS] Synonym properties does not show OID.

2020-04-08 Thread Akshay Joshi
Hi Khushboo

Schema Diff test cases are failing with this patch. Please fix and resend
the patch.

On Tue, Apr 7, 2020 at 6:37 PM Khushboo Vashi <
khushboo.va...@enterprisedb.com> wrote:

> Hi,
>
> Please find the attached patch to fix the RM # 5270 - [EPAS] Synonym
> properties does not show OID.
>
> As per the current implementation, we completely ignored OID and instead
> considered the name as the unique field, now with this patch OID will be
> used as an unique id and also will display OID in the properties tab.
>
> Thanks,
> Khushboo
>
>

-- 
*Thanks & Regards*
*Akshay Joshi*

*Sr. Software Architect*
*EnterpriseDB Software India Private Limited*
*Mobile: +91 976-788-8246*


pgAdmin 4 commit: Using the 'gettext' as oppose to '_', which is not de

2020-04-08 Thread Ashesh Vashi
Using the 'gettext' as oppose to '_', which is not defined in these
files.

Branch
--
master

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

Modified Files
--
.../browser/server_groups/servers/databases/casts/__init__.py   | 6 +++---
.../browser/server_groups/servers/databases/extensions/__init__.py  | 2 +-
.../servers/databases/foreign_data_wrappers/__init__.py | 4 +++-
3 files changed, 7 insertions(+), 5 deletions(-)



Re: [pgAdmin4][Patch] - RM 5270 - [EPAS] Synonym properties does not show OID.

2020-04-08 Thread Ashesh Vashi
On Tue, Apr 7, 2020 at 6:37 PM Khushboo Vashi <
khushboo.va...@enterprisedb.com> wrote:

> Hi,
>
> Please find the attached patch to fix the RM # 5270 - [EPAS] Synonym
> properties does not show OID.
>
> As per the current implementation, we completely ignored OID and instead
> considered the name as the unique field, now with this patch OID will be
> used as an unique id and also will display OID in the properties tab.
>
Question is: When we rename a synonym, does it create a new OID, or keep
the same?

-- Ashesh

>
> Thanks,
> Khushboo
>
>


Re: [pgAdmin4][Patch] - RM 5270 - [EPAS] Synonym properties does not show OID.

2020-04-08 Thread Khushboo Vashi
On Wed, Apr 8, 2020 at 12:40 PM Ashesh Vashi 
wrote:

> On Tue, Apr 7, 2020 at 6:37 PM Khushboo Vashi <
> khushboo.va...@enterprisedb.com> wrote:
>
>> Hi,
>>
>> Please find the attached patch to fix the RM # 5270 - [EPAS] Synonym
>> properties does not show OID.
>>
>> As per the current implementation, we completely ignored OID and instead
>> considered the name as the unique field, now with this patch OID will be
>> used as an unique id and also will display OID in the properties tab.
>>
> Question is: When we rename a synonym, does it create a new OID, or keep
> the same?
>
> We can not rename a synonym, must drop it and recreate it.


> -- Ashesh
>
>>
>> Thanks,
>> Khushboo
>>
>>


Re: [pgAdmin4][Patch] - RM 5270 - [EPAS] Synonym properties does not show OID.

2020-04-08 Thread Akshay Joshi
Hi Khushboo

View/MView test also failing with the commit of #5053. Please fix those as
well and send a combined patch.

On Wed, Apr 8, 2020 at 12:47 PM Khushboo Vashi <
khushboo.va...@enterprisedb.com> wrote:

>
>
> On Wed, Apr 8, 2020 at 12:40 PM Ashesh Vashi <
> ashesh.va...@enterprisedb.com> wrote:
>
>> On Tue, Apr 7, 2020 at 6:37 PM Khushboo Vashi <
>> khushboo.va...@enterprisedb.com> wrote:
>>
>>> Hi,
>>>
>>> Please find the attached patch to fix the RM # 5270 - [EPAS] Synonym
>>> properties does not show OID.
>>>
>>> As per the current implementation, we completely ignored OID and instead
>>> considered the name as the unique field, now with this patch OID will be
>>> used as an unique id and also will display OID in the properties tab.
>>>
>> Question is: When we rename a synonym, does it create a new OID, or keep
>> the same?
>>
>> We can not rename a synonym, must drop it and recreate it.
>
>
>> -- Ashesh
>>
>>>
>>> Thanks,
>>> Khushboo
>>>
>>>

-- 
*Thanks & Regards*
*Akshay Joshi*

*Sr. Software Architect*
*EnterpriseDB Software India Private Limited*
*Mobile: +91 976-788-8246*


pgAdmin 4 commit: [Domain] Existing expression will expression will alw

2020-04-08 Thread Ashesh Vashi
[Domain] Existing expression will expression will always result into false

Branch
--
master

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

Modified Files
--
.../server_groups/servers/databases/schemas/domains/static/js/domain.js | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)



pgAdmin 4 commit: [COLLATIONS] Do not assign the paramter values, use s

2020-04-08 Thread Ashesh Vashi
[COLLATIONS] Do not assign the paramter values, use separate variable for new 
value

Branch
--
master

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

Modified Files
--
.../databases/schemas/collations/__init__.py   | 23 +-
1 file changed, 14 insertions(+), 9 deletions(-)



pgAdmin 4 commit: [Packages] Fixed a typo

2020-04-08 Thread Ashesh Vashi
[Packages] Fixed a typo

Branch
--
master

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

Modified Files
--
.../server_groups/servers/databases/schemas/packages/__init__.py| 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)



pgAdmin 4 commit: [Functions] Fixed typos:

2020-04-08 Thread Ashesh Vashi
[Functions] Fixed typos:
- 'gettext' should be used as '_' is not defined
- Identical expressions should not be used on both sides of a binary operator.

Branch
--
master

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

Modified Files
--
.../server_groups/servers/databases/schemas/functions/__init__.py  | 7 ---
1 file changed, 4 insertions(+), 3 deletions(-)



pgAdmin 4 commit: [TABLES] Do not assign the paramter values, use separ

2020-04-08 Thread Ashesh Vashi
[TABLES] Do not assign the paramter values, use separate variable for new value

Branch
--
master

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

Modified Files
--
.../server_groups/servers/databases/schemas/tables/__init__.py| 8 
1 file changed, 4 insertions(+), 4 deletions(-)



pgAdmin 4 commit: [Exclusion Constraint] Fixed an typo - it should have

2020-04-08 Thread Ashesh Vashi
[Exclusion Constraint] Fixed an typo - it should have been assignment

Branch
--
master

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

Modified Files
--
.../constraints/exclusion_constraint/static/js/exclusion_constraint.js  | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)



pgAdmin 4 commit: [EDB Package Functions] [Functions] Fixed typos:

2020-04-08 Thread Ashesh Vashi
[EDB Package Functions] [Functions] Fixed typos:
- 'gettext' should be used as '_' is not defined
- Identical expressions should not be used on both sides of a binary 
operator.

Branch
--
master

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

Modified Files
--
.../servers/databases/schemas/packages/edbfuncs/__init__.py   | 4 ++--
1 file changed, 2 insertions(+), 2 deletions(-)



pgAdmin 4 commit: [FTS Configuration] Fixed an typo - it should have be

2020-04-08 Thread Ashesh Vashi
[FTS Configuration] Fixed an typo - it should have been assignment

Branch
--
master

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

Modified Files
--
.../databases/schemas/fts_configurations/static/js/fts_configuration.js | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)



pgAdmin 4 commit: [Rules] Removing unnecessary 'if' condition

2020-04-08 Thread Ashesh Vashi
[Rules] Removing unnecessary 'if' condition

Branch
--
master

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

Modified Files
--
.../servers/databases/schemas/tables/rules/__init__.py | 7 +++
1 file changed, 3 insertions(+), 4 deletions(-)



Re: Proposal: Drop support for Internet Explorer

2020-04-08 Thread Dave Page
On Tue, Apr 7, 2020 at 1:34 PM richard coleman 
wrote:

> Dave,
>
> Seeing that IE isn't standards compliant and not only is not being further
> developed, but Microsoft is actively discouraging its use, it is probably
> time to drop support for it.
>
> I would caution *against* using browser analytics as any sort of proxy for
> use.  Since pgAdmin 4 lacks a UI of its own, I rely on an instance of
> Chromium (or Vivalidi, or Firefox, depending on the machine) to run pgAdmin
> under.  In every case, the browser that I am *running* pgAdmin 4 under is
> *not* the same browser that I use to browse websites, and so would never
> show up in your analytics.
>

Understood. Analytics are just one source of information, and certainly not
conclusive as you point out. My suspicion is that your situation is not the
norm for most people, but that really is just a suspicion.


>
> Just something to keep in mind,
>
> rik.
>
> On Tue, Apr 7, 2020 at 8:00 AM Dave Page  wrote:
>
>>
>>
>> On Tue, Apr 7, 2020 at 12:41 PM Dave Caughey  wrote:
>>
>>> Check the analytics... I think you'll find dropping it is a non-issue.
>>> In my own web service, I found that IE (all versions) constituted only
>>> about 1% of my users.
>>>
>>
>> Good point - 1.9% of the visitors to the website were on IE this week.
>> 1.8 of those were on IE11. We even had one hit from IE5...
>>
>> By comparison, 72% of users were on Chrome, 13% on Firefox, with 5.5%
>> each for Safari and Edge.
>>
>>
>>>
>>> So I dropped support for IE (since it was preventing me from fully
>>> adopting ES6), and there was not a single complaint from my users.
>>>
>>> Cheers,
>>> Dave
>>>
>>> On Tue., Apr. 7, 2020, 3:36 a.m. Dave Page,  wrote:
>>>
 All,

 Internet Explorer has long been superseded by Microsoft Edge, and even
 that has recently moved to using Chromium as it's core engine. Version 11
 was originally released in 2013, and though Microsoft have committed to
 supporting it until 2025, as far as I can tell there have been no notable
 new features in almost it's entire lifetime, and certainly in recent years
 Microsoft have only been releasing security fixes.

 As you can imagine, supporting Internet Explorer has a non-trivial cost
 to it for the pgAdmin project. Not only do we need to test with it as well
 as Edge, but we also need to write code, CSS and HTML that is fully
 compatible with what essentially is a 7 year old browser. By comparison,
 for all other browsers we typically aim to support releases no more than 2
 years old.

 I therefore propose that we officially drop support for Internet
 Explorer. Practically this means that we would not test with it, and anyone
 reporting a bug with it would be told to use an alternate browser.

 Objections/comments please?

 Thanks!

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

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

>>>
>>
>> --
>> Dave Page
>> Blog: http://pgsnake.blogspot.com
>> Twitter: @pgsnake
>>
>> EnterpriseDB UK: http://www.enterprisedb.com
>> The Enterprise PostgreSQL Company
>>
>

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

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


pgAdmin 4 commit: Various misc fixes:

2020-04-08 Thread Ashesh Vashi
Various misc fixes:
- Using the 'gettext' as oppose to '_', which is not defined
- Define missing variables
- Fixed escape character in string with double quote
- Removed some dead code in a test case
- Removed unnecessary self assignment

Includes some fixes for Accessibility improvements
- Use semantic markup to mark emphasized or special text
- Added hidden legend in  for better screen reader support

Branch
--
master

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

Modified Files
--
.../browser/server_groups/servers/__init__.py  |  2 +-
.../servers/databases/schemas/packages/__init__.py |  3 ++-
.../servers/resource_groups/__init__.py|  4 +--
.../server_groups/servers/roles/tests/utils.py | 31 +-
.../server_groups/servers/tablespaces/__init__.py  |  4 +--
web/pgadmin/misc/file_manager/__init__.py  |  3 ---
web/pgadmin/settings/__init__.py   |  2 +-
.../templates/security/change_password.html|  3 ++-
.../templates/security/forgot_password.html|  1 +
web/pgadmin/templates/security/panel.html  |  2 +-
web/pgadmin/templates/security/reset_password.html |  1 +
.../tools/debugger/templates/debugger/direct.html  | 12 -
web/pgadmin/tools/schema_diff/__init__.py  | 12 -
web/pgadmin/tools/search_objects/__init__.py   |  2 +-
web/pgadmin/tools/sqleditor/__init__.py|  5 +---
15 files changed, 28 insertions(+), 59 deletions(-)



pgAdmin 4 commit: Fixed a typo in previous commit

2020-04-08 Thread Ashesh Vashi
Fixed a typo in previous commit

Branch
--
master

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

Modified Files
--
web/pgadmin/tools/schema_diff/__init__.py | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)



pgAdmin 4 commit: Fixed pep8 issue

2020-04-08 Thread Ashesh Vashi
Fixed pep8 issue

Branch
--
master

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

Modified Files
--
.../server_groups/servers/databases/casts/__init__.py | 15 +++
1 file changed, 7 insertions(+), 8 deletions(-)



pgAdmin 4 commit: Moved the ip-address check functionality to a separat

2020-04-08 Thread Ashesh Vashi
Moved the ip-address check functionality to a separate file to improve
the maintainability of the code.

Branch
--
master

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

Modified Files
--
.../browser/server_groups/servers/__init__.py  | 42 +++
web/pgadmin/utils/ip.py| 61 ++
2 files changed, 69 insertions(+), 34 deletions(-)



pgAdmin 4 commit: Fixed expected output status code, as 410 should be t

2020-04-08 Thread Ashesh Vashi
Fixed expected output status code, as 410 should be the status code
for the object (CAST) not exists in the database server.

Branch
--
master

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

Modified Files
--
.../server_groups/servers/databases/casts/tests/cast_test_data.json | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)



pgAdmin 4 - next gettext usage fixes

2020-04-08 Thread Libor M.
Hello,
I fixed next gettext usage:

- fixed gettext usage with .format() only for original text with %s
- fixed typos
- fixed translation yes/no buttons in dialog
- improved translating sentences without "connecting" words (eg. see
web/pgadmin/dashboard/static/js/dashboard.js, word 'cancel' needs to
be translated in Czech language as 'zrušit' but in another sentence as
'zrušení')
- added gettext for text translations

Diff file is attached.

Best regards,

Libor M.

E-mail: libor...@gmail.com
GitHub: https://github.com/liborm85


pgadmin4_gettext_fixes2.diff
Description: Binary data


Re: Proposal: Drop support for Internet Explorer

2020-04-08 Thread Darren Duncan

If its hard to know how many people are actually using Internet Explorer:

You could make the next release of pgAdmin display a message occasionally to 
users of Internet Explorer saying that Internet Explorer will no longer be 
officially supported in a future version, and when that version comes the 
message says now no longer supported.


You can then see how many people contact you about this to express concern.

-- Darren Duncan




Re: RM4292 - Dark mode support for Windows/macOS

2020-04-08 Thread Akshay Joshi
Neel,

Can you please review/test it?

On Wed, Apr 8, 2020 at 9:08 PM Dave Page  wrote:

> The attached patch detects if dark mode is enabled on Windows (10+)/macOS
> (10.14+) at server start, and styles the runtime accordingly. It doesn't
> dynamically switch if the user changes their preferences.
>
> Linux builds continue to use the standard styling from Qt.
>
> NOTE: I've tested this on macOS, but my Windows build system is playing up
> at the moment. Akshay, can you have someone on your team test it please? I
> believe the code should work; it's just a case of reading a reg key and
> then doing the same thing as on macOS to set the theme accordingly.
>
> --
> Dave Page
> Blog: http://pgsnake.blogspot.com
> Twitter: @pgsnake
>
> EnterpriseDB UK: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>


-- 
*Thanks & Regards*
*Akshay Joshi*

*Sr. Software Architect*
*EnterpriseDB Software India Private Limited*
*Mobile: +91 976-788-8246*