- db.create_tables([VimCredentials, Alarm])
-
- def get_credentials(self, vim_uuid: str = None) -> VimCredentials:
- with db.atomic():
- return VimCredentials.get_or_none(VimCredentials.uuid == vim_uuid)
-
- def save_credentials(self, vim_credentials) -> VimCredentials:
- """Saves vim credentials. If a record with same uuid exists, overwrite it."""
- with db.atomic():
- exists = VimCredentials.get_or_none(VimCredentials.uuid == vim_credentials.uuid)
- if exists:
- vim_credentials.id = exists.id
- vim_credentials.save()
- return vim_credentials
-
- def get_alarm(self, alarm_id) -> Alarm:
- with db.atomic():
- alarm = (Alarm.select()
- .where(Alarm.alarm_id == alarm_id)
- .get())
- return alarm
-
- def save_alarm(self, name, threshold, operation, severity, statistic, metric_name, vdur_name,
- vnf_member_index, nsr_id) -> Alarm:
- """Saves alarm."""
- # TODO: Add uuid optional param and check if exists to handle updates (see self.save_credentials)
- with db.atomic():
- alarm = Alarm()
- alarm.uuid = str(uuid.uuid4())
- alarm.name = name
- alarm.threshold = threshold
- alarm.operation = operation
- alarm.severity = severity
- alarm.statistic = statistic
- alarm.monitoring_param = metric_name
- alarm.vdur_name = vdur_name
- alarm.vnf_member_index = vnf_member_index
- alarm.nsr_id = nsr_id
- alarm.save()
- return alarm
-
- def delete_alarm(self, alarm_uuid) -> None:
- with db.atomic():
- alarm = (Alarm.select()
- .where(Alarm.uuid == alarm_uuid)
- .get())
- alarm.delete_instance()
-
- def get_vim_type(self, vim_account_id) -> str:
- """Get the vim type that is required by the message."""
- credentials = self.get_credentials(vim_account_id)
- return str(credentials.type)
+ router = Router(db, os.path.dirname(migrations.__file__))
+ router.run()
+ db.close()
+
+
+class VimCredentialsRepository:
+ @staticmethod
+ def upsert(**query) -> VimCredentials:
+ vim_credentials = VimCredentials.get_or_none(**query)
+ if vim_credentials:
+ query.update({'id': vim_credentials.id})
+ vim_id = VimCredentials.insert(**query).on_conflict_replace().execute()
+ return VimCredentials.get(id=vim_id)
+
+ @staticmethod
+ def get(*expressions) -> VimCredentials:
+ return VimCredentials.select().where(*expressions).get()
+
+
+class AlarmRepository:
+ @staticmethod
+ def create(**query) -> Alarm:
+ return Alarm.create(**query)
+
+ @staticmethod
+ def get(*expressions) -> Alarm:
+ return Alarm.select().where(*expressions).get()
+
+ @staticmethod
+ def list(*expressions) -> Iterable[Alarm]:
+ if expressions == ():
+ return Alarm.select()
+ else:
+ return Alarm.select().where(*expressions)