# keystone.policy.backends.sql

# Source code for keystone.policy.backends.sql

    # Copyright 2012 OpenStack Foundation
    #
    # Licensed under the Apache License, Version 2.0 (the "License"); you may
    # not use this file except in compliance with the License. You may obtain
    # a copy of the License at
    #
    #      http://www.apache.org/licenses/LICENSE-2.0
    #
    # Unless required by applicable law or agreed to in writing, software
    # distributed under the License is distributed on an "AS IS" BASIS, WITHOUT
    # WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the
    # License for the specific language governing permissions and limitations
    # under the License.

    from keystone.common import sql
    from keystone import exception
    from keystone.policy.backends import rules

    class PolicyModel(sql.ModelBase, sql.ModelDictMixinWithExtras):
        __tablename__ = 'policy'
        attributes = ['id', 'blob', 'type']
        id = sql.Column(sql.String(64), primary_key=True)
        blob = sql.Column(sql.JsonBlob(), nullable=False)
        type = sql.Column(sql.String(255), nullable=False)
        extra = sql.Column(sql.JsonBlob())

    class Policy(rules.Policy):

        @sql.handle_conflicts(conflict_type='policy')
        def create_policy(self, policy_id, policy):
            with sql.session_for_write() as session:
                ref = PolicyModel.from_dict(policy)
                session.add(ref)

                return ref.to_dict()

        def list_policies(self):
            with sql.session_for_read() as session:
                refs = session.query(PolicyModel).all()
                return [ref.to_dict() for ref in refs]

        def _get_policy(self, session, policy_id):
            """Private method to get a policy model object (NOT a dictionary)."""
            ref = session.get(PolicyModel, policy_id)
            if not ref:
                raise exception.PolicyNotFound(policy_id=policy_id)
            return ref

        def get_policy(self, policy_id):
            with sql.session_for_read() as session:
                return self._get_policy(session, policy_id).to_dict()

        @sql.handle_conflicts(conflict_type='policy')
        def update_policy(self, policy_id, policy):
            with sql.session_for_write() as session:
                ref = self._get_policy(session, policy_id)
                old_dict = ref.to_dict()
                old_dict.update(policy)
                new_policy = PolicyModel.from_dict(old_dict)
                ref.blob = new_policy.blob
                ref.type = new_policy.type
                ref.extra = new_policy.extra

            return ref.to_dict()

        def delete_policy(self, policy_id):
            with sql.session_for_write() as session:
                ref = self._get_policy(session, policy_id)
                session.delete(ref)

this page last updated: 2026-06-11 21:50:20

Except where otherwise noted, this document is licensed under Creative Commons Attribution 3.0 License. See all OpenStack Legal Documents.

found an error? report a bug