eca08e9c8df63bd26baa7e170fab422d0ce2188a
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
28 from peewee
import CharField
, TextField
, FloatField
, Model
, AutoField
, Proxy
29 from playhouse
.db_url
import connect
31 from osm_mon
.core
.config
import Config
33 log
= logging
.getLogger(__name__
)
38 class BaseModel(Model
):
39 id = AutoField(primary_key
=True)
45 class VimCredentials(BaseModel
):
46 uuid
= CharField(unique
=True)
51 password
= CharField()
52 tenant_name
= CharField()
53 config
= TextField(default
='{}')
56 class Alarm(BaseModel
):
57 uuid
= CharField(unique
=True)
59 severity
= CharField()
60 threshold
= FloatField()
61 operation
= CharField()
62 statistic
= CharField()
63 monitoring_param
= CharField()
64 vdur_name
= CharField()
65 vnf_member_index
= CharField()
69 class DatabaseManager
:
70 def __init__(self
, config
: Config
):
71 db
.initialize(connect(config
.get('sql', 'database_uri')))
73 def create_tables(self
) -> None:
75 db
.create_tables([VimCredentials
, Alarm
])
77 def get_credentials(self
, vim_uuid
: str = None) -> VimCredentials
:
79 return VimCredentials
.get_or_none(VimCredentials
.uuid
== vim_uuid
)
81 def save_credentials(self
, vim_credentials
) -> VimCredentials
:
82 """Saves vim credentials. If a record with same uuid exists, overwrite it."""
84 exists
= VimCredentials
.get_or_none(VimCredentials
.uuid
== vim_credentials
.uuid
)
86 vim_credentials
.id = exists
.id
87 vim_credentials
.save()
88 return vim_credentials
90 def get_alarm(self
, alarm_id
) -> Alarm
:
92 alarm
= (Alarm
.select()
93 .where(Alarm
.alarm_id
== alarm_id
)
97 def save_alarm(self
, name
, threshold
, operation
, severity
, statistic
, metric_name
, vdur_name
,
98 vnf_member_index
, nsr_id
) -> Alarm
:
100 # TODO: Add uuid optional param and check if exists to handle updates (see self.save_credentials)
103 alarm
.uuid
= str(uuid
.uuid4())
105 alarm
.threshold
= threshold
106 alarm
.operation
= operation
107 alarm
.severity
= severity
108 alarm
.statistic
= statistic
109 alarm
.monitoring_param
= metric_name
110 alarm
.vdur_name
= vdur_name
111 alarm
.vnf_member_index
= vnf_member_index
112 alarm
.nsr_id
= nsr_id
116 def delete_alarm(self
, alarm_uuid
) -> None:
118 alarm
= (Alarm
.select()
119 .where(Alarm
.uuid
== alarm_uuid
)
121 alarm
.delete_instance()
123 def get_vim_type(self
, vim_account_id
) -> str:
124 """Get the vim type that is required by the message."""
125 credentials
= self
.get_credentials(vim_account_id
)
126 return str(credentials
.type)