0636f8cf11
* chore: bump version to 2.23.2 and enhance team account creation - Updated application version from 2.23.1 to 2.23.2 in package.json. - Enhanced team account creation to support slugs for non-Latin names, including validation and UI updates. - Updated localization files to reflect new slug requirements and error messages. - Refactored related schemas and server actions to accommodate slug handling in team account creation and updates. * refactor: remove old trigger and function for adding current user to new account - Dropped the trigger "add_current_user_to_new_account" and the associated function from the database schema. - Updated permissions for the function public.create_team_account to ensure proper access control.
50 lines
1.7 KiB
PL/PgSQL
50 lines
1.7 KiB
PL/PgSQL
BEGIN;
|
|
create extension "basejump-supabase_test_helpers" version '0.0.6';
|
|
|
|
select plan(3);
|
|
|
|
--- Test the trigger_set_user_tracking function on accounts table
|
|
--- This test verifies that created_by and updated_by are properly set on insert
|
|
|
|
--- Create test users
|
|
select tests.create_supabase_user('user_tracking_test1', 'tracking1@example.com');
|
|
|
|
------------
|
|
--- Test accounts table user tracking triggers - INSERT
|
|
------------
|
|
|
|
-- Authenticate first to set JWT claims (for auth.uid() in triggers)
|
|
select makerkit.authenticate_as('user_tracking_test1');
|
|
|
|
-- Switch to service_role for INSERT (create_org_account policy was removed)
|
|
-- but JWT claims are preserved so auth.uid() still works in triggers
|
|
set local role service_role;
|
|
|
|
-- Test INSERT: created_by and updated_by should be set to current user
|
|
INSERT INTO public.accounts (name, is_personal_account, primary_owner_user_id)
|
|
VALUES ('User Tracking Test Account', false, tests.get_supabase_uid('user_tracking_test1'));
|
|
|
|
-- Switch back to authenticated for assertions
|
|
select makerkit.authenticate_as('user_tracking_test1');
|
|
|
|
SELECT ok(
|
|
(SELECT created_by = tests.get_supabase_uid('user_tracking_test1')
|
|
FROM public.accounts WHERE name = 'User Tracking Test Account'),
|
|
'accounts: created_by should be set to current user on insert'
|
|
);
|
|
|
|
SELECT ok(
|
|
(SELECT updated_by = tests.get_supabase_uid('user_tracking_test1')
|
|
FROM public.accounts WHERE name = 'User Tracking Test Account'),
|
|
'accounts: updated_by should be set to current user on insert'
|
|
);
|
|
|
|
SELECT ok(
|
|
(SELECT created_by = updated_by
|
|
FROM public.accounts WHERE name = 'User Tracking Test Account'),
|
|
'accounts: created_by should equal updated_by on insert'
|
|
);
|
|
|
|
SELECT * FROM finish();
|
|
|
|
ROLLBACK; |