[Integration]: GitHub Integration

[ZoranPandovski]

The goal of this issue is to build a new handler that will utilize the GitHub REST API to connect MindsDB to GitHub. This integration will enable organizations and users on GitHub to use ML for issue estimations, labeling, projects recommendation, automation of comments on GitHub issues, proofreading of READMEs etc

Resources 💡

🏁 To get started, please refer to the following resources:

• 📚 Building Application Handler docs: This documentation will guide you through the process of building a custom handler for MindsDB. It contains essential information on the handler structure, methods, and best practices.

• 📖 GitHub REST API docs

• 👉 Twitter Handler: This existing handler connects MindsDB with the Twitter API, allowing users to automate tasks related to posting and analyzing tweets. You can use the Twitter Handler as a reference for building the Slack API integration.

• 👉 Binance API Handler: Another example of a successful MindsDB integration to the Binance API to make trade data available to use for model training and predictions.

Next Steps 🕵️‍♂️ 🕵️‍♀️

• You can familiarize yourself with the GitHub API.
• Create a new handler that connects MindsDB to GitHub.
• Implement the core features mentioned above.
• Thoroughly test the integration to ensure proper functionality.
• Submit a pull request with the new GitHub Integration handler.

Hackathon Issue 📢

MindsDB has organized a hackathon on Hashnode to bring ML to more applications.

Each hackathon issue can bring you rewards and prizes 🏆 .

Check out the MindsDB Hackathon rules on Hashnode!

The hashnode-hackhathon App integrations issues for HashnodeHackhathon Label

We are happy to welcome you on board! Please take a look at the rules below if you are participating in the HashnodeHackhathon.

1. We are not assigning this type of issue to anyone. Multiple contributors can work on this, or even better, you can create a team and work together. Join our Slack to discuss more details. We will merge the best-quality PR.

2. After you create your first PR in the MindsDB repository, please sign our CLA to become a MindsDB contributor. You can do that by leaving a comment in the Pull Request that contains the following: I have read the CLA Document and I hereby sign the CLA

Thank you for contributing to MindsDB 🐻 !

[khanjasir90]

@ZoranPandovski I am working on this issue! :)

[aia]

Wrote an initial implementation in #5474.

• GitHub Issues table for a given Repository
  • Support LIMIT
  • Support WHERE
  • Support ORDER BY
  • Support column selection

[aia]

Added issue INSERT support to the github_handler in #5655.

• GitHub Issues Table for a given Repository
  • Support INSERT
    • Support title, body, assignee, milestone, and labels columns

[ZoranPandovski]

Accepted the #5655 PR from @aia .

[ZoranPandovski]

@aia Feel free to add the new features in new PR

[aia]

Added Pull Requests table implementation in #5792.

• GitHub Pull Requests table for a given Repository
  • Support LIMIT
  • Support WHERE
  • Support ORDER BY
  • Support column selection