def downgrade(active_plugins=None, options=None): op.add_column( u'worklists', sa.Column('permission_id', mysql.INTEGER(display_width=11), autoincrement=False, nullable=True)) op.create_foreign_key(u'worklists_ibfk_2', 'worklists', 'permissions', ['permission_id'], ['id']) op.add_column( u'boards', sa.Column('permission_id', mysql.INTEGER(display_width=11), autoincrement=False, nullable=True)) op.create_foreign_key(u'boards_ibfk_2', 'boards', 'permissions', ['permission_id'], ['id']) session = api_base.get_session(in_request=False) to_delete = [] for board in boards.get_all(session=session): for permission in board.permissions: to_delete.append(permission) for worklist in worklists.get_all(session=session): for permission in worklist.permissions: to_delete.append(permission) op.drop_table('worklist_permissions') op.drop_table('board_permissions') for permission in to_delete: api_base.entity_hard_delete(models.Permission, permission.id, session=session)
def downgrade(active_plugins=None, options=None): op.add_column(u'worklists', sa.Column('permission_id', mysql.INTEGER(display_width=11), autoincrement=False, nullable=True)) op.create_foreign_key(u'worklists_ibfk_2', 'worklists', 'permissions', ['permission_id'], ['id']) op.add_column(u'boards', sa.Column('permission_id', mysql.INTEGER(display_width=11), autoincrement=False, nullable=True)) op.create_foreign_key(u'boards_ibfk_2', 'boards', 'permissions', ['permission_id'], ['id']) session = api_base.get_session(in_request=False) to_delete = [] for board in boards.get_all(session=session): for permission in board.permissions: to_delete.append(permission) for worklist in worklists.get_all(session=session): for permission in worklist.permissions: to_delete.append(permission) op.drop_table('worklist_permissions') op.drop_table('board_permissions') for permission in to_delete: api_base.entity_hard_delete( models.Permission, permission.id, session=session)
def upgrade(active_plugins=None, options=None): op.create_table('board_permissions', sa.Column('board_id', sa.Integer(), nullable=True), sa.Column('permission_id', sa.Integer(), nullable=True), sa.ForeignKeyConstraint(['board_id'], ['boards.id'], ), sa.ForeignKeyConstraint(['permission_id'], ['permissions.id'], ) ) op.create_table('worklist_permissions', sa.Column('worklist_id', sa.Integer(), nullable=True), sa.Column('permission_id', sa.Integer(), nullable=True), sa.ForeignKeyConstraint(['permission_id'], ['permissions.id'], ), sa.ForeignKeyConstraint(['worklist_id'], ['worklists.id'], ) ) session = api_base.get_session(in_request=False) for board in boards.get_all(session=session): edit_permission = { 'name': 'edit_board_%d' % board.id, 'codename': 'edit_board', 'users': [board.creator_id] } move_permission = { 'name': 'move_cards_%d' % board.id, 'codename': 'move_cards', 'users': [] } print('Creating permissions for Board with id: %d' % board.id) boards.create_permission(board.id, edit_permission, session=session) boards.create_permission(board.id, move_permission, session=session) for worklist in worklists.get_all(session=session): edit_permission = { 'name': 'edit_worklist_%d' % worklist.id, 'codename': 'edit_worklist', 'users': [worklist.creator_id] } move_permission = { 'name': 'move_items_%d' % worklist.id, 'codename': 'move_items', 'users': [] } print('Creating permissions for Worklist with id: %d' % worklist.id) worklists.create_permission( worklist.id, edit_permission, session=session) worklists.create_permission( worklist.id, move_permission, session=session) session.flush() dialect = op.get_bind().engine.dialect if dialect.supports_alter: op.drop_constraint(u'boards_ibfk_2', 'boards', type_='foreignkey') op.drop_column(u'boards', 'permission_id') op.drop_constraint(u'worklists_ibfk_2', 'worklists', type_='foreignkey') op.drop_column(u'worklists', 'permission_id')
def upgrade(active_plugins=None, options=None): op.create_table('board_permissions', sa.Column('board_id', sa.Integer(), nullable=True), sa.Column('permission_id', sa.Integer(), nullable=True), sa.ForeignKeyConstraint(['board_id'], ['boards.id'], ), sa.ForeignKeyConstraint(['permission_id'], ['permissions.id'], ) ) op.create_table('worklist_permissions', sa.Column('worklist_id', sa.Integer(), nullable=True), sa.Column('permission_id', sa.Integer(), nullable=True), sa.ForeignKeyConstraint(['permission_id'], ['permissions.id'], ), sa.ForeignKeyConstraint(['worklist_id'], ['worklists.id'], ) ) session = api_base.get_session(in_request=False) for board in boards.get_all(session=session): edit_permission = { 'name': 'edit_board_%d' % board.id, 'codename': 'edit_board', 'users': [board.creator_id] } move_permission = { 'name': 'move_cards_%d' % board.id, 'codename': 'move_cards', 'users': [] } print('Creating permissions for Board with id: %d' % board.id) boards.create_permission(board.id, edit_permission, session=session) boards.create_permission(board.id, move_permission, session=session) for worklist in worklists.get_all(session=session): edit_permission = { 'name': 'edit_worklist_%d' % worklist.id, 'codename': 'edit_worklist', 'users': [worklist.creator_id] } move_permission = { 'name': 'move_items_%d' % worklist.id, 'codename': 'move_items', 'users': [] } print('Creating permissions for Worklist with id: %d' % worklist.id) worklists.create_permission( worklist.id, edit_permission, session=session) worklists.create_permission( worklist.id, move_permission, session=session) session.flush() op.drop_constraint(u'boards_ibfk_2', 'boards', type_='foreignkey') op.drop_column(u'boards', 'permission_id') op.drop_constraint(u'worklists_ibfk_2', 'worklists', type_='foreignkey') op.drop_column(u'worklists', 'permission_id')
def get_all(self, title=None, creator_id=None, project_id=None, archived=False, user_id=None, story_id=None, task_id=None, hide_lanes=True, sort_field='id', sort_dir='asc', board_id=None): """Retrieve definitions of all of the worklists. :param title: A string to filter the title by. :param creator_id: Filter worklists by their creator. :param project_id: Filter worklists by project ID. :param archived: Filter worklists by whether they are archived or not. :param user_id: Filter worklists by the users with permissions. :param story_id: Filter worklists by whether they contain a story. :param task_id: Filter worklists by whether they contain a task. :param hide_lanes: If true, don't return worklists which are lanes in a board. :param sort_field: The name of the field to sort on. :param sort_dir: Sort direction for results (asc, desc). :param board_id: Get all worklists in the board with this id. Other filters are not applied. """ worklists = worklists_api.get_all(title=title, creator_id=creator_id, project_id=project_id, archived=archived, board_id=board_id, user_id=user_id, story_id=story_id, task_id=task_id, sort_field=sort_field, sort_dir=sort_dir) user_id = request.current_user_id visible_worklists = [] for worklist in worklists: if (worklists_api.visible(worklist, user_id, hide_lanes) and worklist.archived == archived): worklist_model = wmodels.Worklist.from_db_model(worklist) worklist_model.resolve_permissions(worklist) worklist_model.items = [ wmodels.WorklistItem.from_db_model(item) for item in worklist.items ] visible_worklists.append(worklist_model) # Apply the query response headers response.headers['X-Total'] = str(len(visible_worklists)) return visible_worklists
def get_all(self, title=None, creator_id=None, project_id=None, archived=False, user_id=None, story_id=None, task_id=None, hide_lanes=True, sort_field='id', sort_dir='asc', item_type=None, board_id=None, subscriber_id=None, offset=None, limit=None): """Retrieve definitions of all of the worklists. Example:: curl https://my.example.org/api/v1/worklists :param title: A string to filter the title by. :param creator_id: Filter worklists by their creator. :param project_id: Filter worklists by project ID. :param archived: Filter worklists by whether they are archived or not. :param user_id: Filter worklists by the users with permissions. :param story_id: Filter worklists by whether they contain a story. :param task_id: Filter worklists by whether they contain a task. :param hide_lanes: If true, don't return worklists which are lanes in a board. :param sort_field: The name of the field to sort on. :param sort_dir: Sort direction for results (asc, desc). :param item_type: Used when filtering by story_id. If item_type is 'story' then only return worklists that contain the story, if item_type is 'task' then only return worklists that contain tasks from the story, otherwise return worklists that contain the story or tasks from the story. :param board_id: Get all worklists in the board with this id. Other filters are not applied. :param subscriber_id: Filter worklists by whether a user is subscribed. :param offset: Offset at which to begin the results. :param limit: Maximum number of results to return. """ current_user = request.current_user_id # If a non existent story/task is requested, there is no point trying # to find worklists which contain it if story_id: story = stories_api.story_get(story_id, current_user=current_user) if story is None: response.headers['X-Total'] = '0' return [] if task_id: task = tasks_api.task_get(task_id, current_user=current_user) if task is None: response.headers['X-Total'] = '0' return [] worklists = worklists_api.get_all(title=title, creator_id=creator_id, project_id=project_id, archived=archived, board_id=board_id, user_id=user_id, story_id=story_id, task_id=task_id, subscriber_id=subscriber_id, sort_field=sort_field, sort_dir=sort_dir, offset=offset, limit=limit, current_user=current_user, hide_lanes=hide_lanes, item_type=item_type) count = worklists_api.get_count(title=title, creator_id=creator_id, project_id=project_id, archived=archived, board_id=board_id, user_id=user_id, story_id=story_id, task_id=task_id, subscriber_id=subscriber_id, current_user=current_user, hide_lanes=hide_lanes, item_type=item_type) visible_worklists = [] for worklist in worklists: worklist_model = wmodels.Worklist.from_db_model(worklist) worklist_model.resolve_permissions(worklist) visible_items = worklists_api.get_visible_items( worklist, request.current_user_id) worklist_model.items = [ wmodels.WorklistItem.from_db_model(item) for item in visible_items ] visible_worklists.append(worklist_model) # Apply the query response headers response.headers['X-Total'] = str(count) if limit is not None: response.headers['X-Limit'] = str(limit) if offset is not None: response.headers['X-Offset'] = str(offset) return visible_worklists