Add Sum

[peterdudfield]

Detailed Description

Add a route that gets the sum of forecasts and generations

Context

• this can be used by the front end

Possible Implementation

• for both forecast and truths
• sum can be done in database

[BraunRudolf]

I'll implement this one.

[BraunRudolf]

Just looked into it, is this still relevant? Both routes

@app.get(
    "/sites/pv_actual",
    response_model=Union[list[MultiplePVActual], list[GenerationSum], MultipleSitePVActualCompact],
    tags=["Generation"],)
)

and

@app.get(
    "/sites/pv_forecast",
    tags=["Forecast"],
)

have the sum_by option which would return the sum (right?) Shall I implement a route that returns both, or can we close this issue?

[peterdudfield]

I think close the issue