Time and pointing info not available for recent runs in merged run summary

[morcuended]

Since 2023-12-05 the time start and pointing information that the merge run summary script produces.

2023-12-05 15821 DRS4 22 1969-12-31T23:59:52.000 nan nan nan nan

after moving to EVBv6 run start field in the run summary files is not available, so we need to take this info from the TCU database (as lstosa does, see snippet below):

def get_run_tstart_from_TCU(run_id: int, tcu_server: str):
    """Get start timestamps in ISOT format for a given run ID.

    Parameters
    ----------
    run_id : int
    tcu_server : str
        Host of the TCU database

    Returns
    -------
    run_id : int
    tstart : datetime.datetime

    Notes
    -----
    TCU Monitoring database can be accessed at 'lst101-int' server
    from lstanalyzer@tcs06 and cp's
    """

    client = MongoClient(tcu_server)
    collection = client["lst1_obs_summary"]["camera"]
    summary = collection.find_one({"run_number": run_id})

    if summary is not None:
        tstart = datetime.fromtimestamp(summary["tstart"])
   
    return tstart

[moralejo]

Was the info used in the pipeline? (and if so, why wasn't this spotted earlier?)

[morcuended]

Not used in the analysis other than for bookkeeping of all the runs taken. However, this was revived to use this information for the dl2 to dl3 stage (name/main target coordinates) instead of accessing multiple times TCU database.

This is why it went unnoticed.