Mini-reporting system

[kinow]

At least a few basic reports. Two or three would be enough. Something that could be used with dashboards too would be useful and convenient.

[kinow]

• [x] Choose basic reports
• [x] Implement backend logic
• [x] Create views

[kinow]

Project simple report: list number of test plans, number of test suites, number of test cases, number of test runs, number of test cases executed, % of each execution statuses.

Test Plan testing report: first user selects a test plan, then he gets the latest execution status for each test case in the test plan.

[kinow]

Sample response for the projects report:

{

    "test_plans_count": 1,
    "test_suites_count": 4,
    "test_cases_count": 3,
    "test_runs_count": 2,
    "executions_count": 5,
    "executions_summary": {
        "1": 1,
        "2": 2,
        "3": 2,
        "4": 1
    }

}

[kinow]

Sample response for the test plans report:

{

    "test_cases": [
        {
            "id": 1,
            "version": null,
            "test_cases_id": "1",
            "execution_type_id": "1",
            "name": "Test Case A - 1",
            "prerequisite": "None",
            "description": "Example test case",
            "created_at": "2016-09-18 09:06:43",
            "updated_at": "2016-09-18 09:06:43",
            "latest_execution": {
                "id": 1,
                "test_run_id": "1",
                "test_cases_versions_id": "1",
                "execution_status_id": "2",
                "notes": "",
                "created_at": "2016-09-20 00:58:38",
                "updated_at": "2016-09-20 00:58:38",
                "test_cases_id": "1"
            }
        },
        {
            "id": 2,
            "version": null,
            "test_cases_id": "2",
            "execution_type_id": "2",
            "name": "Test Case A - 2",
            "prerequisite": "Everything must be working!",
            "description": "Example test case",
            "created_at": "2016-09-18 09:06:43",
            "updated_at": "2016-09-18 09:06:43",
            "latest_execution": {
                "id": 5,
                "test_run_id": "2",
                "test_cases_versions_id": "2",
                "execution_status_id": "3",
                "notes": "",
                "created_at": "2016-09-20 01:22:55",
                "updated_at": "2016-09-20 01:22:55",
                "test_cases_id": "2"
            }
        },
        {
            "id": 3,
            "version": null,
            "test_cases_id": "3",
            "execution_type_id": "1",
            "name": "Test Case A - 3",
            "prerequisite": "None",
            "description": "Example test case",
            "created_at": "2016-09-18 09:06:43",
            "updated_at": "2016-09-18 09:06:43",
            "latest_execution": {
                "id": 4,
                "test_run_id": "2",
                "test_cases_versions_id": "3",
                "execution_status_id": "4",
                "notes": "",
                "created_at": "2016-09-20 00:59:31",
                "updated_at": "2016-09-20 00:59:31",
                "test_cases_id": "3"
            }
        }
    ]

}

[kinow]

Backend implemented, just need to complete the views now.

[kinow]

Simple Project Report implemented!

[kinow]

Simple Test Plan Report implemented!

[kinow]

Done!