[Apr 21] Hook App Sync app up to RDS data source

[ryanabooth]

Overview of tasks:

• [x] Set up Data API for the database
• [x] edit the existing app sync app's (web) data sources
• [x] make a new action with an RDS resolver
• [x] test the new endpoint in the playground

I got caught in the first step because I forgot the password of the Aurora database. 😆 We can reset it, or create a new database with a snapshot of the existing schema.

[ryanabooth]

@EricNguyen-B this is where we need to start:

• read through this and ask questions: https://docs.aws.amazon.com/appsync/latest/devguide/tutorial-rds-resolvers.html#enable-data-api
• this is the App Sync app we want to update: https://console.aws.amazon.com/appsync/home?region=us-east-1#/tsrn23zxs5ek5flg4we6speka4/v1/datasources
• this is our database https://us-east-2.console.aws.amazon.com/rds/home?region=us-east-2#database:id=righton-games-production-1-cluster;is-cluster=false

Start by reading through the tutorial and then let's chat about what to do. 😄

[ryanabooth]

@EricNguyen-B and I just finished setting up the data source and two resolvers. Thanks for adding the config and schema @maniramezan. Check it out in the App Sync query editor: https://console.aws.amazon.com/appsync/home?region=us-east-1#/fyjwr57bh5b2fji7ear7bwlxca/v1/queries