[pgAdmin4][Patch]: Fix for Feature #4334, RM #4496 and #4497

2019-07-24 Thread Akshay Joshi
Hi Hackers,

I have added the support of Generated Columns (PG/EPAS 12) and also fixed
RM #4496, #4497.

During the implementation of that I have also fixed following issues that I
encountered:

   - User should not be able to provide Default value with Identity column.
   - 'Drop Cascade' button to delete multiple columns should be disabled.
   - Set "Not Null?" switch to 'Yes' when we create Identity column.
   - Fix issue when we insert default value for the column and then remove
   it. It generates wrong msql.
   - Fix issue when we provide the default value of a column and then
   select the datatype to serial/bigserial/smallserial, it generates wrong
   msql.

Modified/Added regression test cases for adding Identity column and
Generated columns.
Please review it.

-- 
*Thanks & Regards*
*Akshay Joshi*

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


RM_4334_4496_4497.patch
Description: Binary data


Re: pgAdmin4 v4.11 candidate builds

2019-07-24 Thread Devrim Gündüz

Hi,

On Wed, 2019-07-24 at 10:48 +0530, Akshay Joshi wrote:
>Feature test are not stable yet, so we will have to remove that from our
> build process.

How? Will you re-wrap 4.11? If not, can you please send me a patch so that I
can apply it to the RPMs?

Thanks!

Cheers,
-- 
Devrim Gündüz
Open Source Solution Architect, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR


signature.asc
Description: This is a digitally signed message part


Re: pgAdmin4 v4.11 candidate builds

2019-07-24 Thread Akshay Joshi
Hi Devrim

On Wed, Jul 24, 2019 at 1:02 PM Devrim Gündüz  wrote:

>
> Hi,
>
> On Wed, 2019-07-24 at 10:48 +0530, Akshay Joshi wrote:
> >Feature test are not stable yet, so we will have to remove that from
> our
> > build process.
>
> How? Will you re-wrap 4.11? If not, can you please send me a patch so that
> I
> can apply it to the RPMs?
>

   No, I'll not re-wrap 4.11. I am not much aware of the RPM's, but I think
you will need to change the spec file and add "--exclude feature_tests"
parameter to the command for regression test.

>
> Thanks!
>
> Cheers,
> --
> Devrim Gündüz
> Open Source Solution Architect, Red Hat Certified Engineer
> Twitter: @DevrimGunduz , @DevrimGunduzTR
>


-- 
*Thanks & Regards*
*Akshay Joshi*

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


Re: pgAdmin4 v4.11 candidate builds

2019-07-24 Thread Dave Page
On Wed, Jul 24, 2019 at 8:39 AM Akshay Joshi 
wrote:

> Hi Devrim
>
> On Wed, Jul 24, 2019 at 1:02 PM Devrim Gündüz  wrote:
>
>>
>> Hi,
>>
>> On Wed, 2019-07-24 at 10:48 +0530, Akshay Joshi wrote:
>> >Feature test are not stable yet, so we will have to remove that from
>> our
>> > build process.
>>
>> How? Will you re-wrap 4.11? If not, can you please send me a patch so
>> that I
>> can apply it to the RPMs?
>>
>
>No, I'll not re-wrap 4.11. I am not much aware of the RPM's, but I
> think you will need to change the spec file and add "--exclude
> feature_tests" parameter to the command for regression test.
>

He's not running the tests, it's the RPM build precompiling the bytecode
automatically.

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

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


Re: pgAdmin4 v4.11 candidate builds

2019-07-24 Thread Dave Page
On Tue, Jul 23, 2019 at 10:41 PM Devrim Gündüz  wrote:

>
> Hi Ashesh,
>
> On Tue, 2019-07-23 at 21:58 +0530, Ashesh Vashi wrote:
> > Because - pgAdmin4 has its own documentation theme. :-)
>
> Thanks, but this does not answer my question. This theme (like the previous
> "classic" theme) breaks RHEL 7 builds:
>
> Running Sphinx v1.1.3
> loading pickled environment... not yet created
>
> Theme error:
> no theme named 'classic' found, inherited by 'pgadmin4'
> make[2]: *** [html] Error 1
> make[2]: Leaving directory
> `/home/pgsql/git/pgrpms/rpm/redhat/master/pgadmin4/master/pgadmin4-4.11/docs/en_US'
> make[1]: *** [docs] Error 2
> make[1]: Leaving directory
> `/home/pgsql/git/pgrpms/rpm/redhat/master/pgadmin4/master/pgadmin4-4.11'
> error: Bad exit status from /var/tmp/rpm-tmp.Afb3Zm (%build)
>
> So, I updated the patch, and used the default theme again in 4.11 RPMs.
>

Stupid CentOS/RHEL...

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

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


Re: pgAdmin4 v4.11 candidate builds

2019-07-24 Thread Devrim Gündüz

Hi Akshay,

On Wed, 2019-07-24 at 13:08 +0530, Akshay Joshi wrote:
>No, I'll not re-wrap 4.11. I am not much aware of the RPM's, but I think
> you will need to change the spec file and add "--exclude
> feature_tests"
> parameter to the command for regression test.

I don't run regression tests in the spec file:

https://git.postgresql.org/gitweb/?p=pgrpms.git;a=blob;f=rpm/redhat/master/pgadmin4/master/pgadmin4.spec;h=576a07420ecb250dfdc57291f1c294cb06c963f9;hb=HEAD

What I basically do is:
* cd runtime; qmake -o Makefile pgAdmin4.pro; cd ..
* build docs
* Manually install the files.
* Create config_distro.py file

Cheers,
-- 
Devrim Gündüz
Open Source Solution Architect, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR


signature.asc
Description: This is a digitally signed message part


Re: pgAdmin4 v4.11 candidate builds

2019-07-24 Thread Akshay Joshi
Hi Devrim

We have figure out the problem with the syntax print("Copy rows...",
file=sys.stderr, end="") with Python 2.7.
Attached is the patch please apply, test it and let me know.

On Wed, Jul 24, 2019 at 1:25 PM Devrim Gündüz  wrote:

>
> Hi Akshay,
>
> On Wed, 2019-07-24 at 13:08 +0530, Akshay Joshi wrote:
> >No, I'll not re-wrap 4.11. I am not much aware of the RPM's, but I
> think
> > you will need to change the spec file and add "--exclude
> > feature_tests"
> > parameter to the command for regression test.
>
> I don't run regression tests in the spec file:
>
>
> https://git.postgresql.org/gitweb/?p=pgrpms.git;a=blob;f=rpm/redhat/master/pgadmin4/master/pgadmin4.spec;h=576a07420ecb250dfdc57291f1c294cb06c963f9;hb=HEAD
>
> What I basically do is:
> * cd runtime; qmake -o Makefile pgAdmin4.pro; cd ..
> * build docs
> * Manually install the files.
> * Create config_distro.py file
>
> Cheers,
> --
> Devrim Gündüz
> Open Source Solution Architect, Red Hat Certified Engineer
> Twitter: @DevrimGunduz , @DevrimGunduzTR
>


-- 
*Thanks & Regards*
*Akshay Joshi*

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


Fix_Feature_Test_RPM.patch
Description: Binary data


[RM#4508] Fix tab navigation issue with Backgrid Datetime cell

2019-07-24 Thread Murtuza Zabuawala
Hi,

PFA minor patch to fix the tab navigation issue with Backgrid datetime cell.

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


fix_datetime_backgrid.diff
Description: Binary data


Re: pgAdmin4 v4.11 candidate builds

2019-07-24 Thread Devrim Gündüz

Hi Akshay,

On Wed, 2019-07-24 at 14:45 +0530, Akshay Joshi wrote:
> We have figure out the problem with the syntax print("Copy rows...",
> file=sys.stderr, end="") with Python 2.7.
> Attached is the patch please apply, test it and let me know.

Great, it worked!

Will this patch be included in 4.12?

Cheers,
-- 
Devrim Gündüz
Open Source Solution Architect, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR


signature.asc
Description: This is a digitally signed message part


Re: pgAdmin4 v4.11 candidate builds

2019-07-24 Thread Akshay Joshi
On Wed, 24 Jul, 2019, 19:26 Devrim Gündüz,  wrote:

>
> Hi Akshay,
>
> On Wed, 2019-07-24 at 14:45 +0530, Akshay Joshi wrote:
> > We have figure out the problem with the syntax print("Copy rows...",
> > file=sys.stderr, end="") with Python 2.7.
> > Attached is the patch please apply, test it and let me know.
>
> Great, it worked!
>
> Will this patch be included in 4.12?
>

@Dave, Can you please comment on this. If we include this patch in
4.11, I'll have to rewrap the candidate build.

>
> Cheers,
> --
> Devrim Gündüz
> Open Source Solution Architect, Red Hat Certified Engineer
> Twitter: @DevrimGunduz , @DevrimGunduzTR
>


Re: pgAdmin4 v4.11 candidate builds

2019-07-24 Thread Dave Page
On Wed, Jul 24, 2019 at 3:10 PM Akshay Joshi 
wrote:

>
>
> On Wed, 24 Jul, 2019, 19:26 Devrim Gündüz,  wrote:
>
>>
>> Hi Akshay,
>>
>> On Wed, 2019-07-24 at 14:45 +0530, Akshay Joshi wrote:
>> > We have figure out the problem with the syntax print("Copy rows...",
>> > file=sys.stderr, end="") with Python 2.7.
>> > Attached is the patch please apply, test it and let me know.
>>
>> Great, it worked!
>>
>> Will this patch be included in 4.12?
>>
>
> @Dave, Can you please comment on this. If we include this patch in
> 4.11, I'll have to rewrap the candidate build.
>

Commit for 4.12 please. Thanks.

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

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


pgAdmin 4 commit: Remove duplicated blank message entry which is illega

2019-07-24 Thread Dave Page
Remove duplicated blank message entry which is illegal.

Branch
--
master

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

Modified Files
--
web/pgadmin/translations/ja/LC_MESSAGES/messages.po | 3 ---
1 file changed, 3 deletions(-)



pgAdmin 4 commit: Fix syntax error in query tool feature test for Pytho

2019-07-24 Thread Akshay Joshi
Fix syntax error in query tool feature test for Python 2.7

Branch
--
master

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

Modified Files
--
web/pgadmin/feature_tests/query_tool_journey_test.py | 1 +
1 file changed, 1 insertion(+)