Re: [pgadmin-hackers] pgAdmin IV- Testing framework: Enhanced Test Result Summary

2016-09-19 Thread Navnath Gadakh
Hi Dave,
Error resolved. Please find the revised patch.

On Fri, Sep 16, 2016 at 9:23 PM, Dave Page 
wrote:

> Hi
>
> On Fri, Sep 16, 2016 at 2:37 PM, Navnath Gadakh
>  wrote:
> > Hi Dave,
> >  Please find the patch for the enhanced test result summary for
> testing
> > framework. The code for this, was completed before drop object's
> > functionality & independent from drop objects work.
> > Drop objects work will take time, I am working on that for remaining
> nodes.
> > Meanwhile, we go ahead with enhanced test summary.
> >
> > To run the test suite follow the commands
> > 1. python regression/runtests.py --pkg browser.server_groups.servers
> > 2. python regression/runtests.py --pkg
> > browser.server_groups.servers.databases
>
> I'm seeing some issues with this patch:
>
> - There are updates to config.py and setup.py that shouldn't be there.
> - I get this error at the end of a successful test run:
>
> Test Result Summary
> 
> Regression - PG 9.4: 25 tests passed, 0 tests failed
> 
>
> Please check output in file:
> /Users/dpage/git/pgadmin4/web/regression/regression.log
> Error in atexit._run_exitfuncs:
> Traceback (most recent call last):
>   File "/System/Library/Frameworks/Python.framework/Versions/2.7/
> lib/python2.7/atexit.py",
> line 24, in _run_exitfuncs
> func(*targs, **kargs)
>   File "/Users/dpage/git/pgadmin4/web/regression/test_utils.py", line
> 360, in drop_objects
> file_name, sys.exc_traceback.tb_lineno, exception))
> Exception: test_utils.py: line:337 'NoneType' object has no attribute
> '__getitem__'
> Error in sys.exitfunc:
> Traceback (most recent call last):
>   File "/System/Library/Frameworks/Python.framework/Versions/2.7/
> lib/python2.7/atexit.py",
> line 24, in _run_exitfuncs
> func(*targs, **kargs)
>   File "/Users/dpage/git/pgadmin4/web/regression/test_utils.py", line
> 360, in drop_objects
> file_name, sys.exc_traceback.tb_lineno, exception))
> Exception: test_utils.py: line:337 'NoneType' object has no attribute
> '__getitem__'
>
>
  Thanks.

> --
> Dave Page
> VP, Chief Architect, Tools & Installers
> EnterpriseDB: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>
> Blog: http://pgsnake.blogspot.com
> Twitter: @pgsnake
>



-- 
Regards,
Navnath


enhanced_testresult_summary.patch
Description: Binary data

-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers


[pgadmin-hackers] PATCH: To fix the issue in Packages node (pgAdmin4)

2016-09-19 Thread Murtuza Zabuawala
Hi,

PFA minor patch to fix the issue in Packages node where after updating any
package user was getting 'Not Found' error.
RM#1625

*Issue:*
It was due to wrong parent was provided while sending the node to client.

--
Regards,
Murtuza Zabuawala
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


RM_1625.patch
Description: Binary data

-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers


Re: [pgadmin-hackers] pgAdmin IV- Testing framework: Enhanced Test Result Summary

2016-09-19 Thread Dave Page
Hi

On Mon, Sep 19, 2016 at 8:14 AM, Navnath Gadakh
 wrote:
> Hi Dave,
> Error resolved. Please find the revised patch.

I still see the error:

Test Result Summary

Regression - PG 9.4: 25 tests passed, 0 tests failed


Please check output in file:
/Users/dpage/git/pgadmin4/web/regression/regression.log
Error in atexit._run_exitfuncs:
Traceback (most recent call last):
  File 
"/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/atexit.py",
line 24, in _run_exitfuncs
func(*targs, **kargs)
  File "/Users/dpage/git/pgadmin4/web/regression/test_utils.py", line
360, in drop_objects
file_name, sys.exc_traceback.tb_lineno, exception))
Exception: test_utils.py: line:337 'NoneType' object has no attribute
'__getitem__'
Error in sys.exitfunc:
Traceback (most recent call last):
  File 
"/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/atexit.py",
line 24, in _run_exitfuncs
func(*targs, **kargs)
  File "/Users/dpage/git/pgadmin4/web/regression/test_utils.py", line
360, in drop_objects
file_name, sys.exc_traceback.tb_lineno, exception))
Exception: test_utils.py: line:337 'NoneType' object has no attribute
'__getitem__'


-- 
Dave Page
VP, Chief Architect, Tools & Installers
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake


-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers


[pgadmin-hackers] pgAdmin 4 commit: Resolve a refresh issue when updating packages. Fixes

2016-09-19 Thread Dave Page
Resolve a refresh issue when updating packages. Fixes #1625

Branch
--
master

Details
---
http://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=82d63804c1877f6e272b02a54c1b420ae034bd28
Author: Murtuza Zabuawala 

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


-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers


Re: [pgadmin-hackers] PATCH: To fix the issue in Packages node (pgAdmin4)

2016-09-19 Thread Dave Page
Thanks, applied.

On Mon, Sep 19, 2016 at 8:20 AM, Murtuza Zabuawala
 wrote:
> Hi,
>
> PFA minor patch to fix the issue in Packages node where after updating any
> package user was getting 'Not Found' error.
> RM#1625
>
> Issue:
> It was due to wrong parent was provided while sending the node to client.
>
> --
> Regards,
> Murtuza Zabuawala
> EnterpriseDB: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>
>
> --
> Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgadmin-hackers
>



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

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


-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers


[pgadmin-hackers] [pgAdmin4][Patch]: RM1588 - User can not change the code of header through right if package created without body

2016-09-19 Thread Surinder Kumar
Hi

Please find attached patch with fix:
Minor changes in template file. Checks were missing for creating package
body and drop package body.

Please review.


Thanks,
Surinder Kumar


RM1588.patch
Description: Binary data

-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers


[pgadmin-hackers] PATCH: To fix column editor issue (pgAdmin4)

2016-09-19 Thread Murtuza Zabuawala
Hi,

PFA patch to fix the issue in column editor where subnode control was not
expanding properly.
RM#1703/04

*Issue:*
There was issue in SecurityGroup function(used to show/hide security tab)
which was not able to find node_info property when called from subnode
control, due t which it was breaking while expanding subnode control.

--
Regards,
Murtuza Zabuawala
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


RM_1703_1704.patch
Description: Binary data

-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers


[pgadmin-hackers] pgAdmin website commit: Add Linux package info

2016-09-19 Thread Dave Page
Add Linux package info

Branch
--
master

Details
---
http://git.postgresql.org/gitweb?p=pgadmin-www.git;a=commitdiff;h=b321740bf3193822afade8ec809b43e550e67a7f

Modified Files
--
download/linux4.php | 22 ++
download/menu.php   |  1 +
2 files changed, 23 insertions(+)


-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers


[pgadmin-hackers] pgAdmin website commit: Fix brain fart

2016-09-19 Thread Dave Page
Fix brain fart

Branch
--
master

Details
---
http://git.postgresql.org/gitweb?p=pgadmin-www.git;a=commitdiff;h=5aa32cc67ebeda7a9a3a87cc876eac12c6333db7

Modified Files
--
download/linux4.php | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)


-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers


Re: [pgadmin-hackers] Finalizing pgadmin4 RPM work

2016-09-19 Thread Dave Page
On Fri, Sep 16, 2016 at 9:17 AM, Devrim Gündüz  wrote:
>
> Hi,
>
> On Mon, 2016-09-12 at 11:46 +0100, Dave Page wrote:
>>
>> Awesome - thanks Devrim! I owe you a nice cool glass of spring water :-)
>
> \o/ Can't wait ;)
>
>> Let me know when packages available and ready to use, and I'll add a
>> page to the website to point people at them.
>
> They are currently available for 9.6 only, on yum.postgresql.org. All testing
> has been good so far. Feel free to add info to pgadmin website. I am planning
> to write a short blog post about that soon, about installation instructions,
> running, etc.

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

How's that? If you have instructions, please send me text (or better
yet, a patch), and I'll add them.

Thanks!

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

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


-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers


[pgadmin-hackers] PATCH: To fix the issue where user gets error following application server restart (pgAdmin4)

2016-09-19 Thread Murtuza Zabuawala
Hi,

PFA patch to fix the issue where user gets error following application
server restart.
RM#1707

--
Regards,
Murtuza Zabuawala
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


RM_1707.patch
Description: Binary data

-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers


Re: [pgadmin-hackers] pgAdmin IV- Testing framework: Enhanced Test Result Summary

2016-09-19 Thread Navnath Gadakh
Hi Dave,
  In the drop objects function scenario for 'NoneType' was not handled.
Code is added in the revised patch.

Thanks.

On Mon, Sep 19, 2016 at 2:03 PM, Dave Page 
wrote:

> Hi
>
> On Mon, Sep 19, 2016 at 8:14 AM, Navnath Gadakh
>  wrote:
> > Hi Dave,
> > Error resolved. Please find the revised patch.
>
> I still see the error:
>
> Test Result Summary
> 
> Regression - PG 9.4: 25 tests passed, 0 tests failed
> 
>
> Please check output in file:
> /Users/dpage/git/pgadmin4/web/regression/regression.log
> Error in atexit._run_exitfuncs:
> Traceback (most recent call last):
>   File "/System/Library/Frameworks/Python.framework/Versions/2.7/
> lib/python2.7/atexit.py",
> line 24, in _run_exitfuncs
> func(*targs, **kargs)
>   File "/Users/dpage/git/pgadmin4/web/regression/test_utils.py", line
> 360, in drop_objects
> file_name, sys.exc_traceback.tb_lineno, exception))
> Exception: test_utils.py: line:337 'NoneType' object has no attribute
> '__getitem__'
> Error in sys.exitfunc:
> Traceback (most recent call last):
>   File "/System/Library/Frameworks/Python.framework/Versions/2.7/
> lib/python2.7/atexit.py",
> line 24, in _run_exitfuncs
> func(*targs, **kargs)
>   File "/Users/dpage/git/pgadmin4/web/regression/test_utils.py", line
> 360, in drop_objects
> file_name, sys.exc_traceback.tb_lineno, exception))
> Exception: test_utils.py: line:337 'NoneType' object has no attribute
> '__getitem__'
>
>
> --
> Dave Page
> VP, Chief Architect, Tools & Installers
> EnterpriseDB: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>
> Blog: http://pgsnake.blogspot.com
> Twitter: @pgsnake
>



-- 
Regards,
Navnath


enhanced_testresult_summary.patch
Description: Binary data

-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers


[pgadmin-hackers] [pgAdmin4][Patch]: Slickgrid loading issue in Query tool

2016-09-19 Thread Surinder Kumar
Hi

*Issue:*
Slick-grid libraries loads when an instance of query tool is opened. But
sometimes it throws exception "jQuery is not defined" and it doesn't opens
up.

*Solution:*
As per my understanding, In *datagrid/index.html* file, we set the order of
loading libraries such as
*require(['jquery', 'pgadmin', 'pgadmin.sqleditor']) *
but it still loads *pgadmin.sqleditor.js* file before *jQuery* for unknown
reason.

To fix this, we load *pgadmin.sqleditor.js* file using *require([],
function(){}) *module loader which ensures that the code within
*function(){}* will be executed when pgadmin.sqleditor.js is loaded.

Please find attache patch.
This issue is fixed by *Ashesh Vashi*.

Thanks,
Surinder Kumar


slickgrid_js_load_issue.patch
Description: Binary data

-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers


[pgadmin-hackers] [pgAdmin4][Patch]: RM1592 - Download as CSV should be supported for DDL

2016-09-19 Thread Surinder Kumar
Hi

Please find attached patch with fix.

> ​Download as CSV
>  button should be enabled only for SELECT queries.


​Please review.

Thanks,
Surinder Kumar​


RM1592.patch
Description: Binary data

-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers


[pgadmin-hackers] pgAdmin 4 commit: Resolve a syntax error when updating packages with no

2016-09-19 Thread Dave Page
Resolve a syntax error when updating packages with no body. Fixes #1588

Branch
--
master

Details
---
http://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=cc0cb8327750e6ee1b13193d5afdc22ff3754022
Author: Surinder Kumar 

Modified Files
--
.../packages/templates/package/ppas/9.1_plus/update.sql  | 12 +---
.../packages/templates/package/ppas/9.2_plus/update.sql  | 11 +--
2 files changed, 2 insertions(+), 21 deletions(-)


-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers


Re: [pgadmin-hackers] [pgAdmin4][Patch]: RM1588 - User can not change the code of header through right if package created without body

2016-09-19 Thread Dave Page
Thanks, applied.

On Mon, Sep 19, 2016 at 10:29 AM, Surinder Kumar
 wrote:
> Hi
>
> Please find attached patch with fix:
> Minor changes in template file. Checks were missing for creating package
> body and drop package body.
>
> Please review.
>
>
> Thanks,
> Surinder Kumar
>
>
> --
> Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgadmin-hackers
>



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

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


-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers


[pgadmin-hackers] pgAdmin 4 commit: Fix an issue where the edit icon vanished and the def

2016-09-19 Thread Dave Page
Fix an issue where the edit icon vanished and the default tab wasn't shown when 
advanced-editing a column in the table dialogue. Fixes #1704

Branch
--
master

Details
---
http://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=2440f89a7134d9c8ff28b8f93ea0baf1e2abb211
Author: Murtuza Zabuawala 

Modified Files
--
.../servers/databases/schemas/templates/schema/js/schema.js| 7 +--
1 file changed, 5 insertions(+), 2 deletions(-)


-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers


Re: [pgadmin-hackers] PATCH: To fix column editor issue (pgAdmin4)

2016-09-19 Thread Dave Page
Thanks, applied.

On Mon, Sep 19, 2016 at 11:10 AM, Murtuza Zabuawala
 wrote:
> Hi,
>
> PFA patch to fix the issue in column editor where subnode control was not
> expanding properly.
> RM#1703/04
>
> Issue:
> There was issue in SecurityGroup function(used to show/hide security tab)
> which was not able to find node_info property when called from subnode
> control, due t which it was breaking while expanding subnode control.
>
> --
> Regards,
> Murtuza Zabuawala
> EnterpriseDB: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>
>
> --
> Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgadmin-hackers
>



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

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


-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers


[pgadmin-hackers] pgAdmin 4 commit: Fix an exception that could occur when the browser pi

2016-09-19 Thread Dave Page
Fix an exception that could occur when the browser pings the server following a 
restart. Fixes #1707

Branch
--
master

Details
---
http://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=881d2a60a4e1ef357dcf9fcfb5375f8dc3dd2163
Author: Murtuza Zabuawala 

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


-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers


Re: [pgadmin-hackers] PATCH: To fix the issue where user gets error following application server restart (pgAdmin4)

2016-09-19 Thread Dave Page
Thanks, applied.

On Mon, Sep 19, 2016 at 12:48 PM, Murtuza Zabuawala
 wrote:
> Hi,
>
> PFA patch to fix the issue where user gets error following application
> server restart.
> RM#1707
>
> --
> Regards,
> Murtuza Zabuawala
> EnterpriseDB: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>
>
> --
> Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgadmin-hackers
>



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

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


-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers


Re: [pgadmin-hackers] [pgAdmin4][Patch]: RM1592 - Download as CSV should be supported for DDL

2016-09-19 Thread Dave Page
Hi

On Mon, Sep 19, 2016 at 3:03 PM, Surinder Kumar
 wrote:
> Hi
>
> Please find attached patch with fix.
>>
>> Download as CSV
>>  button should be enabled only for SELECT queries.

I'm not sure there's a way to do this without parsing the query.
Simply matching on ^select certainly won't work reliably - for
example, there could be multiple statements in the script, or it could
be PERFORM ...  or UPDATE ... RETURNING ...

I think we need to leave the button enabled, but give the user a
message if no data is returned, e.g.

===
Download as CSV
-

The query executed did not return any data.

[OK]


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

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


-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers


[pgadmin-hackers] [pgAdmin4][Patch]: RM1627 - Objects are not visible after creation until press refresh button

2016-09-19 Thread Surinder Kumar
Hi

Please find patch with following fixes:

1) Newly added server-group not listing in tree view.

2) On creating a first node for collection node with no child. the created
node doesn't show up under its respective parent node.
- to add a node to child under its parent node. its parent node attribute
must be set 'inode: true' but it always gets false for inode that doesn't
add the node.

Ashesh - Can you please review it?

Thanks
Surinder Kumar


RM1627.patch
Description: Binary data

-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers


Re: [pgadmin-hackers] [pgAdmin4][Patch]: RM1592 - Download as CSV should be supported for DDL

2016-09-19 Thread Surinder Kumar
On Mon, Sep 19, 2016 at 8:48 PM, Dave Page  wrote:

> Hi
>
> On Mon, Sep 19, 2016 at 3:03 PM, Surinder Kumar
>  wrote:
> > Hi
> >
> > Please find attached patch with fix.
> >>
> >> Download as CSV
> >>  button should be enabled only for SELECT queries.
>
> I'm not sure there's a way to do this without parsing the query.
> Simply matching on ^select certainly won't work reliably - for
> example, there could be multiple statements in the script, or it could
> be PERFORM ...  or UPDATE ... RETURNING ...
>
I wasn't aware of such cases.

>
> I think we need to leave the button enabled, but give the user a
> message if no data is returned, e.g.
>
​ok.​ sure.

>
> ===
> Download as CSV
> -
>
> The query executed did not return any data.
>
> [OK]
> 


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


[pgadmin-hackers] pgAdmin 4 commit: Enhanced summary output for the test suite.

2016-09-19 Thread Dave Page
Enhanced summary output for the test suite.

Branch
--
master

Details
---
http://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=c84fd83595be4922879c150314e9f1973e087e3f
Author: Navnath Gadakh 

Modified Files
--
.../servers/databases/tests/test_db_add.py |  35 +--
.../servers/databases/tests/test_db_delete.py  |  19 +-
.../servers/databases/tests/test_db_get.py |  40 +--
.../servers/databases/tests/test_db_put.py |  33 ++-
.../server_groups/servers/databases/tests/utils.py | 113 +++--
.../server_groups/servers/tests/test_server_add.py |  21 +-
.../servers/tests/test_server_delete.py|  28 +--
.../server_groups/servers/tests/test_server_put.py |  33 +--
.../browser/server_groups/servers/tests/utils.py   |  37 +--
web/regression/__init__.py |   4 +-
web/regression/runtests.py |  49 +++-
web/regression/test_utils.py   | 279 ++---
12 files changed, 419 insertions(+), 272 deletions(-)


-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers


Re: [pgadmin-hackers] pgAdmin IV- Testing framework: Enhanced Test Result Summary

2016-09-19 Thread Dave Page
Thanks - applied with minor tweaks to the output formatting.

On Mon, Sep 19, 2016 at 2:03 PM, Navnath Gadakh
 wrote:
> Hi Dave,
>   In the drop objects function scenario for 'NoneType' was not handled.
> Code is added in the revised patch.
>
> Thanks.
>
> On Mon, Sep 19, 2016 at 2:03 PM, Dave Page 
> wrote:
>>
>> Hi
>>
>> On Mon, Sep 19, 2016 at 8:14 AM, Navnath Gadakh
>>  wrote:
>> > Hi Dave,
>> > Error resolved. Please find the revised patch.
>>
>> I still see the error:
>>
>> Test Result Summary
>> 
>> Regression - PG 9.4: 25 tests passed, 0 tests failed
>> 
>>
>> Please check output in file:
>> /Users/dpage/git/pgadmin4/web/regression/regression.log
>> Error in atexit._run_exitfuncs:
>> Traceback (most recent call last):
>>   File
>> "/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/atexit.py",
>> line 24, in _run_exitfuncs
>> func(*targs, **kargs)
>>   File "/Users/dpage/git/pgadmin4/web/regression/test_utils.py", line
>> 360, in drop_objects
>> file_name, sys.exc_traceback.tb_lineno, exception))
>> Exception: test_utils.py: line:337 'NoneType' object has no attribute
>> '__getitem__'
>> Error in sys.exitfunc:
>> Traceback (most recent call last):
>>   File
>> "/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/atexit.py",
>> line 24, in _run_exitfuncs
>> func(*targs, **kargs)
>>   File "/Users/dpage/git/pgadmin4/web/regression/test_utils.py", line
>> 360, in drop_objects
>> file_name, sys.exc_traceback.tb_lineno, exception))
>> Exception: test_utils.py: line:337 'NoneType' object has no attribute
>> '__getitem__'
>>
>>
>> --
>> Dave Page
>> VP, Chief Architect, Tools & Installers
>> EnterpriseDB: http://www.enterprisedb.com
>> The Enterprise PostgreSQL Company
>>
>> Blog: http://pgsnake.blogspot.com
>> Twitter: @pgsnake
>
>
>
>
> --
> Regards,
> Navnath
>
>



-- 
Dave Page
VP, Chief Architect, Tools & Installers
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake


-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers


[pgadmin-hackers] Regression errors - database node

2016-09-19 Thread Dave Page
Hi Navnath

I keep seeing the errors below when running tests. It seems to be
consistent on EPAS, but intermittent on PG. Any ideas what the issue
is? I'm fairly convinced it's a test issue not an actual problem.

2016-09-19 
16:47:49,567:ERROR:STDERR:==
2016-09-19 16:47:49,568:ERROR:STDERR:ERROR: runTest
(pgadmin.browser.server_groups.servers.databases.tests.test_db_get.DatabasesGetTestCase)
2016-09-19 16:47:49,568:ERROR:STDERR:This function will fetch added
database. (Check Databases Node URL)
2016-09-19 
16:47:49,568:ERROR:STDERR:--
2016-09-19 16:47:49,568:ERROR:STDERR:Traceback (most recent call last):
2016-09-19 16:47:49,568:ERROR:STDERR:  File
"/Users/dpage/git/pgadmin4/web/pgadmin/browser/server_groups/servers/databases/tests/test_db_get.py",
line 33, in runTest
2016-09-19 16:47:49,568:ERROR:STDERR:self.db_id)
2016-09-19 16:47:49,568:ERROR:STDERR:  File
"/Users/dpage/git/pgadmin4/web/pgadmin/browser/server_groups/servers/databases/tests/utils.py",
line 142, in verify_database
2016-09-19 16:47:49,568:ERROR:STDERR:follow_redirects=True)
2016-09-19 16:47:49,568:ERROR:STDERR:  File
"/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packages/werkzeug/test.py",
line 788, in post
2016-09-19 16:47:49,568:ERROR:STDERR:return self.open(*args, **kw)
2016-09-19 16:47:49,568:ERROR:STDERR:  File
"/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packages/flask/testing.py",
line 113, in open
2016-09-19 16:47:49,568:ERROR:STDERR:follow_redirects=follow_redirects)
2016-09-19 16:47:49,568:ERROR:STDERR:  File
"/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packages/werkzeug/test.py",
line 751, in open
2016-09-19 16:47:49,568:ERROR:STDERR:response =
self.run_wsgi_app(environ, buffered=buffered)
2016-09-19 16:47:49,568:ERROR:STDERR:  File
"/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packages/werkzeug/test.py",
line 668, in run_wsgi_app
2016-09-19 16:47:49,568:ERROR:STDERR:rv =
run_wsgi_app(self.application, environ, buffered=buffered)
2016-09-19 16:47:49,568:ERROR:STDERR:  File
"/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packages/werkzeug/test.py",
line 871, in run_wsgi_app
2016-09-19 16:47:49,568:ERROR:STDERR:app_rv = app(environ, start_response)
2016-09-19 16:47:49,568:ERROR:STDERR:  File
"/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packages/flask/app.py",
line 2000, in __call__
2016-09-19 16:47:49,568:ERROR:STDERR:return self.wsgi_app(environ,
start_response)
2016-09-19 16:47:49,568:ERROR:STDERR:  File
"/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packages/flask/app.py",
line 1991, in wsgi_app
2016-09-19 16:47:49,568:ERROR:STDERR:response =
self.make_response(self.handle_exception(e))
2016-09-19 16:47:49,568:ERROR:STDERR:  File
"/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packages/flask/app.py",
line 1567, in handle_exception
2016-09-19 16:47:49,568:ERROR:STDERR:reraise(exc_type, exc_value, tb)
2016-09-19 16:47:49,569:ERROR:STDERR:  File
"/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packages/flask/app.py",
line 1988, in wsgi_app
2016-09-19 16:47:49,569:ERROR:STDERR:response = self.full_dispatch_request()
2016-09-19 16:47:49,569:ERROR:STDERR:  File
"/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packages/flask/app.py",
line 1641, in full_dispatch_request
2016-09-19 16:47:49,569:ERROR:STDERR:rv = self.handle_user_exception(e)
2016-09-19 16:47:49,569:ERROR:STDERR:  File
"/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packages/flask/app.py",
line 1544, in handle_user_exception
2016-09-19 16:47:49,569:ERROR:STDERR:reraise(exc_type, exc_value, tb)
2016-09-19 16:47:49,569:ERROR:STDERR:  File
"/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packages/flask/app.py",
line 1639, in full_dispatch_request
2016-09-19 16:47:49,569:ERROR:STDERR:rv = self.dispatch_request()
2016-09-19 16:47:49,569:ERROR:STDERR:  File
"/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packages/flask/app.py",
line 1625, in dispatch_request
2016-09-19 16:47:49,569:ERROR:STDERR:return
self.view_functions[rule.endpoint](**req.view_args)
2016-09-19 16:47:49,569:ERROR:STDERR:  File
"/Users/dpage/.virtualenvs/pgadmin4/lib/python2.7/site-packages/flask/views.py",
line 84, in view
2016-09-19 16:47:49,569:ERROR:STDERR:return
self.dispatch_request(*args, **kwargs)
2016-09-19 16:47:49,569:ERROR:STDERR:  File
"/Users/dpage/git/pgadmin4/web/pgadmin/browser/utils.py", line 235, in
dispatch_request
2016-09-19 16:47:49,569:ERROR:STDERR:return method(*args, **kwargs)
2016-09-19 16:47:49,569:ERROR:STDERR:  File
"/Users/dpage/git/pgadmin4/web/pgadmin/browser/server_groups/servers/databases/__init__.py",
line 364, in connect
2016-09-19 16:47:49,569:ERROR:STDERR:conn =
manager.connection(did=did, auto_reconnect=True)
2016-09-19 16:47:49,569:ERROR:STDERR:  File
"/Users/dpage

[pgadmin-hackers] pgAdmin 4 commit: Ensure jQuery is loaded before SlickGrid. Fixes #1712

2016-09-19 Thread Dave Page
Ensure jQuery is loaded before SlickGrid. Fixes #1712

Patch by Ashesh with contributions from Surinder.

Branch
--
master

Details
---
http://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=7ab0eb158f52d8fa662b55035f5dc91b7dd4c332
Author: Ashesh Vashi 

Modified Files
--
.../tools/datagrid/templates/datagrid/index.html   | 102 ++---
1 file changed, 49 insertions(+), 53 deletions(-)


-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers


Re: [pgadmin-hackers] [pgAdmin4][Patch]: Slickgrid loading issue in Query tool

2016-09-19 Thread Dave Page
Thanks, applied.

On Mon, Sep 19, 2016 at 2:58 PM, Surinder Kumar
 wrote:
> Hi
>
> Issue:
> Slick-grid libraries loads when an instance of query tool is opened. But
> sometimes it throws exception "jQuery is not defined" and it doesn't opens
> up.
>
> Solution:
> As per my understanding, In datagrid/index.html file, we set the order of
> loading libraries such as
> require(['jquery', 'pgadmin', 'pgadmin.sqleditor'])
> but it still loads pgadmin.sqleditor.js file before jQuery for unknown
> reason.
>
> To fix this, we load pgadmin.sqleditor.js file using require([],
> function(){}) module loader which ensures that the code within function(){}
> will be executed when pgadmin.sqleditor.js is loaded.
>
> Please find attache patch.
> This issue is fixed by Ashesh Vashi.
>
> Thanks,
> Surinder Kumar
>
>
> --
> Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgadmin-hackers
>



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

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


-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers


Re: [pgadmin-hackers] [pgAdmin4][Patch]: RM1627 - Objects are not visible after creation until press refresh button

2016-09-19 Thread Dave Page
Hi


On Mon, Sep 19, 2016 at 4:23 PM, Surinder Kumar
 wrote:
> Hi
>
> Please find patch with following fixes:
>
> 1) Newly added server-group not listing in tree view.
>
> 2) On creating a first node for collection node with no child. the created
> node doesn't show up under its respective parent node.
> - to add a node to child under its parent node. its parent node attribute
> must be set 'inode: true' but it always gets false for inode that doesn't
> add the node.
>
> Ashesh - Can you please review it?

I tested this by adding a sequence to a database and schema that
didn't previously contain any. The node was not added, and in the
Javascript console I get:

browser.js:1108 Failed to append

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

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


-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers


Re: [pgadmin-hackers] [pgAdmin4][Patch]: RM1592 - Download as CSV should be supported for DDL

2016-09-19 Thread Surinder Kumar
On Mon, Sep 19, 2016 at 8:59 PM, Surinder Kumar <
surinder.ku...@enterprisedb.com> wrote:

> On Mon, Sep 19, 2016 at 8:48 PM, Dave Page  wrote:
>
>> Hi
>>
>> On Mon, Sep 19, 2016 at 3:03 PM, Surinder Kumar
>>  wrote:
>> > Hi
>> >
>> > Please find attached patch with fix.
>> >>
>> >> Download as CSV
>> >>  button should be enabled only for SELECT queries.
>>
>> I'm not sure there's a way to do this without parsing the query.
>> Simply matching on ^select certainly won't work reliably - for
>> example, there could be multiple statements in the script, or it could
>> be PERFORM ...  or UPDATE ... RETURNING ...
>>
> I wasn't aware of such cases.
>
>>
>> I think we need to leave the button enabled, but give the user a
>> message if no data is returned, e.g.
>>
> ​ok.​ sure.
>
​I discussed the issue with Harshal and this is how download csv works:
​We just hit the url to download csv, and let the browser handle the
response from the server side. we don't have access to response data to
check if no data is returned.

The other approach is to hit the same query twice. First time an ajax query
to check if data is returned or not. if returned, fire another query to
download csv otherwise set message in message panel.
But the limitation with this approach is that we are just increasing load
over server by hitting same query twice, incase returned data rows in
billions.
Thoughts ?

>
>> ===
>> Download as CSV
>> -
>>
>> The query executed did not return any data.
>>
>> [OK]
>> 
>
>
>> --
>> Dave Page
>> Blog: http://pgsnake.blogspot.com
>> Twitter: @pgsnake
>>
>> EnterpriseDB UK: http://www.enterprisedb.com
>> The Enterprise PostgreSQL Company
>>
>
>