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"])