Python remove_propagated_roles Beispiele

Beispiel #1

Datei: 20180704150104_786774c00050_product_group_acr_update.py Projekt: wslukaa/ggrc-core

def downgrade():
    """Downgrade database schema and/or data back to the previous revision."""
    for object_type, roles_tree \
            in product_group_rules.GGRC_BASIC_PERMISSIONS_PROPAGATION.items():
        if "ProductGroup" in object_type:
            acr_propagation.remove_propagated_roles(object_type,
                                                    roles_tree.keys())

Beispiel #2

Datei: 20180818154238_c3ef0656a527_add_workflow_propagation_roles.py Projekt: wangsaisai/ggrc-core

def downgrade():
    """Remove Risk propagated roles"""
    for object_type, roles_tree in const.WORKFLOW_PROPAGATION.items():
        acr_propagation.remove_propagated_roles(object_type, roles_tree.keys())

    op.bulk_insert(acr_propagation.ACR_TABLE,
                   [{
                       'name': 'Admin Mapped',
                       'object_type': 'Workflow',
                       'tooltip': None,
                       'read': True,
                       'update': True,
                       'delete': True,
                       'my_work': False,
                       'mandatory': False,
                       'non_editable': True,
                       'internal': True,
                       'created_at': datetime.datetime.now(),
                       'updated_at': datetime.datetime.now(),
                       'default_to_current_user': False,
                   }, {
                       'name': 'Workflow Member Mapped',
                       'object_type': 'Workflow',
                       'tooltip': None,
                       'read': True,
                       'update': False,
                       'delete': False,
                       'my_work': False,
                       'mandatory': False,
                       'non_editable': True,
                       'internal': True,
                       'created_at': datetime.datetime.now(),
                       'updated_at': datetime.datetime.now(),
                       'default_to_current_user': False,
                   }])

Beispiel #3

def downgrade():
    """Downgrade database schema and/or data back to the previous revision."""

    connection = op.get_bind()
    ids = connection.execute("""
      select
        acl.id,
        acl.object_type,
        acl.object_id,
        p.email,
        acr.name
      from acl_copy as acl
      left join people as p on
        acl.person_id = p.id
      left join access_control_roles as acr on
        acl.ac_role_id = acr.id
      where
        acl.parent_id is null and
        acl.id not in (select id from access_control_list)
  """).fetchall()
    print "ACL entries that will be reintroduced by this downgrade:"
    for row in ids:
        print row

    ids = connection.execute("""
      select
        acl.id,
        acl.object_type,
        acl.object_id,
        p.email,
        acr.name
      from access_control_list as acl
      left join people as p on
        acl.person_id = p.id
      left join access_control_roles as acr on
        acl.ac_role_id = acr.id
      where
        acl.parent_id is null and
        acl.id not in (select id from acl_copy)
  """).fetchall()
    print "ACL entries that will not be propagated properly by this downgrade:"
    print "To fix these roles please manually remove and re-add them."
    for row in ids:
        print row

    for object_type, roles_tree in const.GGRC_PROPAGATION.items():
        acr_propagation.remove_propagated_roles(object_type, roles_tree.keys())
    _remove_parent_id_column()

    op.execute(
        "INSERT IGNORE INTO access_control_roles SELECT * from acr_copy")
    op.execute("INSERT IGNORE INTO access_control_list SELECT * from acl_copy")

Beispiel #4

def downgrade():
  """Downgrade database schema and/or data back to the previous revision."""

  connection = op.get_bind()
  ids = connection.execute("""
      select
        acl.id,
        acl.object_type,
        acl.object_id,
        p.email,
        acr.name
      from acl_copy as acl
      left join people as p on
        acl.person_id = p.id
      left join access_control_roles as acr on
        acl.ac_role_id = acr.id
      where
        acl.parent_id is null and
        acl.id not in (select id from access_control_list)
  """).fetchall()
  print "ACL entries that will be reintroduced by this downgrade:"
  for row in ids:
    print row

  ids = connection.execute("""
      select
        acl.id,
        acl.object_type,
        acl.object_id,
        p.email,
        acr.name
      from access_control_list as acl
      left join people as p on
        acl.person_id = p.id
      left join access_control_roles as acr on
        acl.ac_role_id = acr.id
      where
        acl.parent_id is null and
        acl.id not in (select id from acl_copy)
  """).fetchall()
  print "ACL entries that will not be propagated properly by this downgrade:"
  print "To fix these roles please manually remove and re-add them."
  for row in ids:
    print row

  for object_type, roles_tree in const.GGRC_PROPAGATION.items():
    acr_propagation.remove_propagated_roles(object_type, roles_tree.keys())
  _remove_parent_id_column()

  op.execute("INSERT IGNORE INTO access_control_roles SELECT * from acr_copy")
  op.execute("INSERT IGNORE INTO access_control_list SELECT * from acl_copy")

Beispiel #5

def downgrade():
  """Downgrade database schema and/or data back to the previous revision."""
  op.drop_table('technology_environments')

  for object_type, roles_tree in tech_env_rules.GGRC_PROPAGATION.items():
    if "TechnologyEnvironment" in object_type:
      acr_propagation.remove_propagated_roles(object_type, roles_tree.keys())

  # Remove items from access_control_list
  op.execute("DELETE FROM access_control_list "
             "WHERE object_type = 'TechnologyEnvironment'")
  # Remove items from access_control_roles
  op.execute("DELETE FROM access_control_roles "
             "WHERE object_type = 'TechnologyEnvironment'")

Beispiel #6

def downgrade():
    """Downgrade database schema and/or data back to the previous revision."""
    op.drop_table('product_groups')

    for object_type, roles_tree in product_group_rules.GGRC_PROPAGATION.items(
    ):
        if "ProductGroup" in object_type:
            acr_propagation.remove_propagated_roles(object_type,
                                                    roles_tree.keys())

    # Remove items from access_control_list
    op.execute("DELETE FROM access_control_list "
               "WHERE object_type = 'ProductGroup'")
    # Remove items from access_control_roles
    op.execute("DELETE FROM access_control_roles "
               "WHERE object_type = 'ProductGroup'")

Beispiel #7

Datei: 20180818154238_c3ef0656a527_add_workflow_propagation_roles.py Projekt: google/ggrc-core

def downgrade():
  """Remove Risk propagated roles"""
  for object_type, roles_tree in const.WORKFLOW_PROPAGATION.items():
    acr_propagation.remove_propagated_roles(object_type, roles_tree.keys())

  op.bulk_insert(
      acr_propagation.ACR_TABLE,
      [{
          'name': 'Admin Mapped',
          'object_type': 'Workflow',
          'tooltip': None,
          'read': True,
          'update': True,
          'delete': True,
          'my_work': False,
          'mandatory': False,
          'non_editable': True,
          'internal': True,
          'created_at': datetime.datetime.now(),
          'updated_at': datetime.datetime.now(),
          'default_to_current_user': False,
      }, {
          'name': 'Workflow Member Mapped',
          'object_type': 'Workflow',
          'tooltip': None,
          'read': True,
          'update': False,
          'delete': False,
          'my_work': False,
          'mandatory': False,
          'non_editable': True,
          'internal': True,
          'created_at': datetime.datetime.now(),
          'updated_at': datetime.datetime.now(),
          'default_to_current_user': False,
      }]
  )

Beispiel #8

def downgrade():
  """Remove Risk propagated roles"""
  for object_type, roles_tree in const.GGRC_RISKS_PROPAGATION.items():
    acr_propagation.remove_propagated_roles(object_type, roles_tree.keys())

Beispiel #9

Datei: 20180425112829_b1cb47a3bb3b_update_propagation_rules_for_evidence.py Projekt: zdqf/ggrc-core

def remove_old_rule_tree():
    """Remove old ACL propagation rules"""
    propagation = prev_rules.GGRC_PROPAGATION
    for object_type, roles_tree in propagation.items():
        acr_propagation.remove_propagated_roles(object_type, roles_tree.keys())

Beispiel #10

Datei: 20180312115757_507a59a3e70c_add_audit_acr_propagation.py Projekt: zdqf/ggrc-core

def downgrade():
    """Downgrade database schema and/or data back to the previous revision."""
    propagation = const.GGRC_BASIC_PERMISSIONS_PROPAGATION
    for object_type, roles_tree in propagation.items():
        acr_propagation.remove_propagated_roles(object_type, roles_tree.keys())

Beispiel #11

def downgrade():
    """Remove Risk propagated roles"""
    for object_type, roles_tree in const.GGRC_RISKS_PROPAGATION.items():
        acr_propagation.remove_propagated_roles(object_type, roles_tree.keys())

Beispiel #12

def downgrade():
  """Downgrade database schema and/or data back to the previous revision."""
  propagation = const.GGRC_BASIC_PERMISSIONS_PROPAGATION
  for object_type, roles_tree in propagation.items():
    acr_propagation.remove_propagated_roles(object_type, roles_tree.keys())

Beispiel #13

def remove_old_rule_tree():
  """Remove old ACL propagation rules"""
  propagation = prev_rules.GGRC_PROPAGATION
  for object_type, roles_tree in propagation.items():
    acr_propagation.remove_propagated_roles(object_type, roles_tree.keys())

Beispiel #14

def downgrade():
  """Downgrade database schema and/or data back to the previous revision."""
  for object_type, roles_tree in \
          scoping_objects_rules.GGRC_PROPAGATION.items():
    acr_propagation.remove_propagated_roles(object_type, roles_tree.keys())

Beispiel #15

Datei: 20180614084547_e7c4703cb09c_update_acl_propagation_rules_for_tech_.py Projekt: wslukaa/ggrc-core

def downgrade():
  """Downgrade database schema and/or data back to the previous revision."""
  for object_type, roles_tree \
          in tech_env_rules.GGRC_BASIC_PERMISSIONS_PROPAGATION.items():
    if "TechnologyEnvironment" in object_type:
      acr_propagation.remove_propagated_roles(object_type, roles_tree.keys())