mirror of
https://github.com/coder/coder.git
synced 2025-07-03 16:13:58 +00:00
This PR will ensure that optional fields are ignored when they are unset in user account related templates.
42 lines
1.7 KiB
SQL
42 lines
1.7 KiB
SQL
-- https://github.com/coder/coder/issues/14893
|
|
|
|
-- UserAccountSuspended
|
|
UPDATE notification_templates
|
|
SET
|
|
body_template = E'Hi {{.UserName}},\n\n' || -- Add a \n
|
|
E'User account **{{.Labels.suspended_account_name}}** has been suspended.\n\n' ||
|
|
-- Use the conventional initiator label:
|
|
E'The newly suspended account belongs to **{{.Labels.suspended_account_user_name}}** and was suspended by **{{.Labels.initiator}}**.'
|
|
WHERE
|
|
id = 'b02ddd82-4733-4d02-a2d7-c36f3598997d';
|
|
|
|
-- UserAccountActivated
|
|
UPDATE notification_templates
|
|
SET
|
|
body_template = E'Hi {{.UserName}},\n\n' || -- Add a \n
|
|
E'User account **{{.Labels.activated_account_name}}** has been activated.\n\n' ||
|
|
-- Use the conventional initiator label:
|
|
E'The newly activated account belongs to **{{.Labels.activated_account_user_name}}** and was activated by **{{.Labels.initiator}}**.'
|
|
WHERE
|
|
id = '9f5af851-8408-4e73-a7a1-c6502ba46689';
|
|
|
|
-- UserAccountCreated
|
|
UPDATE notification_templates
|
|
SET
|
|
body_template = E'Hi {{.UserName}},\n\n' ||
|
|
E'New user account **{{.Labels.created_account_name}}** has been created.\n\n' ||
|
|
-- Use the conventional initiator label:
|
|
E'This new user account was created for **{{.Labels.created_account_user_name}}** by **{{.Labels.initiator}}**.'
|
|
WHERE
|
|
id = '4e19c0ac-94e1-4532-9515-d1801aa283b2';
|
|
|
|
-- UserAccountDeleted
|
|
UPDATE notification_templates
|
|
SET
|
|
body_template = E'Hi {{.UserName}},\n\n' ||
|
|
E'User account **{{.Labels.deleted_account_name}}** has been deleted.\n\n' ||
|
|
-- Use the conventional initiator label:
|
|
E'The deleted account belonged to **{{.Labels.deleted_account_user_name}}** and was deleted by **{{.Labels.initiator}}**.'
|
|
WHERE
|
|
id = 'f44d9314-ad03-4bc8-95d0-5cad491da6b6';
|