fix_datetime.py

#!/usr/bin/env powerscript
from cdb import tools
from cdb.platform.mom.fields import DDDateField
from cdb.progress import ProgressBar

if __name__ == "__main__":
    included_classes = [
        # NOTE: extend this list as needed.
        "cs_ticket_ticket",
        "cdbpcs_issue",
        "cdbwf_task",
        "cdbwf_process_component",
    ]
    fields = DDDateField.Query(DDDateField.with_time != 1)
    for field in fields:
        if field.classname not in included_classes:
            print(f"Skipped {field.classname}.{field.field_name}")
            continue
        print(f"> {field.classname}.{field.field_name}")
        fpyname = field.Entity.getFqpyname()
        if fpyname:
            print(f"  > FQPY {fpyname}")
            cls = tools.getObjectByName(fpyname)
            progress_bar = ProgressBar()
            objs = cls.Query().Execute()
            print(f"  > {len(objs)} objects")
            for o in progress_bar(objs):
                attr = getattr(o, field.field_name)
                if attr is not None:
                    o.Update(**{field.field_name: getattr(o, field.field_name)})
        else:
            print("No FQPY, skipping")