report.py
62 lines
| 2.4 KiB
| text/x-python
|
PythonLexer
r0 | # -*- 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 | ||||