Update daily reports
Change-Id: Ice40afa6aab108d901921f7f76c9c59c0c787028
Related-prod: PROD-31716
diff --git a/daily_jenkins_job_report/daily_report/config.py b/daily_jenkins_job_report/daily_report/config.py
index 3407c0b..ef2778e 100755
--- a/daily_jenkins_job_report/daily_report/config.py
+++ b/daily_jenkins_job_report/daily_report/config.py
@@ -5,7 +5,7 @@
# For updating Google sheets
GOOGLE_AUTH = '/home/ubuntu/osccore-qa-testing-tools/daily_jenkins_job_report/daily_report/oscore-e717344565a0.json'
-GOOGLE_SHEET_NAME = 'June 2019'
+GOOGLE_SHEET_NAME = 'July 2019'
# For get_jobs_results.py save_results_to_html method
GENERATED_REPORT = '/var/www/oscore_jobs.com/html/reports/'
diff --git a/daily_jenkins_job_report/daily_report/update_google_sheets.py b/daily_jenkins_job_report/daily_report/update_google_sheets.py
index 86b74b7..8cb00c5 100755
--- a/daily_jenkins_job_report/daily_report/update_google_sheets.py
+++ b/daily_jenkins_job_report/daily_report/update_google_sheets.py
@@ -93,7 +93,9 @@
"""
logger.info('Getting all the google sheet jobs for updating from the first column')
all_jobs = []
- for i in range(3, 41):
+
+ # If delete or remove a job from google sheet, update this:
+ for i in range(3, 40):
all_jobs.append({'gs_job_name': self.wks.acell(column_number + str(i)).value,
'row_number': i,
'column_number': column_number})