Edgewall Software

Opened 9 years ago

Last modified 8 years ago

#11872 closed enhancement

DatabaseManager should support adding and removing table columns — at Version 5

Reported by: Ryan J Ollos Owned by: Ryan J Ollos
Priority: normal Milestone: 1.2
Component: database backend Version:
Severity: normal Keywords:
Cc: Branch:
Release Notes:
API Changes:

Added method to DatabaseManager for upgrading database tables: upgrade_tables. Added method to Table class for removing columns: remove_columns.

Internal Changes:

Description

The DatabaseManager class has methods to create and drop tables (#11512). It would be useful to have a method to add a column to a table.

Change History (5)

comment:1 by Ryan J Ollos, 9 years ago

A drop_column method could be useful as well. One use-case in #9612.

The approach to adding columns has been to create a temporary table for the data and drop/re-create the table. For example: tags/trac-1.0.2/trac/upgrades/db11.py​.

Last edited 8 years ago by Ryan J Ollos (previous) (diff)

comment:2 by Ryan J Ollos, 9 years ago

Summary: DatabaseManager should support adding a column to a table → DatabaseManager should support adding and removing table columns

comment:3 by Ryan J Ollos, 9 years ago

Milestone: next-dev-1.1.x → next-dev-1.3.x

Narrowing focus for milestone:1.2. Please move ticket to milestone:1.2 if you intend to fix it.

comment:4 by Ryan J Ollos, 8 years ago

Milestone: next-dev-1.3.x → 1.2
Owner: set to Ryan J Ollos
Status: new → assigned

comment:5 by Ryan J Ollos, 8 years ago

API Changes: modified (diff)

This is being addressed as part of #9612.

Note: See TracTickets for help on using tickets.