diff options
Diffstat (limited to 'bin/common/srtool_defect.py')
-rwxr-xr-x | bin/common/srtool_defect.py | 13 |
1 files changed, 9 insertions, 4 deletions
diff --git a/bin/common/srtool_defect.py b/bin/common/srtool_defect.py index 7cee1f85..d2a6878f 100755 --- a/bin/common/srtool_defect.py +++ b/bin/common/srtool_defect.py @@ -46,6 +46,11 @@ except ImportError: srtDbName = 'srt.sqlite' +# load the srt.sqlite schema indexes +dir_path = os.path.dirname(os.path.dirname(os.path.realpath(__file__))) +sys.path.insert(0, dir_path) +from common.srt_schema import ORM + ################################# # Helper methods # @@ -178,10 +183,10 @@ def update_defects(): log.write("=============================================================================\n") log.write("\n") - # Reset datasource's update_time as today - sql = "UPDATE orm_datasource SET update_time=?,lastModifiedDate=? WHERE data='defect_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='Defect'" + date_string = datetime.today().strftime(ORM.DATASOURCE_DATETIME_FORMAT) + c.execute(sql, (date_string,) ) conn.commit() c.close() |