1개 답변
- 최신
- 최다 투표
- 가장 많은 댓글
2
Some resources that can help you get started:
AWS IoT Core Developer Guide: https://docs.aws.amazon.com/iot/latest/developerguide/what-is-aws-iot.html AWS Lambda Developer Guide: https://docs.aws.amazon.com/lambda/latest/dg/welcome.html AWS SDK for Python (Boto3) Documentation: https://boto3.amazonaws.com/v1/documentation/api/latest/index.html
you can use a Lambda function to detect updates in your MySQL RDS table and publish messages to an IoT Core topic. Here's a high-level overview of the steps you can take:
- Set up an AWS Lambda function with an execution role that has permission to access your MySQL RDS database and IoT Core.
- In your Lambda function code, establish a connection to your MySQL RDS database and query for the relevant data (in this case, the 'Paused' column).
- Compare the current and previous values of the 'Paused' column to determine if it has changed.
- If the value has changed, publish a message to your IoT Core topic using the AWS IoT SDK for Python.
- You can format the message payload to include the new value of the 'Paused' column and the corresponding code number, as you described.
관련 콘텐츠
- 질문됨 7년 전
- 질문됨 14일 전