def test_removeRedundantRemarks(self) -> None:
"""tests the function that removes redundant remarks
"""
tag, reas, rem = removeRedundantRemarks("Outage", "RSD", "RSD")
self.assertTrue((tag == None) and (reas == "RSD") and (rem == "RSD"))
tag, reas, rem = removeRedundantRemarks("RSD", "RSD ", " rsd")
self.assertTrue((tag == "RSD") and (reas == None) and (rem == None))
tag, reas, rem = removeRedundantRemarks("RSD", "something", " rsd")
self.assertTrue((tag == "RSD") and (reas == "something")
and (rem == None))
tag, reas, rem = removeRedundantRemarks("RSD", " rsd", "somthing")
self.assertTrue((tag == "RSD") and (reas == None)
and (rem == "somthing"))
tag, reas, rem = removeRedundantRemarks("Voltage Regulation", " VR",
"vr")
self.assertTrue((tag == "Voltage Regulation") and (reas == None)
and (rem == None))
tag, reas, rem = removeRedundantRemarks(
"Manually opened due to High Voltage", " mohv", "MoHV")
self.assertTrue((tag == "Manually opened due to High Voltage")
and (reas == None) and (rem == None))
tag, reas, rem = removeRedundantRemarks("Voltage Regulation", " VR",
"vr. ")
self.assertTrue((tag == "Voltage Regulation") and (reas == None)
and (rem == None))
tag, reas, rem = removeRedundantRemarks(
"Manually opened due to High Voltage", " Vr.", "VR")
self.assertTrue((tag == "Manually opened due to High Voltage")
and (reas == None) and (rem == None))
tag, reas, rem = removeRedundantRemarks("RSD", "rsd", "rsd.")
self.assertTrue((tag == "RSD") and (reas == None) and (rem == None))
def fetchTransElOutages(conStr: str, startDt: dt.datetime, endDt: dt.datetime) -> List[IOutage]:
"""fetch transmission element outages for a start and end dates, where
outage time between start and end time
revived time between start and end time
Args:
conStr (str): connection string to reports database
startDt (dt.datetime): start date of report time scope
endDt (dt.datetime): end date of report time scope
Returns:
List[IOutage]: list of outage objects that contain the following data
element_name, owners, capacity, outage date, outage time, revival date, revival time, reason
"""
# connect to app database
con = cx_Oracle.connect(conStr)
# sql query to fetch the outages
outagesFetchSql = '''select oe.ELEMENT_NAME,
oe.OWNERS, oe.CAPACITY,
oe.OUTAGE_DATETIME, oe.REVIVED_DATETIME,
oe.OUTAGE_REMARKS, oe.REASON, oe.shutdown_tag
from mis_warehouse.outage_events oe
where not(oe.entity_name = 'GENERATING_UNIT') and
(
(oe.OUTAGE_DATETIME between :1 and :2)
or (oe.REVIVED_DATETIME between :1 and :2)
or (oe.OUTAGE_DATETIME <= :1 and oe.REVIVED_DATETIME >= :2)
or (oe.OUTAGE_DATETIME <= :1 and oe.REVIVED_DATETIME IS NULL)
)
order by oe.OUTAGE_DATETIME desc
'''
# get cursor and execute fetch sql
cur = con.cursor()
cur.execute(outagesFetchSql, (startDt, endDt))
colNames = [row[0] for row in cur.description]
targetColumns = ['ELEMENT_NAME', 'OWNERS', 'CAPACITY',
'OUTAGE_DATETIME', 'REVIVED_DATETIME', 'OUTAGE_REMARKS', 'REASON', 'SHUTDOWN_TAG']
if (False in [(col in targetColumns) for col in colNames]):
# all desired columns not fetched, hence return empty
return []
# print(colNames)
# fetch all rows
dbRows = cur.fetchall()
# initialise outages to be returned
outages: List[IOutage] = []
elNameInd = colNames.index('ELEMENT_NAME')
ownersInd = colNames.index('OWNERS')
capInd = colNames.index('CAPACITY')
outDtInd = colNames.index('OUTAGE_DATETIME')
reviveDtInd = colNames.index('REVIVED_DATETIME')
remarksInd = colNames.index('OUTAGE_REMARKS')
reasonInd = colNames.index('REASON')
outageTagInd = colNames.index('SHUTDOWN_TAG')
# iterate through each row to populate result outage rows
for row in dbRows:
elName: str = row[elNameInd]
owners: str = row[ownersInd]
voltLvl: str = str(row[capInd])
outDateStr: str = dt.datetime.strftime(row[outDtInd], "%d-%m-%Y")
outTimeStr: str = dt.datetime.strftime(row[outDtInd], "%H:%M")
revivalDateStr: str = 'Still out'
revivalTimeStr: str = 'Still out'
revivalDt = row[reviveDtInd]
if not(revivalDt == None):
revivalDateStr = dt.datetime.strftime(revivalDt, "%d-%m-%Y")
revivalTimeStr = dt.datetime.strftime(revivalDt, "%H:%M")
reason = row[reasonInd]
remarks = row[remarksInd]
outageTag = row[outageTagInd]
outageTag, reason, remarks = removeRedundantRemarks(
outageTag, reason, remarks)
reasonStr = combineTagReasonRemarks(outageTag, reason, remarks)
# create outage record
outageObj: IOutage = {
'elName': elName,
'owners': owners,
'capacity': voltLvl,
'outageDate': outDateStr,
'outageTime': outTimeStr,
'revivalDate': revivalDateStr,
'revivalTime': revivalTimeStr,
'reason': reasonStr
}
outages.append(outageObj)
return outages
def getLongTimeUnrevivedForcedOutages(conStr: str, startDt: dt.datetime,
endDt: dt.datetime) -> List[IOutage]:
"""fetch forced outages that are still out and outage duration greater than 6 months
here we take (revived time = null) or (revived time > endTimeInput)
Args:
conStr (str): connection string to application database
startDt (dt.datetime): start date of report time scope
endDt (dt.datetime): end date of report time scope
Returns:
List[IOutage]: list of outage objects that contain the following data
element_name, owners, capacity, outage date, outage time, revival date, revival time, reason
"""
# connect to app database
con = cx_Oracle.connect(conStr)
# sql query to fetch the outages
outagesFetchSql = '''select oe.ELEMENT_NAME, ENTITY_NAME,
oe.OWNERS, oe.CAPACITY,
oe.OUTAGE_DATETIME, oe.REVIVED_DATETIME,
oe.OUTAGE_REMARKS, oe.REASON, oe.shutdown_tag, oe.SHUTDOWN_TYPENAME
from mis_warehouse.outage_events oe
where (oe.shutdown_typename = 'FORCED') and
(oe.OUTAGE_DATETIME < :1) and
((oe.REVIVED_DATETIME IS NULL) or (oe.REVIVED_DATETIME>:1)) and
((:1 - oe.OUTAGE_DATETIME) > INTERVAL '180' DAY(3))
order by oe.OUTAGE_DATETIME
'''
# get cursor and execute fetch sql
cur = con.cursor()
cur.execute(outagesFetchSql, (endDt, ))
colNames = [row[0] for row in cur.description]
targetColumns = [
'ELEMENT_NAME', 'ENTITY_NAME', 'OWNERS', 'CAPACITY', 'OUTAGE_DATETIME',
'REVIVED_DATETIME', 'OUTAGE_REMARKS', 'REASON', 'SHUTDOWN_TAG',
'SHUTDOWN_TYPENAME'
]
if (False in [(col in targetColumns) for col in colNames]):
# all desired columns not fetched, hence return empty
return []
# print(colNames)
# fetch all rows
dbRows = cur.fetchall()
# initialise outages to be returned
outages: List[IOutage] = []
elNameInd = colNames.index('ELEMENT_NAME')
elTypeInd = colNames.index('ENTITY_NAME')
ownersInd = colNames.index('OWNERS')
capInd = colNames.index('CAPACITY')
outDtInd = colNames.index('OUTAGE_DATETIME')
reviveDtInd = colNames.index('REVIVED_DATETIME')
remarksInd = colNames.index('OUTAGE_REMARKS')
reasonInd = colNames.index('REASON')
outageTagInd = colNames.index('SHUTDOWN_TAG')
outageTypeInd = colNames.index('SHUTDOWN_TYPENAME')
# iterate through each row to populate result outage rows
for row in dbRows:
elName: str = row[elNameInd]
elType: str = row[elTypeInd]
owners: str = row[ownersInd]
voltLvl: str = str(row[capInd])
outDateStr: str = dt.datetime.strftime(row[outDtInd], "%Y-%m-%d")
outTimeStr: str = dt.datetime.strftime(row[outDtInd], "%H:%M")
revivalDateStr: str = 'Still out'
revivalTimeStr: str = 'Still out'
revivalDt = row[reviveDtInd]
if not (revivalDt == None):
revivalDateStr = dt.datetime.strftime(revivalDt, "%Y-%m-%d")
revivalTimeStr = dt.datetime.strftime(revivalDt, "%H:%M")
reason = row[reasonInd]
remarks = row[remarksInd]
outageType = row[outageTypeInd]
outageTag = row[outageTagInd]
outageTag, reason, remarks = removeRedundantRemarks(
outageTag, reason, remarks)
reasonStr = combineTagReasonRemarks(outageTag, reason, remarks)
# create outage record
outageObj: IOutage = {
'elName': elName,
'elType': elType,
'owners': owners,
'capacity': voltLvl,
'outageDate': outDateStr,
'outageTime': outTimeStr,
'revivalDate': revivalDateStr,
'revivalTime': revivalTimeStr,
'reason': reasonStr,
'outageType': outageType
}
outages.append(outageObj)
return outages