# -*- cpy-indent-level: 4; indent-tabs-mode: nil -*-
# ex: set expandtab softtabstop=4 shiftwidth=4:
#
# Copyright (C) 2008,2009,2010,2011,2012,2013,2015  Contributor
#
# 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 sqlalchemy.orm import undefer, joinedload

from aquilon.worker.broker import BrokerCommand  # pylint: disable=W0611
from aquilon.aqdb.model import Feature


class CommandShowFeature(BrokerCommand):

    required_parameters = ['feature', 'type']

    def render(self, session, feature, type, **arguments):
        cls = Feature.polymorphic_subclass(type, "Unknown feature type")
        options = [undefer('comments'),
                   joinedload('owner_grn')]
        return cls.get_unique(session, name=feature, compel=True,
                              query_options=options)

# -*- cpy-indent-level: 4; indent-tabs-mode: nil -*-
# ex: set expandtab softtabstop=4 shiftwidth=4:
#
# Copyright (C) 2008,2009,2010,2011,2012,2013,2015  Contributor
#
# 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 sqlalchemy.orm import undefer, joinedload, subqueryload

from aquilon.worker.broker import BrokerCommand  # pylint: disable=W0611
from aquilon.aqdb.model import Feature


class CommandShowFeature(BrokerCommand):

    required_parameters = ['feature', 'type']

    def render(self, session, feature, type, **arguments):
        cls = Feature.polymorphic_subclass(type, "Unknown feature type")
        options = [undefer('comments'),
                   joinedload('owner_grn'),
                   subqueryload('links'),
                   joinedload('links.personality_stage'),
                   joinedload('links.personality_stage.personality'),
                   joinedload('links.model')]
        return cls.get_unique(session, name=feature, compel=True,
                              query_options=options)

Speed up show_feature for heavily used features