MIME-Version: 1.0
From: Surinder Kumar <surinder.kumar@enterprisedb.com>
Date: Fri, 18 Mar 2016 16:07:36 +0530
Message-ID: 
 <CAM5-9D9Nwm2SKkaRpWpMy=95RhKO+qm1O9TvhXE8dmCiUFe1Cw@mail.gmail.com>
Subject: Control for displaying "auto vacuum" fields into grid
To: pgadmin-hackers <pgadmin-hackers@postgresql.org>
Content-Type: multipart/mixed; boundary=047d7bf0c29a9fc02c052e50570b
Precedence: bulk
Sender: pgadmin-hackers-owner@postgresql.org

--047d7bf0c29a9fc02c052e50570b
Content-Type: multipart/alternative; boundary=047d7bf0c29a9fc025052e505709

--047d7bf0c29a9fc025052e505709
Content-Type: text/plain; charset=UTF-8

Hi,

PFA control for displaying auto vacuum fields into grid. This control is
common for
Materialized View Node and Table Node.

*Usage:*

{
  id: 'vacuum_table', label: '{{ _("Vacuum Table") }}',
  model: VacuumTableModel, editable: false, type: 'collection',
  canEdit: true, group: '{{ _("Table") }}',
  mode: ['edit', 'create'], url: 'get_vacuum_defaults',
  control: Backform.VacuumCollectionControl.extend({
    grid_columns :[
      {
        name: 'label', label: '{{ _("Label") }}',
        cell: 'string', editable: false
      },
      {
        name: 'value', label: '{{ _("Value") }}',
        cellFunction: cellFunction, editable: function(m) {
          if(m.handler.has('autovacuum_enabled')) {
            return m.handler.get('autovacuum_enabled');
          }
          return !m.handler.isNew();
        }
      },
      {
        name: 'setting', label: '{{ _("Default value") }}',
        cellFunction: cellFunction, editable: false
      }
    ]
  }),


When using this control, provide following parameters in schema:
*1. model*
2. *url - *to fetch default values for auto vacuum fields.
3. *grid columns - *Name of the columns to display in the grid.


Please review the patch.


Thanks
Surinder Kumar

--047d7bf0c29a9fc025052e505709
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hi,<div><br></div><div>PFA control for displaying auto vac=
uum fields into grid. This control is common for</div><div>Materialized Vie=
w Node and Table Node.</div><div><br></div><div><b>Usage:</b></div><div><br=
></div><div><div><font face=3D"monospace, monospace" style=3D"background-co=
lor:rgb(255,255,255)">{ =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =
=C2=A0 =C2=A0</font></div><div><font face=3D"monospace, monospace" style=3D=
"background-color:rgb(255,255,255)">=C2=A0 id: &#39;vacuum_table&#39;, labe=
l: &#39;{{ _(&quot;Vacuum Table&quot;) }}&#39;,</font></div><div><font face=
=3D"monospace, monospace" style=3D"background-color:rgb(255,255,255)">=C2=
=A0 model: VacuumTableModel, editable: false, type: &#39;collection&#39;,</=
font></div><div><font face=3D"monospace, monospace" style=3D"background-col=
or:rgb(255,255,255)">=C2=A0 canEdit: true, group: &#39;{{ _(&quot;Table&quo=
t;) }}&#39;,</font></div><div><font face=3D"monospace, monospace" style=3D"=
background-color:rgb(255,255,255)">=C2=A0 mode: [&#39;edit&#39;, &#39;creat=
e&#39;], url: &#39;get_vacuum_defaults&#39;,</font></div><div><font face=3D=
"monospace, monospace" style=3D"background-color:rgb(255,255,255)">=C2=A0 c=
ontrol: Backform.VacuumCollectionControl.extend({</font></div><div><font fa=
ce=3D"monospace, monospace" style=3D"background-color:rgb(255,255,255)">=C2=
=A0 =C2=A0 grid_columns :[</font></div><div><font face=3D"monospace, monosp=
ace" style=3D"background-color:rgb(255,255,255)">=C2=A0 =C2=A0 =C2=A0 {</fo=
nt></div><div><font face=3D"monospace, monospace" style=3D"background-color=
:rgb(255,255,255)">=C2=A0 =C2=A0 =C2=A0 =C2=A0 name: &#39;label&#39;, label=
: &#39;{{ _(&quot;Label&quot;) }}&#39;,</font></div><div><font face=3D"mono=
space, monospace" style=3D"background-color:rgb(255,255,255)">=C2=A0 =C2=A0=
 =C2=A0 =C2=A0 cell: &#39;string&#39;, editable: false=C2=A0</font></div><d=
iv><font face=3D"monospace, monospace" style=3D"background-color:rgb(255,25=
5,255)">=C2=A0 =C2=A0 =C2=A0 },</font></div><div><font face=3D"monospace, m=
onospace" style=3D"background-color:rgb(255,255,255)">=C2=A0 =C2=A0 =C2=A0 =
{</font></div><div><font face=3D"monospace, monospace" style=3D"background-=
color:rgb(255,255,255)">=C2=A0 =C2=A0 =C2=A0 =C2=A0 name: &#39;value&#39;, =
label: &#39;{{ _(&quot;Value&quot;) }}&#39;,</font></div><div><font face=3D=
"monospace, monospace" style=3D"background-color:rgb(255,255,255)">=C2=A0 =
=C2=A0 =C2=A0 =C2=A0 cellFunction: cellFunction, editable: function(m) {</f=
ont></div><div><font face=3D"monospace, monospace" style=3D"background-colo=
r:rgb(255,255,255)">=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 if(m.handler.has(=
9;autovacuum_enabled&#39;)) {</font></div><div><font face=3D"monospace, mon=
ospace" style=3D"background-color:rgb(255,255,255)">=C2=A0 =C2=A0 =C2=A0 =
=C2=A0 =C2=A0 =C2=A0 return m.handler.get(&#39;autovacuum_enabled&#39;);</f=
ont></div><div><font face=3D"monospace, monospace" style=3D"background-colo=
r:rgb(255,255,255)">=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 } =C2=A0 =C2=A0 =C2=
=A0 =C2=A0</font></div><div><font face=3D"monospace, monospace" style=3D"ba=
ckground-color:rgb(255,255,255)">=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 return =
!m.handler.isNew();</font></div><div><font face=3D"monospace, monospace" st=
yle=3D"background-color:rgb(255,255,255)">=C2=A0 =C2=A0 =C2=A0 =C2=A0 }</fo=
nt></div><div><font face=3D"monospace, monospace" style=3D"background-color=
:rgb(255,255,255)">=C2=A0 =C2=A0 =C2=A0 },</font></div><div><font face=3D"m=
onospace, monospace" style=3D"background-color:rgb(255,255,255)">=C2=A0 =C2=
=A0 =C2=A0 {</font></div><div><font face=3D"monospace, monospace" style=3D"=
background-color:rgb(255,255,255)">=C2=A0 =C2=A0 =C2=A0 =C2=A0 name: &#39;s=
etting&#39;, label: &#39;{{ _(&quot;Default value&quot;) }}&#39;,</font></d=
iv><div><font face=3D"monospace, monospace" style=3D"background-color:rgb(2=
55,255,255)">=C2=A0 =C2=A0 =C2=A0 =C2=A0 cellFunction: cellFunction, editab=
le: false</font></div><div><font face=3D"monospace, monospace" style=3D"bac=
kground-color:rgb(255,255,255)">=C2=A0 =C2=A0 =C2=A0 }=C2=A0</font></div><d=
iv><font face=3D"monospace, monospace" style=3D"background-color:rgb(255,25=
5,255)">=C2=A0 =C2=A0 ]=C2=A0</font></div><div><font face=3D"monospace, mon=
ospace" style=3D"background-color:rgb(255,255,255)">=C2=A0 }),=C2=A0</font>=
</div><div>=C2=A0=C2=A0</div></div><div><br></div><div>When using this cont=
rol, provide following parameters in schema:</div><div><b>1. model</b></div=
><div>2.=C2=A0<b>url -=C2=A0</b>to fetch default values for auto vacuum fie=
lds.</div><div>3.=C2=A0<b>grid columns - </b>Name of the columns to display=
 in the grid.</div><div><br></div><div><br></div><div>Please review the pat=
ch.</div><div><br></div><div><br></div><div><br></div><div>Thanks</div><div=
>Surinder Kumar</div><div><br></div></div>

--047d7bf0c29a9fc025052e505709--

--047d7bf0c29a9fc02c052e50570b
Content-Type: application/octet-stream;
	name="vacuum_collection_control.patch"
Content-Disposition: attachment; filename="vacuum_collection_control.patch"
Content-Transfer-Encoding: base64
X-Attachment-Id: f_ilxkqc6i0

ZGlmZiAtLWdpdCBhL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vw
cy9zZXJ2ZXJzL2RhdGFiYXNlcy9zY2hlbWFzL3RlbXBsYXRlcy9zY2hlbWEv
anMvc2NoZW1hLmpzIGIvd2ViL3BnYWRtaW4vYnJvd3Nlci9zZXJ2ZXJfZ3Jv
dXBzL3NlcnZlcnMvZGF0YWJhc2VzL3NjaGVtYXMvdGVtcGxhdGVzL3NjaGVt
YS9qcy9zY2hlbWEuanMKaW5kZXggMzUyZGExZi4uODhlMzczMSAxMDA2NDQK
LS0tIGEvd2ViL3BnYWRtaW4vYnJvd3Nlci9zZXJ2ZXJfZ3JvdXBzL3NlcnZl
cnMvZGF0YWJhc2VzL3NjaGVtYXMvdGVtcGxhdGVzL3NjaGVtYS9qcy9zY2hl
bWEuanMKKysrIGIvd2ViL3BnYWRtaW4vYnJvd3Nlci9zZXJ2ZXJfZ3JvdXBz
L3NlcnZlcnMvZGF0YWJhc2VzL3NjaGVtYXMvdGVtcGxhdGVzL3NjaGVtYS9q
cy9zY2hlbWEuanMKQEAgLTQsNiArNCw4NiBAQCBkZWZpbmUoCiAgICAgICAg
ICdwZ2FkbWluLmJyb3dzZXIuY29sbGVjdGlvbicsCiAgICAgICAgICdwZ2Fk
bWluLmJyb3dzZXIuc2VydmVyLnByaXZpbGVnZSddLAogZnVuY3Rpb24oJCwg
XywgUywgcGdBZG1pbiwgcGdCcm93c2VyLCBCYWNrZm9ybSwgYWxlcnRpZnkp
IHsKKworICAgIHZhciBWYWN1dW1Db2xsZWN0aW9uQ29udHJvbCA9IEJhY2tm
b3JtLlZhY3V1bUNvbGxlY3Rpb25Db250cm9sID0KKyAgICAgIEJhY2tmb3Jt
LkNvbnRyb2wuZXh0ZW5kKHsKKworICAgICAgZ3JpZF9jb2x1bW5zOnVuZGVm
aW5lZCwKKworICAgICAgaW5pdGlhbGl6ZTogZnVuY3Rpb24oKSB7CisgICAg
ICAgIEJhY2tmb3JtLkNvbnRyb2wucHJvdG90eXBlLmluaXRpYWxpemUuYXBw
bHkodGhpcywgYXJndW1lbnRzKTsKKyAgICAgICAgdmFyIHNlbGYgPSB0aGlz
LAorICAgICAgICAgICAgbSA9IHRoaXMubW9kZWw7CisgICAgICAgICAgICB1
cmwgPSBzZWxmLmZpZWxkLmdldCgndXJsJyk7CisKKyAgICAgICAgaWYgKHVy
bCAmJiBtLmlzTmV3KCkpIHsKKyAgICAgICAgICB2YXIgbm9kZSA9IHNlbGYu
ZmllbGQuZ2V0KCdub2RlJyksCisgICAgICAgICAgICAgIG5vZGVfZGF0YSA9
IHNlbGYuZmllbGQuZ2V0KCdub2RlX2RhdGEnKSwKKyAgICAgICAgICAgICAg
bm9kZV9pbmZvID0gc2VsZi5maWVsZC5nZXQoJ25vZGVfaW5mbycpLAorICAg
ICAgICAgICAgICBmdWxsX3VybCA9IG5vZGUuZ2VuZXJhdGVfdXJsLmFwcGx5
KAorICAgICAgICAgICAgICAgIG5vZGUsIFsKKyAgICAgICAgICAgICAgICAg
IG51bGwsIHVybCwgbm9kZV9kYXRhLCB0cnVlLCBub2RlX2luZm8KKyAgICAg
ICAgICAgICAgICBdKSwKKyAgICAgICAgICAgICAgZGF0YTsKKyAgICAgICAg
ICBtLnRyaWdnZXIoJ3BnYWRtaW4tdmlldzpmZXRjaGluZycsIG0sIHNlbGYu
ZmllbGQpOworCisgICAgICAgICAgLy8gZmV0Y2ggZGVmYXVsdCB2YWx1ZXMg
Zm9yIGF1dG92YWN1dW0gZmllbGRzCisgICAgICAgICAgJC5hamF4KHsKKyAg
ICAgICAgICAgIGFzeW5jOiBmYWxzZSwKKyAgICAgICAgICAgIHVybDogZnVs
bF91cmwsCisgICAgICAgICAgICBzdWNjZXNzOiBmdW5jdGlvbiAocmVzKSB7
CisgICAgICAgICAgICAgIGRhdGEgPSByZXM7CisgICAgICAgICAgICB9LAor
ICAgICAgICAgICAgZXJyb3I6IGZ1bmN0aW9uKCkgeworICAgICAgICAgICAg
ICBtLnRyaWdnZXIoJ3BnYWRtaW4tdmlldzpmZXRjaDplcnJvcicsIG0sIHNl
bGYuZmllbGQpOworICAgICAgICAgICAgfQorICAgICAgICAgIH0pOworICAg
ICAgICAgIG0udHJpZ2dlcigncGdhZG1pbi12aWV3OmZldGNoZWQnLCBtLCBz
ZWxmLmZpZWxkKTsKKworICAgICAgICAgIC8vIEFkZCBmZXRjaGVkIG1vZGVs
cyBpbnRvIGNvbGxlY3Rpb24KKyAgICAgICAgICBpZiAoZGF0YSAmJiBfLmlz
QXJyYXkoZGF0YSkpIHsKKyAgICAgICAgICAgIG0uZ2V0KHNlbGYuZmllbGQu
Z2V0KCduYW1lJykpLnJlc2V0KGRhdGEsIHtzaWxlbnQ6IHRydWV9KTsKKyAg
ICAgICAgICB9CisgICAgICAgIH0KKyAgICAgIH0sCisKKyAgICAgIHJlbmRl
cjogZnVuY3Rpb24oKSB7CisgICAgICAgIHZhciBzZWxmID0gdGhpcywKKyAg
ICAgICAgICAgIG0gPSB0aGlzLm1vZGVsLAorICAgICAgICAgICAgYXR0cmli
dXRlcyA9IHNlbGYuZmllbGQuYXR0cmlidXRlczsKKworICAgICAgICAvLyBy
ZW1vdmUgZ3JpZAorICAgICAgICBpZihzZWxmLmdyaWQpIHsKKyAgICAgICAg
ICBzZWxmLmdyaWQucmVtb3ZlKCk7CisgICAgICAgICAgZGVsZXRlIHNlbGYu
Z3JpZDsKKyAgICAgICAgICBzZWxmLmdyaWQgPSB1bmRlZmluZWQ7CisgICAg
ICAgIH0KKworICAgICAgICBzZWxmLiRlbC5lbXB0eSgpOworCisgICAgICAg
IHZhciBncmlkSGVhZGVyID0gXy50ZW1wbGF0ZShbCisgICAgICAgICAgICAn
PGRpdiBjbGFzcz0ic3Vibm9kZS1oZWFkZXIiPicsCisgICAgICAgICAgICAn
ICA8bGFiZWwgY2xhc3M9ImNvbnRyb2wtbGFiZWwgY29sLXNtLTQiPjwlLWxh
YmVsJT48L2xhYmVsPicsCisgICAgICAgICAgICAnPC9kaXY+J10uam9pbigi
XG4iKSksCisgICAgICAgICAgICBncmlkQm9keSA9ICQoJzxkaXYgY2xhc3M9
InBnYWRtaW4tY29udHJvbC1ncm91cCBiYWNrZ3JpZCBmb3JtLWdyb3VwIGNv
bC14cy0xMiBvYmplY3Qgc3Vibm9kZSI+PC9kaXY+JykuYXBwZW5kKAorICAg
ICAgICAgICAgICAgIGdyaWRIZWFkZXIoYXR0cmlidXRlcykKKyAgICAgICAg
ICAgICAgICApOworCisgICAgICAgIC8vIEluaXRpYWxpemUgYSBuZXcgR3Jp
ZCBpbnN0YW5jZQorICAgICAgICB2YXIgZ3JpZCA9IHNlbGYuZ3JpZCA9IG5l
dyBCYWNrZ3JpZC5HcmlkKHsKKyAgICAgICAgICBjb2x1bW5zOiBzZWxmLmdy
aWRfY29sdW1ucywKKyAgICAgICAgICBjb2xsZWN0aW9uOiBzZWxmLm1vZGVs
LmdldChzZWxmLmZpZWxkLmdldCgnbmFtZScpKSwKKyAgICAgICAgICBjbGFz
c05hbWU6ICJiYWNrZ3JpZCB0YWJsZS1ib3JkZXJlZCIKKyAgICAgICAgfSk7
CisKKyAgICAgICAgLy8gcmVuZGVyIGdyaWQKKyAgICAgICAgc2VsZi4kZWwu
YXBwZW5kKCQoZ3JpZEJvZHkpLmFwcGVuZChncmlkLnJlbmRlcigpLiRlbCkp
OworCisgICAgICAgIHJldHVybiBzZWxmOworICAgICAgfQorICAgIH0pOwor
CisKICAgIC8vIEV4dGVuZCB0aGUgYnJvd3NlcidzIGNvbGxlY3Rpb24gY2xh
c3MgZm9yIFNlY3VyaXR5TGFiZWwgY29udHJvbAogICAgIHZhciBTZWN1cml0
eU1vZGVsID0gQmFja2Zvcm0uU2VjdXJpdHlNb2RlbCA9IHBnQWRtaW4uQnJv
d3Nlci5Ob2RlLk1vZGVsLmV4dGVuZCh7CiAgICAgZGVmYXVsdHM6IHsK

--047d7bf0c29a9fc02c052e50570b
Content-Type: text/plain
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
MIME-Version: 1.0


-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers

--047d7bf0c29a9fc02c052e50570b--