Update to new version 5.4HEADstable/jermamaster

Signed-off-by: Thomas Duval <thomas.duval@orange.com>
Change-Id: Idcd868133d75928a1ffd74d749ce98503e0555ea

5 files changed, 1659 insertions, 0 deletions

diff --git a/old/python_moondb/tests/unit_python/policies/__init__.py b/old/python_moondb/tests/unit_python/policies/__init__.py
new file mode 100644
index 00000000..e69de29b
--- /dev/null
+++ b/old/python_moondb/tests/unit_python/policies/__init__.py
diff --git a/old/python_moondb/tests/unit_python/policies/mock_data.py b/old/python_moondb/tests/unit_python/policies/mock_data.py
new file mode 100644
index 00000000..47fc9f9e
--- /dev/null
+++ b/old/python_moondb/tests/unit_python/policies/mock_data.py
@@ -0,0 +1,74 @@
+import helpers.model_helper as model_helper
+import helpers.meta_rule_helper as meta_rule_helper
+import helpers.policy_helper as policy_helper
+import helpers.category_helper as category_helper
+
+
+def create_meta_rule(meta_rule_name="meta_rule1", category_prefix=""):
+    meta_rule_value = {
+        "name": meta_rule_name,
+        "algorithm": "name of the meta rule algorithm",
+        "subject_categories": [category_prefix + "subject_category_id1",
+                               category_prefix + "subject_category_id2"],
+        "object_categories": [category_prefix + "object_category_id1"],
+        "action_categories": [category_prefix + "action_category_id1"]
+    }
+    return meta_rule_value
+
+
+def create_model(meta_rule_id, model_name="test_model"):
+    value = {
+        "name": model_name,
+        "description": "test",
+        "meta_rules": [meta_rule_id]
+
+    }
+    return value
+
+
+def create_policy(model_id, policy_name="policy_1"):
+    value = {
+        "name": policy_name,
+        "model_id": model_id,
+        "genre": "authz",
+        "description": "test",
+    }
+    return value
+
+
+def create_pdp(pdp_ids):
+    value = {
+        "name": "test_pdp",
+        "security_pipeline": pdp_ids,
+        "keystone_project_id": "keystone_project_id1",
+        "description": "...",
+    }
+    return value
+
+
+def get_policy_id(model_name="test_model", policy_name="policy_1", meta_rule_name="meta_rule1", category_prefix=""):
+    category_helper.add_subject_category(
+        category_prefix + "subject_category_id1",
+        value={"name": category_prefix + "subject_category_id1",
+               "description": "description 1"})
+    category_helper.add_subject_category(
+        category_prefix + "subject_category_id2",
+        value={"name": category_prefix + "subject_category_id2",
+               "description": "description 1"})
+    category_helper.add_object_category(
+        category_prefix + "object_category_id1",
+        value={"name": category_prefix + "object_category_id1",
+               "description": "description 1"})
+    category_helper.add_action_category(
+        category_prefix + "action_category_id1",
+        value={"name": category_prefix + "action_category_id1",
+               "description": "description 1"})
+    meta_rule = meta_rule_helper.add_meta_rule(value=create_meta_rule(meta_rule_name, category_prefix))
+    meta_rule_id = list(meta_rule.keys())[0]
+    model = model_helper.add_model(value=create_model(meta_rule_id, model_name))
+    model_id = list(model.keys())[0]
+    value = create_policy(model_id, policy_name)
+    policy = policy_helper.add_policies(value=value)
+    assert policy
+    policy_id = list(policy.keys())[0]
+    return policy_id
diff --git a/old/python_moondb/tests/unit_python/policies/test_assignments.py b/old/python_moondb/tests/unit_python/policies/test_assignments.py
new file mode 100755
index 00000000..24a3a7b0
--- /dev/null
+++ b/old/python_moondb/tests/unit_python/policies/test_assignments.py
@@ -0,0 +1,235 @@
+# Copyright 2015 Open Platform for NFV Project, Inc. and its contributors
+# This software is distributed under the terms and conditions of the 'Apache-2.0'
+# license which can be found in the file 'LICENSE' in this package distribution
+# or at 'http://www.apache.org/licenses/LICENSE-2.0'.
+
+import helpers.mock_data as mock_data
+import helpers.assignment_helper as assignment_helper
+from python_moonutilities.exceptions import *
+import pytest
+
+
+def test_get_action_assignments(db):
+    subject_category_id, object_category_id, action_category_id, meta_rule_id, policy_id = mock_data.create_new_policy(
+        subject_category_name="subject_category1",
+        object_category_name="object_category1",
+        action_category_name="action_category1",
+        meta_rule_name="meta_rule_1")
+    action_id = mock_data.create_action(policy_id)
+    data_id = mock_data.create_action_data(policy_id=policy_id, category_id=action_category_id)
+
+    assignment_helper.add_action_assignment(policy_id, action_id, action_category_id, data_id)
+    act_assignments = assignment_helper.get_action_assignments(policy_id, action_id,
+                                                               action_category_id)
+    action_id_1 = list(act_assignments.keys())[0]
+    assert act_assignments[action_id_1]["policy_id"] == policy_id
+    assert act_assignments[action_id_1]["action_id"] == action_id
+    assert act_assignments[action_id_1]["category_id"] == action_category_id
+    assert len(act_assignments[action_id_1].get("assignments")) == 1
+    assert data_id in act_assignments[action_id_1].get("assignments")
+
+
+def test_add_action_assignments(db):
+    subject_category_id, object_category_id, action_category_id, meta_rule_id, policy_id = mock_data.create_new_policy(
+        subject_category_name="subject_category1",
+        object_category_name="object_category1",
+        action_category_name="action_category1",
+        meta_rule_name="meta_rule_1")
+    action_id = mock_data.create_action(policy_id)
+    data_id = mock_data.create_action_data(policy_id=policy_id, category_id=action_category_id)
+    action_assignments = assignment_helper.add_action_assignment(policy_id, action_id,
+                                                                 action_category_id, data_id)
+    assert action_assignments
+    action_id_1 = list(action_assignments.keys())[0]
+    assert action_assignments[action_id_1]["policy_id"] == policy_id
+    assert action_assignments[action_id_1]["action_id"] == action_id
+    assert action_assignments[action_id_1]["category_id"] == action_category_id
+    assert len(action_assignments[action_id_1].get("assignments")) == 1
+    assert data_id in action_assignments[action_id_1].get("assignments")
+
+    with pytest.raises(ActionAssignmentExisting) as exception_info:
+        assignment_helper.add_action_assignment(policy_id, action_id, action_category_id, data_id)
+    assert str(exception_info.value) == '409: Action Assignment Existing'
+    assert str(exception_info.value.description) == 'The given action assignment value is existing.'
+
+
+def test_delete_action_assignment(db):
+    subject_category_id, object_category_id, action_category_id, meta_rule_id, policy_id = mock_data.create_new_policy(
+        subject_category_name="subject_category1",
+        object_category_name="object_category1",
+        action_category_name="action_category1",
+        meta_rule_name="meta_rule_1")
+    action_id = mock_data.create_action(policy_id)
+    data_id = mock_data.create_action_data(policy_id=policy_id, category_id=action_category_id)
+    assignment_helper.add_action_assignment(policy_id, action_id, action_category_id, data_id)
+    assignment_helper.delete_action_assignment(policy_id, "", "", "")
+    assignments = assignment_helper.get_action_assignments(policy_id, )
+    assert len(assignments) == 1
+
+
+def test_delete_action_assignment_with_invalid_policy_id(db):
+    policy_id = "invalid_id"
+    assignment_helper.delete_action_assignment(policy_id, "", "", "")
+    assignments = assignment_helper.get_action_assignments(policy_id, )
+    assert len(assignments) == 0
+
+
+def test_get_object_assignments(db):
+    subject_category_id, object_category_id, action_category_id, meta_rule_id, policy_id = mock_data.create_new_policy(
+        subject_category_name="subject_category1",
+        object_category_name="object_category1",
+        action_category_name="action_category1",
+        meta_rule_name="meta_rule_1")
+    object_id = mock_data.create_object(policy_id)
+    data_id = mock_data.create_object_data(policy_id=policy_id, category_id=object_category_id)
+    assignment_helper.add_object_assignment(policy_id, object_id, object_category_id, data_id)
+    obj_assignments = assignment_helper.get_object_assignments(policy_id, object_id,
+                                                               object_category_id)
+    object_id_1 = list(obj_assignments.keys())[0]
+    assert obj_assignments[object_id_1]["policy_id"] == policy_id
+    assert obj_assignments[object_id_1]["object_id"] == object_id
+    assert obj_assignments[object_id_1]["category_id"] == object_category_id
+    assert len(obj_assignments[object_id_1].get("assignments")) == 1
+    assert data_id in obj_assignments[object_id_1].get("assignments")
+
+
+def test_get_object_assignments_by_policy_id(db):
+    subject_category_id, object_category_id, action_category_id, meta_rule_id, policy_id = mock_data.create_new_policy(
+        subject_category_name="subject_category1",
+        object_category_name="object_category1",
+        action_category_name="action_category1",
+        meta_rule_name="meta_rule_1")
+    object_id = mock_data.create_object(policy_id)
+    data_id = mock_data.create_object_data(policy_id=policy_id, category_id=object_category_id)
+    assignment_helper.add_object_assignment(policy_id, object_id, object_category_id, data_id)
+    obj_assignments = assignment_helper.get_object_assignments(policy_id)
+    assert len(obj_assignments) == 1
+
+
+def test_add_object_assignments(db):
+    subject_category_id, object_category_id, action_category_id, meta_rule_id, policy_id = mock_data.create_new_policy(
+        subject_category_name="subject_category1",
+        object_category_name="object_category1",
+        action_category_name="action_category1",
+        meta_rule_name="meta_rule_1")
+    object_id = mock_data.create_object(policy_id)
+    data_id = mock_data.create_object_data(policy_id=policy_id, category_id=object_category_id)
+    object_assignments = assignment_helper.add_object_assignment(policy_id, object_id,
+                                                                 object_category_id, data_id)
+    assert object_assignments
+    object_id_1 = list(object_assignments.keys())[0]
+    assert object_assignments[object_id_1]["policy_id"] == policy_id
+    assert object_assignments[object_id_1]["object_id"] == object_id
+    assert object_assignments[object_id_1]["category_id"] == object_category_id
+    assert len(object_assignments[object_id_1].get("assignments")) == 1
+    assert data_id in object_assignments[object_id_1].get("assignments")
+
+    with pytest.raises(ObjectAssignmentExisting) as exception_info:
+        assignment_helper.add_object_assignment(policy_id, object_id, object_category_id, data_id)
+    assert str(exception_info.value) == '409: Object Assignment Existing'
+    assert str(exception_info.value.description) == 'The given object assignment value is existing.'
+
+
+def test_delete_object_assignment(db):
+    subject_category_id, object_category_id, action_category_id, meta_rule_id, policy_id = mock_data.create_new_policy(
+        subject_category_name="subject_category1",
+        object_category_name="object_category1",
+        action_category_name="action_category1",
+        meta_rule_name="meta_rule_1")
+    object_id = mock_data.create_object(policy_id)
+    data_id = mock_data.create_object_data(policy_id=policy_id, category_id=object_category_id)
+    assignment_helper.add_object_assignment(policy_id, object_id, object_category_id, data_id)
+
+    assignment_helper.delete_object_assignment(policy_id, object_id, object_category_id,
+                                               data_id=data_id)
+    assignments = assignment_helper.get_object_assignments(policy_id)
+    assert len(assignments) == 0
+
+
+def test_delete_object_assignment_with_invalid_policy_id(db):
+    policy_id = "invalid_id"
+    assignment_helper.delete_object_assignment(policy_id, "", "", "")
+    assignments = assignment_helper.get_object_assignments(policy_id, )
+    assert len(assignments) == 0
+
+
+def test_get_subject_assignments(db):
+    subject_category_id, object_category_id, action_category_id, meta_rule_id, policy_id = mock_data.create_new_policy(
+        subject_category_name="subject_category1",
+        object_category_name="object_category1",
+        action_category_name="action_category1",
+        meta_rule_name="meta_rule_1")
+    subject_id = mock_data.create_subject(policy_id)
+    data_id = mock_data.create_subject_data(policy_id=policy_id, category_id=subject_category_id)
+
+    assignment_helper.add_subject_assignment(policy_id, subject_id, subject_category_id, data_id)
+    subj_assignments = assignment_helper.get_subject_assignments(policy_id, subject_id,
+                                                                 subject_category_id)
+    subject_id_1 = list(subj_assignments.keys())[0]
+    assert subj_assignments[subject_id_1]["policy_id"] == policy_id
+    assert subj_assignments[subject_id_1]["subject_id"] == subject_id
+    assert subj_assignments[subject_id_1]["category_id"] == subject_category_id
+    assert len(subj_assignments[subject_id_1].get("assignments")) == 1
+    assert data_id in subj_assignments[subject_id_1].get("assignments")
+
+
+def test_get_subject_assignments_by_policy_id(db):
+    subject_category_id, object_category_id, action_category_id, meta_rule_id, policy_id = mock_data.create_new_policy(
+        subject_category_name="subject_category1",
+        object_category_name="object_category1",
+        action_category_name="action_category1",
+        meta_rule_name="meta_rule_1")
+    subject_id = mock_data.create_subject(policy_id)
+    data_id = mock_data.create_subject_data(policy_id=policy_id, category_id=subject_category_id)
+
+    assignment_helper.add_subject_assignment(policy_id, subject_id, subject_category_id, data_id)
+    subj_assignments = assignment_helper.get_subject_assignments(policy_id)
+    assert len(subj_assignments) == 1
+
+
+def test_add_subject_assignments(db):
+    subject_category_id, object_category_id, action_category_id, meta_rule_id, policy_id = mock_data.create_new_policy(
+        subject_category_name="subject_category1",
+        object_category_name="object_category1",
+        action_category_name="action_category1",
+        meta_rule_name="meta_rule_1")
+    subject_id = mock_data.create_subject(policy_id)
+    data_id = mock_data.create_subject_data(policy_id=policy_id, category_id=subject_category_id)
+
+    subject_assignments = assignment_helper.add_subject_assignment(policy_id, subject_id,
+                                                                   subject_category_id, data_id)
+    assert subject_assignments
+    subject_id_1 = list(subject_assignments.keys())[0]
+    assert subject_assignments[subject_id_1]["policy_id"] == policy_id
+    assert subject_assignments[subject_id_1]["subject_id"] == subject_id
+    assert subject_assignments[subject_id_1]["category_id"] == subject_category_id
+    assert len(subject_assignments[subject_id_1].get("assignments")) == 1
+    assert data_id in subject_assignments[subject_id_1].get("assignments")
+
+    with pytest.raises(SubjectAssignmentExisting) as exception_info:
+        assignment_helper.add_subject_assignment(policy_id, subject_id, subject_category_id,
+                                                 data_id)
+    assert str(exception_info.value) == '409: Subject Assignment Existing'
+    assert str(
+        exception_info.value.description) == 'The given subject assignment value is existing.'
+
+
+def test_delete_subject_assignment(db):
+    subject_category_id, object_category_id, action_category_id, meta_rule_id, policy_id = mock_data.create_new_policy(
+        subject_category_name="subject_category1",
+        object_category_name="object_category1",
+        action_category_name="action_category1",
+        meta_rule_name="meta_rule_1")
+    subject_id = mock_data.create_subject(policy_id)
+    data_id = mock_data.create_subject_data(policy_id=policy_id, category_id=subject_category_id)
+    assignment_helper.add_subject_assignment(policy_id, subject_id, subject_category_id, data_id)
+    assignment_helper.delete_subject_assignment(policy_id, subject_id, subject_category_id, data_id)
+    assignments = assignment_helper.get_subject_assignments(policy_id)
+    assert len(assignments) == 0
+
+
+def test_delete_subject_assignment_with_invalid_policy_id(db):
+    policy_id = "invalid_id"
+    assignment_helper.delete_subject_assignment(policy_id, "", "", "")
+    assignments = assignment_helper.get_subject_assignments(policy_id, )
+    assert len(assignments) == 0
diff --git a/old/python_moondb/tests/unit_python/policies/test_data.py b/old/python_moondb/tests/unit_python/policies/test_data.py
new file mode 100755
index 00000000..8ce1ac00
--- /dev/null
+++ b/old/python_moondb/tests/unit_python/policies/test_data.py
@@ -0,0 +1,707 @@
+# Copyright 2015 Open Platform for NFV Project, Inc. and its contributors
+# This software is distributed under the terms and conditions of the 'Apache-2.0'
+# license which can be found in the file 'LICENSE' in this package distribution
+# or at 'http://www.apache.org/licenses/LICENSE-2.0'.
+
+import helpers.mock_data as mock_data
+import policies.mock_data
+import helpers.data_helper as data_helper
+import helpers.assignment_helper as assignment_helper
+import pytest
+from uuid import uuid4
+import logging
+from python_moonutilities.exceptions import *
+
+logger = logging.getLogger("python_moondb.tests.api.test_data")
+
+
+def test_get_action_data(db):
+    subject_category_id, object_category_id, action_category_id, meta_rule_id, policy_id = mock_data.create_new_policy(
+        subject_category_name="subject_category1",
+        object_category_name="object_category1",
+        action_category_name="action_category1",
+        meta_rule_name="meta_rule_1")
+    value = {
+        "name": "action-type",
+        "description": {"vm-action": "", "storage-action": "", },
+    }
+    action_data = data_helper.add_action_data(policy_id=policy_id, category_id=action_category_id, value=value)
+    data_id = list(action_data["data"])[0]
+    found_action_data = data_helper.get_action_data(policy_id=policy_id, data_id=data_id,
+                                                    category_id=action_category_id)
+    assert found_action_data
+    assert len(found_action_data[0]["data"]) == 1
+
+
+def test_get_action_data_with_invalid_category_id(db):
+    subject_category_id, object_category_id, action_category_id, meta_rule_id, policy_id = mock_data.create_new_policy(
+        subject_category_name="subject_category1",
+        object_category_name="object_category1",
+        action_category_name="action_category1",
+        meta_rule_name="meta_rule_1")
+    action_data = data_helper.get_action_data(policy_id=policy_id, category_id="invalid")
+    assert len(action_data) == 0
+
+
+def test_add_action_data(db):
+    subject_category_id, object_category_id, action_category_id, meta_rule_id, policy_id = mock_data.create_new_policy(
+        subject_category_name="subject_category1",
+        object_category_name="object_category1",
+        action_category_name="action_category1",
+        meta_rule_name="meta_rule_1")
+    value = {
+        "name": "action-type",
+        "description": {"vm-action": "", "storage-action": "", },
+    }
+    action_data = data_helper.add_action_data(policy_id=policy_id, category_id=action_category_id, value=value)
+    assert action_data
+    assert len(action_data['data']) == 1
+
+
+def test_add_action_data_duplicate(db):
+    subject_category_id, object_category_id, action_category_id, meta_rule_id, policy_id = mock_data.create_new_policy(
+        subject_category_name="subject_category1",
+        object_category_name="object_category1",
+        action_category_name="action_category1",
+        meta_rule_name="meta_rule_1")
+    value = {
+        "name": "action-type",
+        "description": {"vm-action": "", "storage-action": "", },
+    }
+    action_data = data_helper.add_action_data(policy_id=policy_id, category_id=action_category_id, value=value)
+    with pytest.raises(ActionScopeExisting) as exception_info:
+        action_data = data_helper.add_action_data(policy_id=policy_id, category_id=action_category_id, value=value)
+    assert str(exception_info.value) == '409: Action Scope Existing'
+
+def test_add_action_data_with_invalid_category_id(db):
+    subject_category_id, object_category_id, action_category_id, meta_rule_id, policy_id = mock_data.create_new_policy(
+        subject_category_name="subject_category1",
+        object_category_name="object_category1",
+        action_category_name="action_category1",
+        meta_rule_name="meta_rule_1")
+    value = {
+        "name": "action-type",
+        "description": {"vm-action": "", "storage-action": "", },
+    }
+    with pytest.raises(ActionCategoryUnknown) as exception_info:
+        data_helper.add_action_data(policy_id=policy_id, value=value).get('data')
+    assert str(exception_info.value) == '400: Action Category Unknown'
+
+
+def test_delete_action_data(db):
+    subject_category_id, object_category_id, action_category_id, meta_rule_id, policy_id = mock_data.create_new_policy(
+        subject_category_name="subject_category1",
+        object_category_name="object_category1",
+        action_category_name="action_category1",
+        meta_rule_name="meta_rule_1")
+    data_helper.get_available_metadata(policy_id)
+    value = {
+        "name": "action-type",
+        "description": {"vm-action": "", "storage-action": "", },
+    }
+    action_data = data_helper.add_action_data(policy_id=policy_id, category_id=action_category_id, value=value)
+    data_id = list(action_data["data"])[0]
+    data_helper.delete_action_data(policy_id=policy_id, data_id=data_id)
+    new_action_data = data_helper.get_action_data(policy_id)
+    assert len(new_action_data[0]['data']) == 0
+
+
+def test_get_object_data(db):
+    subject_category_id, object_category_id, action_category_id, meta_rule_id, policy_id = mock_data.create_new_policy(
+        subject_category_name="subject_category1",
+        object_category_name="object_category1",
+        action_category_name="action_category1",
+        meta_rule_name="meta_rule_1")
+    value = {
+        "name": "object-security-level",
+        "description": {"low": "", "medium": "", "high": ""},
+    }
+    object_data = data_helper.add_object_data(policy_id=policy_id, category_id=object_category_id, value=value)
+    data_id = list(object_data["data"])[0]
+    found_object_data = data_helper.get_object_data(policy_id=policy_id, data_id=data_id,
+                                                    category_id=object_category_id)
+    assert found_object_data
+    assert len(found_object_data[0]['data']) == 1
+
+
+def test_get_object_data_with_invalid_category_id(db):
+    subject_category_id, object_category_id, action_category_id, meta_rule_id, policy_id = mock_data.create_new_policy(
+        subject_category_name="subject_category1",
+        object_category_name="object_category1",
+        action_category_name="action_category1",
+        meta_rule_name="meta_rule_1")
+    object_data = data_helper.get_object_data(policy_id=policy_id, category_id="invalid")
+    assert len(object_data) == 0
+
+
+def test_add_object_data(db):
+    subject_category_id, object_category_id, action_category_id, meta_rule_id, policy_id = mock_data.create_new_policy(
+        subject_category_name="subject_category1",
+        object_category_name="object_category1",
+        action_category_name="action_category1",
+        meta_rule_name="meta_rule_1")
+    value = {
+        "name": "object-security-level",
+        "description": {"low": "", "medium": "", "high": ""},
+    }
+    object_data = data_helper.add_object_data(policy_id=policy_id, category_id=object_category_id, value=value).get(
+        'data')
+    assert object_data
+    object_data_id = list(object_data.keys())[0]
+    assert object_data[object_data_id].get('policy_id') == policy_id
+
+
+def test_add_object_data_with_invalid_category_id(db):
+    subject_category_id, object_category_id, action_category_id, meta_rule_id, policy_id = mock_data.create_new_policy(
+        subject_category_name="subject_category1",
+        object_category_name="object_category1",
+        action_category_name="action_category1",
+        meta_rule_name="meta_rule_1")
+    value = {
+        "name": "object-security-level",
+        "description": {"low": "", "medium": "", "high": ""},
+    }
+    with pytest.raises(ObjectCategoryUnknown) as exception_info:
+        data_helper.add_object_data(policy_id=policy_id, category_id="invalid", value=value).get('data')
+    assert str(exception_info.value) == '400: Object Category Unknown'
+
+
+def test_add_object_data_duplicate(db):
+    subject_category_id, object_category_id, action_category_id, meta_rule_id, policy_id = mock_data.create_new_policy(
+        subject_category_name="subject_category1",
+        object_category_name="object_category1",
+        action_category_name="action_category1",
+        meta_rule_name="meta_rule_1")
+    value = {
+        "name": "object-security-level",
+        "description": {"low": "", "medium": "", "high": ""},
+    }
+    object_data = data_helper.add_object_data(policy_id=policy_id, category_id=object_category_id, value=value).get(
+        'data')
+    with pytest.raises(ObjectScopeExisting) as exception_info:
+        data_helper.add_object_data(policy_id=policy_id, category_id=object_category_id, value=value).get(
+            'data')
+    assert str(exception_info.value) == '409: Object Scope Existing'
+
+
+def test_delete_object_data(db):
+    subject_category_id, object_category_id, action_category_id, meta_rule_id, policy_id = mock_data.create_new_policy(
+        subject_category_name="subject_category1",
+        object_category_name="object_category1",
+        action_category_name="action_category1",
+        meta_rule_name="meta_rule_1")
+    value = {
+        "name": "object-security-level",
+        "description": {"low": "", "medium": "", "high": ""},
+    }
+    object_data = data_helper.add_object_data(policy_id=policy_id, category_id=object_category_id, value=value).get(
+        'data')
+    object_data_id = list(object_data.keys())[0]
+    data_helper.delete_object_data(policy_id=object_data[object_data_id].get('policy_id'), data_id=object_data_id)
+    new_object_data = data_helper.get_object_data(policy_id)
+    assert len(new_object_data[0]['data']) == 0
+
+
+def test_get_subject_data(db):
+    subject_category_id, object_category_id, action_category_id, meta_rule_id, policy_id = mock_data.create_new_policy(
+        subject_category_name="subject_category1",
+        object_category_name="object_category1",
+        action_category_name="action_category1",
+        meta_rule_name="meta_rule_1")
+    value = {
+        "name": "subject-security-level",
+        "description": {"low": "", "medium": "", "high": ""},
+    }
+    subject_data = data_helper.add_subject_data(policy_id=policy_id, category_id=subject_category_id, value=value).get(
+        'data')
+    subject_data_id = list(subject_data.keys())[0]
+    subject_data = data_helper.get_subject_data(policy_id, subject_data_id, subject_category_id)
+    assert subject_data
+    assert len(subject_data[0]['data']) == 1
+
+
+def test_get_subject_data_with_invalid_category_id(db):
+    subject_category_id, object_category_id, action_category_id, meta_rule_id, policy_id = mock_data.create_new_policy(
+        subject_category_name="subject_category1",
+        object_category_name="object_category1",
+        action_category_name="action_category1",
+        meta_rule_name="meta_rule_1")
+    value = {
+        "name": "subject-security-level",
+        "description": {"low": "", "medium": "", "high": ""},
+    }
+    subject_data = data_helper.add_subject_data(policy_id=policy_id, category_id=subject_category_id, value=value).get(
+        'data')
+    subject_data_id = list(subject_data.keys())[0]
+    found_subject_data = data_helper.get_subject_data(policy_id, subject_data_id, "invalid")
+    assert len(found_subject_data) == 0
+
+
+def test_add_subject_data(db):
+    subject_category_id, object_category_id, action_category_id, meta_rule_id, policy_id = mock_data.create_new_policy(
+        subject_category_name="subject_category1",
+        object_category_name="object_category1",
+        action_category_name="action_category1",
+        meta_rule_name="meta_rule_1")
+    value = {
+        "name": "subject-security-level",
+        "description": {"low": "", "medium": "", "high": ""},
+    }
+    subject_data = data_helper.add_subject_data(policy_id=policy_id, category_id=subject_category_id, value=value).get(
+        'data')
+    assert subject_data
+    subject_data_id = list(subject_data.keys())[0]
+    assert subject_data[subject_data_id].get('policy_id') == policy_id
+
+
+def test_add_subject_data_with_no_category_id(db):
+    subject_category_id, object_category_id, action_category_id, meta_rule_id, policy_id = mock_data.create_new_policy(
+        subject_category_name="subject_category1",
+        object_category_name="object_category1",
+        action_category_name="action_category1",
+        meta_rule_name="meta_rule_1")
+    value = {
+        "name": "subject-security-level",
+        "description": {"low": "", "medium": "", "high": ""},
+    }
+    with pytest.raises(SubjectCategoryUnknown) as exception_info:
+        data_helper.add_subject_data(policy_id=policy_id, data_id=subject_category_id, value=value).get('data')
+    assert str(exception_info.value) == '400: Subject Category Unknown'
+
+
+def test_add_subject_data_duplicate(db):
+    subject_category_id, object_category_id, action_category_id, meta_rule_id, policy_id = mock_data.create_new_policy(
+        subject_category_name="subject_category1",
+        object_category_name="object_category1",
+        action_category_name="action_category1",
+        meta_rule_name="meta_rule_1")
+    value = {
+        "name": "subject-security-level",
+        "description": {"low": "", "medium": "", "high": ""},
+    }
+    subject_data = data_helper.add_subject_data(policy_id=policy_id, category_id=subject_category_id, value=value).get(
+        'data')
+
+    with pytest.raises(SubjectScopeExisting) as exception_info:
+        subject_data = data_helper.add_subject_data(policy_id=policy_id, category_id=subject_category_id,
+                                                    value=value).get('data')
+    assert str(exception_info.value) == '409: Subject Scope Existing'
+
+
+def test_delete_subject_data(db):
+    subject_category_id, object_category_id, action_category_id, meta_rule_id, policy_id = mock_data.create_new_policy(
+        subject_category_name="subject_category1",
+        object_category_name="object_category1",
+        action_category_name="action_category1",
+        meta_rule_name="meta_rule_1")
+    value = {
+        "name": "subject-security-level",
+        "description": {"low": "", "medium": "", "high": ""},
+    }
+    subject_data = data_helper.add_subject_data(policy_id=policy_id, category_id=subject_category_id, value=value).get(
+        'data')
+    subject_data_id = list(subject_data.keys())[0]
+    data_helper.delete_subject_data(policy_id=subject_data[subject_data_id].get('policy_id'), data_id=subject_data_id)
+    new_subject_data = data_helper.get_subject_data(policy_id)
+    assert len(new_subject_data[0]['data']) == 0
+
+
+def test_get_actions(db):
+    subject_category_id, object_category_id, action_category_id, meta_rule_id, policy_id = mock_data.create_new_policy(
+        subject_category_name="subject_category1",
+        object_category_name="object_category1",
+        action_category_name="action_category1",
+        meta_rule_name="meta_rule_1")
+    value = {
+        "name": "test_action",
+        "description": "test",
+    }
+    data_helper.add_action(policy_id=policy_id, value=value)
+    actions = data_helper.get_actions(policy_id, )
+    assert actions
+    assert len(actions) == 1
+    action_id = list(actions.keys())[0]
+    assert actions[action_id].get('policy_list')[0] == policy_id
+
+
+def test_add_action(db):
+    subject_category_id, object_category_id, action_category_id, meta_rule_id, policy_id = mock_data.create_new_policy(
+        subject_category_name="subject_category1",
+        object_category_name="object_category1",
+        action_category_name="action_category1",
+        meta_rule_name="meta_rule_1")
+    value = {
+        "name": "test_action",
+        "description": "test",
+    }
+    action = data_helper.add_action(policy_id=policy_id, value=value)
+    assert action
+    action_id = list(action.keys())[0]
+    assert len(action[action_id].get('policy_list')) == 1
+
+
+def test_add_action_twice(db):
+    subject_category_id, object_category_id, action_category_id, meta_rule_id, policy_id = mock_data.create_new_policy(
+        subject_category_name="subject_category1",
+        object_category_name="object_category1",
+        action_category_name="action_category1",
+        meta_rule_name="meta_rule_1")
+    value = {
+        "name": "test_action",
+        "description": "test",
+    }
+    data_helper.add_action(policy_id=policy_id, value=value)
+    with pytest.raises(PolicyExisting) as exception_info:
+        data_helper.add_action(policy_id=policy_id, value=value)
+    assert str(exception_info.value) == '409: Policy Already Exists'
+
+
+def test_add_action_blank_name(db):
+    policy_id = policies.mock_data.get_policy_id()
+    value = {
+        "name": "",
+        "description": "test",
+    }
+    with pytest.raises(PerimeterContentError) as exception_info:
+        data_helper.add_action(policy_id=policy_id, value=value)
+    assert str(exception_info.value) == '400: Perimeter content is invalid.'
+
+
+def test_add_action_with_name_space(db):
+    policy_id = policies.mock_data.get_policy_id()
+    value = {
+        "name": "   ",
+        "description": "test",
+    }
+    with pytest.raises(PerimeterContentError) as exception_info:
+        data_helper.add_action(policy_id=policy_id, value=value)
+    assert str(exception_info.value) == '400: Perimeter content is invalid.'
+
+
+def test_add_action_multiple_times(db):
+    subject_category_id, object_category_id, action_category_id, meta_rule_id, policy_id1 = mock_data.create_new_policy(
+        subject_category_name="subject_category1",
+        object_category_name="object_category1",
+        action_category_name="action_category1",
+        meta_rule_name="meta_rule_1",
+        model_name="model1")
+    value = {
+        "name": "test_action",
+        "description": "test",
+    }
+    action = data_helper.add_action(policy_id=policy_id1, value=value)
+    logger.info("action : {}".format(action))
+    action_id = list(action.keys())[0]
+    perimeter_id = action[action_id].get('id')
+    assert action
+    value = {
+        "name": "test_action",
+        "description": "test",
+        "policy_list": ['policy_id_3', 'policy_id_4']
+    }
+    subject_category_id, object_category_id, action_category_id, meta_rule_id, policy_id2 = mock_data.create_new_policy(
+        subject_category_name="subject_category2",
+        object_category_name="object_category2",
+        action_category_name="action_category2",
+        meta_rule_name="meta_rule_2",
+        model_name="model2")
+    action = data_helper.add_action(policy_id=policy_id2, perimeter_id=perimeter_id, value=value)
+    logger.info("action : {}".format(action))
+    assert action
+    action_id = list(action.keys())[0]
+    assert len(action[action_id].get('policy_list')) == 2
+
+
+def test_delete_action(db):
+    subject_category_id, object_category_id, action_category_id, meta_rule_id, policy_id = mock_data.create_new_policy(
+        subject_category_name="subject_category1",
+        object_category_name="object_category1",
+        action_category_name="action_category1",
+        meta_rule_name="meta_rule_1")
+    value = {
+        "name": "test_action",
+        "description": "test",
+    }
+    action = data_helper.add_action(policy_id=policy_id, value=value)
+    action_id = list(action.keys())[0]
+    data_helper.delete_action(policy_id, action_id)
+    actions = data_helper.get_actions(policy_id, )
+    assert not actions
+
+
+def test_delete_action_with_invalid_perimeter_id(db):
+    policy_id = "invalid"
+    perimeter_id = "invalid"
+    with pytest.raises(PolicyUnknown) as exception_info:
+        data_helper.delete_action(policy_id, perimeter_id)
+    assert str(exception_info.value) == '400: Policy Unknown'
+
+
+def test_get_objects(db):
+    subject_category_id, object_category_id, action_category_id, meta_rule_id, policy_id = mock_data.create_new_policy(
+        subject_category_name="subject_category1",
+        object_category_name="object_category1",
+        action_category_name="action_category1",
+        meta_rule_name="meta_rule_1")
+    value = {
+        "name": "test_object",
+        "description": "test",
+    }
+    data_helper.add_object(policy_id=policy_id, value=value)
+    objects = data_helper.get_objects(policy_id, )
+    assert objects
+    assert len(objects) == 1
+    object_id = list(objects.keys())[0]
+    assert objects[object_id].get('policy_list')[0] == policy_id
+
+
+def test_add_object_with_same_policy_twice(db):
+    subject_category_id, object_category_id, action_category_id, meta_rule_id, policy_id = mock_data.create_new_policy(
+        subject_category_name="subject_category1",
+        object_category_name="object_category1",
+        action_category_name="action_category1",
+        meta_rule_name="meta_rule_1")
+    value = {
+        "name": "test_object",
+        "description": "test",
+    }
+    added_object = data_helper.add_object(policy_id=policy_id, value=value)
+    assert added_object
+    object_id = list(added_object.keys())[0]
+    assert len(added_object[object_id].get('policy_list')) == 1
+
+    with pytest.raises(PolicyExisting) as exception_info:
+        data_helper.add_object(policy_id=policy_id, value=value)
+    assert str(exception_info.value) == '409: Policy Already Exists'
+
+
+def test_add_objects_multiple_times(db):
+    subject_category_id, object_category_id, action_category_id, meta_rule_id, policy_id = mock_data.create_new_policy(
+        subject_category_name="subject_category1",
+        object_category_name="object_category1",
+        action_category_name="action_category1",
+        meta_rule_name="meta_rule_1",
+        model_name="model1")
+    value = {
+        "name": "test_object",
+        "description": "test",
+    }
+    added_object = data_helper.add_object(policy_id=policy_id, value=value)
+    object_id = list(added_object.keys())[0]
+    perimeter_id = added_object[object_id].get('id')
+    assert added_object
+    value = {
+        "name": "test_object",
+        "description": "test",
+    }
+    subject_category_id, object_category_id, action_category_id, meta_rule_id, policy_id = mock_data.create_new_policy(
+        subject_category_name="subject_category2",
+        object_category_name="object_category2",
+        action_category_name="action_category2",
+        meta_rule_name="meta_rule_2",
+        model_name="model2")
+    added_object = data_helper.add_object(policy_id=policy_id, perimeter_id=perimeter_id, value=value)
+    assert added_object
+    object_id = list(added_object.keys())[0]
+    assert len(added_object[object_id].get('policy_list')) == 2
+
+
+def test_delete_object(db):
+    subject_category_id, object_category_id, action_category_id, meta_rule_id, policy_id = mock_data.create_new_policy(
+        subject_category_name="subject_category1",
+        object_category_name="object_category1",
+        action_category_name="action_category1",
+        meta_rule_name="meta_rule_1")
+    value = {
+        "name": "test_object",
+        "description": "test",
+    }
+    added_object = data_helper.add_object(policy_id=policy_id, value=value)
+    object_id = list(added_object.keys())[0]
+    data_helper.delete_object(policy_id, object_id)
+    objects = data_helper.get_objects(policy_id, )
+    assert not objects
+
+
+def test_delete_object_with_invalid_perimeter_id(db):
+    policy_id = "invalid"
+    perimeter_id = "invalid"
+    with pytest.raises(PolicyUnknown) as exception_info:
+        data_helper.delete_object(policy_id, perimeter_id)
+    assert str(exception_info.value) == '400: Policy Unknown'
+
+
+def test_get_subjects(db):
+    subject_category_id, object_category_id, action_category_id, meta_rule_id, policy_id = mock_data.create_new_policy(
+        subject_category_name="subject_category1",
+        object_category_name="object_category1",
+        action_category_name="action_category1",
+        meta_rule_name="meta_rule_1")
+    value = {
+        "name": "testuser",
+        "description": "test",
+    }
+    data_helper.add_subject(policy_id=policy_id, value=value)
+    subjects = data_helper.get_subjects(policy_id=policy_id)
+    assert subjects
+    assert len(subjects) == 1
+    subject_id = list(subjects.keys())[0]
+    assert subjects[subject_id].get('policy_list')[0] == policy_id
+
+
+def test_get_subjects_with_invalid_policy_id(db):
+    subject_category_id, object_category_id, action_category_id, meta_rule_id, policy_id = mock_data.create_new_policy(
+        subject_category_name="subject_category1",
+        object_category_name="object_category1",
+        action_category_name="action_category1",
+        meta_rule_name="meta_rule_1")
+    value = {
+        "name": "testuser",
+        "description": "test",
+    }
+    data_helper.add_subject(policy_id=policy_id, value=value)
+    with pytest.raises(PolicyUnknown) as exception_info:
+        data_helper.get_subjects(policy_id="invalid")
+    assert str(exception_info.value) == '400: Policy Unknown'
+
+
+def test_add_subject_with_same_policy_twice(db):
+    subject_category_id, object_category_id, action_category_id, meta_rule_id, policy_id = mock_data.create_new_policy(
+        subject_category_name="subject_category1",
+        object_category_name="object_category1",
+        action_category_name="action_category1",
+        meta_rule_name="meta_rule_1")
+    value = {
+        "name": "testuser",
+        "description": "test",
+    }
+    subject = data_helper.add_subject(policy_id=policy_id, value=value)
+    assert subject
+    subject_id = list(subject.keys())[0]
+    assert len(subject[subject_id].get('policy_list')) == 1
+    with pytest.raises(PolicyExisting) as exception_info:
+        data_helper.add_subject(policy_id=policy_id, value=value)
+    assert str(exception_info.value) == '409: Policy Already Exists'
+
+
+def test_add_subjects_multiple_times(db):
+    subject_category_id, object_category_id, action_category_id, meta_rule_id, policy_id = mock_data.create_new_policy(
+        subject_category_name="subject_category1",
+        object_category_name="object_category1",
+        action_category_name="action_category1",
+        meta_rule_name="meta_rule_1",
+        model_name="model1")
+    value = {
+        "name": "testuser",
+        "description": "test",
+    }
+    subject = data_helper.add_subject(policy_id=policy_id, value=value)
+    subject_id = list(subject.keys())[0]
+    perimeter_id = subject[subject_id].get('id')
+    assert subject
+    value = {
+        "name": "testuser",
+        "description": "test",
+    }
+    subject_category_id, object_category_id, action_category_id, meta_rule_id, policy_id = mock_data.create_new_policy(
+        subject_category_name="subject_category2",
+        object_category_name="object_category2",
+        action_category_name="action_category2",
+        meta_rule_name="meta_rule_2",
+        model_name="model2")
+    subject = data_helper.add_subject(policy_id=policy_id, perimeter_id=perimeter_id, value=value)
+    assert subject
+    subject_id = list(subject.keys())[0]
+    assert len(subject[subject_id].get('policy_list')) == 2
+
+
+def test_delete_subject(db):
+    subject_category_id, object_category_id, action_category_id, meta_rule_id, policy_id = mock_data.create_new_policy(
+        subject_category_name="subject_category1",
+        object_category_name="object_category1",
+        action_category_name="action_category1",
+        meta_rule_name="meta_rule_1")
+    value = {
+        "name": "testuser",
+        "description": "test",
+    }
+    subject = data_helper.add_subject(policy_id=policy_id, value=value)
+    subject_id = list(subject.keys())[0]
+    data_helper.delete_subject(policy_id, subject_id)
+    subjects = data_helper.get_subjects(policy_id, )
+    assert not subjects
+
+
+def test_delete_subject_with_invalid_perimeter_id(db):
+    policy_id = "invalid"
+    perimeter_id = "invalid"
+    with pytest.raises(PolicyUnknown) as exception_info:
+        data_helper.delete_subject(policy_id, perimeter_id)
+    assert str(exception_info.value) == '400: Policy Unknown'
+
+
+def test_delete_subject_with_assignment(db):
+
+    subject_category_id, object_category_id, action_category_id, meta_rule_id, policy_id = mock_data.create_new_policy(
+        subject_category_name="subject_category"+uuid4().hex,
+        object_category_name="object_category"+uuid4().hex,
+        action_category_name="action_category"+uuid4().hex,
+        meta_rule_name="meta_rule_"+uuid4().hex)
+
+    subject_id = mock_data.create_subject(policy_id)
+    data_id = mock_data.create_subject_data(policy_id=policy_id, category_id=subject_category_id)
+    assignment_helper.add_subject_assignment(policy_id, subject_id, subject_category_id, data_id)
+
+    with pytest.raises(DeletePerimeterWithAssignment) as exception_info:
+        data_helper.delete_subject(policy_id, subject_id)
+    assert '400: Perimeter With Assignment Error' == str(exception_info.value)
+
+
+def test_delete_object_with_assignment(db):
+    subject_category_id, object_category_id, action_category_id, meta_rule_id, policy_id = mock_data.create_new_policy(
+        subject_category_name="subject_category" + uuid4().hex,
+        object_category_name="object_category" + uuid4().hex,
+        action_category_name="action_category" + uuid4().hex,
+        meta_rule_name="meta_rule_" + uuid4().hex)
+
+    object_id = mock_data.create_object(policy_id)
+    data_id = mock_data.create_object_data(policy_id=policy_id, category_id=object_category_id)
+    assignment_helper.add_object_assignment(policy_id, object_id, object_category_id, data_id)
+
+    with pytest.raises(DeletePerimeterWithAssignment) as exception_info:
+        data_helper.delete_object(policy_id, object_id)
+    assert '400: Perimeter With Assignment Error' == str(exception_info.value)
+
+def test_delete_action_with_assignment(db):
+    subject_category_id, object_category_id, action_category_id, meta_rule_id, policy_id = mock_data.create_new_policy(
+        subject_category_name="subject_category" + uuid4().hex,
+        object_category_name="object_category" + uuid4().hex,
+        action_category_name="action_category" + uuid4().hex,
+        meta_rule_name="meta_rule_" + uuid4().hex)
+
+    action_id = mock_data.create_action(policy_id)
+    data_id = mock_data.create_action_data(policy_id=policy_id, category_id=action_category_id)
+    assignment_helper.add_action_assignment(policy_id, action_id, action_category_id, data_id)
+
+    with pytest.raises(DeletePerimeterWithAssignment) as exception_info:
+        data_helper.delete_action(policy_id, action_id)
+    assert '400: Perimeter With Assignment Error' == str(exception_info.value)
+
+
+def test_get_available_metadata(db):
+    subject_category_id, object_category_id, action_category_id, meta_rule_id, policy_id = mock_data.create_new_policy(
+        subject_category_name="subject_category1",
+        object_category_name="object_category1",
+        action_category_name="action_category1",
+        meta_rule_name="meta_rule_1")
+    metadata = data_helper.get_available_metadata(policy_id=policy_id)
+    assert metadata
+    assert metadata['object'][0] == object_category_id
+    assert metadata['subject'][0] == subject_category_id
+    assert metadata['action'][0] == action_category_id
+
+
+def test_get_available_metadata_with_invalid_policy_id(db):
+    with pytest.raises(PolicyUnknown) as exception_info:
+        data_helper.get_available_metadata(policy_id='invalid')
+    assert '400: Policy Unknown' == str(exception_info.value)
diff --git a/old/python_moondb/tests/unit_python/policies/test_policies.py b/old/python_moondb/tests/unit_python/policies/test_policies.py
new file mode 100755
index 00000000..b2394203
--- /dev/null
+++ b/old/python_moondb/tests/unit_python/policies/test_policies.py
@@ -0,0 +1,643 @@
+# Copyright 2015 Open Platform for NFV Project, Inc. and its contributors
+# This software is distributed under the terms and conditions of the 'Apache-2.0'
+# license which can be found in the file 'LICENSE' in this package distribution
+# or at 'http://www.apache.org/licenses/LICENSE-2.0'.
+
+import pytest
+import helpers.mock_data as mock_data
+import helpers.policy_helper as policy_helper
+import helpers.model_helper as model_helper
+import helpers.model_helper as model_helper
+from python_moonutilities.exceptions import *
+import helpers.pdp_helper as pdp_helper
+import helpers.data_helper as data_helper
+import helpers.assignment_helper as assignment_helper
+from uuid import uuid4
+
+
+def test_get_policies(db):
+    policies = policy_helper.get_policies()
+    assert isinstance(policies, dict)
+    assert not policies
+
+
+def test_add_policies(db):
+    model = model_helper.add_model(model_id=uuid4().hex)
+    model_id = next(iter(model))
+    value = {
+        "name": "test_policy",
+        "model_id": model_id,
+        "genre": "authz",
+        "description": "test",
+    }
+    policies = policy_helper.add_policies(value=value)
+    assert isinstance(policies, dict)
+    assert policies
+    assert len(policies.keys()) == 1
+    policy_id = list(policies.keys())[0]
+    for key in ("genre", "name", "model_id", "description"):
+        assert key in policies[policy_id]
+        assert policies[policy_id][key] == value[key]
+
+
+def test_add_policies_twice_with_same_id(db):
+    policy_id = 'policy_id_1'
+    model = model_helper.add_model(model_id=uuid4().hex)
+    model_id = next(iter(model))
+    value = {
+        "name": "test_policy",
+        "model_id": model_id,
+        "genre": "authz",
+        "description": "test",
+    }
+    policy_helper.add_policies(policy_id, value)
+    with pytest.raises(PolicyExisting) as exception_info:
+        policy_helper.add_policies(policy_id, value)
+    assert str(exception_info.value) == '409: Policy Already Exists'
+
+
+def test_add_policies_twice_with_same_name(db):
+    model = model_helper.add_model(model_id=uuid4().hex)
+    model_id = next(iter(model))
+    policy_name=uuid4().hex
+    value = {
+        "name": policy_name,
+        "model_id": model_id,
+        "genre": "authz",
+        "description": "test",
+    }
+    policy_helper.add_policies(value=value)
+    with pytest.raises(Exception) as exception_info:
+        policy_helper.add_policies(value=value)
+    assert str(exception_info.value) == '409: Policy Already Exists'
+    assert str(exception_info.value.description)== 'Policy name Existed'
+
+
+def test_delete_policies(db):
+    model = model_helper.add_model(model_id=uuid4().hex)
+    model_id = next(iter(model))
+    policy_name1 = uuid4().hex
+    value = {
+        "name": policy_name1,
+        "model_id": model_id,
+        "genre": "authz",
+        "description": "test",
+    }
+    policies = policy_helper.add_policies(value=value)
+    policy_id1 = list(policies.keys())[0]
+    policy_name2 = uuid4().hex
+    value = {
+        "name": policy_name2,
+        "model_id": model_id,
+        "genre": "authz",
+        "description": "test",
+    }
+    policies = policy_helper.add_policies(value=value)
+    policy_id2 = list(policies.keys())[0]
+    assert policy_id1 != policy_id2
+    policy_helper.delete_policies(policy_id1)
+    policies = policy_helper.get_policies()
+    assert policy_id1 not in policies
+
+
+def test_delete_policies_with_invalid_id(db):
+    policy_id = 'policy_id_1'
+    with pytest.raises(PolicyUnknown) as exception_info:
+        policy_helper.delete_policies(policy_id)
+    # assert str(exception_info.value) == '400: Policy Unknown'
+
+
+def test_update_policy(db):
+    policies = policy_helper.add_policies()
+    policy_id = list(policies.keys())[0]
+    value = {
+        "name": "test_policy4",
+        "model_id": policies[policy_id]['model_id'],
+        "genre": "authz",
+        "description": "test-3",
+    }
+    updated_policy = policy_helper.update_policy(policy_id, value)
+    assert updated_policy
+    for key in ("genre", "name", "model_id", "description"):
+        assert key in updated_policy[policy_id]
+        assert updated_policy[policy_id][key] == value[key]
+
+
+def test_update_policy_name_with_existed_one(db):
+    policies = policy_helper.add_policies()
+    policy_id1 = list(policies.keys())[0]
+    policy_name = uuid4().hex
+    value = {
+        "name": policy_name,
+        "model_id": policies[policy_id1]['model_id'],
+        "genre": "authz",
+        "description": "test-3",
+    }
+    policy_helper.add_policies(value=value)
+    with pytest.raises(PolicyExisting) as exception_info:
+        policy_helper.update_policy(policy_id=policy_id1,value=value)
+
+    assert str(exception_info.value) == '409: Policy Already Exists'
+    assert str(exception_info.value.description)== 'Policy name Existed'
+
+
+def test_update_policy_with_invalid_id(db):
+    policy_id = 'invalid-id'
+    value = {
+        "name": "test_policy4",
+        "model_id": "",
+        "genre": "authz",
+        "description": "test-3",
+    }
+    with pytest.raises(PolicyUnknown) as exception_info:
+        policy_helper.update_policy(policy_id, value)
+    assert str(exception_info.value) == '400: Policy Unknown'
+
+
+def test_get_policy_from_meta_rules(db):
+    subject_category_id, object_category_id, action_category_id, meta_rule_id, policy_id = mock_data.create_new_policy(
+        subject_category_name="subject_category1",
+        object_category_name="object_category1",
+        action_category_name="action_category1",
+        meta_rule_name="meta_rule_1",
+        model_name="model1")
+    security_pipeline = [policy_id]
+    pdp_obj = mock_data.create_pdp(security_pipeline)
+    pdp_helper.add_pdp(value=pdp_obj)
+    matched_policy_id = policy_helper.get_policy_from_meta_rules(meta_rule_id)
+    assert matched_policy_id
+    assert policy_id == matched_policy_id
+
+
+def test_get_policy_from_meta_rules_with_no_policy_ids(db):
+    meta_rule_id = 'meta_rule_id'
+    value = {
+        "name": "test_pdp",
+        "security_pipeline": [],
+        "keystone_project_id": "keystone_project_id1",
+        "description": "...",
+    }
+    pdp_helper.add_pdp(value=value)
+    matched_policy_id = policy_helper.get_policy_from_meta_rules(meta_rule_id)
+    assert not matched_policy_id
+
+
+def test_get_rules(db):
+    subject_category_id, object_category_id, action_category_id, meta_rule_id, policy_id = mock_data.create_new_policy(
+        subject_category_name="subject_category12",
+        object_category_name="object_category12",
+        action_category_name="action_category12",
+        meta_rule_name="meta_rule_12",
+        model_name="model12")
+
+    policy_helper.add_rule(policy_id=policy_id, meta_rule_id=meta_rule_id)
+
+    policy_helper.add_rule(policy_id=policy_id, meta_rule_id=meta_rule_id)
+    rules = policy_helper.get_rules(policy_id=policy_id, meta_rule_id=meta_rule_id)
+    assert isinstance(rules, dict)
+    assert rules
+    obj = rules.get('rules')
+    assert len(obj) == 2
+
+
+def test_get_rules_with_invalid_policy_id_failure(db):
+    rules = policy_helper.get_rules("invalid_policy_id", "meta_rule_id")
+    assert not rules.get('meta_rule-id')
+    assert len(rules.get('rules')) == 0
+
+
+def test_add_rule_existing(db):
+    subject_category_id, object_category_id, action_category_id, meta_rule_id, policy_id = mock_data.create_new_policy(
+        subject_category_name="subject_category1",
+        object_category_name="object_category1",
+        action_category_name="action_category1",
+        meta_rule_name="meta_rule_1",
+        model_name="model1")
+    subject_data_id = mock_data.create_subject_data(policy_id=policy_id,
+                                                    category_id=subject_category_id)
+    object_data_id = mock_data.create_object_data(policy_id=policy_id,
+                                                  category_id=object_category_id)
+    action_data_id = mock_data.create_action_data(policy_id=policy_id,
+                                                  category_id=action_category_id)
+
+    value = {
+        "rule": (subject_data_id, object_data_id, action_data_id),
+        "instructions": ({"decision": "grant"}),
+        "enabled": "",
+    }
+
+    rules = policy_helper.add_rule(policy_id=policy_id, meta_rule_id=meta_rule_id, value=value)
+    assert rules
+    assert len(rules) == 1
+    assert isinstance(rules, dict)
+    rule_id = list(rules.keys())[0]
+    for key in ("rule", "instructions", "enabled"):
+        assert key in rules[rule_id]
+        assert rules[rule_id][key] == value[key]
+
+    with pytest.raises(RuleExisting) as exception_info:
+        policy_helper.add_rule(policy_id=policy_id, meta_rule_id=meta_rule_id, value=value)
+    assert str(exception_info.value) == '409: Rule Existing'
+
+
+def test_check_existing_rule_valid_request(db):
+    subject_category_id, object_category_id, action_category_id, meta_rule_id, policy_id = mock_data.create_new_policy(
+        subject_category_name="subject_category1",
+        object_category_name="object_category1",
+        action_category_name="action_category1",
+        meta_rule_name="meta_rule_1",
+        model_name="model1")
+    subject_data_id = mock_data.create_subject_data(policy_id=policy_id,
+                                                    category_id=subject_category_id)
+    object_data_id = mock_data.create_object_data(policy_id=policy_id,
+                                                  category_id=object_category_id)
+    action_data_id = mock_data.create_action_data(policy_id=policy_id,
+                                                  category_id=action_category_id)
+    value = {
+        "rule": (subject_data_id, object_data_id, action_data_id),
+        "instructions": ({"decision": "grant"}),
+        "enabled": "",
+    }
+
+    rules = policy_helper.add_rule(policy_id=policy_id, meta_rule_id=meta_rule_id, value=value)
+    assert rules
+    assert len(rules) == 1
+    assert isinstance(rules, dict)
+    rule_id = list(rules.keys())[0]
+    for key in ("rule", "instructions", "enabled"):
+        assert key in rules[rule_id]
+        assert rules[rule_id][key] == value[key]
+
+    with pytest.raises(RuleExisting) as exception_info:
+        policy_helper.add_rule(policy_id=policy_id, meta_rule_id=meta_rule_id, value=value)
+    assert str(exception_info.value) == '409: Rule Existing'
+
+
+def test_check_existing_rule_valid_multiple__data(db):
+    subject_category_id, object_category_id, action_category_id, meta_rule_id, policy_id = mock_data.create_new_policy(
+        subject_category_name="subject_category1",
+        object_category_name="object_category1",
+        action_category_name="action_category1",
+        meta_rule_name="meta_rule_1",
+        model_name="model1")
+    subject_data_id1 = mock_data.create_subject_data(policy_id=policy_id,
+                                                     category_id=subject_category_id)
+    subject_data_id2 = mock_data.create_subject_data(policy_id=policy_id,
+                                                     category_id=subject_category_id)
+    object_data_id1 = mock_data.create_object_data(policy_id=policy_id,
+                                                   category_id=object_category_id)
+    object_data_id2 = mock_data.create_object_data(policy_id=policy_id,
+                                                   category_id=object_category_id)
+    action_data_id1 = mock_data.create_action_data(policy_id=policy_id,
+                                                   category_id=action_category_id)
+    action_data_id2 = mock_data.create_action_data(policy_id=policy_id,
+                                                   category_id=action_category_id)
+    value = {
+        "rule": (
+            subject_data_id1, object_data_id2, action_data_id1),
+        "instructions": ({"decision": "grant"}),
+        "enabled": "",
+    }
+
+    rules = policy_helper.add_rule(policy_id=policy_id, meta_rule_id=meta_rule_id, value=value)
+    assert rules
+    assert len(rules) == 1
+    assert isinstance(rules, dict)
+    rule_id = list(rules.keys())[0]
+    for key in ("rule", "instructions", "enabled"):
+        assert key in rules[rule_id]
+        assert rules[rule_id][key] == value[key]
+
+    with pytest.raises(RuleExisting) as exception_info:
+        policy_helper.add_rule(policy_id=policy_id, meta_rule_id=meta_rule_id, value=value)
+    assert str(exception_info.value) == '409: Rule Existing'
+
+
+def test_check_existing_rule_missing_data(db):
+    subject_category_id, object_category_id, action_category_id, meta_rule_id, policy_id = mock_data.create_new_policy(
+        subject_category_name="subject_category1",
+        object_category_name="object_category1",
+        action_category_name="action_category1",
+        meta_rule_name="meta_rule_1",
+        model_name="model1")
+    subject_data_id = mock_data.create_subject_data(policy_id=policy_id,
+                                                    category_id=subject_category_id)
+    object_data_id = mock_data.create_object_data(policy_id=policy_id,
+                                                  category_id=object_category_id)
+    action_data_id = mock_data.create_action_data(policy_id=policy_id,
+                                                  category_id=action_category_id)
+    value = {
+        "rule": (object_data_id, action_data_id),
+        "instructions": ({"decision": "grant"}),
+        "enabled": "",
+    }
+
+    with pytest.raises(RuleContentError) as exception_info:
+        policy_helper.add_rule(policy_id=policy_id, meta_rule_id=meta_rule_id, value=value)
+    assert str(exception_info.value) == '400: Rule Error'
+    assert exception_info.value.description== "Missing Data"
+
+
+def test_check_existing_rule_meta_rule_missing_data(db):
+    subject_category_id, object_category_id, action_category_id, meta_rule_id, policy_id = mock_data.create_new_policy(
+        subject_category_name="subject_category1",
+        object_category_name="object_category1",
+        action_category_name="action_category1",
+        meta_rule_name="meta_rule_1",
+        model_name="model1")
+    subject_data_id = mock_data.create_subject_data(policy_id=policy_id,
+                                                    category_id=subject_category_id)
+    object_data_id = mock_data.create_object_data(policy_id=policy_id,
+                                                  category_id=object_category_id)
+    action_data_id = mock_data.create_action_data(policy_id=policy_id,
+                                                  category_id=action_category_id)
+    value = {
+        "rule": (subject_data_id, object_data_id, action_data_id, action_data_id),
+        "instructions": ({"decision": "grant"}),
+        "enabled": "",
+    }
+
+    with pytest.raises(MetaRuleContentError) as exception_info:
+        policy_helper.add_rule(policy_id=policy_id, meta_rule_id=meta_rule_id, value=value)
+    assert str(exception_info.value) == '400: Meta Rule Error'
+    assert exception_info.value.description == "Missing Data"
+
+
+def test_check_existing_rule_invalid_data_id_order(db):
+    subject_category_id, object_category_id, action_category_id, meta_rule_id, policy_id = mock_data.create_new_policy(
+        subject_category_name="subject_category1",
+        object_category_name="object_category1",
+        action_category_name="action_category1",
+        meta_rule_name="meta_rule_1",
+        model_name="model1")
+    subject_data_id = mock_data.create_subject_data(policy_id=policy_id,
+                                                    category_id=subject_category_id)
+    object_data_id = mock_data.create_object_data(policy_id=policy_id,
+                                                  category_id=object_category_id)
+    action_data_id = mock_data.create_action_data(policy_id=policy_id,
+                                                  category_id=action_category_id)
+    value = {
+        "rule": (object_data_id, action_data_id, subject_data_id),
+        "instructions": ({"decision": "grant"}),
+        "enabled": "",
+    }
+
+    with pytest.raises(RuleContentError) as exception_info:
+        policy_helper.add_rule(policy_id=policy_id, meta_rule_id=meta_rule_id, value=value)
+    assert str(exception_info.value) == '400: Rule Error'
+    assert "Missing Subject_category" in exception_info.value.description
+
+
+def test_check_existing_rule_invalid_data_id_order_scenrio_2(db):
+    subject_category_id, object_category_id, action_category_id, meta_rule_id, policy_id = mock_data.create_new_policy(
+        subject_category_name="subject_category1",
+        object_category_name="object_category1",
+        action_category_name="action_category1",
+        meta_rule_name="meta_rule_1",
+        model_name="model1")
+    subject_data_id = mock_data.create_subject_data(policy_id=policy_id,
+                                                    category_id=subject_category_id)
+    object_data_id = mock_data.create_object_data(policy_id=policy_id,
+                                                  category_id=object_category_id)
+    action_data_id = mock_data.create_action_data(policy_id=policy_id,
+                                                  category_id=action_category_id)
+    value = {
+        "rule": (subject_data_id, action_data_id, object_data_id),
+        "instructions": ({"decision": "grant"}),
+        "enabled": "",
+    }
+
+    with pytest.raises(RuleContentError) as exception_info:
+        policy_helper.add_rule(policy_id=policy_id, meta_rule_id=meta_rule_id, value=value)
+    assert str(exception_info.value) == '400: Rule Error'
+    assert "Missing Object_category" in exception_info.value.description
+
+
+def test_check_existing_rule_wrong_subject_data_id(db):
+    subject_category_id, object_category_id, action_category_id, meta_rule_id, policy_id = mock_data.create_new_policy(
+        subject_category_name="subject_category1",
+        object_category_name="object_category1",
+        action_category_name="action_category1",
+        meta_rule_name="meta_rule_1",
+        model_name="model1")
+    subject_data_id = mock_data.create_subject_data(policy_id=policy_id,
+                                                    category_id=subject_category_id)
+    object_data_id = mock_data.create_object_data(policy_id=policy_id,
+                                                  category_id=object_category_id)
+    action_data_id = mock_data.create_action_data(policy_id=policy_id,
+                                                  category_id=action_category_id)
+    value = {
+        "rule": (uuid4().hex, object_data_id, action_data_id),
+        "instructions": ({"decision": "grant"}),
+        "enabled": "",
+    }
+
+    with pytest.raises(RuleContentError) as exception_info:
+        policy_helper.add_rule(policy_id=policy_id, meta_rule_id=meta_rule_id, value=value)
+    assert str(exception_info.value) == '400: Rule Error'
+    assert "Missing Subject_category" in exception_info.value.description
+
+
+def test_check_existing_rule_wrong_object_data_id(db):
+    subject_category_id, object_category_id, action_category_id, meta_rule_id, policy_id = mock_data.create_new_policy(
+        subject_category_name="subject_category1",
+        object_category_name="object_category1",
+        action_category_name="action_category1",
+        meta_rule_name="meta_rule_1",
+        model_name="model1")
+    subject_data_id = mock_data.create_subject_data(policy_id=policy_id,
+                                                    category_id=subject_category_id)
+    object_data_id = mock_data.create_object_data(policy_id=policy_id,
+                                                  category_id=object_category_id)
+    action_data_id = mock_data.create_action_data(policy_id=policy_id,
+                                                  category_id=action_category_id)
+    value = {
+        "rule": (subject_data_id, uuid4().hex, action_data_id),
+        "instructions": ({"decision": "grant"}),
+        "enabled": "",
+    }
+
+    with pytest.raises(RuleContentError) as exception_info:
+        policy_helper.add_rule(policy_id=policy_id, meta_rule_id=meta_rule_id, value=value)
+    assert str(exception_info.value) == '400: Rule Error'
+    assert "Missing Object_category" in exception_info.value.description
+
+
+def test_check_existing_rule_wrong_action_data_id(db):
+    subject_category_id, object_category_id, action_category_id, meta_rule_id, policy_id = mock_data.create_new_policy(
+        subject_category_name="subject_category1",
+        object_category_name="object_category1",
+        action_category_name="action_category1",
+        meta_rule_name="meta_rule_1",
+        model_name="model1")
+    subject_data_id = mock_data.create_subject_data(policy_id=policy_id,
+                                                    category_id=subject_category_id)
+    object_data_id = mock_data.create_object_data(policy_id=policy_id,
+                                                  category_id=object_category_id)
+    action_data_id = mock_data.create_action_data(policy_id=policy_id,
+                                                  category_id=action_category_id)
+    value = {
+        "rule": (subject_data_id, object_data_id, uuid4().hex),
+        "instructions": ({"decision": "grant"}),
+        "enabled": "",
+    }
+
+    with pytest.raises(RuleContentError) as exception_info:
+        policy_helper.add_rule(policy_id=policy_id, meta_rule_id=meta_rule_id, value=value)
+    assert str(exception_info.value) == '400: Rule Error'
+    assert "Missing Action_category" in exception_info.value.description
+
+
+def test_delete_rule(db):
+    subject_category_id, object_category_id, action_category_id, meta_rule_id, policy_id = mock_data.create_new_policy()
+
+    rules = policy_helper.add_rule(policy_id, meta_rule_id)
+    rule_id = list(rules.keys())[0]
+    policy_helper.delete_rule(policy_id, rule_id)
+    rules = policy_helper.get_rules(policy_id, meta_rule_id)
+    assert not rules.get('rules')
+
+
+def test_delete_policies_with_pdp(db):
+    policies = policy_helper.add_policies()
+    policy_id1 = list(policies.keys())[0]
+    pdp_id = "pdp_id1"
+    value = {
+        "name": "test_pdp",
+        "security_pipeline": [policy_id1],
+        "keystone_project_id": "keystone_project_id1",
+        "description": "...",
+    }
+    pdp_helper.add_pdp(pdp_id=pdp_id, value=value)
+    with pytest.raises(DeletePolicyWithPdp) as exception_info:
+        policy_helper.delete_policies(policy_id1)
+    assert str(exception_info.value) == '400: Policy With PDP Error'
+    assert 'Cannot delete policy with pdp' == exception_info.value.description
+
+
+def test_delete_policies_with_subject_perimeter(db):
+    policies = policy_helper.add_policies()
+    policy_id1 = list(policies.keys())[0]
+
+    value = {
+        "name": "testuser",
+        "security_pipeline": [policy_id1],
+        "keystone_project_id": "keystone_project_id1",
+        "description": "...",
+    }
+    data_helper.add_subject(policy_id=policy_id1, value=value)
+    with pytest.raises(DeletePolicyWithPerimeter) as exception_info:
+        policy_helper.delete_policies(policy_id1)
+    assert str(exception_info.value) == '400: Policy With Perimeter Error'
+    assert 'Cannot delete policy with perimeter'== exception_info.value.description
+
+
+def test_delete_policies_with_object_perimeter(db):
+    policies = policy_helper.add_policies()
+    policy_id1 = list(policies.keys())[0]
+
+    value = {
+        "name": "test_obj",
+        "security_pipeline": [policy_id1],
+        "keystone_project_id": "keystone_project_id1",
+        "description": "...",
+    }
+    data_helper.add_object(policy_id=policy_id1, value=value)
+    with pytest.raises(DeletePolicyWithPerimeter) as exception_info:
+        policy_helper.delete_policies(policy_id1)
+    assert str(exception_info.value) == '400: Policy With Perimeter Error'
+    assert 'Cannot delete policy with perimeter'== exception_info.value.description
+
+
+def test_delete_policies_with_action_perimeter(db):
+    policies = policy_helper.add_policies()
+    policy_id1 = list(policies.keys())[0]
+
+    value = {
+        "name": "test_act",
+        "security_pipeline": [policy_id1],
+        "keystone_project_id": "keystone_project_id1",
+        "description": "...",
+    }
+    data_helper.add_action(policy_id=policy_id1, value=value)
+    with pytest.raises(DeletePolicyWithPerimeter) as exception_info:
+        policy_helper.delete_policies(policy_id1)
+    assert '400: Policy With Perimeter Error' == str(exception_info.value)
+
+
+def test_delete_policies_with_subject_assignment(db):
+    subject_category_id, object_category_id, action_category_id, meta_rule_id, policy_id = mock_data.create_new_policy()
+
+    subject_id = mock_data.create_subject(policy_id)
+    data_id = mock_data.create_subject_data(policy_id=policy_id, category_id=subject_category_id)
+    assignment_helper.add_subject_assignment(policy_id, subject_id, subject_category_id, data_id)
+
+    with pytest.raises(DeletePolicyWithPerimeter) as exception_info:
+        policy_helper.delete_policies(policy_id)
+
+    assert '400: Policy With Perimeter Error' == str(exception_info.value)
+
+
+def test_delete_policies_with_object_assignment(db):
+    subject_category_id, object_category_id, action_category_id, meta_rule_id, policy_id = mock_data.create_new_policy()
+
+    object_id = mock_data.create_object(policy_id)
+    data_id = mock_data.create_object_data(policy_id=policy_id, category_id=object_category_id)
+    assignment_helper.add_object_assignment(policy_id, object_id, object_category_id, data_id)
+
+    with pytest.raises(DeletePolicyWithPerimeter) as exception_info:
+        policy_helper.delete_policies(policy_id)
+    assert '400: Policy With Perimeter Error' == str(exception_info.value)
+
+
+def test_delete_policies_with_action_assignment(db):
+    subject_category_id, object_category_id, action_category_id, meta_rule_id, policy_id = mock_data.create_new_policy()
+
+    action_id = mock_data.create_action(policy_id)
+    data_id = mock_data.create_action_data(policy_id=policy_id, category_id=action_category_id)
+    assignment_helper.add_action_assignment(policy_id, action_id, action_category_id, data_id)
+
+    with pytest.raises(DeletePolicyWithPerimeter) as exception_info:
+        policy_helper.delete_policies(policy_id)
+    assert '400: Policy With Perimeter Error' == str(exception_info.value)
+
+
+def test_delete_policies_with_subject_data(db):
+    subject_category_id, object_category_id, action_category_id, meta_rule_id, policy_id = mock_data.create_new_policy()
+
+    data_id = mock_data.create_subject_data(policy_id=policy_id, category_id=subject_category_id)
+
+    with pytest.raises(DeletePolicyWithData) as exception_info:
+        policy_helper.delete_policies(policy_id)
+
+    assert '400: Policy With Data Error' == str(exception_info.value)
+
+
+def test_delete_policies_with_object_data(db):
+    subject_category_id, object_category_id, action_category_id, meta_rule_id, policy_id = mock_data.create_new_policy()
+
+    data_id = mock_data.create_object_data(policy_id=policy_id, category_id=object_category_id)
+
+    with pytest.raises(DeletePolicyWithData) as exception_info:
+        policy_helper.delete_policies(policy_id)
+    assert '400: Policy With Data Error' == str(exception_info.value)
+
+
+def test_delete_policies_with_action_data(db):
+    subject_category_id, object_category_id, action_category_id, meta_rule_id, policy_id = mock_data.create_new_policy()
+
+    data_id = mock_data.create_action_data(policy_id=policy_id, category_id=action_category_id)
+
+    with pytest.raises(DeletePolicyWithData) as exception_info:
+        policy_helper.delete_policies(policy_id)
+    assert '400: Policy With Data Error' == str(exception_info.value)
+
+
+def test_delete_policies_with_rule(db):
+    subject_category_id, object_category_id, action_category_id, meta_rule_id, policy_id = mock_data.create_new_policy()
+
+    rules = policy_helper.add_rule(policy_id, meta_rule_id)
+
+    with pytest.raises(DeletePolicyWithRules) as exception_info:
+        policy_helper.delete_policies(policy_id)
+    assert '400: Policy With Rule Error' == str(exception_info.value)