[Bug][Framework] Devlake tasks table began_at field not correct about incubator-devlake HOT 1 OPEN

The issue with the began_at field in the _devlake_tasks table mirroring the value from the _devlake_pipelines table is due to the began_at field not being set correctly for individual tasks. To resolve this, ensure that the began_at field for each task is set when the task starts, rather than inheriting the value from the pipeline.

Here's an example of how to set the began_at field correctly:

func StartTask(task *Task) {
    now := time.Now()
    task.BeganAt = &now
    // Save the task to the database
    db.Save(task)
}

This function should be called when the task starts, ensuring that the began_at field is set to the current time. This will help in accurately calculating the spent_seconds field.

Additionally, you can use the logging functionality provided by the getTaskLogger function to trace the exact point at which the began_at field is set. Add logging right before and after setting the began_at field:

logger.Info("Setting began_at for task: %d", task.ID)
beganAt := time.Now()
if task.BeganAt != nil {
    beganAt = *task.BeganAt
}
logger.Info("began_at set to: %v for task: %d", beganAt, task.ID)

This will help you trace and debug the setting of the began_at field for tasks ^[1][2].

To continue talking to Dosu, mention @dosu.

from incubator-devlake.