osm_policy_module/migrations/002_add_vnf_alarm.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 """Peewee migrations -- 002_add_vnf_alarm.py.
  25
  26 Some examples (model - class or model name)::
  27
  28     > Model = migrator.orm['model_name']            # Return model in current state by name
  29
  30     > migrator.sql(sql)                             # Run custom SQL
  31     > migrator.python(func, *args, **kwargs)        # Run python code
  32     > migrator.create_model(Model)                  # Create a model (could be used as decorator)
  33     > migrator.remove_model(model, cascade=True)    # Remove a model
  34     > migrator.add_fields(model, **fields)          # Add fields to a model
  35     > migrator.change_fields(model, **fields)       # Change fields
  36     > migrator.remove_fields(model, *field_names, cascade=True)
  37     > migrator.rename_field(model, old_field_name, new_field_name)
  38     > migrator.rename_table(model, new_table_name)
  39     > migrator.add_index(model, *col_names, unique=False)
  40     > migrator.drop_index(model, *col_names)
  41     > migrator.add_not_null(model, *field_names)
  42     > migrator.drop_not_null(model, *field_names)
  43     > migrator.add_default(model, field_name, default)
  44
  45 """
  46
  47 import peewee as pw
  48
  49 SQL = pw.SQL
  50
  51
  52 def migrate(migrator, database, fake=False, **kwargs):
  53     """Write your migrations here."""
  54
  55     @migrator.create_model
  56     class VnfAlarm(pw.Model):
  57         id = pw.AutoField()
  58         alarm_id = pw.CharField(max_length=255)
  59         alarm_uuid = pw.CharField(max_length=255, unique=True)
  60         nsr_id = pw.CharField(max_length=255)
  61         vnf_member_index = pw.IntegerField()
  62         vdu_name = pw.CharField(max_length=255)
  63         last_action = pw.CharField(max_length=255, default='insufficient-data')
  64         id_suffix = pw.IntegerField()
  65         ok_ack = pw.BooleanField(default=False)
  66         alarm_ack = pw.BooleanField(default=False)
  67
  68         class Meta:
  69             table_name = "vnfalarm"
  70
  71     @migrator.create_model
  72     class AlarmAction(pw.Model):
  73         id = pw.AutoField()
  74         type = pw.CharField(max_length=255)
  75         url = pw.TextField()
  76         alarm = pw.ForeignKeyField(
  77             backref="actions",
  78             column_name="alarm_id",
  79             field="id",
  80             model=migrator.orm["vnfalarm"],
  81             on_delete="CASCADE",
  82         )
  83
  84         class Meta:
  85             table_name = "alarmaction"
  86
  87
  88 def rollback(migrator, database, fake=False, **kwargs):
  89     """Write your rollback migrations here."""
  90
  91     migrator.remove_model("vnfalarm")
  92
  93     migrator.remove_model("alarmaction")