[FEATURE] Add database code to this repository

[guibranco]

Description

The current database processing code is located in the Webhooks repository. To streamline our setup and manage everything in one place, we need to migrate this code to the current repository and implement webhook handling here. This will consolidate our operations and simplify maintenance.

Tasks

1. Database Migration:

   • Create a MySQL database with the following schema:
     • github_issues
     • github_pull_requests
     • github_pull_requests_comments
     • github_signatures
   • Copy migration files from the Webhooks repository to this repository.
   • Update the connection string in the current repository to use the new database.

2. Webhook Implementation:

   • Implement a webhook handler for:
     • Pull requests
     • Pull request comments
   • Expose the webhook endpoint to receive and process events.

3. Clean-Up:

   • Drop tables in the old database once data migration is verified.
   • Remove the old processing code from the Webhooks repository.

4. Related Issue:

   • Address issue guibranco/webhooks#65 to ensure that related tasks are covered.

Expected Outcome

• The database processing code is successfully migrated to the current repository.
• The webhook feature is implemented and fully operational.
• The old repository is cleaned up by removing obsolete code and database tables.

Tech Notes

• Ensure that all migration scripts are tested thoroughly before deployment.
• Update documentation to reflect changes in the webhook handling and database schema.
• Verify that webhook events are correctly received and processed in the new setup.

[gitauto-ai[bot]]

Sorry, we have an error. Please try again.

Have feedback or need help? Feel free to email info@gitauto.ai.