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 peewee
import CharField
, TextField
, FloatField
, Model
28 from playhouse
.db_url
import connect
30 from osm_mon
.core
.settings
import Config
32 log
= logging
.getLogger(__name__
)
33 cfg
= Config
.instance()
36 db
= connect(cfg
.DATABASE
)
39 class BaseModel(Model
):
45 class VimCredentials(BaseModel
):
46 uuid
= CharField(unique
=True)
51 password
= CharField()
52 tenant_name
= CharField()
53 config
= TextField(default
='{}')
56 class Alarm(BaseModel
):
58 severity
= CharField()
59 threshold
= FloatField()
60 operation
= CharField()
61 statistic
= CharField()
62 monitoring_param
= CharField()
63 vdur_name
= CharField()
64 vnf_member_index
= CharField()
68 class DatabaseManager
:
69 def create_tables(self
) -> None:
72 db
.create_tables([VimCredentials
, Alarm
])
75 log
.exception("Error creating tables: ")
77 def get_credentials(self
, vim_uuid
) -> VimCredentials
:
78 return VimCredentials
.get_or_none(VimCredentials
.uuid
== vim_uuid
)
80 def save_credentials(self
, vim_credentials
) -> VimCredentials
:
81 """Saves vim credentials. If a record with same uuid exists, overwrite it."""
82 exists
= VimCredentials
.get_or_none(VimCredentials
.uuid
== vim_credentials
.uuid
)
84 vim_credentials
.uuid
= exists
.uuid
85 vim_credentials
.save()
86 return vim_credentials
88 def get_alarm(self
, alarm_id
) -> Alarm
:
89 alarm
= (Alarm
.select()
90 .where(Alarm
.alarm_id
== alarm_id
)
94 def save_alarm(self
, name
, threshold
, operation
, severity
, statistic
, metric_name
, vdur_name
,
95 vnf_member_index
, nsr_id
) -> Alarm
:
99 alarm
.threshold
= threshold
100 alarm
.operation
= operation
101 alarm
.severity
= severity
102 alarm
.statistic
= statistic
103 alarm
.monitoring_param
= metric_name
104 alarm
.vdur_name
= vdur_name
105 alarm
.vnf_member_index
= vnf_member_index
106 alarm
.nsr_id
= nsr_id
110 def delete_alarm(self
, alarm_id
) -> None:
111 alarm
= (Alarm
.select()
112 .where(Alarm
.alarm_id
== alarm_id
)
116 def get_vim_type(self
, vim_account_id
) -> str:
117 """Get the vim type that is required by the message."""
118 credentials
= self
.get_credentials(vim_account_id
)
119 return str(credentials
.type)