Dynamic supabase db test --db-url with preview branches?
Hi there! I built a small set of sql tests and am trying to automate it in our git flow. I have the github action to do so, however it only points to our develop supabase branch. So we hardcoded that connection string in our GH secrets, but now I am wondering what if a dev changes the schema, and it runs the tests but fails because we haven't applied the migration to our develop branch yet?
Is there a way to wait for supabase to generate a preview branch and then dynamically get that connection string to use in the test GH action? Or maybe this isn't a good idea from a QA perspective, but tests should fail from the POV of the current schema, which might not be pushed yet
Is there a way to wait for supabase to generate a preview branch and then dynamically get that connection string to use in the test GH action? Or maybe this isn't a good idea from a QA perspective, but tests should fail from the POV of the current schema, which might not be pushed yet