Re: PATCH: PGADMIN 4 - FTS templates node

Поиск
Список
Период
Сортировка
От Sanket Mehta
Тема Re: PATCH: PGADMIN 4 - FTS templates node
Дата
Msg-id CA+yw=mMzgpzGoLu=zgg-c3Zeo59=LMAXi4D73dX5Pp-M9h_4bg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: PATCH: PGADMIN 4 - FTS templates node  (Dave Page <dpage@pgadmin.org>)
Ответы Re: PATCH: PGADMIN 4 - FTS templates node  (Dave Page <dpage@pgadmin.org>)
Список pgadmin-hackers
Hi Dave,

I have found out the root cause of this issue.

This issue is occurring at your side as you are using python 2.7 so in that case sql query returned from sql template is of type 'unicode'.
And in __init__.py file we have checked if the sql query is of string type then only we would proceed further.

I was not getting this issue as I was using python 3.0

I have resolved this issue and some other typo errors in comments and patch is attached with this mail.

Please do review it and let me know in case of any issues.





Regards,
Sanket Mehta
Sr Software engineer
Enterprisedb

On Tue, Mar 22, 2016 at 8:11 PM, Dave Page <dpage@pgadmin.org> wrote:
Hi,

This seems to be fine, except:

- The icons were missing from the patch (I added them manually)

- The issue you couldn't reproduce that I reported previously still
exists. I created an FTS template per the attached screenshots, and
the SQL tab shows only "Modified SQL". The template is correctly
created though. When I edit the template, I can also successfully
rename it and update the comment, though the SQL tab still says
"Modified SQL".



On Wed, Mar 16, 2016 at 7:10 AM, Sanket Mehta
<sanket.mehta@enterprisedb.com> wrote:
> Hi,
>
> Sorry its misunderstanding from my side.
> That node refresh on tree issue has been resolved.
>
> Patch is attached with this mail.
>
> Please do review it.
>
> Regards,
> Sanket Mehta
> Sr Software engineer
> Enterprisedb
>
> On Mon, Mar 14, 2016 at 7:27 PM, Dave Page <dpage@pgadmin.org> wrote:
>>
>> On Mon, Mar 14, 2016 at 1:52 PM, Sanket Mehta
>> <sanket.mehta@enterprisedb.com> wrote:
>> > Hi Dave,
>> >
>> > I have incorporated your changes.
>> > I have also tried to reproduce the Issues that you have mentioned.
>> > find the response inline.
>> >
>> > Also find revised patch having your suggested changes attached with this
>> > mail.
>> > Please do review it and let me know in case anything is missing.
>> >
>> >
>> > Regards,
>> > Sanket Mehta
>> > Sr Software engineer
>> > Enterprisedb
>> >
>> > On Fri, Mar 11, 2016 at 6:41 PM, Dave Page <dpage@pgadmin.org> wrote:
>> >>
>> >> Hi
>> >>
>> >> On Thu, Mar 10, 2016 at 6:28 AM, Sanket Mehta
>> >> <sanket.mehta@enterprisedb.com> wrote:
>> >> > Hi,
>> >> >
>> >> > PFA the patch for fts template after replacing collectionNodeModule
>> >> > with
>> >> > SchemaChildModule in __init__.py
>> >> >
>> >> > Apart from that, there was an error while updating the name of fts
>> >> > template
>> >> > which I have resolved in the same.
>> >> >
>> >> > Please do review it and let me know in case of any changes.
>> >>
>> >> I've updated the patch for consistency with others. Please find
>> >> attached. Aside from those changes, there are two issues:
>> >>
>> >> - When creating or editing a template the SQL pane just says
>> >> "--modified SQL" even when all required options are specified. The
>> >> template is created correctly though.
>> >
>> > I have tried to reproduce this issue on my system but could not
>> > reproduce
>> > it. PFA screen shorts explaining sql I got while creating and editing a
>> > template.
>> >
>> >>
>> >> - If a template is renamed, the treeview node is not updated.
>> >
>> > This is generic issue and needed to be resolved at higher level.
>>
>> No, I tested other nodes (database and sequence for example) and they
>> were properly updated. It's possible *some* are broken, but it's
>> certainly not a general issue.
>>
>>
>> --
>> Dave Page
>> Blog: http://pgsnake.blogspot.com
>> Twitter: @pgsnake
>>
>> EnterpriseDB UK: http://www.enterprisedb.com
>> The Enterprise PostgreSQL Company
>
>



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

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

Вложения

В списке pgadmin-hackers по дате отправления:

Предыдущее
От: Surinder Kumar
Дата:
Сообщение: Re: [pgAdmin4] [Patch]: Grant Wizard
Следующее
От: Sanket Mehta
Дата:
Сообщение: PATCH: pgadmin 4: FTS Parser