osm_mon/core/database.py

   1 # -*- coding: utf-8 -*-
   2
   3 # Copyright 2018 Whitestack, LLC
   4 # *************************************************************
   5
   6 # This file is part of OSM Monitoring module
   7 # All Rights Reserved to Whitestack, LLC
   8
   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
  12
  13 #         http://www.apache.org/licenses/LICENSE-2.0
  14
  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
  19 # under the License.
  20
  21 # For those usages not covered by the Apache License, Version 2.0 please
  22 # contact: bdiaz@whitestack.com or glavado@whitestack.com
  23 ##
  24
  25 import logging
  26
  27 from peewee import *
  28 from playhouse.sqlite_ext import SqliteExtDatabase
  29
  30 from osm_mon.plugins.OpenStack.settings import Config
  31
  32 log = logging.getLogger(__name__)
  33 cfg = Config.instance()
  34
  35 db = SqliteExtDatabase('mon.db')
  36
  37
  38 class BaseModel(Model):
  39     class Meta:
  40         database = db
  41
  42
  43 class VimCredentials(BaseModel):
  44     uuid = CharField(unique=True)
  45     name = CharField()
  46     type = CharField()
  47     url = CharField()
  48     user = CharField()
  49     password = CharField()
  50     tenant_name = CharField()
  51     config = TextField()
  52     region_name = CharField()
  53     endpoint_type = CharField()
  54
  55 class Alarm(BaseModel):
  56     alarm_id = CharField()
  57     credentials = ForeignKeyField(VimCredentials, backref='alarms')
  58
  59
  60 class DatabaseManager:
  61     def create_tables(self):
  62         try:
  63             db.connect()
  64             db.create_tables([VimCredentials, Alarm])
  65             db.close()
  66         except Exception as e:
  67             log.exception("Error creating tables: ")
  68
  69     def get_credentials(self, vim_uuid):
  70         return VimCredentials.get_or_none(VimCredentials.uuid == vim_uuid)
  71
  72     def save_credentials(self, vim_credentials):
  73         """Saves vim credentials. If a record with same uuid exists, overwrite it."""
  74         exists = VimCredentials.get_or_none(VimCredentials.uuid == vim_credentials.uuid)
  75         if exists:
  76             vim_credentials.id = exists.id
  77         vim_credentials.save()
  78
  79     def get_credentials_for_alarm_id(self, alarm_id, vim_type):
  80         alarm = Alarm.select() \
  81             .where(Alarm.alarm_id == alarm_id) \
  82             .join(VimCredentials) \
  83             .where(VimCredentials.type == vim_type).get()
  84         return alarm.credentials
  85
  86     def save_alarm(self, alarm_id, vim_uuid):
  87         """Saves alarm. If a record with same id and vim_uuid exists, overwrite it."""
  88         alarm = Alarm()
  89         alarm.alarm_id = alarm_id
  90         creds = VimCredentials.get(VimCredentials.uuid == vim_uuid)
  91         alarm.credentials = creds
  92         exists = Alarm.select(Alarm.alarm_id == alarm.alarm_id) \
  93             .join(VimCredentials) \
  94             .where(VimCredentials.uuid == vim_uuid)
  95         if len(exists):
  96             alarm.id = exists[0].id
  97         alarm.save()