We've ran into an issue where we have the db backed up, but migrations got out of sorts and as a result there are a lot of GraphQL queries in our frontend code that don't match up to the db relationships at all.
I'm new to the project, but it looks like people were just making changes in the Hasura console instead of via the CLI and committing migrations.
I'm going through and recreating relationships manually so they match up with the GraphQL queries in the frontend, but moving forward I'd like to ensure this doesn't happen again.
We'd also prefer to move everything from our Docker image on Heroku to Hasura Cloud if possible.
My question is:
Is there a standardized pattern for ensuring the db data, the db schema, and the Hasura [preferably Hasura Cloud] metadata are all version controlled?
Moreover, is there a way to enforce that pattern so other devs can't simply tweak things in Hasura Console and everything gets out of sync again.
Thank you so much in advance if you can help. ♂️