Add forecast initialization time

[peterdudfield]

Detailed Description

Add a column on the forecast table that

Context

• we already have creation time, but this is the forecast initialisation time. We might make the foreacst ay 16.13, but the initalisation time is 16.00
• https://github.com/openclimatefix/pv-site-datamodel/blob/main/pvsite_datamodel/sqlmodels.py#L320
• Dynamic weights uk-pv-forecast-blend#39

Possible Implementation

• add optional column to ForecastSQL table, name could be intialization_datetime_utc
• add to Forecast pydantic object too
• update PVnet-app to add this time ine
• update National-xg to add this time in

[Averagenormaljoe]

May I work on this?

[lambaaryan011]

Hey @peterdudfield i love to solve this issue, can you assign to me.

[peterdudfield]

@Averagenormaljoe have you done any sqlalchemy stuff before?

[Averagenormaljoe]

Yes. @peterdudfield

[Averagenormaljoe]

Thank you, I will start working on it now.

[Averagenormaljoe]

When modifying the ForecastSQL code to incorporate 'initialisation_datetime_utc', should code validation be implemented to ensure that the 'initialisation_datetime_utc' is not earlier than the 'creation_time' if 'initialisation_datetime_utc' is included as a parameter? @peterdudfield

[peterdudfield]

No, don't worry about that

[Averagenormaljoe]

Another question: when 'initialisation_datetime_utc' is not included as a parameter, should it default to being null in the ForecastSQL table 'initialisation_datetime_utc', or would a different value be preferred? @peterdudfield

[peterdudfield]

Null is fine

[Dakshbir]

hey @Averagenormaljoe are you working on this issue??