prejournal=# select c.name, sum(m.amount) as hours from movements m inner join components c on m.fromcomponent = c.id where m.tocomponent=8 and m.timestamp_ < date('2022-08-05 00:00:00') group by c.name;
name | hours
---------+-------
ismoil | 476
michiel | 221.5
(2 rows)
You should be seeing the same numbers when you query the API of https://time.pondersource.com
This does mean that we're already over budget, especially if we give half of milestone 4 to m-ld as discussed on Monday's meeting. That's OK because the Ponder Source Foundation can finance the rest, but it does mean we're nearing wrap-up time from our side. :) Ponder Source Foundation also financed the hours made by Triantafullenia and Lambert already, and Andrej worked as a volunteer on the project from our side.