osm_policy_module/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 import logging
  25
  26 from peewee import CharField, IntegerField, ForeignKeyField, Model, TextField, AutoField
  27 from playhouse.sqlite_ext import SqliteExtDatabase
  28
  29 from osm_policy_module.core.config import Config
  30
  31 log = logging.getLogger(__name__)
  32 cfg = Config.instance()
  33
  34 db = SqliteExtDatabase('policy_module.db')
  35
  36
  37 class BaseModel(Model):
  38     id = AutoField(primary_key=True)
  39
  40     class Meta:
  41         database = db
  42
  43
  44 class ScalingGroup(BaseModel):
  45     nsr_id = CharField()
  46     name = CharField()
  47     content = TextField()
  48
  49
  50 class ScalingPolicy(BaseModel):
  51     name = CharField()
  52     scaling_group = ForeignKeyField(ScalingGroup, related_name='scaling_policies')
  53
  54
  55 class ScalingCriteria(BaseModel):
  56     name = CharField()
  57     scaling_policy = ForeignKeyField(ScalingPolicy, related_name='scaling_criterias')
  58
  59
  60 class ScalingAlarm(BaseModel):
  61     alarm_id = CharField()
  62     action = CharField()
  63     vnf_member_index = IntegerField()
  64     vdu_name = CharField()
  65     scaling_criteria = ForeignKeyField(ScalingCriteria, related_name='scaling_alarms')
  66
  67
  68 class DatabaseManager:
  69     def create_tables(self):
  70         try:
  71             db.connect()
  72             db.create_tables([ScalingGroup, ScalingPolicy, ScalingCriteria, ScalingAlarm])
  73             db.close()
  74         except Exception as e:
  75             log.exception("Error creating tables: ")