aboutsummaryrefslogtreecommitdiffstats
path: root/bin/acme/srtool_jira.py
diff options
context:
space:
mode:
Diffstat (limited to 'bin/acme/srtool_jira.py')
-rwxr-xr-xbin/acme/srtool_jira.py10
1 files changed, 5 insertions, 5 deletions
diff --git a/bin/acme/srtool_jira.py b/bin/acme/srtool_jira.py
index a0a90851..dc72404b 100755
--- a/bin/acme/srtool_jira.py
+++ b/bin/acme/srtool_jira.py
@@ -214,10 +214,10 @@ def do_update_jira():
log.write("=============================================================================\n")
log.write("\n")
- # Reset datasource's update_time as today
- sql = "UPDATE orm_datasource SET update_time=?,lastModifiedDate=? WHERE data='jira_status'"
- date_string = datetime.today().strftime('%Y-%m-%d %H:%M:%S')
- c.execute(sql, (date_string,date_string,) )
+ # Reset datasource's lastModifiedDate as today
+ sql = "UPDATE orm_datasource SET lastModifiedDate=? WHERE name='Jira'"
+ date_string = datetime.now().strftime(ORM.DATASOURCE_DATETIME_FORMAT)
+ c.execute(sql, (date_string,) )
conn.commit()
c.close()
@@ -433,7 +433,7 @@ def update_project_issues(project, issues, conn, log):
sql = ''' INSERT into orm_cve (name, name_sort, priority, status, comments, comments_private, cve_data_type, cve_data_format, cve_data_version, public, publish_state, publish_date, description, publishedDate, lastModifiedDate, recommend, recommend_list, cvssV3_baseScore, cvssV3_baseSeverity, cvssV2_baseScore, cvssV2_severity, packages, srt_updated)
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)'''
- c.execute(sql, (cve_name, cve_name_sort, d.priority, cve_status, '', '', '', '', '', 1, 0, '', 'Created from defect %s' % d.name, '', '', 0, '', '', '', '', '', '', datetime.now()))
+ c.execute(sql, (cve_name, cve_name_sort, d.priority, cve_status, '', '', '', '', '', 1, 0, '', 'Created from defect %s' % d.name, '', '', 0, '', '', '', '', '', '', datetime.now().strftime(ORM.DATASOURCE_DATETIME_FORMAT)))
# Find the new id
print("FINDING CVE ID for %s\n" % cve_name)