2 duration fields in TestCase class

[atodorov]

Kiwi TCMS needs additional fields for the TestCase class. This is a prerequisite for time tracking features & telemetry some of which is described at https://kiwitcms.org/blog/kiwi-tcms-team/2019/03/03/legacy-reports-become-telemetry/.

Definition of Done:

• [x] New field TestCase.setup_duration of type DurationField(db_index=True, null=True, blank=True)
• [x] New field TestCase.testing_duration of type DurationField(db_index=True, null=True, blank=True)
• [x] New property TestCase.expected_duration - the sum of the previous 2 fields
• [x] All 3 fields shown in the testcases/get.html
• [x] get.html shows the 3 fields in a human readable format - will probably need a custom template filter to print in a format like "6 minutes" - NOTE: https://github.com/sookasa/django-timedelta-field/blob/master/timedelta/helpers.py will help but copying verbatim has many implications and we can leave this until the end.
• [x] setup_duration & testing_duration are added in testcases/mutable.html and can be editted
• [x] API methods TestCase.create & TestCase.update allow storing values for these fields - tests are updated to match
• [x] API method TestCase.filter returns the value of all 3 fields - tests are updated to match
• [ ] All 3 fields are available as filters in the /cases/search/ page - special care should be taken for handling filtering by expected_duration, see https://docs.djangoproject.com/en/3.1/ref/models/expressions/#using-f-with-annotations

Note: when DurationField type is used in forms it doesn't have a nice widget so something like https://github.com/koss-lebedev/bootstrap-duration-picker will probably work. Could be different if there is something nicer.

• [ ] Test coverage for all of the related changes. This means both positive/negative scenarios where this makes sense or scenarios which traverse different branches of the code where that makes sense.
• test class/test method names are descriptive and reflect the behavior of the subject under test. A good scheme to follow is Test<ClassUnderTest>.test_[who][what][expected_results]
• [ ] CI pass
• [ ] All code review passed & PR merged

Hints:

• Coverage report is at https://codecov.io/gh/kiwitcms/Kiwi/tree/master/tcms
• Devel getting started docs: https://kiwitcms.readthedocs.io/en/latest/contribution.html#testing
• Django testing documentation: https://docs.djangoproject.com/en/3.0/topics/testing/

This issue is part of Kiwi TCMS open source bounty program. For more information see the link(s) in bounty-program milestone

[atodorov]

Related 9348d74a67c82be5d9c063e88a3bacb3d3410443, a43d5a129849ad4e65957b257376385c46f22a0c, 6f0483a59def15ade9df926365b2f552bc657752, 083e3cd667654efebd0b401178e77411ff689d15,

git log & search for estimated - there are a few more

840fa03856f71da340d8b85711a5b5c2e69d8a80 - timedelta2seconds

[gasharova]

Hello, I'm one of the MLH fellows and I'd like to start with this issue if possible. Awaiting assignment. Thank you in advance.

[atodorov]

CC @mfonism, please see the remaining sub-tasks here.