[ISSUE-ID] : RICAPP-208 Degradation type entry is empty in anomaly message from AD... 92/10192/1
authorDeepanshu Karnwal <deepanshu.k@hcl.com>
Mon, 19 Dec 2022 14:23:33 +0000 (19:53 +0530)
committerDeepanshu Karnwal <deepanshu.k@hcl.com>
Mon, 19 Dec 2022 14:23:33 +0000 (19:53 +0530)
Signed-off-by: Deepanshu Karnwal <deepanshu.k@hcl.com>
Change-Id: I34ef324b2f5deb68230d2654470d7136681d87dc

src/ad_model.py

index 617fc9f..6e14fa5 100644 (file)
@@ -99,7 +99,7 @@ class CAUSE(object):
         sample.index = range(len(sample))
         for i in range(len(sample)):
             if sample.iloc[i]['Anomaly'] == 1:
-                query = 'select * from {} where {} = \'{}\' and time<now() and time>now()-20s'.format(db.meas, db.ue, sample.iloc[i][db.ue])
+                query = """select * from "{}" where {} = \'{}\' and time<now() and time>now()-20s""".format(db.meas, db.ue, sample.iloc[i][db.ue])
                 normal = db.query(query)
                 if normal:
                     normal = normal[db.meas][[db.thpt, db.rsrp, db.rsrq]]