Setup tables
- Create the following tables using the console:
Table name: notes
Columns:
id: Integer auto-increment
note: Text
Table name: note_revision
Columns:
id: Integer auto-increment
note: Text
note_id: Integer (foreign key to notes.id)
update_at: Timestamp, default `now()`
Setup AWS Lambda
Create a lambda function in AWS. This will be our webhook.
- Create a function.
- Select Python 3.6 as the runtime.
- Select "start from scratch".
- Add API gateway as a trigger.
- Add an API to API gateway.
- Add the code in
mutation.py
. The handler function of your lambda will be themutation.lambda_handler
. - Add the following enviroment variables in your lambda config:
ADMIN_SECRET
: this is the admin secret key you configured when you setup HGE.HGE_ENDPOINT
: the URL on which you HGE instance is running.
Add the trigger in Hasura GraphQL
- In events tab, add a trigger
- Select all insert, update, delete operations for the trigger.
- Paste the API endpoint of your AWS lambda as the webhook.