You are viewing a plain text version of this content. The canonical link for it is here.
Posted to ddlutils-dev@db.apache.org by "Rick Riemer (JIRA)" <ji...@apache.org> on 2008/07/17 15:01:31 UTC
[jira] Created: (DDLUTILS-216) Split SqlBuilder.copyData() to allow
for copying specific columns
Split SqlBuilder.copyData() to allow for copying specific columns
-----------------------------------------------------------------
Key: DDLUTILS-216
URL: https://issues.apache.org/jira/browse/DDLUTILS-216
Project: DdlUtils
Issue Type: Improvement
Components: Core (No specific database)
Affects Versions: 1.0
Reporter: Rick Riemer
Assignee: Thomas Dudziak
Fix For: 1.1
Attachments: split_copy_data.patch
Currently the copyData() method on SqlBuilder is protected and only allows for copying data between columns with the same name. In some cases (especially during upgrades) it may be useful to copy the content of one column to another.
As an example: during an upgrade a column may be moved out of a table to another table. To implement this change it is required to create the new column in a table, copy the data from the old column to the new column and optionally drop the old column.
This behavior can easily be achieved by splitting copyData() into a part that determines the set of columns to copy and a part that actually copies the data between those columns. If the last part if made into a public method, this also allows for users to implement their custom table copy changes in combination with #DDLUTILS-215.
The attached patch implements this behavior. The patch does not break the existing API.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DDLUTILS-216) Split SqlBuilder.copyData() to allow
for copying specific columns
Posted by "Rick Riemer (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DDLUTILS-216?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rick Riemer updated DDLUTILS-216:
---------------------------------
Attachment: split_copy_data.patch
> Split SqlBuilder.copyData() to allow for copying specific columns
> -----------------------------------------------------------------
>
> Key: DDLUTILS-216
> URL: https://issues.apache.org/jira/browse/DDLUTILS-216
> Project: DdlUtils
> Issue Type: Improvement
> Components: Core (No specific database)
> Affects Versions: 1.0
> Reporter: Rick Riemer
> Assignee: Thomas Dudziak
> Fix For: 1.1
>
> Attachments: split_copy_data.patch
>
>
> Currently the copyData() method on SqlBuilder is protected and only allows for copying data between columns with the same name. In some cases (especially during upgrades) it may be useful to copy the content of one column to another.
> As an example: during an upgrade a column may be moved out of a table to another table. To implement this change it is required to create the new column in a table, copy the data from the old column to the new column and optionally drop the old column.
> This behavior can easily be achieved by splitting copyData() into a part that determines the set of columns to copy and a part that actually copies the data between those columns. If the last part if made into a public method, this also allows for users to implement their custom table copy changes in combination with #DDLUTILS-215.
> The attached patch implements this behavior. The patch does not break the existing API.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.