def _rename_burndown_columns(cursor, db_connector):
burndown = Table('agilo_burndown',
key=('task_id',
'date'))[Column('task_id', type='integer'),
Column('date', type='integer'),
Column('remaining_time', type='real'), ]
recreate_table_with_changed_types(
burndown,
cursor,
db_connector,
old_column_names=['task_id', 'day', 'time'])
def _rename_column_key_in_team_metrics_entry(env, cursor, db_connector):
team_metrics_entry = \
Table('team_metrics_entry', key=('team', 'sprint', 'metrics_key'))[
Column('team'),
Column('sprint'),
Column('metrics_key'),
Column('value', type='real'),
]
if get_db_type(env) == 'mysql':
# Agilo 0.7 before final (db version 3) was unable to run with
# MySQL. So the table could not be created in db version 2.
# Therefore we can just create a new one.
create_table_with_cursor(team_metrics_entry, cursor, db_connector)
else:
old_team_metrics_entry_colum_names = ['team', 'sprint', 'key', 'value']
recreate_table_with_changed_types(team_metrics_entry, cursor, db_connector,
old_column_names=old_team_metrics_entry_colum_names)
def _rename_column_end_in_sprint_table(env, cursor, db_connector):
if get_db_type(env) != 'postgres':
# Agilo 0.7 before final (db version 3) was unable to run with
# PostgreSQL. As we need the sprint table in db2 already, we had to
# create it with the new table layout. Therefore we don't change the
# postgres table here.
sprint = \
Table('sprint', key=('name'))[
Column('name'),
Column('description'),
Column('start', type='integer'),
Column('sprint_end', type='integer'),
Column('milestone'),
Column('team'),
]
old_sprint_column_names = ['name', 'description', 'start', 'end',
'milestone', 'team']
recreate_table_with_changed_types(sprint, cursor, db_connector,
old_column_names=old_sprint_column_names)
def _rename_column_key_in_team_metrics_entry(env, cursor, db_connector):
team_metrics_entry = \
Table('team_metrics_entry', key=('team', 'sprint', 'metrics_key'))[
Column('team'),
Column('sprint'),
Column('metrics_key'),
Column('value', type='real'),
]
if get_db_type(env) == 'mysql':
# Agilo 0.7 before final (db version 3) was unable to run with
# MySQL. So the table could not be created in db version 2.
# Therefore we can just create a new one.
create_table_with_cursor(team_metrics_entry, cursor, db_connector)
else:
old_team_metrics_entry_colum_names = ['team', 'sprint', 'key', 'value']
recreate_table_with_changed_types(
team_metrics_entry,
cursor,
db_connector,
old_column_names=old_team_metrics_entry_colum_names)
def _rename_column_end_in_sprint_table(env, cursor, db_connector):
if get_db_type(env) != 'postgres':
# Agilo 0.7 before final (db version 3) was unable to run with
# PostgreSQL. As we need the sprint table in db2 already, we had to
# create it with the new table layout. Therefore we don't change the
# postgres table here.
sprint = \
Table('sprint', key=('name'))[
Column('name'),
Column('description'),
Column('start', type='integer'),
Column('sprint_end', type='integer'),
Column('milestone'),
Column('team'),
]
old_sprint_column_names = [
'name', 'description', 'start', 'end', 'milestone', 'team'
]
recreate_table_with_changed_types(
sprint,
cursor,
db_connector,
old_column_names=old_sprint_column_names)
def _rename_burndown_columns(cursor, db_connector):
burndown = Table("agilo_burndown", key=("task_id", "date"))[
Column("task_id", type="integer"), Column("date", type="integer"), Column("remaining_time", type="real")
]
recreate_table_with_changed_types(burndown, cursor, db_connector, old_column_names=["task_id", "day", "time"])
