| 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: | Whole Thread | Raw Message | 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 |