Re: [pgAdmin][RM4144] Compound Trigger support for EPAS-v12

Aditya Toshniwal <[email protected]>
Newsgroups gmane.comp.db.postgresql.pgadmin.devel
Message-ID <CAM9w-_n+PcFXsZE2Md7tQ8-4vEYi_vHTBAjhAxunhcNGZJDxJw@mail.gmail.com>
Hi Akshay,

Everything seems to be fine. I have a few suggestions:
1) In class CompoundTriggerModule (python), "A module class for Trigger"
should be "A module class for Compound Trigger"
2) We need to send a pull request to Code Mirror to highlight to make show
the word - COMPOUND as a keyword.
3) Add the trigger name after END of the compound trigger definition. eg
END <cp trig>;
4) Table SQL tab should show compound triggers.
5) Compound trigger disabled icon is cut. @Chethana Kumar
<[email protected]> - the icon need to be revisited.
[image: Screenshot 2019-08-08 at 11.58.27.png]
6) In edit, SQL generated (msql) is having minor spacing issues on the "FOR
..." line. Eg:
CREATE OR REPLACE TRIGGER comptrig
    FOR  INSERT  OR DELETE   OR UPDATE

You can commit the code once fixed.


On Wed, Aug 7, 2019 at 4:00 PM Aditya Toshniwal <
[email protected]> wrote:

> I'll do.
>
> On Wed, Aug 7, 2019 at 3:34 PM Dave Page <[email protected]> wrote:
>
>> Thanks Akshay. I want to do a pass over the docs before this is
>> committed. Otherwise, I don't see any obvious issues - however, it's a
>> pretty big patch, so can you have one of the others on the team do a
>> review/test as well please?
>>
>>
>> On Wed, Aug 7, 2019 at 8:08 AM Akshay Joshi <
>> [email protected]> wrote:
>>
>>> Hi Hackers
>>>
>>> I have added the support of *Compound Trigger* in pgAdmin4 for EPAS v12
>>> and above. I have created a new collection node named "*Compound
>>> Triggers" *under the Tables node. API and RE-SQL test cases are covered
>>> and documentation is done.
>>>
>>> Please review the attached patch.
>>>
>>> --
>>> *Thanks & Regards*
>>> *Akshay Joshi*
>>>
>>> *Sr. Software Architect*
>>> *EnterpriseDB Software India Private Limited*
>>> *Mobile: +91 976-788-8246*
>>>
>>
>>
>> --
>> Dave Page
>> Blog: http://pgsnake.blogspot.com
>> Twitter: @pgsnake
>>
>> EnterpriseDB UK: http://www.enterprisedb.com
>> The Enterprise PostgreSQL Company
>>
>
>
> --
> Thanks and Regards,
> Aditya Toshniwal
> Software Engineer | EnterpriseDB India | Pune
> "Don't Complain about Heat, Plant a TREE"
>


-- 
Thanks and Regards,
Aditya Toshniwal
Software Engineer | EnterpriseDB India | Pune
"Don't Complain about Heat, Plant a TREE"
Screenshot 2019-08-08 at 11.58.27.png (image/png, 148.5 KB) - not displayed
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.