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