update_activity.py

import json

try:
    with open("data/excel/activity_table.json", encoding="utf-8") as f:
        activity_table = json.load(f)

    activity_start_time_list = []

    for i in activity_table["basicInfo"]:
        if i.endswith("side"):
            startTime = activity_table["basicInfo"][i]["startTime"]
            endTime = activity_table["basicInfo"][i]["endTime"]
            activity_start_time_list.append((startTime, endTime))

    max_activity_start_time, max_activity_end_time = max(
        activity_start_time_list, key=lambda k: k[0]
    )

    with open("config/config.json") as f:
        config = json.load(f)

    config["userConfig"]["activityMinStartTs"] = max_activity_start_time - \
        (7*24*60*60)
    config["userConfig"]["activityMaxStartTs"] = max_activity_end_time + \
        (7*24*60*60)

    with open("config/config.json", "w") as f:
        json.dump(config, f, indent=4)
except Exception:
    pass