[BUG] Tasking Manager validation time too big

[NicolasGrosjean]

Describe the bug

The validation time of the tasking manager is too big.

I suppose, the time are aggregated without manage the fact a user validate several tasks at the same time.

To Reproduce

Execute /mapathon/detail with the following request body

{"fromTimestamp":"2022-09-15T08:00:00.000","toTimestamp":"2022-09-15T08:15:00.000","projectIds":[13503],"hashtags":[]}

Expected behavior

All time are lower than 7,200 (2 hours in seconds).

Screenshots

[NicolasGrosjean]

TODO list:

• Reproduce the issue with the fixtures (see Integration tests #326 for test with fixture)
• Fix create_user_time_spent_mapping_and_validating_query (for example with a trick like this one)
• Update test_app.py

[NicolasGrosjean]

Example of SQL to reproduce issue after using #329

-- Copy values which are in reality in project 13503 and tasks 2, 3 and 47, done by another user
COPY public.task_history (id, project_id, task_id, action, action_text, action_date, user_id) FROM stdin;
22217985	1	169	LOCKED_FOR_VALIDATION	01:26:17.469080	2022-09-15 14:26:01.778760	360183
22217986	1	170	LOCKED_FOR_VALIDATION	01:26:17.487379	2022-09-15 14:26:01.804268	360183
22217994	1	171	LOCKED_FOR_VALIDATION	01:26:17.534701	2022-09-15 14:26:02.108510	360183
22218532	1	169	STATE_CHANGE	VALIDATED	2022-09-15 15:52:19.237511	360183
22218533	1	170	STATE_CHANGE	VALIDATED	2022-09-15 15:52:19.286513	360183
22218541	1	171	STATE_CHANGE	VALIDATED	2022-09-15 15:52:19.637390	360183
\.

[kshitijrajsharma]

Interesting issue ! Thank you for this detailed info on your issue ! @NicolasGrosjean I will also look deeply in to this , So that i can provide support !
cc : @ramyaragupathy