MySQL Automate

This workflow is designed for DevOps engineers, project managers, and team leads who want to streamline communication in their development processes. It is particularly beneficial for teams using Azure DevOps and DingTalk for notifications, allowing them to efficiently notify the right stakeholders about new pull requests.

This workflow addresses the challenge of ensuring that team members are promptly notified about new pull requests in Azure DevOps. By integrating with MySQL for user mapping, it ensures that notifications are sent to the correct DingTalk users, minimizing the risk of missed communications and enhancing collaboration within the team.

1. Receive Pull Request Notification: The workflow begins when a new pull request is created in Azure DevOps, triggering the ReceiveTfsPullRequestCreatedMessage webhook.
2. Load User Mapping: The LoadDingTalkAccountMap node queries the MySQL database to retrieve the mapping between Azure DevOps users and their corresponding DingTalk accounts.
3. Build Notification Message: The BuildDingTalkWebHookData node processes the pull request information and constructs a notification message. It replaces Azure user names with their DingTalk equivalents and includes mentions for reviewers.
4. Send Notification: The SendDingTalkMessageViaWebHook node sends the constructed message to the specified DingTalk group chat using the provided webhook URL.
5. Visualize Workflow: The Sticky Note node provides an overview of the workflow, including setup instructions and customization options.