1 # -*- coding: utf-8 -*-
3 # Copyright 2018 Whitestack, LLC
4 # *************************************************************
6 # This file is part of OSM Monitoring module
7 # All Rights Reserved to Whitestack, LLC
9 # Licensed under the Apache License, Version 2.0 (the "License"); you may
10 # not use this file except in compliance with the License. You may obtain
11 # a copy of the License at
13 # http://www.apache.org/licenses/LICENSE-2.0
15 # Unless required by applicable law or agreed to in writing, software
16 # distributed under the License is distributed on an "AS IS" BASIS, WITHOUT
17 # WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the
18 # License for the specific language governing permissions and limitations
21 # For those usages not covered by the Apache License, Version 2.0 please
22 # contact: bdiaz@whitestack.com or glavado@whitestack.com
27 from typing
import Iterable
29 from peewee
import CharField
, FloatField
, Model
, AutoField
, Proxy
, ForeignKeyField
30 from peewee_migrate
import Router
31 from playhouse
.db_url
import connect
33 from osm_mon
import migrations
34 from osm_mon
.core
.config
import Config
36 log
= logging
.getLogger(__name__
)
41 class BaseModel(Model
):
42 id = AutoField(primary_key
=True)
48 class Alarm(BaseModel
):
49 uuid
= CharField(unique
=True)
51 severity
= CharField()
52 threshold
= FloatField()
53 operation
= CharField()
54 statistic
= CharField()
58 class AlarmTag(BaseModel
):
61 alarm
= ForeignKeyField(Alarm
, related_name
='tags', on_delete
='CASCADE')
64 class DatabaseManager
:
65 def __init__(self
, config
: Config
):
66 db
.initialize(connect(config
.get('sql', 'database_uri')))
68 def create_tables(self
) -> None:
71 router
= Router(db
, os
.path
.dirname(migrations
.__file
__))
76 class AlarmTagRepository
:
78 def create(**query
) -> Alarm
:
79 return AlarmTag
.create(**query
)
82 class AlarmRepository
:
84 def create(**query
) -> Alarm
:
85 return Alarm
.create(**query
)
88 def get(*expressions
) -> Alarm
:
89 return Alarm
.select().where(*expressions
).get()
92 def list(*expressions
) -> Iterable
[Alarm
]:
96 return Alarm
.select().where(*expressions
)