[GSoC][New Feature] Editable and Read-only Columns

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

Responses

Browse pgadmin-hackers by date

  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