-- ҰൠϢʔβ SELECT tests.create_supabase_user ('sample_user', '
[email protected]', '555-555-5555'); -- ໊લͱϩʔϧΛมߋ͓ͯ͘͠ UPDATE profiles …; SELECT tests.authenticate_as ('sample_user'); SELECT plan (6); SELECT results_eq ('SELECT name::text FROM profiles', ARRAY['sample_user'], 'ࣗͷϓϩϑΟʔϧͷΈ͕ಡΈऔΕΔ͜ͱ'); -- roleΛมߋͰ͖ͳ͍͜ͱ PREPARE update_role_throw AS UPDATE profiles SET ROLE = 'admin' WHERE name = 'sample_user'; SELECT throws_ok ('update_role_throw', 'P0001', 'Updating "role" is not allowed', 'role ΛมߋͰ͖ͳ͍͜ͱ'); -- ໊લΛมߋͰ͖Δ͜ͱ UPDATE profiles SET name = 'updated_sample_user' WHERE name = 'sample_user'; SELECT results_eq ('SELECT name::text FROM profiles', ARRAY['updated_sample_user'], '໊લΛมߋͰ͖Δ͜ͱ'); packages/common/data/supabase/tests/profiles/ rls_test_as_user_role.sql αϯϓϧϢʔβͱͯ͠ೝূ Ϣʔβ͕ΞΫηεՄೳͳൣғΛݕূ αϯϓϧϢʔβΛ࡞