KDbAlterTableHandler

Search for usage in LXR

#include <KDbAlter.h>

Inheritance diagram for KDbAlterTableHandler:

Classes

class  ActionBase
 
class  ChangeFieldPropertyAction
 
class  ExecutionArguments
 
class  FieldActionBase
 
class  InsertFieldAction
 
class  MoveFieldPositionAction
 
class  RemoveFieldAction
 

Public Types

typedef KDbUtils::AutodeletedHash< QByteArray, ActionBase * > ActionDict
 
typedef QHash< QByteArray, ActionBase * >::ConstIterator ActionDictConstIterator
 
typedef KDbUtils::AutodeletedHash< int, ActionDict * > ActionDictDict
 
typedef QHash< int, ActionDict * >::ConstIterator ActionDictDictConstIterator
 
typedef QHash< int, ActionDict * >::Iterator ActionDictDictIterator
 
typedef QHash< QByteArray, ActionBase * >::Iterator ActionDictIterator
 
typedef QList< ActionBase * > ActionList
 
typedef QList< ActionBase * >::ConstIterator ActionListIterator
 
typedef QVector< ActionBase * > ActionsVector
 
enum  AlteringRequirements {
  PhysicalAlteringRequired = 1, DataConversionRequired = 2, MainSchemaAlteringRequired = 4, ExtendedSchemaAlteringRequired = 8,
  SchemaAlteringRequired = ExtendedSchemaAlteringRequired | MainSchemaAlteringRequired
}
 

Public Member Functions

 KDbAlterTableHandler (KDbConnection *conn)
 
const ActionListactions () const
 
void addAction (ActionBase *action)
 
void clear ()
 
void debug ()
 
KDbTableSchemaexecute (const QString &tableName, ExecutionArguments *args)
 
KDbAlterTableHandleroperator<< (ActionBase *action)
 
void removeAction (int index)
 
void setActions (const ActionList &actions)
 
- Public Member Functions inherited from KDbResultable
 KDbResultable (const KDbResultable &other)
 
void clearResult ()
 
KDbMessageHandlermessageHandler () const
 
KDbResultableoperator= (const KDbResultable &other)
 
KDbResult result () const
 
virtual QString serverResultName () const
 
void setMessageHandler (KDbMessageHandler *handler)
 
void showMessage ()
 

Static Public Member Functions

static int alteringTypeForProperty (const QByteArray &propertyName)
 

Additional Inherited Members

- Protected Attributes inherited from KDbResultable
Private *const d
 
KDbResult m_result
 

Detailed Description

A tool for handling altering database table schema.

In relational (and other) databases, table schema altering is not an easy task. It may be considered as easy if there is no data that user wants to keep while the table schema is altered. Otherwise, if the table is alredy filled with data, there could be no easy algorithm like:

  1. Drop existing table
  2. Create new one with altered schema.

Instead, more complex algorithm is needed. To perform the table schema alteration, a list of well defined atomic operations is used as a "recipe".

  1. Look at the current data, and: 1.1. analyze what values will be removed (in case of impossible conversion or table field removal); 1.2. analyze what values can be converted (e.g. from numeric types to text), and so on.
  2. Optimize the atomic actions knowing that sometimes a compilation of one action and another that's opposite to the first means "do nothing". The optimization is a simulating of actions' execution. For example, when both action A="change field name from 'city' to 'town'" and action B="change field name from 'town' to 'city'" is specified, the compilation of the actions means "change field name from 'city' to 'city'", what is a NULL action. On the other hand, we need to execute all the actions on the destination table in proper order, and not just drop them. For the mentioned example, between actions A and B there can be an action like C="change the type of field 'city' to LongText". If A and B were simply removed, C would become invalid (there is no 'city' field).
  3. Ask user whether she agrees with the results of analysis mentioned in 1. 3.2. Additionally, it may be possible to get some hints from the user, as humans usually know more about logic behind the altered table schema than any machine. If the user provided hints about the altering, apply them to the actions list.
  4. Create (empty) destination table schema with temporary name, using the information collected so far.
  5. Copy the data from the source to destionation table. Convert values, move them between fields, using the information collected.
  6. Remove the source table.
  7. Rename the destination table to the name previously assigned for the source table.

Notes: The actions 4 to 7 should be performed within a database transaction. [todo] We want to take care about database relationships as well. For example, is a table field is removed, relationships related to this field should be also removed (similar rules as in the Query Designer). Especially, care about primary keys and uniquess (indices). Recreate them when needed. The problem could be if such analysis may require to fetch the entire table data to the client side. Use "SELECT INTO" statements if possible to avoid such a treat.

The KDbAlterTableHandler is used in Kexi's Table Designer. Already opened KDbConnection object is needed.

Use case:

KDbConnection *conn = ...
// add some actions (in reality this is performed by tracking user's actions)
// Actions 1, 2 will require physical table altering PhysicalAltering
// Action 3 will only require changes in kexi__fields
// Action 4 will only require changes in extended table schema written in kexi__objectdata
AlterTable::ActionList list;
// 1. rename the "city" field to "town"
list << new ChangeFieldPropertyAction("city", "name", "town")
// 2. change type of "town" field to "LongText"
<< new ChangeFieldPropertyAction("town", "type", "LongText")
// 3. set caption of "town" field to "Town"
<< new ChangeFieldPropertyAction("town", "caption", "Town")
// 4. set visible decimal places to 4 for "cost" field
<< new ChangeFieldPropertyAction("cost", "visibleDecimalPlaces", 4)

Actions for Alter

Definition at line 109 of file KDbAlter.h.

Member Typedef Documentation

◆ ActionDict

For collecting actions related to a single field.

Definition at line 141 of file KDbAlter.h.

◆ ActionDictDict

for collecting groups of actions by field UID

Definition at line 144 of file KDbAlter.h.

◆ ActionList

Defines a type for action list.

Definition at line 152 of file KDbAlter.h.

◆ ActionListIterator

Defines a type for action list's iterator.

Definition at line 155 of file KDbAlter.h.

◆ ActionsVector

for collecting actions related to a single field

Definition at line 149 of file KDbAlter.h.

Member Enumeration Documentation

◆ AlteringRequirements

Defines flags for possible altering requirements; can be combined.

Enumerator
PhysicalAlteringRequired 

Physical table altering is required; e.g. ALTER TABLE ADD COLUMN.

DataConversionRequired 

Data conversion is required; e.g. converting integer values to string after changing column type from integer to text.

MainSchemaAlteringRequired 

Changes to the main table schema (in kexi__fields) required, this does not require physical changes for the table; e.g. changing value of the "caption" or "description" property.

ExtendedSchemaAlteringRequired 

Only changes to extended table schema required, this does not require physical changes for the table; e.g. changing value of the "visibleDecimalPlaces" property or any of the custom properties.

SchemaAlteringRequired 

Convenience flag, changes to the main or extended schema is required.

Definition at line 118 of file KDbAlter.h.

Member Function Documentation

◆ actions()

const KDbAlterTableHandler::ActionList & KDbAlterTableHandler::actions ( ) const
Returns
a list of actions for this AlterTable object. Use ActionBase::ListIterator to iterate over the list items.

Definition at line 784 of file KDbAlter.cpp.

◆ addAction()

void KDbAlterTableHandler::addAction ( ActionBase action)

Appends action for the alter table tool.

Definition at line 773 of file KDbAlter.cpp.

◆ alteringTypeForProperty()

int KDbAlterTableHandler::alteringTypeForProperty ( const QByteArray propertyName)
static

Like execute() with simulate set to true, but debug is directed to debugString. This function is used only in the alter table test suite.

Helper.

Returns
a combination of AlteringRequirements values decribing altering type required when a given property field's propertyName is altered. Used internally KDbAlterTableHandler. Moreover it can be also used in the Table Designer's code as a temporary replacement before KDbAlterTableHandler is fully implemented. Thus, it is possible to identify properties that have no PhysicalAlteringRequired flag set (e.g. caption or extended properties like visibleDecimalPlaces.

Definition at line 181 of file KDbAlter.cpp.

◆ clear()

void KDbAlterTableHandler::clear ( )

Removes all actions from the alter table tool.

Definition at line 794 of file KDbAlter.cpp.

◆ debug()

void KDbAlterTableHandler::debug ( )

Displays debug information about all actions collected by the handler.

Definition at line 805 of file KDbAlter.cpp.

◆ execute()

KDbTableSchema * KDbAlterTableHandler::execute ( const QString tableName,
ExecutionArguments args 
)

Performs table alteration using predefined actions for table named tableName, assuming it already exists. The KDbConnection object passed to the constructor must exist, must be connected and a database must be used. The connection must not be read-only.

If args.simulate is true, the execution is only simulated, i.e. al lactions are processed like for regular execution but no changes are performed physically. This mode is used only for debugging purposes.

Todo:
For some cases, table schema can completely change, so it will be needed to refresh all objects depending on it. Implement this!

Sets args.result to true on success, to false on failure or when the above requirements are not met (then, you can get a detailed error message from KDbObject). When the action has been cancelled (stopped), args.result is set to cancelled value. If args.debugString is not 0, it will be filled with debugging output.

Returns
the new table schema object created as a result of schema altering. The old table is returned if recreating table schema was not necessary or args.simulate is true. 0 is returned if args.result is not true.
Todo:
err msg?
Todo:
err msg?
Todo:
err msg?
Todo:
err msg?
Todo:
transaction!

copy id

Todo:
better errmsg?
Todo:
delete newTable...
Todo:
support expressions (eg. TODAY()) as a default value
Todo:
this field can be notNull or notEmpty - check whether the default is ok (or do this checking also in the Table Designer?)
Todo:
support unique, validatationRule, unsigned flags...
Todo:
check for foreignKey values...
Todo:
delete newTable...
Todo:
delete newTable...
Todo:
delete newTable...

Definition at line 813 of file KDbAlter.cpp.

◆ operator<<()

KDbAlterTableHandler & KDbAlterTableHandler::operator<< ( ActionBase action)

Provided for convenience,

See also
addAction(const ActionBase& action).

Definition at line 778 of file KDbAlter.cpp.

◆ removeAction()

void KDbAlterTableHandler::removeAction ( int  index)

Removes an action from the alter table tool at index index.

Definition at line 789 of file KDbAlter.cpp.

◆ setActions()

void KDbAlterTableHandler::setActions ( const ActionList actions)

Sets actions for the alter table tool. Previous actions are cleared. actions will be owned by the KDbAlterTableHandler object.

Definition at line 799 of file KDbAlter.cpp.


The documentation for this class was generated from the following files:
KIOFILEWIDGETS_EXPORT QStringList list(const QString &fileClass)
KDbTableSchema * execute(const QString &tableName, ExecutionArguments *args)
Definition: KDbAlter.cpp:813
Provides database connection, allowing queries and data modification.
Definition: KDbConnection.h:51
A tool for handling altering database table schema.
Definition: KDbAlter.h:109
This file is part of the KDE documentation.
Documentation copyright © 1996-2022 The KDE developers.
Generated on Tue Aug 16 2022 04:06:30 by doxygen 1.8.17 written by Dimitri van Heesch, © 1997-2006

KDE's Doxygen guidelines are available online.