X-Git-Url: https://osm.etsi.org/gitweb/?a=blobdiff_plain;f=osm_policy_module%2Fcore%2Fdatabase.py;h=9bd8ac82e679675d0c61c21d15e56bdbb8976d69;hb=023473295ef70215b9603e1fa0de8d71c0f6d0a2;hp=8ad19f2f4ecbe928fad165a921e1cceaa368be4a;hpb=4c5541f020bbc56e9ae1a326b0d33e673dcd5f0b;p=osm%2FPOL.git diff --git a/osm_policy_module/core/database.py b/osm_policy_module/core/database.py index 8ad19f2..9bd8ac8 100644 --- a/osm_policy_module/core/database.py +++ b/osm_policy_module/core/database.py @@ -25,14 +25,14 @@ import datetime import logging from peewee import CharField, IntegerField, ForeignKeyField, Model, TextField, AutoField, DateTimeField -from playhouse.sqlite_ext import SqliteExtDatabase +from playhouse.db_url import connect from osm_policy_module.core.config import Config log = logging.getLogger(__name__) cfg = Config.instance() -db = SqliteExtDatabase('policy_module.db') +db = connect(cfg.OSMPOL_SQL_DATABASE_URI) class BaseModel(Model): @@ -75,5 +75,8 @@ class DatabaseManager: db.connect() db.create_tables([ScalingGroup, ScalingPolicy, ScalingCriteria, ScalingAlarm]) db.close() - except Exception as e: + except Exception: log.exception("Error creating tables: ") + + def get_alarm(self, alarm_id: str): + return ScalingAlarm.select().where(ScalingAlarm.alarm_id == alarm_id).get()