pgAdmin 4 commit: Fixed fatal error while launching the pgAdmin4 3.5. U

2018-10-31 Thread Akshay Joshi
Fixed fatal error while launching the pgAdmin4 3.5. Update the version of the 
Flask to 0.12.4 for release. Fixes #3730

Branch
--
master

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

Modified Files
--
docs/en_US/release_notes_3_5.rst | 3 ++-
requirements.txt | 2 +-
2 files changed, 3 insertions(+), 2 deletions(-)



Re: pgAdmin4 v3.5 candidate builds

2018-10-31 Thread Akshay Joshi
Hi Hackers,

Issue has been resolved and new candidate builds and source can be found at
https://developer.pgadmin.org/builds/2018-10-31-2 .

@Fahar, Can you please verify it.

On Wed, Oct 31, 2018 at 12:25 PM Akshay Joshi 
wrote:

> Hi Hackers,
>
> I have googled and found the similar issue
> https://github.com/plotly/dash/issues/257 in another project, so it looks
> like Flask==1.0.2 creates the problem. We will have to downgrade the
> Flask back to 0.12.2
>
> @Fahar meanwhile can you please uninstall the Flask and reinstall the
> v0.12.2. Please follow the commands that I did on my windows machine (Refer
> attached screenshot)
>
> On Wed, Oct 31, 2018 at 10:30 AM Fahar Abbas 
> wrote:
>
>> Hi,
>>
>> Here is the showstopper issue for pgAdmin4 3.5 Release:
>> https://redmine.postgresql.org/issues/3730
>>
>> Kind Regards,
>>
>> On Mon, Oct 29, 2018 at 11:19 PM Akshay Joshi <
>> akshay.jo...@enterprisedb.com> wrote:
>>
>>> Hi All,
>>>
>>> pgAdmin4 v3.5 candidate builds and source can be found at
>>> https://developer.pgadmin.org/builds/2018-10-29-1/
>>>
>>> Fahar, can you please verify it for release on Thursday.
>>>
>>> --
>>> *Akshay Joshi*
>>>
>>> *Sr. Software Architect *
>>>
>>>
>>>
>>> *Phone: +91 20-3058-9517Mobile: +91 976-788-8246*
>>>
>>
>>
>> --
>> Fahar Abbas
>> QMG
>> EnterpriseDB Corporation
>> Phone Office: +92-51-835-8874
>> Phone Direct: +92-51-8466803
>> Mobile: +92-333-5409707
>> Skype ID: *live:fahar.abbas*
>> Website: www.enterprisedb.com
>>
>
>
> --
> *Akshay Joshi*
>
> *Sr. Software Architect *
>
>
>
> *Phone: +91 20-3058-9517Mobile: +91 976-788-8246*
>


-- 
*Akshay Joshi*

*Sr. Software Architect *



*Phone: +91 20-3058-9517Mobile: +91 976-788-8246*


pgAdmin 4 commit: Japanese translation update.

2018-10-31 Thread Dave Page
Japanese translation update.

Branch
--
master

Details
---
https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=6e03775f05427023f474c414ad4c3c938aeb1ae1
Author: Identifier Anonymous 

Modified Files
--
.../translations/ja/LC_MESSAGES/messages.mo| Bin 159509 -> 159902 bytes
.../translations/ja/LC_MESSAGES/messages.po|  91 ++---
2 files changed, 44 insertions(+), 47 deletions(-)



Re: Japanese translation for v3.5

2018-10-31 Thread Dave Page
Thanks, patch applied.

On Tue, Oct 30, 2018 at 12:13 PM fn ln  wrote:

> Hello.
> Updated japanese translation for v3.5 is in attachment.
> Message catalog is based on v3.5 d97431cb4f.
>


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

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


pgAdmin 4 commit: Allow the selection order to be preserved in the Sele

2018-10-31 Thread Dave Page
Allow the selection order to be preserved in the Select2 control to fix column 
ordering in data Import/Export. Fixes #3029

Branch
--
master

Details
---
https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=3359a0de7abc65ce7b30d2fce465e48caa35ac5d
Author: Akshay Joshi 

Modified Files
--
docs/en_US/release_notes.rst   |  1 +
docs/en_US/release_notes_3_6.rst   | 18 ++
web/pgadmin/static/js/backform.pgadmin.js  | 22 ++
.../tools/import_export/static/js/import_export.js |  2 ++
4 files changed, 43 insertions(+)



Re: [pgAdmin4][Patch]: RM #3029 Cannot sort columns when importing data

2018-10-31 Thread Dave Page
Thanks, patch applied.

On Thu, Oct 25, 2018 at 11:58 AM Akshay Joshi 
wrote:

> Hi Hackers,
>
> Attached is the patch to fix the RM #3029 Cannot sort columns when
> importing data.
> Select2 orders the selections based on the order of the `` behind
> the scenes. This means that the order will typically match the order of the
> options as they appear in the dropdown. For *import/export* it shows in
> the order of columns define in the table.
>
> Solution: I have just reorders the options inside the select2 every time,
> an item is selected. I have made this change into the select2 control with
> new option "*preserveSelectionOrder*" by default it is false, so won't
> impact any other module.
>
> --
> *Akshay Joshi*
>
> *Sr. Software Architect *
>
>
>
> *Phone: +91 20-3058-9517Mobile: +91 976-788-8246*
>


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

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


pgAdmin 4 commit: Add support for dropping multiple objects at once fro

2018-10-31 Thread Dave Page
Add support for dropping multiple objects at once from the collection 
Properties panel. Fixes #1513

Branch
--
master

Details
---
https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=f17979141cf55a3e7e75dc92ac4cd9c8bd0ad908
Author: Khushboo Vashi 

Modified Files
--
docs/en_US/pgadmin_tabbed_browser.rst  |   10 +-
docs/en_US/release_notes_3_6.rst   |2 +-
.../browser/register_browser_preferences.py|   30 +
.../server_groups/servers/databases/__init__.py|   77 +-
.../servers/databases/casts/__init__.py|   92 +-
.../servers/databases/casts/static/js/cast.js  |1 +
.../templates/cast/sql/default/properties.sql  |3 +-
.../casts/tests/test_cast_delete_multiple.py   |   73 +
.../servers/databases/event_triggers/__init__.py   |   71 +-
.../event_triggers/static/js/event_trigger.js  |3 +
.../tests/test_event_trigger_delete_multiple.py|  107 ++
.../servers/databases/extensions/__init__.py   |   72 +-
.../databases/extensions/static/js/extension.js|1 +
.../tests/test_extension_delete_multiple.py|   74 +
.../databases/foreign_data_wrappers/__init__.py|   95 +-
.../foreign_servers/__init__.py|   76 +-
.../foreign_servers/static/js/foreign_server.js|1 +
.../tests/test_foreign_servers_delete.py   |   17 +-
.../tests/test_foreign_servers_delete_multiple.py  |   90 ++
.../foreign_servers/user_mapping/__init__.py   |  107 +-
.../user_mapping/static/js/user_mapping.js |1 +
.../user_mapping/tests/test_user_mapping_delete.py |   14 +-
.../tests/test_user_mapping_delete_multiple.py |   91 ++
.../static/js/foreign_data_wrapper.js  |1 +
.../tests/test_fdw_delete_multiple.py  |   76 +
.../databases/foreign_data_wrappers/tests/utils.py |2 +-
.../servers/databases/languages/__init__.py|   54 +-
.../databases/languages/static/js/language.js  |1 +
.../tests/test_language_delete_multiple.py |   67 +
.../servers/databases/schemas/__init__.py  |   91 +-
.../columns/static/js/catalog_object_column.js |2 +
.../catalog_objects/static/js/catalog_object.js|2 +
.../databases/schemas/collations/__init__.py   |   66 +-
.../schemas/collations/static/js/collation.js  |1 +
.../tests/test_collation_delete_multiple.py|   80 ++
.../servers/databases/schemas/domains/__init__.py  |   70 +-
.../schemas/domains/domain_constraints/__init__.py |   67 +-
.../static/js/domain_constraints.js|3 +
.../databases/schemas/domains/static/js/domain.js  |1 +
.../schemas/domains/tests/test_domain_delete.py|8 +-
.../domains/tests/test_domain_delete_multiple.py   |   79 ++
.../databases/schemas/foreign_tables/__init__.py   |   75 +-
.../tests/test_foreign_table_delete_multiple.py|   99 ++
.../schemas/fts_configurations/__init__.py |   82 +-
.../static/js/fts_configuration.js |1 +
.../test_fts_configuration_delete_multiple.py  |   89 ++
.../databases/schemas/fts_dictionaries/__init__.py |   78 +-
.../fts_dictionaries/static/js/fts_dictionary.js   |1 +
.../tests/test_fts_dictionaries_delete_multiple.py |  104 ++
.../databases/schemas/fts_parser/__init__.py   |   81 +-
.../schemas/fts_parser/static/js/fts_parser.js |1 +
.../tests/test_fts_parser_delete_multiple.py   |  104 ++
.../databases/schemas/fts_templates/__init__.py|   73 +-
.../fts_templates/static/js/fts_template.js|1 +
.../tests/test_fts_templates_delete_multiple.py|  102 ++
.../databases/schemas/functions/__init__.py|   74 +-
.../functions/static/js/trigger_function.js|1 +
.../tests/test_function_delete_multiple.py |   56 +
.../tests/test_procedure_delete_multiple.py|   64 +
.../tests/test_trigger_func_delete_multiple.py |   59 +
.../servers/databases/schemas/packages/__init__.py |   70 +-
.../schemas/packages/edbfuncs/static/js/edbfunc.js |3 +
.../schemas/packages/edbfuncs/static/js/edbproc.js |2 +
.../schemas/packages/edbvars/static/js/edbvar.js   |3 +
.../schemas/packages/static/js/package.js  |1 +
.../packages/tests/test_package_delete_multiple.py |  101 ++
.../databases/schemas/sequences/__init__.py|   69 +-
.../schemas/sequences/static/js/sequence.js|1 +
.../tests/test_sequence_delete_multiple.py |   93 ++
.../servers/databases/schemas/static/js/catalog.js |2 +
.../servers/databases/schemas/static/js/schema.js  |1 +
.../servers/databases/schemas/synonyms/__init__.py |   58 +-
.../synonyms/tests/test_synonym_delete_multiple.py |  103 ++
.../servers/databases/schemas/tables/__init__.py   |   58 +-
.../databases/schemas/tables/column/__init__.py|   71 +-
.../column/tests/test_column_delete_multiple.py|   91 ++
.../constraints/check_constraint/__init__.py   |   68 +-
.../check_constraint/static/js/che

Re: [pgAdmin4][Patch]: RM #1513 - Unable to do max selection to drop tables/sequences/functions

2018-10-31 Thread Dave Page
Thanks - patch applied!

On Wed, Oct 31, 2018 at 10:05 AM Khushboo Vashi <
khushboo.va...@enterprisedb.com> wrote:

> Hi,
>
> Please find the attached updated patch.
>
> Thanks,
> Khushboo
>
> On Mon, Oct 22, 2018 at 6:15 PM Akshay Joshi <
> akshay.jo...@enterprisedb.com> wrote:
>
>> Hi Khushboo
>>
>> Following are the review comments:
>>
>>1. There is difference in the colour of the two icons for Drop and
>>Drop Cascade when both the button are disabled. Please refer 
>> Disabled_Icons.
>>png.
>>
>> This will be taken care in the design changes.
>
>>
>>1. Delete/Drop and Drop Cascade button should not be enabled if none
>>of the object is selected.
>>
>> Provided alert messages.
>
>>
>>1.
>>2. Databases:
>>   - When select all the databases including maintenance database it
>>   throws an error "Connection to the server has been lost". Please refer
>>   Database_Error.png
>>   - Checkbox should be disabled for maintenance database (if
>>   possible)
>>
>> Done
>
>>
>>1. Catalogs:
>>   - This feature should not be applicable to *Catalogs* and all
>>   there child nodes.
>>
>> Done
>
>>
>>-
>>1. Roles:
>>   - When select all the roles and try to delete it, it throws an
>>   error "Current user can not be dropped". Can we specify the name of the
>>   current user in the error message? Please refer Role_Error.png
>>   - Checkbox should be disabled for current user (if possible)
>>   - When select all the roles except the current user, for some
>>   reason pgAdmin4 unable to delete one role then, rest of the roles are 
>> not
>>   deleted. Is this expected behaviour?
>>2. pgAgent Jobs:
>>   - Unable to Delete/Drop pgAgent Jobs. Please refer pgAgent_Jobs.png
>>
>> Done
>
>>
>>1. Document changes not included in the patch.
>>
>> Missed to attach in the previous patch. attached now.
>
>>
>>1. Following API test cases were failing:
>>   - EventTriggerMultipleDeleteTestCase (Fetch Event Trigger Node URL)
>>   - SchemaDeleteMultipleTestCase (Check Schema Node URL)
>>   - DatabaseMultipleDeleteTestCase (Check Databases Node URL)
>>   - ExtensionsDeleteMultipleTestCase (Check Extension Node)
>>   - CollationDeleteMultipleTestCase (Fetch collation Node URL)
>>
>> Error:-  " flask.debughelpers.FormDataRoutingRedirect: b'A request was
>> sent to this URL (http://localhost/browser/database/obj/1/5) but a
>> redirect was issued automatically by the routing system to "http://
>> localhost/browser/database/obj/1/5/".  The URL was defined with a
>> trailing slash so Flask will automatically redirect to the URL with the
>> trailing slash if it was accessed without one.  Make sure to directly send
>> your DELETE-request to this URL since we can\'t make browsers or HTTP
>> clients redirect with form data reliably or without user interaction.\n\
>> nNote: this exception is only raised in debug mode".
>>
>>
>> Can not reproduce at my end.
>
>>
>> On Mon, Oct 22, 2018 at 11:36 AM Khushboo Vashi <
>> khushboo.va...@enterprisedb.com> wrote:
>>
>>> Hi,
>>>
>>> Please find the attached updated patch.
>>>
>>> On Wed, Oct 17, 2018 at 7:58 PM Dave Page  wrote:
>>>
 Hi

 Some relatively minor details to fix please:

 - There's no doc update.

 Done.
>>>
 - I think fa-trash-alt might be better for the Drop icon.

 Done.
>>>
 - I don't like the Drop Cascade icon. Maybe have Chethana create one
 based on fa-trash-alt, shrunken a little with a downwards pointing arrow on
 the bottom right.

 Done.
>>>
 Thanks!

 Thanks,
>>> Khushboo
>>>
 On Tue, Oct 16, 2018 at 10:23 AM Khushboo Vashi <
 khushboo.va...@enterprisedb.com> wrote:

> Hi,
>
> Please find the attached updated patch with the following changes.
> 1. Introduced header buttons for Drop and Drop Cascade
> 2. Fixed checkbox alignment issue
> 3. Refresh the grid on the error
>
> Currently I have removed multi delete table-space test case. I have
> tried to create sub directories but didn't work due to permission issue.
>
> Thanks,
> Khushboo
>
>
>
>
> On Tue, Oct 9, 2018 at 3:35 PM Dave Page  wrote:
>
>> Hi
>>
>> On Tue, Oct 9, 2018 at 8:03 AM Khushboo Vashi <
>> khushboo.va...@enterprisedb.com> wrote:
>>
>>> Hi Dave,
>>>
>>> On Mon, Oct 8, 2018 at 5:35 PM Dave Page  wrote:
>>>


 On Mon, Oct 8, 2018 at 12:50 PM Khushboo Vashi <
 khushboo.va...@enterprisedb.com> wrote:

> Hi Dave,
>
> On Mon, Oct 8, 2018 at 3:47 PM Dave Page 
> wrote:
>
>> Hi
>> On Fri, Oct 5, 2018 at 12:28 PM Khushboo Vashi <
>> khushboo.va...@enterprisedb.com> wrote:
>>
>>> Hi,
>>>
>>> Please find the attached updated patch with the fixes.
>>>
>>
>>>

Build failed in Jenkins: pgadmin4-master-python35 #788

2018-10-31 Thread pgAdmin 4 Jenkins
See 


Changes:

[Dave Page] Japanese translation update.

[Dave Page] Allow the selection order to be preserved in the Select2 control to 
fix

[Dave Page] Add support for dropping multiple objects at once from the 
collection

--
[...truncated 1.10 MB...]
Update schedule change exception date 
and time,
Update schedule delete exception,
Update schedule with repeat,
Update schedule add exception)
ViewsAddTestCase (Add materialized view under schema node)
EventTriggerMultipleDeleteTestCase (Fetch Event Trigger Node 
URL)
EventTriggerDeleteTestCase (Fetch Event Trigger Node URL)
PgAgentAddStepTestCase (Create step for pgAgent job)
PgAgentDeleteTestCase (Delete pgAgent job)
PgAgentPutStepTestCase (Update step with connection type and 
string,
Update step with kind, description, 
code and error)
PgAgentPutTestCase (Put pgAgent job)
MaintenanceCreateJobTest (When maintenance object with default 
options,
When maintenance the object with the 
CLUSTER,
When maintenance object with the 
ANALYZE,
When maintenance object with VACUUM 
FULL,
When maintenance the object with the 
REINDEX)
PgAgentStatsTestCase (Check the stats of pgAgent job)
TestSSLConnection (Test for SSL connection)
ResourceGroupsPutTestCase (Put resource groups)
BackupJobTest (When backup the object with the default options)

PostgreSQL 9.2:

367 tests passed
4 tests failed:
ExtensionsDeleteMultipleTestCase (Check Extension Node)
SchemaDeleteMultipleTestCase (Check Schema Node URL)
CollationDeleteMultipleTestCase (Fetch collation Node URL)
DatabaseMultipleDeleteTestCase (Check Databases Node URL)
50 tests skipped:
TableUpdateTestCase (Detach partition from existing list 
partitioned table,
Attach partition to existing list 
partitioned table,
Detach partition from existing range 
partitioned table,
Create partitions of existing range 
partitioned table,
Create partitions of existing list 
partitioned table,
Attach partition to existing range 
partitioned table)
RestoreCreateJobTest (When restore object with option - Do not 
save,
When restore object with the sections 
options,
When restore object with option - 
Miscellaneous,
When restore the object with Type of 
objects,
When restore object with option - 
Queries,
When restore object with default 
options,
When restore object with format 
directory,
When restore object with option - 
Disbale,
When restore object with option - Do 
not save comments)
PgAgentDeleteStepTestCase (Delete pgAgent Step)
ProcedureGetTestCase (Fetch Procedure Node URL)
ResourceGroupsAddTestCase (Add resource groups)
procedureDeleteTestCase (Fetch Procedure Node URL)
EventTriggerAddTestCase (Fetch Event Trigger Node URL)
ResourceGroupsGetTestCase (Get resource groups)
EventTriggerPutTestCase (Fetch Event Trigger Node URL)
PackageEDBFuncsGetTestCase (Fetch Package Functions/Procedures 
URL)
ViewsAddTestCase (Add materialized view under schema node)
SynonymGetTestCase (Fetch synonym Node URL)
ViewsDeleteTestCase (Delete materialized view under schema node)
PackagePutTestCase (Fetch Package Node URL)
PgAgentAddTestCase (Add pgAgent job)
SynonymDeleteTestCase (Fetch synonym Node URL)
MaintenanceJobTest (When maintenance the object with the 
default options)
ViewsDeleteMultipleTestCase (Delete multiple materialized view 
under schema node)
PgAgentPutScheduleTestCase (Update schedule with start and end 
time,
Update schedule c

Build failed in Jenkins: pgadmin4-master-python26 #932

2018-10-31 Thread pgAdmin 4 Jenkins
See 


Changes:

[Dave Page] Japanese translation update.

[Dave Page] Allow the selection order to be preserved in the Select2 control to 
fix

[Dave Page] Add support for dropping multiple objects at once from the 
collection

--
[...truncated 1.09 MB...]
When backup the object with option - Do 
not save privilege, tablespace, unlogged table data,
When backup object with format 
directory,
When backup the server with option 
only_data,
When backup the object with option - 
all queries,
When backup the object with option - 
format plain and dns_owner,
When backup the server with option - 
miscellaneous,
When backup the object with option 
only_schema)
TableAddTestCase (Create Hash partitioned table with 2 
partitions,
Create Range partitioned table with 2 
partitions,
Create List partitioned table with 2 
partitions)
BackupJobTest (When backup the object with the default options)
RestoreCreateJobTest (When restore object with option - Disbale,
When restore the object with Type of 
objects,
When restore object with option - 
Miscellaneous,
When restore object with option - Do 
not save,
When restore object with option - 
Queries,
When restore object with default 
options,
When restore object with the sections 
options,
When restore object with option - Do 
not save comments,
When restore object with format 
directory)
PgAgentDeleteStepTestCase (Delete pgAgent Step)
PgAgentPutScheduleTestCase (Update schedule with repeat,
Update schedule change exception date 
and time,
Update schedule delete exception,
Update schedule add exception,
Update schedule with start and end time)
PgAgentDeleteScheduleTestCase (Delete pgAgent Schedule)
TestSSLConnection (Test for SSL connection)
PgAgentGetTestCase (Get pgAgent job)
PgAgentPutStepTestCase (Update step with kind, description, 
code and error,
Update step with connection type and 
string)
PgAgentDeleteTestCase (Delete pgAgent job)
RestoreJobTest (When restore the object with the default 
options)

EDB Postgres AS 9.2:

383 tests passed
4 tests failed:
SchemaDeleteMultipleTestCase (Check Schema Node URL)
DatabaseMultipleDeleteTestCase (Check Databases Node URL)
CollationDeleteMultipleTestCase (Fetch collation Node URL)
ExtensionsDeleteMultipleTestCase (Check Extension Node)
34 tests skipped:
PgAgentAddStepTestCase (Create step for pgAgent job)
PgAgentAddScheduleTestCase (Create schedule with exception in 
pgAgent job)
TableUpdateTestCase (Detach partition from existing list 
partitioned table,
Create partitions of existing range 
partitioned table,
Detach partition from existing range 
partitioned table,
Attach partition to existing range 
partitioned table,
Attach partition to existing list 
partitioned table,
Create partitions of existing list 
partitioned table)
ViewsDeleteTestCase (Delete materialized view under schema node)
ViewsGetTestCase (Get materialized view under schema node)
PgAgentPutTestCase (Put pgAgent job)
ResourceGroupsGetTestCase (Get resource groups)
TableAddTestCase (Create Hash partitioned table with 2 
partitions,
Create Range partitioned table with 2 
partitions,
Create List partitioned table with 2 
partitions)
ViewsDeleteMultipleTestCase (Delete multiple materialized view 
under schema node)
PgAgentDeleteScheduleTestCase (Delete pgAgent Schedule)
 

Build failed in Jenkins: pgadmin4-master-python34 #789

2018-10-31 Thread pgAdmin 4 Jenkins
See 


Changes:

[Dave Page] Allow the selection order to be preserved in the Select2 control to 
fix

[Dave Page] Add support for dropping multiple objects at once from the 
collection

--
[...truncated 1.10 MB...]
PgAgentStatsTestCase (Check the stats of pgAgent job)
MaintenanceCreateJobTest (When maintenance the object with the 
REINDEX,
When maintenance the object with the 
CLUSTER,
When maintenance object with VACUUM 
FULL,
When maintenance object with default 
options,
When maintenance object with the 
ANALYZE)
PgAgentGetTestCase (Get pgAgent job)
PgAgentPutStepTestCase (Update step with kind, description, 
code and error,
Update step with connection type and 
string)
PgAgentAddTestCase (Add pgAgent job)
PgAgentPutScheduleTestCase (Update schedule with start and end 
time,
Update schedule with repeat,
Update schedule delete exception,
Update schedule add exception,
Update schedule change exception date 
and time)
PgAgentDeleteScheduleTestCase (Delete pgAgent Schedule)
BackupJobTest (When backup the object with the default options)

PostgreSQL 9.6:

376 tests passed
5 tests failed:
ExtensionsDeleteMultipleTestCase (Check Extension Node)
EventTriggerMultipleDeleteTestCase (Fetch Event Trigger Node 
URL)
CollationDeleteMultipleTestCase (Fetch collation Node URL)
SchemaDeleteMultipleTestCase (Check Schema Node URL)
DatabaseMultipleDeleteTestCase (Check Databases Node URL)
40 tests skipped:
ResourceGroupsAddTestCase (Add resource groups)
ResourceGroupsGetTestCase (Get resource groups)
PackageDeleteMultipleTestCase (Fetch Package Node URL)
PgAgentAddStepTestCase (Create step for pgAgent job)
PgAgentAddScheduleTestCase (Create schedule with exception in 
pgAgent job)
ResourceGroupsPutTestCase (Put resource groups)
PgAgentDeleteScheduleTestCase (Delete pgAgent Schedule)
ProcedureGetTestCase (Fetch Procedure Node URL)
TableAddTestCase (Create List partitioned table with 2 
partitions,
Create Hash partitioned table with 2 
partitions,
Create Range partitioned table with 2 
partitions)
SynonymDeleteMultipleTestCase (Fetch synonym Node URL)
procedureDeleteTestCase (Fetch Procedure Node URL)
BackupCreateJobTest (When backup the object with option 
only_schema,
When backup the object with option - 
miscellaneous,
When backup the object with option 
only_data,
When backup the server with option 
only_data,
When backup globals,
When backup the object with option - 
format plain and dns_owner,
When backup the server with option - Do 
not save privilege, tablespace, unlogged table data,
When backup the object with option - Do 
not save privilege, tablespace, unlogged table data,
When backup the server with option 
only_schema,
When backup the object with option - 
load via partition root,
When backup the server with option - 
all queries,
When backup the server with encoding,
When backup object with format 
directory,
When backup the object with option - Do 
not save comments,,
When backup object with default options,
When backup the server with option - Do 
not save comments,,
When backup the object with option 
sections to all data,
When backup the object with format tar,
When backup the server,
When backup the object with option - 
all queries,
When back

Build failed in Jenkins: pgadmin4-master-python36 #791

2018-10-31 Thread pgAdmin 4 Jenkins
See 


Changes:

[Dave Page] Allow the selection order to be preserved in the Select2 control to 
fix

[Dave Page] Add support for dropping multiple objects at once from the 
collection

--
[...truncated 1.10 MB...]
PgAgentDeleteStepTestCase (Delete pgAgent Step)
PgAgentGetTestCase (Get pgAgent job)
PgAgentPutScheduleTestCase (Update schedule with start and end 
time,
Update schedule with repeat,
Update schedule add exception,
Update schedule change exception date 
and time,
Update schedule delete exception)
PgAgentPutStepTestCase (Update step with kind, description, 
code and error,
Update step with connection type and 
string)
PgAgentStatsTestCase (Check the stats of pgAgent job)
TestSSLConnection (Test for SSL connection)
BackupCreateJobTest (When backup object with default options,
When backup object with format 
directory,
When backup the object with option 
sections to all data,
When backup the object with option 
only_data,
When backup the object with option 
only_schema,
When backup the object with option - 
format plain and dns_owner,
When backup the object with option - Do 
not save privilege, tablespace, unlogged table data,
When backup the object with option - Do 
not save comments,,
When backup the object with option - 
all queries,
When backup the object with option - 
load via partition root,
When backup the object with option - 
all queries and format custom,
When backup the object with option - 
miscellaneous,
When backup the object with format tar,
When backup the server,
When backup the server with option 
only_data,
When backup the server with option 
only_schema,
When backup the server with option - Do 
not save privilege, tablespace, unlogged table data,
When backup the server with option - Do 
not save comments,,
When backup the server with option - 
all queries,
When backup the server with option - 
miscellaneous,
When backup the server with encoding,
When backup globals)
BackupJobTest (When backup the object with the default options)
MaintenanceJobTest (When maintenance the object with the 
default options)
MaintenanceCreateJobTest (When maintenance object with default 
options,
When maintenance object with VACUUM 
FULL,
When maintenance object with the 
ANALYZE,
When maintenance the object with the 
REINDEX,
When maintenance the object with the 
CLUSTER)
RestoreJobTest (When restore the object with the default 
options)
RestoreCreateJobTest (When restore object with default options,
When restore object with format 
directory,
When restore object with the sections 
options,
When restore the object with Type of 
objects,
When restore object with option - Do 
not save,
When restore object with option - Do 
not save comments,
When restore object with option - 
Queries,
When restore object with option - 
Disbale,
When restore object with option - 
Miscellaneous)

EDB Postgres AS 9.5:

395 tests passed
6 tests failed:
EventTriggerMultipleDeleteTestCase (Fetch Event Trigger Node 
URL)
ExtensionsDeleteMultipleTestCase (Check Extension Node)
CollationDeleteMultipleTestCase (Fetch collation Node URL)
Sch

Re: [pgAdmin4][Patch]: RM #1513 - Unable to do max selection to drop tables/sequences/functions

2018-10-31 Thread Khushboo Vashi
Please find the patch to fix the test cases.
As I can not reproduce the issue, I have fixed as per the logs.



On Wed, Oct 31, 2018 at 4:01 PM Dave Page  wrote:

> Thanks - patch applied!
>
> On Wed, Oct 31, 2018 at 10:05 AM Khushboo Vashi <
> khushboo.va...@enterprisedb.com> wrote:
>
>> Hi,
>>
>> Please find the attached updated patch.
>>
>> Thanks,
>> Khushboo
>>
>> On Mon, Oct 22, 2018 at 6:15 PM Akshay Joshi <
>> akshay.jo...@enterprisedb.com> wrote:
>>
>>> Hi Khushboo
>>>
>>> Following are the review comments:
>>>
>>>1. There is difference in the colour of the two icons for Drop and
>>>Drop Cascade when both the button are disabled. Please refer 
>>> Disabled_Icons.
>>>png.
>>>
>>> This will be taken care in the design changes.
>>
>>>
>>>1. Delete/Drop and Drop Cascade button should not be enabled if none
>>>of the object is selected.
>>>
>>> Provided alert messages.
>>
>>>
>>>1.
>>>2. Databases:
>>>   - When select all the databases including maintenance database it
>>>   throws an error "Connection to the server has been lost". Please refer
>>>   Database_Error.png
>>>   - Checkbox should be disabled for maintenance database (if
>>>   possible)
>>>
>>> Done
>>
>>>
>>>1. Catalogs:
>>>   - This feature should not be applicable to *Catalogs* and all
>>>   there child nodes.
>>>
>>> Done
>>
>>>
>>>-
>>>1. Roles:
>>>   - When select all the roles and try to delete it, it throws an
>>>   error "Current user can not be dropped". Can we specify the name of 
>>> the
>>>   current user in the error message? Please refer Role_Error.png
>>>   - Checkbox should be disabled for current user (if possible)
>>>   - When select all the roles except the current user, for some
>>>   reason pgAdmin4 unable to delete one role then, rest of the roles are 
>>> not
>>>   deleted. Is this expected behaviour?
>>>2. pgAgent Jobs:
>>>   - Unable to Delete/Drop pgAgent Jobs. Please refer pgAgent_Jobs.
>>>   png
>>>
>>> Done
>>
>>>
>>>1. Document changes not included in the patch.
>>>
>>> Missed to attach in the previous patch. attached now.
>>
>>>
>>>1. Following API test cases were failing:
>>>   - EventTriggerMultipleDeleteTestCase (Fetch Event Trigger Node
>>>   URL)
>>>   - SchemaDeleteMultipleTestCase (Check Schema Node URL)
>>>   - DatabaseMultipleDeleteTestCase (Check Databases Node URL)
>>>   - ExtensionsDeleteMultipleTestCase (Check Extension Node)
>>>   - CollationDeleteMultipleTestCase (Fetch collation Node URL)
>>>
>>> Error:-  " flask.debughelpers.FormDataRoutingRedirect: b'A request was
>>> sent to this URL (http://localhost/browser/database/obj/1/5) but a
>>> redirect was issued automatically by the routing system to "http://
>>> localhost/browser/database/obj/1/5/".  The URL was defined with a
>>> trailing slash so Flask will automatically redirect to the URL with the
>>> trailing slash if it was accessed without one.  Make sure to directly send
>>> your DELETE-request to this URL since we can\'t make browsers or HTTP
>>> clients redirect with form data reliably or without user interaction.\n\
>>> nNote: this exception is only raised in debug mode".
>>>
>>>
>>> Can not reproduce at my end.
>>
>>>
>>> On Mon, Oct 22, 2018 at 11:36 AM Khushboo Vashi <
>>> khushboo.va...@enterprisedb.com> wrote:
>>>
 Hi,

 Please find the attached updated patch.

 On Wed, Oct 17, 2018 at 7:58 PM Dave Page  wrote:

> Hi
>
> Some relatively minor details to fix please:
>
> - There's no doc update.
>
> Done.

> - I think fa-trash-alt might be better for the Drop icon.
>
> Done.

> - I don't like the Drop Cascade icon. Maybe have Chethana create one
> based on fa-trash-alt, shrunken a little with a downwards pointing arrow 
> on
> the bottom right.
>
> Done.

> Thanks!
>
> Thanks,
 Khushboo

> On Tue, Oct 16, 2018 at 10:23 AM Khushboo Vashi <
> khushboo.va...@enterprisedb.com> wrote:
>
>> Hi,
>>
>> Please find the attached updated patch with the following changes.
>> 1. Introduced header buttons for Drop and Drop Cascade
>> 2. Fixed checkbox alignment issue
>> 3. Refresh the grid on the error
>>
>> Currently I have removed multi delete table-space test case. I have
>> tried to create sub directories but didn't work due to permission issue.
>>
>> Thanks,
>> Khushboo
>>
>>
>>
>>
>> On Tue, Oct 9, 2018 at 3:35 PM Dave Page  wrote:
>>
>>> Hi
>>>
>>> On Tue, Oct 9, 2018 at 8:03 AM Khushboo Vashi <
>>> khushboo.va...@enterprisedb.com> wrote:
>>>
 Hi Dave,

 On Mon, Oct 8, 2018 at 5:35 PM Dave Page  wrote:

>
>
> On Mon, Oct 8, 2018 at 12:50 PM Khushboo Vashi <
> khushboo.va...@enterprisedb.com> wrote:
>
>>

Build failed in Jenkins: pgadmin4-master-python37 #36

2018-10-31 Thread pgAdmin 4 Jenkins
See 


Changes:

[Dave Page] Add support for dropping multiple objects at once from the 
collection

--
[...truncated 1.10 MB...]
PgAgentDeleteStepTestCase (Delete pgAgent Step)
PgAgentGetTestCase (Get pgAgent job)
PgAgentPutScheduleTestCase (Update schedule with start and end 
time,
Update schedule with repeat,
Update schedule add exception,
Update schedule change exception date 
and time,
Update schedule delete exception)
PgAgentPutStepTestCase (Update step with kind, description, 
code and error,
Update step with connection type and 
string)
PgAgentStatsTestCase (Check the stats of pgAgent job)
TestSSLConnection (Test for SSL connection)
BackupCreateJobTest (When backup object with default options,
When backup object with format 
directory,
When backup the object with option 
sections to all data,
When backup the object with option 
only_data,
When backup the object with option 
only_schema,
When backup the object with option - 
format plain and dns_owner,
When backup the object with option - Do 
not save privilege, tablespace, unlogged table data,
When backup the object with option - Do 
not save comments,,
When backup the object with option - 
all queries,
When backup the object with option - 
load via partition root,
When backup the object with option - 
all queries and format custom,
When backup the object with option - 
miscellaneous,
When backup the object with format tar,
When backup the server,
When backup the server with option 
only_data,
When backup the server with option 
only_schema,
When backup the server with option - Do 
not save privilege, tablespace, unlogged table data,
When backup the server with option - Do 
not save comments,,
When backup the server with option - 
all queries,
When backup the server with option - 
miscellaneous,
When backup the server with encoding,
When backup globals)
BackupJobTest (When backup the object with the default options)
MaintenanceJobTest (When maintenance the object with the 
default options)
MaintenanceCreateJobTest (When maintenance object with default 
options,
When maintenance object with VACUUM 
FULL,
When maintenance object with the 
ANALYZE,
When maintenance the object with the 
REINDEX,
When maintenance the object with the 
CLUSTER)
RestoreJobTest (When restore the object with the default 
options)
RestoreCreateJobTest (When restore object with default options,
When restore object with format 
directory,
When restore object with the sections 
options,
When restore the object with Type of 
objects,
When restore object with option - Do 
not save,
When restore object with option - Do 
not save comments,
When restore object with option - 
Queries,
When restore object with option - 
Disbale,
When restore object with option - 
Miscellaneous)

EDB Postgres AS 9.5:

395 tests passed
6 tests failed:
EventTriggerMultipleDeleteTestCase (Fetch Event Trigger Node 
URL)
ExtensionsDeleteMultipleTestCase (Check Extension Node)
CollationDeleteMultipleTestCase (Fetch collation Node URL)
SchemaDeleteMultipleTestCase (Check Schema Node URL)
DatabaseMultipleDelet

Build failed in Jenkins: pgadmin4-master-python27 #802

2018-10-31 Thread pgAdmin 4 Jenkins
See 


Changes:

[Dave Page] Add support for dropping multiple objects at once from the 
collection

--
[...truncated 1.09 MB...]
When backup the object with option - Do 
not save privilege, tablespace, unlogged table data,
When backup object with format 
directory,
When backup the server with option 
only_data,
When backup the object with option - 
all queries,
When backup the object with option - 
format plain and dns_owner,
When backup the server with option - 
miscellaneous,
When backup the object with option 
only_schema)
TableAddTestCase (Create Hash partitioned table with 2 
partitions,
Create Range partitioned table with 2 
partitions,
Create List partitioned table with 2 
partitions)
BackupJobTest (When backup the object with the default options)
RestoreCreateJobTest (When restore object with option - Disbale,
When restore the object with Type of 
objects,
When restore object with option - 
Miscellaneous,
When restore object with option - Do 
not save,
When restore object with option - 
Queries,
When restore object with default 
options,
When restore object with the sections 
options,
When restore object with option - Do 
not save comments,
When restore object with format 
directory)
PgAgentDeleteStepTestCase (Delete pgAgent Step)
PgAgentPutScheduleTestCase (Update schedule with repeat,
Update schedule change exception date 
and time,
Update schedule delete exception,
Update schedule add exception,
Update schedule with start and end time)
PgAgentDeleteScheduleTestCase (Delete pgAgent Schedule)
TestSSLConnection (Test for SSL connection)
PgAgentGetTestCase (Get pgAgent job)
PgAgentPutStepTestCase (Update step with kind, description, 
code and error,
Update step with connection type and 
string)
PgAgentDeleteTestCase (Delete pgAgent job)
RestoreJobTest (When restore the object with the default 
options)

EDB Postgres AS 9.2:

383 tests passed
4 tests failed:
SchemaDeleteMultipleTestCase (Check Schema Node URL)
DatabaseMultipleDeleteTestCase (Check Databases Node URL)
CollationDeleteMultipleTestCase (Fetch collation Node URL)
ExtensionsDeleteMultipleTestCase (Check Extension Node)
34 tests skipped:
PgAgentAddStepTestCase (Create step for pgAgent job)
PgAgentAddScheduleTestCase (Create schedule with exception in 
pgAgent job)
TableUpdateTestCase (Detach partition from existing list 
partitioned table,
Create partitions of existing range 
partitioned table,
Detach partition from existing range 
partitioned table,
Attach partition to existing range 
partitioned table,
Attach partition to existing list 
partitioned table,
Create partitions of existing list 
partitioned table)
ViewsDeleteTestCase (Delete materialized view under schema node)
ViewsGetTestCase (Get materialized view under schema node)
PgAgentPutTestCase (Put pgAgent job)
ResourceGroupsGetTestCase (Get resource groups)
TableAddTestCase (Create Hash partitioned table with 2 
partitions,
Create Range partitioned table with 2 
partitions,
Create List partitioned table with 2 
partitions)
ViewsDeleteMultipleTestCase (Delete multiple materialized view 
under schema node)
PgAgentDeleteScheduleTestCase (Delete pgAgent Schedule)
ResourceGroupsDeleteTestCase (Delete multiple resource groups,
Delete resource groups

pgAdmin 4 commit: Fix buildfarm failures.

2018-10-31 Thread Dave Page
Fix buildfarm failures.

Branch
--
master

Details
---
https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=e59eaedfd0e11bb316f6749419b74eba6859b5c8
Author: Khushboo Vashi 

Modified Files
--
.../databases/extensions/tests/test_extension_delete_multiple.py| 2 +-
.../schemas/collations/tests/test_collation_delete_multiple.py  | 2 +-
.../servers/databases/schemas/tests/test_schema_delete_multiple.py  | 2 +-
.../server_groups/servers/databases/tests/test_db_delete_multiple.py| 2 +-
4 files changed, 4 insertions(+), 4 deletions(-)



Re: [pgAdmin4][Patch]: RM #1513 - Unable to do max selection to drop tables/sequences/functions

2018-10-31 Thread Dave Page
Ahh - ignore my previous email :-)

Patch committed!

On Wed, Oct 31, 2018 at 11:09 AM Khushboo Vashi <
khushboo.va...@enterprisedb.com> wrote:

> Please find the patch to fix the test cases.
> As I can not reproduce the issue, I have fixed as per the logs.
>
>
>
> On Wed, Oct 31, 2018 at 4:01 PM Dave Page  wrote:
>
>> Thanks - patch applied!
>>
>> On Wed, Oct 31, 2018 at 10:05 AM Khushboo Vashi <
>> khushboo.va...@enterprisedb.com> wrote:
>>
>>> Hi,
>>>
>>> Please find the attached updated patch.
>>>
>>> Thanks,
>>> Khushboo
>>>
>>> On Mon, Oct 22, 2018 at 6:15 PM Akshay Joshi <
>>> akshay.jo...@enterprisedb.com> wrote:
>>>
 Hi Khushboo

 Following are the review comments:

1. There is difference in the colour of the two icons for Drop and
Drop Cascade when both the button are disabled. Please refer 
 Disabled_Icons.
png.

 This will be taken care in the design changes.
>>>

1. Delete/Drop and Drop Cascade button should not be enabled if
none of the object is selected.

 Provided alert messages.
>>>

1.
2. Databases:
   - When select all the databases including maintenance database
   it throws an error "Connection to the server has been lost". Please 
 refer
   Database_Error.png
   - Checkbox should be disabled for maintenance database (if
   possible)

 Done
>>>

1. Catalogs:
   - This feature should not be applicable to *Catalogs* and all
   there child nodes.

 Done
>>>

-
1. Roles:
   - When select all the roles and try to delete it, it throws an
   error "Current user can not be dropped". Can we specify the name of 
 the
   current user in the error message? Please refer Role_Error.png
   - Checkbox should be disabled for current user (if possible)
   - When select all the roles except the current user, for some
   reason pgAdmin4 unable to delete one role then, rest of the roles 
 are not
   deleted. Is this expected behaviour?
2. pgAgent Jobs:
   - Unable to Delete/Drop pgAgent Jobs. Please refer pgAgent_Jobs.
   png

 Done
>>>

1. Document changes not included in the patch.

 Missed to attach in the previous patch. attached now.
>>>

1. Following API test cases were failing:
   - EventTriggerMultipleDeleteTestCase (Fetch Event Trigger Node
   URL)
   - SchemaDeleteMultipleTestCase (Check Schema Node URL)
   - DatabaseMultipleDeleteTestCase (Check Databases Node URL)
   - ExtensionsDeleteMultipleTestCase (Check Extension Node)
   - CollationDeleteMultipleTestCase (Fetch collation Node URL)

 Error:-  " flask.debughelpers.FormDataRoutingRedirect: b'A request was
 sent to this URL (http://localhost/browser/database/obj/1/5) but a
 redirect was issued automatically by the routing system to "http://
 localhost/browser/database/obj/1/5/".  The URL was defined with a
 trailing slash so Flask will automatically redirect to the URL with the
 trailing slash if it was accessed without one.  Make sure to directly send
 your DELETE-request to this URL since we can\'t make browsers or HTTP
 clients redirect with form data reliably or without user interaction.\n\
 nNote: this exception is only raised in debug mode".


 Can not reproduce at my end.
>>>

 On Mon, Oct 22, 2018 at 11:36 AM Khushboo Vashi <
 khushboo.va...@enterprisedb.com> wrote:

> Hi,
>
> Please find the attached updated patch.
>
> On Wed, Oct 17, 2018 at 7:58 PM Dave Page  wrote:
>
>> Hi
>>
>> Some relatively minor details to fix please:
>>
>> - There's no doc update.
>>
>> Done.
>
>> - I think fa-trash-alt might be better for the Drop icon.
>>
>> Done.
>
>> - I don't like the Drop Cascade icon. Maybe have Chethana create one
>> based on fa-trash-alt, shrunken a little with a downwards pointing arrow 
>> on
>> the bottom right.
>>
>> Done.
>
>> Thanks!
>>
>> Thanks,
> Khushboo
>
>> On Tue, Oct 16, 2018 at 10:23 AM Khushboo Vashi <
>> khushboo.va...@enterprisedb.com> wrote:
>>
>>> Hi,
>>>
>>> Please find the attached updated patch with the following changes.
>>> 1. Introduced header buttons for Drop and Drop Cascade
>>> 2. Fixed checkbox alignment issue
>>> 3. Refresh the grid on the error
>>>
>>> Currently I have removed multi delete table-space test case. I have
>>> tried to create sub directories but didn't work due to permission issue.
>>>
>>> Thanks,
>>> Khushboo
>>>
>>>
>>>
>>>
>>> On Tue, Oct 9, 2018 at 3:35 PM Dave Page  wrote:
>>>
 Hi

 On Tue, Oct 9, 2018 at 8:03 AM Kh

Build failed in Jenkins: pgadmin4-master-python26 #933

2018-10-31 Thread pgAdmin 4 Jenkins
See 


Changes:

[Dave Page] Fix buildfarm failures.

--
[...truncated 948.89 KB...]
When backup the object with option 
sections to all data,
When backup the server with option - Do 
not save comments,,
When backup the server,
When backup the object with option - 
load via partition root,
When backup the object with option - 
miscellaneous,
When backup the object with option - 
all queries and format custom,
When backup the server with encoding,
When backup the server with option - Do 
not save privilege, tablespace, unlogged table data,
When backup the object with option - Do 
not save privilege, tablespace, unlogged table data,
When backup object with format 
directory,
When backup the server with option 
only_data,
When backup the object with option - 
all queries,
When backup the object with option - 
format plain and dns_owner,
When backup the server with option - 
miscellaneous,
When backup the object with option 
only_schema)
TableAddTestCase (Create Hash partitioned table with 2 
partitions,
Create Range partitioned table with 2 
partitions,
Create List partitioned table with 2 
partitions)
BackupJobTest (When backup the object with the default options)
RestoreCreateJobTest (When restore object with option - Disbale,
When restore the object with Type of 
objects,
When restore object with option - 
Miscellaneous,
When restore object with option - Do 
not save,
When restore object with option - 
Queries,
When restore object with default 
options,
When restore object with the sections 
options,
When restore object with option - Do 
not save comments,
When restore object with format 
directory)
PgAgentDeleteStepTestCase (Delete pgAgent Step)
PgAgentPutScheduleTestCase (Update schedule with repeat,
Update schedule change exception date 
and time,
Update schedule delete exception,
Update schedule add exception,
Update schedule with start and end time)
PgAgentDeleteScheduleTestCase (Delete pgAgent Schedule)
TestSSLConnection (Test for SSL connection)
PgAgentGetTestCase (Get pgAgent job)
PgAgentPutStepTestCase (Update step with kind, description, 
code and error,
Update step with connection type and 
string)
PgAgentDeleteTestCase (Delete pgAgent job)
RestoreJobTest (When restore the object with the default 
options)

EDB Postgres AS 9.2:

387 tests passed
0 tests failed
34 tests skipped:
PgAgentAddStepTestCase (Create step for pgAgent job)
PgAgentAddScheduleTestCase (Create schedule with exception in 
pgAgent job)
TableUpdateTestCase (Detach partition from existing list 
partitioned table,
Create partitions of existing range 
partitioned table,
Detach partition from existing range 
partitioned table,
Attach partition to existing range 
partitioned table,
Attach partition to existing list 
partitioned table,
Create partitions of existing list 
partitioned table)
ViewsDeleteTestCase (Delete materialized view under schema node)
ViewsGetTestCase (Get materialized view under schema node)
PgAgentPutTestCase (Put pgAgent job)
ResourceGroupsGetTestCase (Get resource groups)
TableAddTestCase (Create Hash partitioned table with 2 
partitions,
Create Ra

Build failed in Jenkins: pgadmin4-master-python34 #790

2018-10-31 Thread pgAdmin 4 Jenkins
See 


Changes:

[Dave Page] Fix buildfarm failures.

--
[...truncated 948.25 KB...]
When backup the object with option - Do 
not save privilege, tablespace, unlogged table data,
When backup the object with option 
only_data,
When backup the server with option 
only_data,
When backup the object with option 
only_schema,
When backup the server with option - 
all queries,
When backup the server with encoding,
When backup the object with option - 
all queries and format custom)
PackagePutTestCase (Fetch Package Node URL)
PgAgentGetTestCase (Get pgAgent job)
BackupJobTest (When backup the object with the default options)
PgAgentAddTestCase (Add pgAgent job)
RestoreJobTest (When restore the object with the default 
options)
PgAgentStatsTestCase (Check the stats of pgAgent job)
TableAddTestCase (Create Hash partitioned table with 2 
partitions,
Create List partitioned table with 2 
partitions,
Create Range partitioned table with 2 
partitions)
MaintenanceCreateJobTest (When maintenance object with VACUUM 
FULL,
When maintenance the object with the 
REINDEX,
When maintenance the object with the 
CLUSTER,
When maintenance object with default 
options,
When maintenance object with the 
ANALYZE)
PgAgentDeleteStepTestCase (Delete pgAgent Step)
PackageAddTestCase (Fetch Package Node URL)
PackageEDBFuncsGetTestCase (Fetch Package Functions/Procedures 
URL)
ResourceGroupsPutTestCase (Put resource groups)
procedureDeleteMultipleTestCase (Fetch Procedure Node URL)

PostgreSQL 9.6:

380 tests passed
1 test failed:
EventTriggerMultipleDeleteTestCase (Fetch Event Trigger Node 
URL)
40 tests skipped:
PackageDeleteTestCase (Fetch Package Node URL)
PgAgentPutScheduleTestCase (Update schedule with repeat,
Update schedule change exception date 
and time,
Update schedule with start and end time,
Update schedule add exception,
Update schedule delete exception)
ResourceGroupsDeleteTestCase (Delete resource groups,
Delete multiple resource groups)
TableUpdateTestCase (Attach partition to existing list 
partitioned table,
Create partitions of existing range 
partitioned table,
Attach partition to existing range 
partitioned table,
Detach partition from existing list 
partitioned table,
Create partitions of existing list 
partitioned table,
Detach partition from existing range 
partitioned table)
SynonymAddTestCase (Default Node URL)
SynonymDeleteMultipleTestCase (Fetch synonym Node URL)
PgAgentDeleteScheduleTestCase (Delete pgAgent Schedule)
MaintenanceJobTest (When maintenance the object with the 
default options)
PgAgentAddScheduleTestCase (Create schedule with exception in 
pgAgent job)
SynonymDeleteTestCase (Fetch synonym Node URL)
PackageDeleteMultipleTestCase (Fetch Package Node URL)
SynonymGetTestCase (Fetch synonym Node URL)
ResourceGroupsGetTestCase (Get resource groups)
ProcedurePutTestCase (Fetch Procedure Node URL)
TestSSLConnection (Test for SSL connection)
PgAgentPutTestCase (Put pgAgent job)
PgAgentAddStepTestCase (Create step for pgAgent job)
PackageGetTestCase (Fetch Package Node URL)
procedureDeleteTestCase (Fetch Procedure Node URL)
RestoreCreateJobTest (When restore object with option - 
Miscellaneous,
When restore object with option - 
Queries,
When restore object with option - Do 
not save,
When restore the

Build failed in Jenkins: pgadmin4-master-python36 #792

2018-10-31 Thread pgAdmin 4 Jenkins
See 


Changes:

[Dave Page] Fix buildfarm failures.

--
[...truncated 947.90 KB...]
Attach partition to existing range 
partitioned table,
Attach partition to existing list 
partitioned table)
PgAgentAddTestCase (Add pgAgent job)
PgAgentDeleteTestCase (Delete pgAgent job)
PgAgentPutTestCase (Put pgAgent job)
PgAgentAddScheduleTestCase (Create schedule with exception in 
pgAgent job)
PgAgentAddStepTestCase (Create step for pgAgent job)
PgAgentDeleteScheduleTestCase (Delete pgAgent Schedule)
PgAgentDeleteStepTestCase (Delete pgAgent Step)
PgAgentGetTestCase (Get pgAgent job)
PgAgentPutScheduleTestCase (Update schedule with start and end 
time,
Update schedule with repeat,
Update schedule add exception,
Update schedule change exception date 
and time,
Update schedule delete exception)
PgAgentPutStepTestCase (Update step with kind, description, 
code and error,
Update step with connection type and 
string)
PgAgentStatsTestCase (Check the stats of pgAgent job)
TestSSLConnection (Test for SSL connection)
BackupCreateJobTest (When backup object with default options,
When backup object with format 
directory,
When backup the object with option 
sections to all data,
When backup the object with option 
only_data,
When backup the object with option 
only_schema,
When backup the object with option - 
format plain and dns_owner,
When backup the object with option - Do 
not save privilege, tablespace, unlogged table data,
When backup the object with option - Do 
not save comments,,
When backup the object with option - 
all queries,
When backup the object with option - 
load via partition root,
When backup the object with option - 
all queries and format custom,
When backup the object with option - 
miscellaneous,
When backup the object with format tar,
When backup the server,
When backup the server with option 
only_data,
When backup the server with option 
only_schema,
When backup the server with option - Do 
not save privilege, tablespace, unlogged table data,
When backup the server with option - Do 
not save comments,,
When backup the server with option - 
all queries,
When backup the server with option - 
miscellaneous,
When backup the server with encoding,
When backup globals)
BackupJobTest (When backup the object with the default options)
MaintenanceJobTest (When maintenance the object with the 
default options)
MaintenanceCreateJobTest (When maintenance object with default 
options,
When maintenance object with VACUUM 
FULL,
When maintenance object with the 
ANALYZE,
When maintenance the object with the 
REINDEX,
When maintenance the object with the 
CLUSTER)
RestoreJobTest (When restore the object with the default 
options)
RestoreCreateJobTest (When restore object with default options,
When restore object with format 
directory,
When restore object with the sections 
options,
When restore the object with Type of 
objects,
When restore object with option - Do 
not save,
When restore object with option - Do 
not save comments,
When restore object with option - 
Queries,
   

[pgAdmin4][patch] Body tag level padding not required

2018-10-31 Thread Aditya Toshniwal
Hi Hackers,

Attached is a tiny patch to remove CSS values set for body tag which are
not required. This may create problems as it is at body level and so should
be removed.

-- 
Thanks and Regards,
Aditya Toshniwal
Software Engineer | EnterpriseDB Software Solutions | Pune
"Don't Complain about Heat, Plant a tree"


body_padding_not_required.patch
Description: Binary data


Build failed in Jenkins: pgadmin4-master-python37 #37

2018-10-31 Thread pgAdmin 4 Jenkins
See 


Changes:

[Dave Page] Fix buildfarm failures.

--
[...truncated 948.31 KB...]
Attach partition to existing range 
partitioned table,
Attach partition to existing list 
partitioned table)
PgAgentAddTestCase (Add pgAgent job)
PgAgentDeleteTestCase (Delete pgAgent job)
PgAgentPutTestCase (Put pgAgent job)
PgAgentAddScheduleTestCase (Create schedule with exception in 
pgAgent job)
PgAgentAddStepTestCase (Create step for pgAgent job)
PgAgentDeleteScheduleTestCase (Delete pgAgent Schedule)
PgAgentDeleteStepTestCase (Delete pgAgent Step)
PgAgentGetTestCase (Get pgAgent job)
PgAgentPutScheduleTestCase (Update schedule with start and end 
time,
Update schedule with repeat,
Update schedule add exception,
Update schedule change exception date 
and time,
Update schedule delete exception)
PgAgentPutStepTestCase (Update step with kind, description, 
code and error,
Update step with connection type and 
string)
PgAgentStatsTestCase (Check the stats of pgAgent job)
TestSSLConnection (Test for SSL connection)
BackupCreateJobTest (When backup object with default options,
When backup object with format 
directory,
When backup the object with option 
sections to all data,
When backup the object with option 
only_data,
When backup the object with option 
only_schema,
When backup the object with option - 
format plain and dns_owner,
When backup the object with option - Do 
not save privilege, tablespace, unlogged table data,
When backup the object with option - Do 
not save comments,,
When backup the object with option - 
all queries,
When backup the object with option - 
load via partition root,
When backup the object with option - 
all queries and format custom,
When backup the object with option - 
miscellaneous,
When backup the object with format tar,
When backup the server,
When backup the server with option 
only_data,
When backup the server with option 
only_schema,
When backup the server with option - Do 
not save privilege, tablespace, unlogged table data,
When backup the server with option - Do 
not save comments,,
When backup the server with option - 
all queries,
When backup the server with option - 
miscellaneous,
When backup the server with encoding,
When backup globals)
BackupJobTest (When backup the object with the default options)
MaintenanceJobTest (When maintenance the object with the 
default options)
MaintenanceCreateJobTest (When maintenance object with default 
options,
When maintenance object with VACUUM 
FULL,
When maintenance object with the 
ANALYZE,
When maintenance the object with the 
REINDEX,
When maintenance the object with the 
CLUSTER)
RestoreJobTest (When restore the object with the default 
options)
RestoreCreateJobTest (When restore object with default options,
When restore object with format 
directory,
When restore object with the sections 
options,
When restore the object with Type of 
objects,
When restore object with option - Do 
not save,
When restore object with option - Do 
not save comments,
When restore object with option - 
Queries,

Build failed in Jenkins: pgadmin4-master-python35 #789

2018-10-31 Thread pgAdmin 4 Jenkins
See 


Changes:

[Dave Page] Fix buildfarm failures.

--
[...truncated 948.19 KB...]
MaintenanceCreateJobTest (When maintenance object with VACUUM 
FULL,
When maintenance the object with the 
CLUSTER,
When maintenance object with default 
options,
When maintenance object with the 
ANALYZE,
When maintenance the object with the 
REINDEX)
BackupCreateJobTest (When backup the object with option 
only_data,
When backup the object with option - 
all queries and format custom,
When backup the server with option - 
miscellaneous,
When backup the server with encoding,
When backup the object with option - Do 
not save privilege, tablespace, unlogged table data,
When backup the server with option - 
all queries,
When backup the object with option 
only_schema,
When backup the server with option 
only_schema,
When backup the server with option 
only_data,
When backup the object with option 
sections to all data,
When backup the object with option - 
format plain and dns_owner,
When backup the object with option - 
load via partition root,
When backup the object with option - Do 
not save comments,,
When backup the object with option - 
all queries,
When backup object with default options,
When backup the server with option - Do 
not save privilege, tablespace, unlogged table data,
When backup the server with option - Do 
not save comments,,
When backup the server,
When backup the object with option - 
miscellaneous,
When backup object with format 
directory,
When backup globals,
When backup the object with format tar)
ResourceGroupsDeleteTestCase (Delete resource groups,
Delete multiple resource groups)
PackageEDBFuncsGetTestCase (Fetch Package Functions/Procedures 
URL)
BackupJobTest (When backup the object with the default options)
ProcedureGetTestCase (Fetch Procedure Node URL)
PackageGetTestCase (Fetch Package Node URL)
PackagePutTestCase (Fetch Package Node URL)
PgAgentAddTestCase (Add pgAgent job)
PgAgentDeleteStepTestCase (Delete pgAgent Step)
PackageAddTestCase (Fetch Package Node URL)
PgAgentGetTestCase (Get pgAgent job)

EDB Postgres AS 9.6:

399 tests passed
2 tests failed:
EventTriggerMultipleDeleteTestCase (Fetch Event Trigger Node 
URL)
ResourceGroupsDeleteTestCase (Delete multiple resource groups)
20 tests skipped:
BackupCreateJobTest (When backup the object with option 
only_data,
When backup the object with option - 
all queries and format custom,
When backup the server with option - 
miscellaneous,
When backup the server with encoding,
When backup the object with option - Do 
not save privilege, tablespace, unlogged table data,
When backup the server with option - 
all queries,
When backup the object with option 
only_schema,
When backup the server with option 
only_schema,
When backup the server with option 
only_data,
When backup the object with option 
sections to all data,
When backup the object with option - 
format plain and dns_owner,
When backup the object with option - 
load via partition root,
When backup the object with option - Do 
not save comments,,
When backup the obj

pgAdmin 4 commit: Remove some CSS for the body level that isn't require

2018-10-31 Thread Dave Page
Remove some CSS for the body level that isn't required and may cause issues.

Branch
--
master

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

Modified Files
--
web/pgadmin/static/scss/_bootstrap.overrides.scss | 2 --
1 file changed, 2 deletions(-)



Re: [pgAdmin4][patch] Body tag level padding not required

2018-10-31 Thread Dave Page
Thanks, committed.

On Wed, Oct 31, 2018 at 12:00 PM Aditya Toshniwal <
aditya.toshni...@enterprisedb.com> wrote:

> Hi Hackers,
>
> Attached is a tiny patch to remove CSS values set for body tag which are
> not required. This may create problems as it is at body level and so should
> be removed.
>
> --
> Thanks and Regards,
> Aditya Toshniwal
> Software Engineer | EnterpriseDB Software Solutions | Pune
> "Don't Complain about Heat, Plant a tree"
>


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

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


Build failed in Jenkins: pgadmin4-master-python27 #803

2018-10-31 Thread pgAdmin 4 Jenkins
See 


Changes:

[Dave Page] Fix buildfarm failures.

--
[...truncated 947.37 KB...]
When backup the object with option 
sections to all data,
When backup the server with option - Do 
not save comments,,
When backup the server,
When backup the object with option - 
load via partition root,
When backup the object with option - 
miscellaneous,
When backup the object with option - 
all queries and format custom,
When backup the server with encoding,
When backup the server with option - Do 
not save privilege, tablespace, unlogged table data,
When backup the object with option - Do 
not save privilege, tablespace, unlogged table data,
When backup object with format 
directory,
When backup the server with option 
only_data,
When backup the object with option - 
all queries,
When backup the object with option - 
format plain and dns_owner,
When backup the server with option - 
miscellaneous,
When backup the object with option 
only_schema)
TableAddTestCase (Create Hash partitioned table with 2 
partitions,
Create Range partitioned table with 2 
partitions,
Create List partitioned table with 2 
partitions)
BackupJobTest (When backup the object with the default options)
RestoreCreateJobTest (When restore object with option - Disbale,
When restore the object with Type of 
objects,
When restore object with option - 
Miscellaneous,
When restore object with option - Do 
not save,
When restore object with option - 
Queries,
When restore object with default 
options,
When restore object with the sections 
options,
When restore object with option - Do 
not save comments,
When restore object with format 
directory)
PgAgentDeleteStepTestCase (Delete pgAgent Step)
PgAgentPutScheduleTestCase (Update schedule with repeat,
Update schedule change exception date 
and time,
Update schedule delete exception,
Update schedule add exception,
Update schedule with start and end time)
PgAgentDeleteScheduleTestCase (Delete pgAgent Schedule)
TestSSLConnection (Test for SSL connection)
PgAgentGetTestCase (Get pgAgent job)
PgAgentPutStepTestCase (Update step with kind, description, 
code and error,
Update step with connection type and 
string)
PgAgentDeleteTestCase (Delete pgAgent job)
RestoreJobTest (When restore the object with the default 
options)

EDB Postgres AS 9.2:

387 tests passed
0 tests failed
34 tests skipped:
PgAgentAddStepTestCase (Create step for pgAgent job)
PgAgentAddScheduleTestCase (Create schedule with exception in 
pgAgent job)
TableUpdateTestCase (Detach partition from existing list 
partitioned table,
Create partitions of existing range 
partitioned table,
Detach partition from existing range 
partitioned table,
Attach partition to existing range 
partitioned table,
Attach partition to existing list 
partitioned table,
Create partitions of existing list 
partitioned table)
ViewsDeleteTestCase (Delete materialized view under schema node)
ViewsGetTestCase (Get materialized view under schema node)
PgAgentPutTestCase (Put pgAgent job)
ResourceGroupsGetTestCase (Get resource groups)
TableAddTestCase (Create Hash partitioned table with 2 
partitions,
Create Ra

pgAdmin 4 commit: Fix regression test.

2018-10-31 Thread Dave Page
Fix regression test.

Branch
--
master

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

Modified Files
--
.../event_triggers/tests/test_event_trigger_delete_multiple.py  | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)



Build failed in Jenkins: pgadmin4-master-python35 #790

2018-10-31 Thread pgAdmin 4 Jenkins
See 


Changes:

[Dave Page] Remove some CSS for the body level that isn't required and may cause

--
[...truncated 948.07 KB...]
When restore object with option - Do 
not save,
When restore object with option - 
Miscellaneous,
When restore the object with Type of 
objects,
When restore object with default 
options)
EventTriggerAddTestCase (Fetch Event Trigger Node URL)
ResourceGroupsDeleteTestCase (Delete resource groups,
Delete multiple resource groups)
EventTriggerPutTestCase (Fetch Event Trigger Node URL)
ViewsGetTestCase (Get materialized view under schema node)
PgAgentPutStepTestCase (Update step with connection type and 
string,
Update step with kind, description, 
code and error)
RestoreJobTest (When restore the object with the default 
options)
MaintenanceJobTest (When maintenance the object with the 
default options)
PgAgentGetTestCase (Get pgAgent job)
ViewsAddTestCase (Add materialized view under schema node)
PgAgentPutTestCase (Put pgAgent job)
PgAgentStatsTestCase (Check the stats of pgAgent job)
PgAgentAddStepTestCase (Create step for pgAgent job)
MaintenanceCreateJobTest (When maintenance the object with the 
CLUSTER,
When maintenance object with the 
ANALYZE,
When maintenance the object with the 
REINDEX,
When maintenance object with VACUUM 
FULL,
When maintenance object with default 
options)
TestSSLConnection (Test for SSL connection)
ViewsDeleteMultipleTestCase (Delete multiple materialized view 
under schema node)
PgAgentAddScheduleTestCase (Create schedule with exception in 
pgAgent job)
ResourceGroupsPutTestCase (Put resource groups)
ResourceGroupsGetTestCase (Get resource groups)
EventTriggerDeleteTestCase (Fetch Event Trigger Node URL)
TableUpdateTestCase (Create partitions of existing list 
partitioned table,
Attach partition to existing range 
partitioned table,
Attach partition to existing list 
partitioned table,
Detach partition from existing list 
partitioned table,
Detach partition from existing range 
partitioned table,
Create partitions of existing range 
partitioned table)
TableAddTestCase (Create List partitioned table with 2 
partitions,
Create Hash partitioned table with 2 
partitions,
Create Range partitioned table with 2 
partitions)

EDB Postgres AS 9.4:

399 tests passed
2 tests failed:
EventTriggerMultipleDeleteTestCase (Fetch Event Trigger Node 
URL)
ResourceGroupsDeleteTestCase (Delete multiple resource groups)
20 tests skipped:
PgAgentPutStepTestCase (Update step with connection type and 
string,
Update step with kind, description, 
code and error)
MaintenanceJobTest (When maintenance the object with the 
default options)
PgAgentGetTestCase (Get pgAgent job)
PgAgentAddStepTestCase (Create step for pgAgent job)
PgAgentPutTestCase (Put pgAgent job)
BackupCreateJobTest (When backup the object with option - load 
via partition root,
When backup the object with option - 
all queries and format custom,
When backup the server with option - Do 
not save privilege, tablespace, unlogged table data,
When backup globals,
When backup the object with option - 
format plain and dns_owner,
When backup the object with option 
only_data,
When backup the object with format tar,
When backup the server with option - 
all queries,
When backup the object with option 
only_schema,
When backup the server,
 

Build failed in Jenkins: pgadmin4-master-python37 #38

2018-10-31 Thread pgAdmin 4 Jenkins
See 


Changes:

[Dave Page] Remove some CSS for the body level that isn't required and may cause

[Dave Page] Fix regression test.

--
[...truncated 910.97 KB...]
Detach partition from existing range 
partitioned table,
Detach partition from existing list 
partitioned table,
Attach partition to existing range 
partitioned table,
Attach partition to existing list 
partitioned table)
PgAgentAddTestCase (Add pgAgent job)
PgAgentDeleteTestCase (Delete pgAgent job)
PgAgentPutTestCase (Put pgAgent job)
PgAgentAddScheduleTestCase (Create schedule with exception in 
pgAgent job)
PgAgentAddStepTestCase (Create step for pgAgent job)
PgAgentDeleteScheduleTestCase (Delete pgAgent Schedule)
PgAgentDeleteStepTestCase (Delete pgAgent Step)
PgAgentGetTestCase (Get pgAgent job)
PgAgentPutScheduleTestCase (Update schedule with start and end 
time,
Update schedule with repeat,
Update schedule add exception,
Update schedule change exception date 
and time,
Update schedule delete exception)
PgAgentPutStepTestCase (Update step with kind, description, 
code and error,
Update step with connection type and 
string)
PgAgentStatsTestCase (Check the stats of pgAgent job)
TestSSLConnection (Test for SSL connection)
BackupCreateJobTest (When backup object with default options,
When backup object with format 
directory,
When backup the object with option 
sections to all data,
When backup the object with option 
only_data,
When backup the object with option 
only_schema,
When backup the object with option - 
format plain and dns_owner,
When backup the object with option - Do 
not save privilege, tablespace, unlogged table data,
When backup the object with option - Do 
not save comments,,
When backup the object with option - 
all queries,
When backup the object with option - 
load via partition root,
When backup the object with option - 
all queries and format custom,
When backup the object with option - 
miscellaneous,
When backup the object with format tar,
When backup the server,
When backup the server with option 
only_data,
When backup the server with option 
only_schema,
When backup the server with option - Do 
not save privilege, tablespace, unlogged table data,
When backup the server with option - Do 
not save comments,,
When backup the server with option - 
all queries,
When backup the server with option - 
miscellaneous,
When backup the server with encoding,
When backup globals)
BackupJobTest (When backup the object with the default options)
MaintenanceJobTest (When maintenance the object with the 
default options)
MaintenanceCreateJobTest (When maintenance object with default 
options,
When maintenance object with VACUUM 
FULL,
When maintenance object with the 
ANALYZE,
When maintenance the object with the 
REINDEX,
When maintenance the object with the 
CLUSTER)
RestoreJobTest (When restore the object with the default 
options)
RestoreCreateJobTest (When restore object with default options,
When restore object with format 
directory,
When restore object with the sections 
options,
When restore the object with Type of 
objects,
 

Build failed in Jenkins: pgadmin4-master-python27 #804

2018-10-31 Thread pgAdmin 4 Jenkins
See 


Changes:

[Dave Page] Remove some CSS for the body level that isn't required and may cause

[Dave Page] Fix regression test.

--
[...truncated 912.95 KB...]
When backup the object with option 
only_data,
When backup the object with option 
sections to all data,
When backup the server with option - Do 
not save comments,,
When backup the server,
When backup the object with option - 
load via partition root,
When backup the object with option - 
miscellaneous,
When backup the object with option - 
all queries and format custom,
When backup the server with encoding,
When backup the server with option - Do 
not save privilege, tablespace, unlogged table data,
When backup the object with option - Do 
not save privilege, tablespace, unlogged table data,
When backup object with format 
directory,
When backup the server with option 
only_data,
When backup the object with option - 
all queries,
When backup the object with option - 
format plain and dns_owner,
When backup the server with option - 
miscellaneous,
When backup the object with option 
only_schema)
TableAddTestCase (Create Hash partitioned table with 2 
partitions,
Create Range partitioned table with 2 
partitions,
Create List partitioned table with 2 
partitions)
BackupJobTest (When backup the object with the default options)
RestoreCreateJobTest (When restore object with option - Disbale,
When restore the object with Type of 
objects,
When restore object with option - 
Miscellaneous,
When restore object with option - Do 
not save,
When restore object with option - 
Queries,
When restore object with default 
options,
When restore object with the sections 
options,
When restore object with option - Do 
not save comments,
When restore object with format 
directory)
PgAgentDeleteStepTestCase (Delete pgAgent Step)
PgAgentPutScheduleTestCase (Update schedule with repeat,
Update schedule change exception date 
and time,
Update schedule delete exception,
Update schedule add exception,
Update schedule with start and end time)
PgAgentDeleteScheduleTestCase (Delete pgAgent Schedule)
TestSSLConnection (Test for SSL connection)
PgAgentGetTestCase (Get pgAgent job)
PgAgentPutStepTestCase (Update step with kind, description, 
code and error,
Update step with connection type and 
string)
PgAgentDeleteTestCase (Delete pgAgent job)
RestoreJobTest (When restore the object with the default 
options)

EDB Postgres AS 9.2:

387 tests passed
0 tests failed
34 tests skipped:
PgAgentAddStepTestCase (Create step for pgAgent job)
PgAgentAddScheduleTestCase (Create schedule with exception in 
pgAgent job)
TableUpdateTestCase (Detach partition from existing list 
partitioned table,
Create partitions of existing range 
partitioned table,
Detach partition from existing range 
partitioned table,
Attach partition to existing range 
partitioned table,
Attach partition to existing list 
partitioned table,
Create partitions of existing list 
partitioned table)
ViewsDeleteTestCase (Delete materialized view under schema node)
ViewsGetTestCase (Get materialized view under schema node)
PgAgentPutTestCase (Put pgAgent job)
ResourceGroupsG

Build failed in Jenkins: pgadmin4-master-python26 #934

2018-10-31 Thread pgAdmin 4 Jenkins
See 


Changes:

[Dave Page] Remove some CSS for the body level that isn't required and may cause

[Dave Page] Fix regression test.

--
[...truncated 914.47 KB...]
When backup the object with option 
only_data,
When backup the object with option 
sections to all data,
When backup the server with option - Do 
not save comments,,
When backup the server,
When backup the object with option - 
load via partition root,
When backup the object with option - 
miscellaneous,
When backup the object with option - 
all queries and format custom,
When backup the server with encoding,
When backup the server with option - Do 
not save privilege, tablespace, unlogged table data,
When backup the object with option - Do 
not save privilege, tablespace, unlogged table data,
When backup object with format 
directory,
When backup the server with option 
only_data,
When backup the object with option - 
all queries,
When backup the object with option - 
format plain and dns_owner,
When backup the server with option - 
miscellaneous,
When backup the object with option 
only_schema)
TableAddTestCase (Create Hash partitioned table with 2 
partitions,
Create Range partitioned table with 2 
partitions,
Create List partitioned table with 2 
partitions)
BackupJobTest (When backup the object with the default options)
RestoreCreateJobTest (When restore object with option - Disbale,
When restore the object with Type of 
objects,
When restore object with option - 
Miscellaneous,
When restore object with option - Do 
not save,
When restore object with option - 
Queries,
When restore object with default 
options,
When restore object with the sections 
options,
When restore object with option - Do 
not save comments,
When restore object with format 
directory)
PgAgentDeleteStepTestCase (Delete pgAgent Step)
PgAgentPutScheduleTestCase (Update schedule with repeat,
Update schedule change exception date 
and time,
Update schedule delete exception,
Update schedule add exception,
Update schedule with start and end time)
PgAgentDeleteScheduleTestCase (Delete pgAgent Schedule)
TestSSLConnection (Test for SSL connection)
PgAgentGetTestCase (Get pgAgent job)
PgAgentPutStepTestCase (Update step with kind, description, 
code and error,
Update step with connection type and 
string)
PgAgentDeleteTestCase (Delete pgAgent job)
RestoreJobTest (When restore the object with the default 
options)

EDB Postgres AS 9.2:

387 tests passed
0 tests failed
34 tests skipped:
PgAgentAddStepTestCase (Create step for pgAgent job)
PgAgentAddScheduleTestCase (Create schedule with exception in 
pgAgent job)
TableUpdateTestCase (Detach partition from existing list 
partitioned table,
Create partitions of existing range 
partitioned table,
Detach partition from existing range 
partitioned table,
Attach partition to existing range 
partitioned table,
Attach partition to existing list 
partitioned table,
Create partitions of existing list 
partitioned table)
ViewsDeleteTestCase (Delete materialized view under schema node)
ViewsGetTestCase (Get materialized view under schema node)
PgAgentPutTestCase (Put pgAgent job)
ResourceGroupsG

Build failed in Jenkins: pgadmin4-master-python36 #793

2018-10-31 Thread pgAdmin 4 Jenkins
See 


Changes:

[Dave Page] Remove some CSS for the body level that isn't required and may cause

[Dave Page] Fix regression test.

--
[...truncated 910.64 KB...]
Detach partition from existing range 
partitioned table,
Detach partition from existing list 
partitioned table,
Attach partition to existing range 
partitioned table,
Attach partition to existing list 
partitioned table)
PgAgentAddTestCase (Add pgAgent job)
PgAgentDeleteTestCase (Delete pgAgent job)
PgAgentPutTestCase (Put pgAgent job)
PgAgentAddScheduleTestCase (Create schedule with exception in 
pgAgent job)
PgAgentAddStepTestCase (Create step for pgAgent job)
PgAgentDeleteScheduleTestCase (Delete pgAgent Schedule)
PgAgentDeleteStepTestCase (Delete pgAgent Step)
PgAgentGetTestCase (Get pgAgent job)
PgAgentPutScheduleTestCase (Update schedule with start and end 
time,
Update schedule with repeat,
Update schedule add exception,
Update schedule change exception date 
and time,
Update schedule delete exception)
PgAgentPutStepTestCase (Update step with kind, description, 
code and error,
Update step with connection type and 
string)
PgAgentStatsTestCase (Check the stats of pgAgent job)
TestSSLConnection (Test for SSL connection)
BackupCreateJobTest (When backup object with default options,
When backup object with format 
directory,
When backup the object with option 
sections to all data,
When backup the object with option 
only_data,
When backup the object with option 
only_schema,
When backup the object with option - 
format plain and dns_owner,
When backup the object with option - Do 
not save privilege, tablespace, unlogged table data,
When backup the object with option - Do 
not save comments,,
When backup the object with option - 
all queries,
When backup the object with option - 
load via partition root,
When backup the object with option - 
all queries and format custom,
When backup the object with option - 
miscellaneous,
When backup the object with format tar,
When backup the server,
When backup the server with option 
only_data,
When backup the server with option 
only_schema,
When backup the server with option - Do 
not save privilege, tablespace, unlogged table data,
When backup the server with option - Do 
not save comments,,
When backup the server with option - 
all queries,
When backup the server with option - 
miscellaneous,
When backup the server with encoding,
When backup globals)
BackupJobTest (When backup the object with the default options)
MaintenanceJobTest (When maintenance the object with the 
default options)
MaintenanceCreateJobTest (When maintenance object with default 
options,
When maintenance object with VACUUM 
FULL,
When maintenance object with the 
ANALYZE,
When maintenance the object with the 
REINDEX,
When maintenance the object with the 
CLUSTER)
RestoreJobTest (When restore the object with the default 
options)
RestoreCreateJobTest (When restore object with default options,
When restore object with format 
directory,
When restore object with the sections 
options,
When restore the object with Type of 
objects,

Build failed in Jenkins: pgadmin4-master-python34 #791

2018-10-31 Thread pgAdmin 4 Jenkins
See 


Changes:

[Dave Page] Remove some CSS for the body level that isn't required and may cause

[Dave Page] Fix regression test.

--
[...truncated 910.95 KB...]
When backup the server with encoding,
When backup globals,
When backup the object with option - 
format plain and dns_owner,
When backup the object with format tar,
When backup the server with option 
only_schema,
When backup the object with option 
sections to all data,
When backup the server,
When backup the server with option - Do 
not save comments,,
When backup the server with option 
only_data,
When backup the server with option - 
all queries,
When backup the object with option - Do 
not save privilege, tablespace, unlogged table data)
SynonymPutTestCase (Fetch synonym Node URL)
PgAgentAddStepTestCase (Create step for pgAgent job)
PgAgentAddScheduleTestCase (Create schedule with exception in 
pgAgent job)
procedureDeleteTestCase (Fetch Procedure Node URL)
ProcedureAddTestCase (Fetch Procedure Node URL)
TableAddTestCase (Create Hash partitioned table with 2 
partitions)
MaintenanceCreateJobTest (When maintenance the object with the 
CLUSTER,
When maintenance object with VACUUM 
FULL,
When maintenance object with the 
ANALYZE,
When maintenance the object with the 
REINDEX,
When maintenance object with default 
options)
RestoreJobTest (When restore the object with the default 
options)
PackageDeleteTestCase (Fetch Package Node URL)
ResourceGroupsGetTestCase (Get resource groups)
SynonymGetTestCase (Fetch synonym Node URL)
PgAgentDeleteScheduleTestCase (Delete pgAgent Schedule)
PgAgentDeleteStepTestCase (Delete pgAgent Step)
procedureDeleteMultipleTestCase (Fetch Procedure Node URL)
ProcedureGetTestCase (Fetch Procedure Node URL)
MaintenanceJobTest (When maintenance the object with the 
default options)
PackageEDBFuncsGetTestCase (Fetch Package Functions/Procedures 
URL)
ResourceGroupsDeleteTestCase (Delete multiple resource groups,
Delete resource groups)
SynonymAddTestCase (Default Node URL)
ProcedurePutTestCase (Fetch Procedure Node URL)
PackageAddTestCase (Fetch Package Node URL)
TestSSLConnection (Test for SSL connection)
PgAgentPutStepTestCase (Update step with kind, description, 
code and error,
Update step with connection type and 
string)
SynonymDeleteTestCase (Fetch synonym Node URL)
PgAgentGetTestCase (Get pgAgent job)
ResourceGroupsAddTestCase (Add resource groups)
ResourceGroupsPutTestCase (Put resource groups)
RestoreCreateJobTest (When restore object with the sections 
options,
When restore object with option - Do 
not save comments,
When restore object with option - 
Miscellaneous,
When restore object with option - 
Queries,
When restore the object with Type of 
objects,
When restore object with format 
directory,
When restore object with option - 
Disbale,
When restore object with option - Do 
not save,
When restore object with default 
options)
PackagePutTestCase (Fetch Package Node URL)
PgAgentStatsTestCase (Check the stats of pgAgent job)
SynonymDeleteMultipleTestCase (Fetch synonym Node URL)

EDB Postgres AS 9.5:

400 tests passed
1 test failed:
ResourceGroupsDeleteTestCase (Delete multiple resource groups)
20 tests skipped:
PgAgentDeleteScheduleTestCase (Delete pgAgent Schedule)
PgAgentDeleteStepTestCase (Delete pgAgent Step)
PgAgentPutSc

Build failed in Jenkins: pgadmin4-master-python35 #791

2018-10-31 Thread pgAdmin 4 Jenkins
See 


Changes:

[Dave Page] Fix regression test.

--
[...truncated 910.89 KB...]
When backup the server with option - Do 
not save comments,,
When backup the object with option - Do 
not save privilege, tablespace, unlogged table data,
When backup the object with option - 
load via partition root,
When backup the object with option 
only_schema,
When backup globals,
When backup the object with option - 
format plain and dns_owner,
When backup the object with option - Do 
not save comments,,
When backup the server with option - 
miscellaneous,
When backup the object with format tar,
When backup the object with option 
sections to all data,
When backup the server with option - 
all queries,
When backup the object with option - 
all queries,
When backup object with format 
directory,
When backup the server with option 
only_schema,
When backup object with default options,
When backup the object with option - 
all queries and format custom,
When backup the server with option - Do 
not save privilege, tablespace, unlogged table data,
When backup the object with option 
only_data,
When backup the server,
When backup the server with option 
only_data,
When backup the server with encoding)
SynonymPutTestCase (Fetch synonym Node URL)
SynonymDeleteTestCase (Fetch synonym Node URL)
SynonymDeleteMultipleTestCase (Fetch synonym Node URL)
PgAgentGetTestCase (Get pgAgent job)
PgAgentStatsTestCase (Check the stats of pgAgent job)
PackageGetTestCase (Fetch Package Node URL)
ProcedurePutTestCase (Fetch Procedure Node URL)
ResourceGroupsPutTestCase (Put resource groups)
PackagePutTestCase (Fetch Package Node URL)
PackageAddTestCase (Fetch Package Node URL)
ProcedureGetTestCase (Fetch Procedure Node URL)
MaintenanceCreateJobTest (When maintenance object with VACUUM 
FULL,
When maintenance object with the 
ANALYZE,
When maintenance the object with the 
CLUSTER,
When maintenance the object with the 
REINDEX,
When maintenance object with default 
options)
PgAgentDeleteScheduleTestCase (Delete pgAgent Schedule)
PgAgentPutStepTestCase (Update step with connection type and 
string,
Update step with kind, description, 
code and error)
RestoreCreateJobTest (When restore object with format directory,
When restore object with option - Do 
not save comments,
When restore object with option - Do 
not save,
When restore object with option - 
Queries,
When restore the object with Type of 
objects,
When restore object with option - 
Disbale,
When restore object with option - 
Miscellaneous,
When restore object with the sections 
options,
When restore object with default 
options)
PgAgentDeleteStepTestCase (Delete pgAgent Step)
TableAddTestCase (Create Hash partitioned table with 2 
partitions,
Create List partitioned table with 2 
partitions,
Create Range partitioned table with 2 
partitions)
PgAgentAddStepTestCase (Create step for pgAgent job)
ResourceGroupsDeleteTestCase (Delete resource groups,
Delete multiple resource groups)
BackupJobTest (When backup the object with the default options)
PgAgentPutTestCase (Put pgAgent job)