# -*- coding: utf-8 -*-

# Copyright (C) 2010-2016  RhodeCode GmbH
#
# This program is free software: you can redistribute it and/or modify
# it under the terms of the GNU Affero General Public License, version 3
# (only), as published by the Free Software Foundation.
#
# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
# GNU General Public License for more details.
#
# You should have received a copy of the GNU Affero General Public License
# along with this program.  If not, see <http://www.gnu.org/licenses/>.
#
# This program is dual-licensed. If you wish to learn more about the
# App Enlight Enterprise Edition, including its added features, Support
# services, and proprietary license terms, please see
# https://rhodecode.com/licenses/

import logging
import sqlalchemy as sa

from appenlight.models import get_db_session
from appenlight.models.report import Report
from appenlight.models.report_stat import ReportStat
from appenlight.models.services.base import BaseService

log = logging.getLogger(__name__)


class ReportService(BaseService):
    @classmethod
    def by_app_ids(cls, app_ids=None, order_by=True, db_session=None):
        db_session = get_db_session(db_session)
        q = db_session.query(Report)
        if app_ids:
            q = q.filter(Report.resource_id.in_(app_ids))
        if order_by:
            q = q.order_by(sa.desc(Report.id))
        return q

    @classmethod
    def generate_stat_rows(cls, report, resource, report_group, occurences=1,
                           db_session=None):
        """
        Generates timeseries for this report's group
        """
        db_session = get_db_session(db_session)
        stats = ReportStat(resource_id=report.resource_id,
                           group_id=report_group.id,
                           start_interval=report.start_time,
                           owner_user_id=resource.owner_user_id,
                           server_name=report.tags.get('server_name'),
                           view_name=report.tags.get('view_name'),
                           type=report.report_type,
                           occurences=occurences,
                           duration=report.duration)
        db_session.add(stats)
        db_session.flush()
        return stats