Re: Fixed RM #1356

From: Akshay Joshi <akshay(dot)joshi(at)enterprisedb(dot)com>
To: Dave Page <dpage(at)pgadmin(dot)org>
Cc: Ashesh Vashi <ashesh(dot)vashi(at)enterprisedb(dot)com>, pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org>
Subject: Re: Fixed RM #1356
Date: 2016-06-15 15:50:09
Message-ID: CANxoLDcJOSomXdbYj9WNhDjBUKkdvC3riXUJtA8+_6FrZmY60A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

Hi

Please ignore the last patch. Attached is the latest patch. Please review
it.

On Wed, Jun 15, 2016 at 9:10 PM, Akshay Joshi <akshay(dot)joshi(at)enterprisedb(dot)com
> wrote:

> Hi
>
> On Wed, Jun 15, 2016 at 5:54 PM, Dave Page <dpage(at)pgadmin(dot)org> wrote:
>
>>
>>
>> On Wed, Jun 15, 2016 at 1:16 PM, Ashesh Vashi <
>> ashesh(dot)vashi(at)enterprisedb(dot)com> wrote:
>>
>>> On Wed, Jun 15, 2016 at 5:44 PM, Akshay Joshi <
>>> akshay(dot)joshi(at)enterprisedb(dot)com> wrote:
>>>
>>>>
>>>>
>>>> On Wed, Jun 15, 2016 at 5:25 PM, Dave Page <dpage(at)pgadmin(dot)org> wrote:
>>>>
>>>>> Hi
>>>>>
>>>>> On Wed, Jun 15, 2016 at 11:27 AM, Akshay Joshi <
>>>>> akshay(dot)joshi(at)enterprisedb(dot)com> wrote:
>>>>>
>>>>>> Hi
>>>>>>
>>>>>> I have fixed RM #1356 "Query tool enhancement". I have added the
>>>>>> logic to preferences which checks the min/max value before setting it. If
>>>>>> value given by user is less than min value then set it to min value and if
>>>>>> value is greater then max value then set it to max value.
>>>>>>
>>>>>> For "items_per_page" minimum value is 1. Attached is the patch file.
>>>>>> Please review it.
>>>>>>
>>>>>
>>>>> That doesn't do what I asked for though. A value of zero should be
>>>>> acceptable (I did say <= 0, but = 0 is probably better), and mean 'disable
>>>>> paging' (i.e. display unlimited rows, and completely hide the paging
>>>>> controls). From the ticket:
>>>>>
>>>>> 1) If "Items per page in grid" <= 0, then never page results. Add a
>>>>> note to that effect on the Preferences pane, and make zero the default
>>>>> value.
>>>>>
>>>>> The patch does appear to implement:
>>>>>
>>>>
>>>> Backbone's Pageble Collection don't allow Zero value. Below is the
>>>> check present in "backbone.paginator.js" file:
>>>>
>>>> if (pageSize < 1) {
>>>> throw new RangeError("`pageSize` must be >= 1");
>>>> }
>>>>
>>> We can avoid using the Pageable Collection in our code, when pageSize is
>>> <= 0 to fix the issue.
>>>
>>
>> Exactly. The entire point of the change is to default to not paging at
>> all.
>>
>> BTW, this may be helpful (also missed from the original patch):
>>
>> help_str=gettext('The number of rows to display per page in the results
>> grid. A value of 0 will disable paging.'),
>>
>
> Fixed above as per suggestion. Attached is the modified patch file.
> Please review it.
>
>>
>> --
>> Dave Page
>> Blog: http://pgsnake.blogspot.com
>> Twitter: @pgsnake
>>
>> EnterpriseDB UK: http://www.enterprisedb.com
>> The Enterprise PostgreSQL Company
>>
>
>
>
> --
> *Akshay Joshi*
> *Principal Software Engineer *
>
>
>
> *Phone: +91 20-3058-9517Mobile: +91 976-788-8246*
>

--
*Akshay Joshi*
*Principal Software Engineer *

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

Attachment Content-Type Size
RM_1356_v2.patch application/octet-stream 16.6 KB

In response to

Responses

Browse pgadmin-hackers by date

  From Date Subject
Next Message Dave Page 2016-06-15 16:10:58 pgAdmin 4 commit: Overhaul the PIP build system so it's less messy on d
Previous Message Akshay Joshi 2016-06-15 15:40:48 Re: Fixed RM #1356