from trac.db import Table, Column

name = 'tracforge.admin'
version = 8
tables = [
    Table('tracforge_projects', key='name')[
        Column('name'),
        Column('env_path'),
    ],
    Table('tracforge_project_log', key=('project', 'action'))[
        Column('id', auto_increment=True),
        Column('project'),
        Column('action'),
        Column('args'),
        Column('return'),
        Column('stdout'),
        Column('stderr'),
    ],
    #Table('tracforge_project_output', key=('ts'
    Table('tracforge_members', key=('project', 'username'))[
        Column('project'),
        Column('username'),
        Column('role'),
    ],
    Table('tracforge_permission', key=('username', 'action'))[
        Column('username'),
        Column('action'),
    ],
    Table('tracforge_prototypes', key=('tag', 'step'))[
        Column('tag'),
        Column('step', type='integer'),
        Column('action'),
        Column('args'),
    ],
    Table('tracforge_configs', key=('tag', 'section', 'key'))[
        Column('tag'),
        Column('section'),
        Column('key'),
        Column('value'),
        Column('action'),
    ],
]

def rename_user_to_username(data):
    """Change tracforge_members.user to tracforge_members.username to work with
    Postgres as "user" is a keyword.
    """
    colnames = data['tracforge_members'][0]
    for i, col in enumerate(colnames):
        # checking for 'sid', which was used instead of 'username' in an earlier
        # version of the bewst/0.11 branch
        if col == 'user' or col == 'sid':
            colnames[i] = 'username'
    
migrations = [
    (xrange(1,8), rename_user_to_username),
]