Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1aiiZO-0003a3-I7 for pgadmin-hackers@arkaria.postgresql.org; Wed, 23 Mar 2016 13:11:30 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1aiiZN-0000tF-Ht for pgadmin-hackers@arkaria.postgresql.org; Wed, 23 Mar 2016 13:11:29 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1aiiZ9-0000dj-P2 for pgadmin-hackers@postgresql.org; Wed, 23 Mar 2016 13:11:15 +0000 Received: from mail-io0-x229.google.com ([2607:f8b0:4001:c06::229]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1aiiZ5-0000UW-Pl for pgadmin-hackers@postgresql.org; Wed, 23 Mar 2016 13:11:15 +0000 Received: by mail-io0-x229.google.com with SMTP id m184so38683201iof.1 for ; Wed, 23 Mar 2016 06:11:11 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=pgadmin-org.20150623.gappssmtp.com; s=20150623; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc; bh=uhFmfYcmyCiccG6+0q00sNRTGkV18ESJaXWZ5bGfm3g=; b=qq9Qhb4Vp9z57pwTrS9im2D0APh25wTNcIyQAOIghkwm7RcQhCywoXgoewbFTQjF25 /1boKfK8VpfgHooCfV/hvMNC7WNmM8b04NAW1YTKQEzCH0SHOUZHv41kkecb1TUHPGQ8 BE+dwXiNCd0k+3QIxK98poN3uh/l6P2+vSsfHBBKaJx4bd0xDA4ff6ovh4rCbLd7IEs+ c+3wk3TMCakYUlnCNQa+ajpbmrzaSEm6Vs6f3bbiWQvKM0RyA1Wt1AVe1VFcHwJ7G1P4 d/obqnFzNM9rViYGyqRslDSqBj1/HDKwPNr4eov3dupGrAUFVIcH8gtnGxvWoG0VRkuL Csww== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:in-reply-to:references:date :message-id:subject:from:to:cc; bh=uhFmfYcmyCiccG6+0q00sNRTGkV18ESJaXWZ5bGfm3g=; b=WDj+Ip2IyCjPDNadLbYMiBKN73KQYpZf2Q8TWWtp0L4jER4f6Cupd323rWS5NvZwGA RLdoz9vIMR8ZfGgY2ZyoB2JEdA7XGU85UtPbahwGDVHxe1cKTlemK37QHBkC3RYFbtCR +vR3CJFBWH62XmFb0MA537nlmybXnJxlLM4ncjhSG4oN4znw8JE0yAgPULQk4ODkftHo 3/i94lBNPUCG4JCk7tV1hHTaFrPmtw1bX+XniUktSzqVPI+aYiFvAF60N+5zoI1xYeTb LWnwCU/VmfvJ0AVsiQJcaRLJrCS0RP9brxXsx+O2VHl43I2wyFNu3bVbSyLZouEUjHeF uCpQ== X-Gm-Message-State: AD7BkJKxwaTWSYK50LlJq/yPLsy5r2+iNNBp+Ay/h/hF/CagRcd2/sUSC4/q/2GZe8GsE7cJju8/bnbVbs3usg== MIME-Version: 1.0 X-Received: by 10.107.43.2 with SMTP id r2mr3543741ior.156.1458738342670; Wed, 23 Mar 2016 06:05:42 -0700 (PDT) Received: by 10.64.24.175 with HTTP; Wed, 23 Mar 2016 06:05:42 -0700 (PDT) In-Reply-To: References: Date: Wed, 23 Mar 2016 13:05:42 +0000 Message-ID: Subject: Re: pgAdmin4 PATCH: Domain Module From: Dave Page To: Khushboo Vashi Cc: pgadmin-hackers Content-Type: text/plain; charset=UTF-8 X-Pg-Spam-Score: -2.6 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgadmin-hackers Precedence: bulk Sender: pgadmin-hackers-owner@postgresql.org Hi Almost there :-s - The hint for default should be a placeholder in the textbox itself (like combos have "Select from the list" - I should be able to check the "Validate?" option on one or more constraints from within the Domain dialogue - Please ensure the capitalisation of all property labels is consistent - it should be "Base type" not "Base Type", "System domain?" not "System Domain?" etc. - The check constraint reverse engineered SQL should include the path to the constraint, e.g. -- CHECK: schema.domain.check_at Once that's done, it can be committed I think. Thanks. On Wed, Mar 23, 2016 at 7:27 AM, Khushboo Vashi wrote: > Updated one comment. > > On Wed, Mar 23, 2016 at 12:48 PM, Khushboo Vashi > wrote: >> >> Hi, >> >> Please find attached updated patch for the Domains module. >> >> On Wed, Mar 16, 2016 at 9:40 PM, Dave Page wrote: >>> >>> Hi >>> >>> On Wed, Mar 16, 2016 at 2:03 PM, Khushboo Vashi >>> wrote: >>> > Hi, >>> > >>> > Please find the updated Domain Module Patch. >>> > >>> > To test this patch, please apply Backgrid Textarea Cell Patch before >>> > this. >>> >>> Thanks. I believe with the following fixes, we'll be done :-) >>> >>> - Default values should be auto-quoted when necessary (ie. strings, on >>> a text-based domain). >> >> As per our discussion, this should leave unquoted. > > And also added a hint to the field stated 'Enter an expression or a value.' >> >> >>> - "System Domain?" should be in the General section, between owner and >>> comment. >> >> Done >>> >>> - The switches should use the same colouring/styling as other objects, >>> e.g. >>> >>> options: { >>> 'onText': 'Yes', 'offText': 'No', >>> 'onColor': 'success', 'offColor': 'primary', >>> 'size': 'small' >>> } >> >> Done >>> >>> - Please remove the Schema property from the main properties tab (not >>> the properties dialogue). >> >> Done >>> >>> - No icon is show for Checks on the Dependents tab for a domain. >> >> Done >>> >>> - The add button on the Security Labels tab is spelt "Add". Why is >>> that? Other instances of this grid use "ADD" which is the default in >>> backform.pgadmin.js. >> >> Done >>> >>> - Dependencies on domain check constraints are listed as being on a >>> "Type" not a "Domain". >> >> Done >>> >>> - If adding a domain constraint using the grid on the Domain dialogue, >>> I cannot specify "NOT VALID". We need a checkbox for that in a narrow >>> columns at the end. Unchecking it for an existing constraint should be >>> the equivalent of doing "ALTER DOMAIN ... VALIDATE CONSTRAINT" >> >> Done >>> >>> - If I switch the "Don't Validate" switch on a constraint, there are >>> leading blank lines in the generated SQL. The same occurs when adding >>> a comment to a constraint. >> >> Done >>> >>> - I think we need to reverse the meaning of "Don't Validate" and >>> rename to match the "Valid?" field that's on the properties list. >>> Otherwise it's not clear they're the same thing. >> >> Done >>> >>> - s/Not Null/Not Null?/ >> >> Done >>> >>> >>> >>> -- >>> 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 -- Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-hackers