From: | Yosry Muhammad <yosrym93(at)gmail(dot)com> |
---|---|
To: | pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org> |
Cc: | Dave Page <dpage(at)pgadmin(dot)org> |
Subject: | [GSoC][New Feature] Editable and Read-only Columns |
Date: | 2019-08-15 19:01:34 |
Message-ID: | CAFSMqn9zz=eWZme5GAJh0RvmQjn2CBukcxszmhp8nMbRwfxyzA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-hackers |
Hi, hackers !
Please find attached a work-in-progress patch adding a new feature to the
Query Tool on top of updatable result-sets.
This patch allows individual columns of an updatable result-set to be
editable or read-only. This allows for a wider variety of updatable
result-sets, for example:
- Result-sets with duplicated columns.
- Result-sets with renamed columns (if a column is renamed to a primary key
name, the real primary key can be correctly identified) .
- Result-sets including columns that are not selected directly from a table
(e.g concatenation of 2 columns or system columns).
In the above cases, these columns would be read-only while other columns of
the result-set are editable. Editable/Read-only columns are identified by
icons and tooltips in the column header.
This is still a work-in-progress, updates to tests and documentation is
still due. Looking forward to your thoughts and feedback!
Also, do you think the editable/read-only icons should apply in both
View/Edit Data and Query Tool for consistency? or hidden from View/Edit
Data as all columns are editable anyway?
Thanks.
--
*Yosry Muhammad Yosry*
Computer Engineering student,
The Faculty of Engineering,
Cairo University (2021).
Class representative of CMP 2021.
https://www.linkedin.com/in/yosrym93/
Attachment | Content-Type | Size |
---|---|---|
editable_readonly_columns.patch | text/x-patch | 21.0 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Murtuza Zabuawala | 2019-08-16 02:01:18 | Re: [RM#4546] Add RE-SQL tests for Column node |
Previous Message | Тараканов Андрей | 2019-08-15 16:08:36 | Minor Readme changes |