[FEATURE] Grab information from Codecov

Description:

We need to create an integration with the CodeCov API to fetch and store relevant code coverage information for each repository. The task involves querying the repositories table, calling the CodeCov API for each repository, and storing the results in a new dedicated table. The table will store only key information (e.g., coverage percentage, number of lines covered, and total lines), avoiding detailed data to keep it lightweight.

Objectives:

Create CodeCov API Integration:
- Develop a PHP integration class to interact with the CodeCov API.
Query the Repositories Table:
- Retrieve the list of repositories from the existing repositories table.
Call the CodeCov API for Each Repository:
- Use the new integration class to call the API and retrieve code coverage data for each repository.
Create a New Database Table:
- Design a new table to store only the key information retrieved from the CodeCov API.
Store Relevant Data:
- Parse the API response and store the relevant data in the new table.

Tasks:

[ ] Develop a PHP integration class for CodeCov API.
[ ] Query the repositories table to fetch the list of repositories.
[ ] Fetch code coverage data for each repository using the CodeCov API.
[ ] Create a new table in the database with relevant fields (e.g., repository ID, coverage percentage, lines covered, total lines).
[ ] Parse the response and insert the relevant data into the new table.
[ ] Ensure the process runs periodically to keep the coverage data up to date.

Code Example:

Here’s a basic pseudo-code example to demonstrate how the integration might work:

// Fetch repositories from the database
$repositories = $database->query('SELECT id, name FROM repositories');

// Instantiate CodeCov integration class
$codeCov = new CodeCovIntegration('YOUR_API_KEY');

foreach ($repositories as $repository) {
    // Call CodeCov API for each repository
    $codeCovData = $codeCov->fetchRepositoryCoverage($repository['name']);

    // Parse relevant data from the API response
    $coveragePercentage = $codeCovData['coverage']['percentage'];
    $linesCovered = $codeCovData['coverage']['covered_lines'];
    $totalLines = $codeCovData['coverage']['total_lines'];

    // Insert the relevant data into the new table
    $database->query('INSERT INTO codecov_info (repository_id, coverage_percentage, lines_covered, total_lines) 
                      VALUES (?, ?, ?, ?)', 
                      [$repository['id'], $coveragePercentage, $linesCovered, $totalLines]);
}

Acceptance Criteria:

[ ] A PHP integration with the CodeCov API is created.
[ ] The repositories table is queried to get the list of repositories.
[ ] CodeCov data (coverage percentage, lines covered, total lines) is fetched and stored in a new dedicated table.
[ ] The new database table is created with relevant fields.
[ ] The process runs periodically to keep the coverage data updated.

Additional Context:

By integrating with CodeCov, we can track and monitor code coverage for each repository, providing useful insights into the health and quality of the codebase. This data will be lightweight and easy to query for further use in dashboards or reporting.

guibranco / projects-monitor