[FEATURE] Grab information from Codacy

Description:

We need to fetch and store relevant information from Codacy for each of our repositories. The project already has an integration class that interacts with the Codacy API, so the task focuses on querying the repositories from the database, calling the Codacy API, and saving relevant information in a new dedicated table. The table should store only the essential details, not the full detailed data.

Objectives:

Query the Repositories Table:
- Retrieve the list of repositories from the existing repositories table.
Call Codacy API for Each Repository:
- Use the existing Codacy integration class to call the API for each repository.
Create a New Database Table:
- Create a new dedicated table to store relevant information from Codacy (e.g., repository name, code quality score, issues count, etc.).
Store Codacy Data:
- Parse the API response and insert the relevant data into the new table.

Tasks:

[ ] Query the repositories table to get the list of repositories.
[ ] Update or reuse the Codacy integration class to call the API for each repository.
[ ] Create a new database table for storing the Codacy information with the necessary fields (e.g., repository name, quality score, issues count, etc.).
[ ] Parse the Codacy API response and store relevant information in the new table.
[ ] Ensure that the new functionality runs periodically to keep Codacy data updated.

Code Example:

Here’s a pseudo-code example of how the process might look:

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

foreach ($repositories as $repository) {
    // Use Codacy integration to fetch data
    $codacyData = $codacyIntegration->fetchRepositoryData($repository['name']);

    // Parse relevant data from Codacy API response
    $qualityScore = $codacyData['quality_score'];
    $issuesCount = $codacyData['issues_count'];

    // Insert relevant data into new table
    $database->query('INSERT INTO codacy_info (repository_id, quality_score, issues_count) VALUES (?, ?, ?)', 
                      [$repository['id'], $qualityScore, $issuesCount]);
}

Acceptance Criteria:

[ ] The Codacy API is successfully called for each repository.
[ ] A new database table is created to store relevant Codacy data.
[ ] The relevant information (such as quality score and issues count) is correctly inserted into the new table.
[ ] The process runs periodically to keep the Codacy data up to date.

Additional Context:

This feature will provide an overview of each repository's code quality and issues based on Codacy data. By storing only the relevant information, we ensure that the database remains efficient and easy to query for dashboards or reporting purposes.

guibranco / projects-monitor