def upgrade():
"""Upgrade database schema and/or data, creating a new revision."""
_add_roles_for_objects(SCOPING_OBJECTS, NEW_ROLES)
acr_propagation.propagate_roles(
acr_constants.GGRC_NEW_ROLES_PROPAGATION,
with_update=True
)
def upgrade():
"""Upgrade database schema and/or data, creating a new revision."""
connection = op.get_bind()
user_id = migrator.get_migration_user_id(connection)
query = acr_propagation.ACR_TABLE.insert().values(
name="Other Contacts",
object_type="Control",
created_at=datetime.datetime.utcnow(),
updated_at=datetime.datetime.utcnow(),
modified_by_id=user_id,
internal=False,
non_editable=True,
mandatory=False,
read=True,
update=True,
delete=True,
)
result = connection.execute(query)
utils.add_to_objects_without_revisions(
connection,
result.lastrowid,
"AccessControlRole"
)
acr_propagation.propagate_roles(
propagation_rule.GGRC_NEW_ROLES_PROPAGATION,
with_update=True
)
update_control_recipients(connection)
def upgrade():
"""Upgrade database schema and/or data, creating a new revision."""
# Add Assignee, Verifier roles
_add_roles_for_objects(SCOPING_OBJECTS, NEW_ROLES)
# Propagate Assignee, Verifier roles
acr_propagation.propagate_roles(
scoping_objects_rules.GGRC_NEW_ROLES_PROPAGATION, with_update=True)
def upgrade():
"""Upgrade database schema and/or data, creating a new revision."""
acr_propagation.propagate_roles(const.WORKFLOW_PROPAGATION)
acr_propagation.remove_deprecated_roles([
'Admin Mapped',
'Workflow Member Mapped',
])
def upgrade(): """Upgrade database schema and/or data, creating a new revision.""" connection = op.get_bind() migrator_id = migrator.get_migration_user_id(connection) update_recipients(connection, migrator_id) update_role_names(connection, migrator_id) propagate_roles(CONTROL_PROPAGATION, with_update=True) update_templates_definitions(connection, migrator_id)
def upgrade():
"""Upgrade database schema and/or data, creating a new revision."""
connection = op.get_bind()
migrator_id = migrator.get_migration_user_id(connection)
update_recipients(connection, migrator_id)
update_role_names(connection, migrator_id)
propagate_roles(CONTROL_PROPAGATION, with_update=True)
update_templates_definitions(connection, migrator_id)
def upgrade():
"""Upgrade database schema and/or data, creating a new revision."""
# Add Assignee, Verifier roles
_add_roles_for_objects(SCOPING_OBJECTS, NEW_ROLES)
# Propagate Assignee, Verifier roles
acr_propagation.propagate_roles(
scoping_objects_rules.GGRC_NEW_ROLES_PROPAGATION,
with_update=True
)
def upgrade():
"""Upgrade database schema and/or data, creating a new revision."""
acr_propagation.propagate_roles(const.GGRC_BASIC_PERMISSIONS_PROPAGATION)
acr_propagation.remove_deprecated_roles([
"Audit Captains Mapped",
"Auditors Assessment Mapped",
"Auditors Document Mapped",
"Auditors Issue Mapped",
"Auditors Mapped",
"Auditors Snapshot Mapped",
"Program Editors Mapped",
"Program Managers Mapped",
"Program Readers Mapped",
])
def upgrade():
"""Upgrade database schema and/or data, creating a new revision."""
acr_propagation.propagate_roles(const.GGRC_BASIC_PERMISSIONS_PROPAGATION)
acr_propagation.remove_deprecated_roles([
"Audit Captains Mapped",
"Auditors Assessment Mapped",
"Auditors Document Mapped",
"Auditors Issue Mapped",
"Auditors Mapped",
"Auditors Snapshot Mapped",
"Program Editors Mapped",
"Program Managers Mapped",
"Program Readers Mapped",
])
def upgrade():
"""Upgrade database schema and/or data, creating a new revision."""
acr_propagation.propagate_roles(
scoping_objects_rules.GGRC_PROPAGATION,
with_update=True
)
def propagate_acr():
"""Create propagation system ACRs for KeyReport model"""
acr_propagation.propagate_roles(
acr_constants.GGRC_BASIC_PERMISSIONS_PROPAGATION, with_update=True)
def upgrade():
"""Upgrade database schema and/or data, creating a new revision."""
_add_roles_for_objects(SCOPING_OBJECTS, NEW_ROLES)
acr_propagation.propagate_roles(acr_constants.GGRC_NEW_ROLES_PROPAGATION,
with_update=True)
def upgrade():
"""Upgrade database schema and/or data, creating a new revision."""
op.create_table(
'product_groups',
# Base, Identifiable, Id
sa.Column('id', sa.Integer(), nullable=False),
# BusinessObject, Titled, title
sa.Column('title', sa.String(length=250), nullable=False),
# BusinessObject, Described, description
sa.Column('description', sa.Text(), nullable=False),
# BusinessObject, Noted, Notes
sa.Column('notes', sa.Text(), nullable=False),
# BusinessObject, Slugged, Code
sa.Column('slug', sa.String(length=250), nullable=False),
# BusinessObject, Stateful, State
sa.Column('status',
sa.String(length=250),
nullable=False,
server_default="Draft"),
# HasObjectState, Review State
sa.Column('os_state',
sa.String(length=250),
nullable=False,
server_default="Unreviewed"),
# TestPlanned, Assessment Procedure
sa.Column('test_plan', sa.Text(), nullable=False),
# ObjectPerson, Timeboxed, WithStartDate, Effective Date
sa.Column('start_date', sa.Date(), nullable=True),
# LastDeprecatedTimeboxed, Last Deprecated Date
sa.Column('end_date', sa.Date(), nullable=True),
# Commentable, Recipients
sa.Column('recipients', sa.String(length=250), nullable=True),
# Commentable, Send by default
sa.Column('send_by_default',
mysql.TINYINT(display_width=1),
nullable=True),
# Base, ContextRBAC, Context Id
sa.Column('context_id', sa.Integer(), nullable=True),
sa.Column('created_at', sa.DateTime(), nullable=False),
sa.Column('updated_at', sa.DateTime(), nullable=False),
sa.Column('modified_by_id', sa.Integer(), nullable=True),
sa.PrimaryKeyConstraint('id'),
mysql_default_charset=u'utf8',
mysql_engine=u'InnoDB',
)
op.create_foreign_key(None, 'product_groups', 'contexts', ['context_id'],
['id'])
op.create_index('fk_product_groups_contexts',
'product_groups', ['context_id'],
unique=False)
op.create_index('ix_product_groups_updated_at',
'product_groups', ['updated_at'],
unique=False)
op.create_unique_constraint('uq_product_groups', 'product_groups',
['slug'])
op.create_unique_constraint('uq_t_product_groups', 'product_groups',
['title'])
update_acr.update_models_with_contacts(['ProductGroup'],
NON_EDITABLE_ROLES)
update_acr.update_ownable_models(['ProductGroup'])
acr_propagation.propagate_roles(product_group_rules.GGRC_PROPAGATION,
with_update=True)
def upgrade(): """Upgrade database schema and/or data, creating a new revision.""" propagate_roles(ASMT_EVIDENCE_PERMISSIONS, with_update=True)
def upgrade():
"""Upgrade database schema and/or data, creating a new revision."""
acr_propagation.propagate_roles(GGRC_NEW_ROLES_PROPAGATION,
with_update=True)
def _add_assessment_roles_tree(): acr_propagation.propagate_roles(const.GGRC_PROPAGATION)
def upgrade(): """Upgrade database schema and/or data, creating a new revision.""" acr_propagation.propagate_roles(const.GGRC_RISKS_PROPAGATION)
def _add_assessment_roles_tree():
acr_propagation.propagate_roles(const.GGRC_PROPAGATION)
def upgrade():
"""Upgrade database schema and/or data, creating a new revision."""
remove_old_rule_tree()
acr_propagation.propagate_roles(
doc_epic_rules.GGRC_PROPAGATION)
def upgrade():
"""Upgrade database schema and/or data, creating a new revision."""
remove_old_rule_tree()
acr_propagation.propagate_roles(doc_epic_rules.GGRC_PROPAGATION)
def propagate_acr():
"""Create propagation system ACRs for KeyReport model"""
acr_propagation.propagate_roles(
acr_constants.CONTROL_PROPAGATION_RULE,
with_update=True
)
def propagate_acr():
"""Create propagation system ACRs for KeyReport model"""
acr_propagation.propagate_roles(
acr_constants.GGRC_BASIC_PERMISSIONS_PROPAGATION,
with_update=True
)
def upgrade():
"""Upgrade database schema and/or data, creating a new revision."""
acr_propagation.propagate_roles(
product_group_rules.GGRC_BASIC_PERMISSIONS_PROPAGATION,
with_update=True)
def upgrade():
"""Upgrade database schema and/or data, creating a new revision."""
acr_propagation.propagate_roles(const.GGRC_RISKS_PROPAGATION)
def upgrade():
"""Upgrade database schema and/or data, creating a new revision."""
propagate_roles(AUDITOR_PERMISSIONS, with_update=True)
def upgrade():
"""Upgrade database schema and/or data, creating a new revision."""
propagate_roles(TASK_ASSIGNEES_PERMISSION, with_update=True)
