davinci resolve dates >> comments (source tape bug)

gistfile1.txt

# use this code for the date created column

from datetime import datetime

pm = resolve.GetProjectManager()
proj = pm.GetCurrentProject()
mp = proj.GetMediaPool()
bin = mp.GetCurrentFolder()
print('in bin ', bin.GetName())
clips = bin.GetClips()

for i in clips:
    print(clips[i].GetClipProperty('Date Created'))
    propDate = clips[i].GetClipProperty('Date Created')  
    date_format = "%a %b %d %Y %H:%M:%S"
    datetime_obj = datetime.strptime(propDate, date_format)
    unix_timestamp = str(int(datetime_obj.timestamp()))
    print("Unix Timestamp:", unix_timestamp)
    clips[i].SetClipProperty("Comments", unix_timestamp)


# use this code for the date modified column

from datetime import datetime

pm = resolve.GetProjectManager()
proj = pm.GetCurrentProject()
mp = proj.GetMediaPool()
bin = mp.GetCurrentFolder()
print('in bin ', bin.GetName())
clips = bin.GetClips()

for i in clips:
    print(clips[i].GetClipProperty('Date Modified'))
    propDate = clips[i].GetClipProperty('Date Modified')  
    date_format = "%a %b %d %H:%M:%S %Y"
    datetime_obj = datetime.strptime(propDate, date_format)
    unix_timestamp = str(int(datetime_obj.timestamp()))
    print("Unix Timestamp:", unix_timestamp)
    clips[i].SetClipProperty("Comments", unix_timestamp)