Local `db reset` & seeds with RLS
authCLIThe goal: I want to have one command to reset local supabase instance, run migrations and seed populate the database.
Note: This has to be one command (script is ok) that resets everything to "initial" state without any further manual steps so that I can imediatelly log-in to my app using known credentials.
The idea: Let's just use
The problem: I'm using row level security (RLS) like
What I tried: I could run
Note: This has to be one command (script is ok) that resets everything to "initial" state without any further manual steps so that I can imediatelly log-in to my app using known credentials.
The idea: Let's just use
supabase db resetThe problem: I'm using row level security (RLS) like
(owner_id = auth.uid())owner_idINSERT INTO auth.users (id, email, raw_user_meta_data, created_at) VALUES ( '25d62eed-4b9f-43cc-b942-6c433ac683a6'::uuid, 'john@example.com [blocked]', '{"email_confirmed": true}'::jsonb, now() );What I tried: I could run
supabase db reset --no-seedsupabase.auth.signUp({ email: ..., password: ... })
