Kexi/Plugins/Tables/Simple alter table: Difference between revisions

Revision as of 23:44, 1 September 2012

Design page for task: Simple approach to fulfill "Add support for alter table's design without losing data" wish.

Started: Jstaniek (talk) August 2012
Wish #125253
Target: 2.6.0

Rationale

Approach when modification to table schema is saved directly after user performed it is much easier than full alter table tired in Kexi 1.x and never delivered.

Analysis

Altering some physical properties would require immediate saving of the design but will not remove all the data.
Other properties (for which KexiDB::isExtendedTableFieldProperty() return true) can be modified without altering any data.

Alter actions

This section publishes details on particular actions of table altering.

Caption rename

triggers name change in propeditor, so:
- if name changed, go to Name change section
- else, do nothing, caption should be saved on Save action

Requirements

Full data safety
- It's better to warn and request data removal than claiming it is not necessary and then doing that

@@ Line 12: / Line 12: @@
 *Altering some physical properties would require immediate saving of the design but will not remove all the data.
 *Other properties (for which KexiDB::isExtendedTableFieldProperty() return true) can be modified without altering any data.
+==Alter actions==
+This section publishes details on particular actions of table altering.
+===Caption rename===
+*triggers name change in propeditor, so:
+**if name changed, go to ''Name change'' section
+**else, do nothing, caption should be saved on Save action
 ==Requirements==
 *Full data safety
 **It's better to warn and request data removal than claiming it is not necessary and then doing that