xmlFilePath = arg
elif opt in ('-p', '--project'):
projectName = arg
elif opt in ('-t', '--to'):
emailto = arg
else:
usage()
checkerPropertiesHash = {}
ConfigFile = XmlConfigFileRead(xmlFilePath)
WSCoverity = ConnectionService(ConfigFile.getHost(), ConfigFile.getPort(),
ConfigFile.getUserName(),
ConfigFile.getPassword(), ConfigFile.getSSL())
filterSpec = WSCoverity.projectScopeDefectFilterSpecDataObj(
None, None, None, None, None, None, None, None, None, None, None, None,
None, None, None, None, None, None, None, None)
workbook = xlsxwriter.Workbook('Defect_Resolved_Report.xlsx')
header_format = workbook.add_format({
'bold': True,
'font_color': 'white',
'bg_color': '#0096d6',
'font_name': 'HP Simplified',
'align': 'center',
'valign': 'center'
})
header_format_bottom = workbook.add_format({
'bold': True,
'font_color': 'white',
'bg_color': '#0096d6',
# sys.exit()
elif opt in ('-c', '--config'):
xmlFilePath= arg
elif opt in ('-p', '--project'):
projectName= arg
elif opt in ('-t', '--to'):
emailto= arg
else:
usage()
checkerPropertiesHash={}
ConfigFile= XmlConfigFileRead(xmlFilePath)
WSCoverity=ConnectionService(ConfigFile.getHost(),ConfigFile.getPort(),ConfigFile.getUserName(),ConfigFile.getPassword(), ConfigFile.getSSL())
filterSpec=WSCoverity.projectScopeDefectFilterSpecDataObj(None,None,None,None,None,None,None,None,None,None,None,None,None,None,None,None,None,None,None,None)
workbook=xlsxwriter.Workbook('Defect_Resolved_Report.xlsx')
header_format=workbook.add_format({'bold':True,'font_color': 'white', 'bg_color':'#0096d6','font_name':'HP Simplified', 'align':'center','valign':'center'})
header_format_bottom=workbook.add_format({'bold':True,'font_color': 'white', 'bg_color':'#0096d6','font_name':'HP Simplified','bottom':True, 'border_color':'#FFFFFF','align':'center','valign':'center'})
data_format=workbook.add_format({'font_name':'HP Simplified'})
projects =projectName.split(",")
for prName in projects:
defects=[]
pageStartIndex=0
numDefects=0
row=3
col=0
domain=prName.split("-")
while True:
sizePage=WSCoverity.pageSpecDataObj(1000,False,None,pageStartIndex)
ConfigFile = XmlConfigFileRead(xmlFilePath)
WSCoverity = ConnectionService(ConfigFile.getHost(), ConfigFile.getPort(),
ConfigFile.getUserName(),
ConfigFile.getPassword(), ConfigFile.getSSL())
fromDate = datetime.now(timezone.utc) - timedelta(days=int(daysBefore))
lastDetectedDate = datetime.now(timezone.utc) - timedelta(days=1)
new_defects = []
mergedDefects = []
pageStartIndex = 0
numDefects = 0
while True:
sizePage = WSCoverity.pageSpecDataObj(1000, True, None, pageStartIndex)
filterSpec = WSCoverity.projectScopeDefectFilterSpecDataObj(
None, None, None, None, None, None, None, None, None, None, None, None,
None, None, None, lastDetectedDate, None, None, None, None)
defectsPage = WSCoverity.getMergedDefectsForProjectScope(
projectName, filterSpec, sizePage)
pageStartIndex += 1000
numDefects = defectsPage['totalNumberOfRecords']
if numDefects > 0:
mergedDefects.extend(defectsPage['mergedDefects'])
if pageStartIndex >= numDefects:
break
print("Defects after date: " + str(fromDate) + "\n")
if len(mergedDefects) == 0:
print("No new defects found. \n")
body = "<html><body><p>The following "
ConfigFile= XmlConfigFileRead(xmlFilePath)
WSCoverity=ConnectionService(ConfigFile.getHost(),ConfigFile.getPort(),ConfigFile.getUserName(),ConfigFile.getPassword(), ConfigFile.getSSL())
fromDate= datetime.now(timezone.utc) - timedelta(days=int(daysBefore))
lastDetectedDate= datetime.now(timezone.utc) - timedelta(days=1)
new_defects=[]
mergedDefects=[]
pageStartIndex=0
numDefects=0
while True:
sizePage=WSCoverity.pageSpecDataObj(1000,True,None,pageStartIndex)
filterSpec=WSCoverity.projectScopeDefectFilterSpecDataObj(None,None,None,None,None,None,None,None,None,None,None,None,None,None,None,lastDetectedDate,None,None,None,None)
defectsPage=WSCoverity.getMergedDefectsForProjectScope(projectName,filterSpec,sizePage)
pageStartIndex+=1000
numDefects=defectsPage['totalNumberOfRecords']
if numDefects > 0 :
mergedDefects.extend(defectsPage['mergedDefects'])
if pageStartIndex >= numDefects:
break
print("Defects after date: "+str(fromDate) +"\n")
if len(mergedDefects) == 0:
print("No new defects found. \n")
body="<html><body><p>The following "
body+="email was sent to notify 0 defects on project "+projectName + "in the past "+ daysBefore + ". No action needs to be performed"
subject="No Defects found on "+projectName+" notification."