Re: [pgAdmin][RM7351]: Templates not displayed

Hi Pradip

Following are the review comments:

- Fixed pep8 issues.
- Documentation updates are missing.
- In the 'alter_online.sql' file correct the comment above the ALTER
statement. Also, remove one extra space after "IS_TEMPLATE". Do this in
both the files.
- Remove extra spaces from all the 'properties.sql' files before the
"ORDER BY" clause.
-

{% if show_user_defined_templates is defined %}
AND db.datistemplate = {{show_user_defined_templates}}
{% endif %} Code is duplicated in the "9.1_plus/properties.sql"
file please check.

-

'IS_TEMPLATE' is available from 9.4 onwards, so change the SQL
files accordingly.

-

Database creation is missing IS_TEMPLATE command, please add that
control into the same patch.

-

Found one issue where SQL tab is thorwing an error when selecting
'template0' database.

On Wed, Jun 1, 2022 at 3:51 PM Pradip Parkale <
pradip(dot)parkale(at)enterprisedb(dot)com> wrote:

> Hi Hackers,
>
> Please find the attached patch for #7351.
> I have made all the necessary changes which were discussed.
>
>
>
> *Thanks & Regards,*
>
> *Pradip ParkaleSoftware Engineer | EnterpriseDB Corporation*
>
>
> On Wed, May 18, 2022 at 7:11 PM Dave Page <dpage(at)pgadmin(dot)org> wrote:
>
>> Hi
>>
>> On Wed, 18 May 2022 at 14:02, Pradip Parkale <
>> pradip(dot)parkale(at)enterprisedb(dot)com> wrote:
>>
>>> Hi Dave/Team,
>>>
>>> I have come up with a plan to implement this. Please give your
>>> suggestions
>>>
>>>
>>> 1. Users will be able to hide user-defined templates in the
>>> preferences setting. By default, the value is 'Yes', and all user-defined
>>> templates will be hidden.
>>> 2. The icon will be different for user-defined templates.
>>> 3. Users can connect to templete DB and properies are also same, so
>>> no need to change the properties dialog options/design.
>>> 4. We are giving options to hide the templates and by default, the
>>> option will be true, so the collection node for template DBs will be the
>>> same as for other databases.
>>>
>>> Works for me. Thanks.
>>
>>
>>
>>>
>>> On Tue, May 17, 2022 at 1:50 PM Dave Page <dpage(at)pgadmin(dot)org> wrote:
>>>
>>>>
>>>>
>>>> On Tue, 17 May 2022 at 08:08, Pradip Parkale <
>>>> pradip(dot)parkale(at)enterprisedb(dot)com> wrote:
>>>>
>>>>> Hi Dave/Team,
>>>>>
>>>>> On Wed, May 11, 2022 at 4:37 PM Aditya Toshniwal <
>>>>> aditya(dot)toshniwal(at)enterprisedb(dot)com> wrote:
>>>>>
>>>>>> Hi,
>>>>>>
>>>>>> On Wed, May 11, 2022 at 4:03 PM Dave Page <dpage(at)pgadmin(dot)org> wrote:
>>>>>>
>>>>>>> Hi
>>>>>>>
>>>>>>> On Wed, 11 May 2022 at 09:40, Aditya Toshniwal <
>>>>>>> aditya(dot)toshniwal(at)enterprisedb(dot)com> wrote:
>>>>>>>
>>>>>>>> Hi Dave,
>>>>>>>>
>>>>>>>> On Wed, May 11, 2022 at 2:00 PM Dave Page <dpage(at)pgadmin(dot)org>
>>>>>>>> wrote:
>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> On Wed, 11 May 2022 at 09:24, Aditya Toshniwal <
>>>>>>>>> aditya(dot)toshniwal(at)enterprisedb(dot)com> wrote:
>>>>>>>>>
>>>>>>>>>> Hi,
>>>>>>>>>>
>>>>>>>>>> On Wed, May 11, 2022 at 1:24 PM Dave Page <dpage(at)pgadmin(dot)org>
>>>>>>>>>> wrote:
>>>>>>>>>>
>>>>>>>>>>> Hi
>>>>>>>>>>>
>>>>>>>>>>> I think this change needs some thought and discussion on how it
>>>>>>>>>>> should be implemented. pgAdmin has worked this way for over 20 years with
>>>>>>>>>>> only this one suggestion to change afaicr - and I for one don't suddenly
>>>>>>>>>>> want templates showing up amongst my other databases.
>>>>>>>>>>>
>>>>>>>>>> User defined template DBs cannot come under "Show system
>>>>>>>>>> objects". I mean, they're not system objects.
>>>>>>>>>>
>>>>>>>>>
>>>>>>>>> No they're not. But we have over 20 years of them being classed
>>>>>>>>> that way, and users may not suddenly want to see template1 (for example)
>>>>>>>>> listed amongst their databases. There are various things to think about
>>>>>>>>> here, for example:
>>>>>>>>>
>>>>>>>> No template1, template0 are system objects. They won't be visible.
>>>>>>>> Only new databases created manually and marked as template are excluded
>>>>>>>> from "Show system objects" .
>>>>>>>>
>>>>>>>
>>>>>>> template0 is. template1 is *by default*, but not if you drop and
>>>>>>> recreate it.
>>>>>>>
>>>>>> Didn't think in that way :)
>>>>>> In that case, we can add a new preference - "Show non-system/user
>>>>>> defined template databases?" explicitly. By default "yes", show them.
>>>>>> Along with a new icon.
>>>>>>
>>>>> Has this been finalized?
>>>>>
>>>>
>>>> No - I haven't seen any proposals for what will be done, except for
>>>> what you've written below which no one has commented on yet.
>>>>
>>>>
>>>>> Could I add a new preference setting to show/hide user-defined
>>>>> template databases? The new icon for that may look like a 'T' on top of the
>>>>> current DB icon.
>>>>>
>>>>
>>>> I think that's fine.
>>>>
>>>>
>>>>>
>>>>>
>>>>>>>
>>>>>>>>
>>>>>>>>> - Should there be a separate option to show/hide template
>>>>>>>>> databases?
>>>>>>>>> - If so, what should the default be (hint: I think yes, and off)
>>>>>>>>> - Should template databases have a different icon?
>>>>>>>>>
>>>>>>>> We can have this. Good to differentiate.
>>>>>>>>
>>>>>>>>> - Should they have their own collection node?
>>>>>>>>> - They can't be connected to, so much of what's on the database
>>>>>>>>> properties dialog won't work. Should they have their own properties
>>>>>>>>> dialogue design?
>>>>>>>>>
>>>>>>>> I can connect to template DBs in pgAdmin.
>>>>>>>>
>>>>>>>
>>>>>>> Yeah, disregard that. My brain was mixing up datistemplate and
>>>>>>> datallowconn.
>>>>>>>
>>>>>>>
>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>> On Wed, 11 May 2022 at 07:12, Pradip Parkale <
>>>>>>>>>>> pradip(dot)parkale(at)enterprisedb(dot)com> wrote:
>>>>>>>>>>>
>>>>>>>>>>>> Hi Hackers,
>>>>>>>>>>>>
>>>>>>>>>>>> Please find the attached patch for # 7351:Templates not
>>>>>>>>>>>> displayed.
>>>>>>>>>>>>
>>>>>>>>>>>> I have fixed below issues
>>>>>>>>>>>>
>>>>>>>>>>>> 1. Databases which are marked as template manually by the
>>>>>>>>>>>> user should be visible independent of - "Show System Objects".
>>>>>>>>>>>> 2. DB properties dialogs should allow you to change
>>>>>>>>>>>> template flag in edit mode.
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>> --
>>>>>>>>>>>> Thanks & Regards,
>>>>>>>>>>>> Pradip Parkale
>>>>>>>>>>>> Software Engineer | EnterpriseDB Corporation
>>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>> --
>>>>>>>>>>> Dave Page
>>>>>>>>>>> Blog: https://pgsnake.blogspot.com
>>>>>>>>>>> Twitter: @pgsnake
>>>>>>>>>>>
>>>>>>>>>>> EDB: https://www.enterprisedb.com
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> --
>>>>>>>>>> Thanks,
>>>>>>>>>> Aditya Toshniwal
>>>>>>>>>> pgAdmin Hacker | Software Architect | *edbpostgres.com*
>>>>>>>>>> <http://edbpostgres.com>
>>>>>>>>>> "Don't Complain about Heat, Plant a TREE"
>>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> --
>>>>>>>>> Dave Page
>>>>>>>>> Blog: https://pgsnake.blogspot.com
>>>>>>>>> Twitter: @pgsnake
>>>>>>>>>
>>>>>>>>> EDB: https://www.enterprisedb.com
>>>>>>>>>
>>>>>>>>>
>>>>>>>>
>>>>>>>> --
>>>>>>>> Thanks,
>>>>>>>> Aditya Toshniwal
>>>>>>>> pgAdmin Hacker | Software Architect | *edbpostgres.com*
>>>>>>>> <http://edbpostgres.com>
>>>>>>>> "Don't Complain about Heat, Plant a TREE"
>>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> --
>>>>>>> Dave Page
>>>>>>> Blog: https://pgsnake.blogspot.com
>>>>>>> Twitter: @pgsnake
>>>>>>>
>>>>>>> EDB: https://www.enterprisedb.com
>>>>>>>
>>>>>>>
>>>>>>
>>>>>> --
>>>>>> Thanks,
>>>>>> Aditya Toshniwal
>>>>>> pgAdmin Hacker | Software Architect | *edbpostgres.com*
>>>>>> <http://edbpostgres.com>
>>>>>> "Don't Complain about Heat, Plant a TREE"
>>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> Thanks & Regards,
>>>>> Pradip Parkale
>>>>> Software Engineer | EnterpriseDB Corporation
>>>>>
>>>>
>>>>
>>>> --
>>>> Dave Page
>>>> Blog: https://pgsnake.blogspot.com
>>>> Twitter: @pgsnake
>>>>
>>>> EDB: https://www.enterprisedb.com
>>>>
>>>>
>>>
>>> --
>>> Thanks & Regards,
>>> Pradip Parkale
>>> Software Engineer | EnterpriseDB Corporation
>>>
>>
>>
>> --
>> Dave Page
>> Blog: https://pgsnake.blogspot.com
>> Twitter: @pgsnake
>>
>> EDB: https://www.enterprisedb.com
>>
>>

--

<http://www.enterprisedb.com>

Akshay Joshi

Principal Software Architect

+91 9767888246

www.enterprisedb.com

<https://www.linkedin.com/company/edbpostgres>
<https://twitter.com/edbpostgres?lang=en>
<https://www.facebook.com/EDBpostgres>
<https://www.instagram.com/EDBpostgres/>