Commit28942f0

committed

send events on ownership transfer

1 parent823e87a commit28942f0Copy full SHA for 28942f0

File tree

+15

-10

lines changed

+15

-10

lines changed

Lines changed: 7 additions & 4 deletions

Some generated files are not rendered by default. Learn more aboutcustomizing how changed files appear on GitHub.

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -4,4 +4,4 @@ DROP TRIGGER IF EXISTS new_workspace_notify ON workspaces;`
`4`	`4`	`DROPFUNCTION IF EXISTS new_workspace_notify;`
`5`	`5`
`6`	`6`	`DROPTRIGGER IF EXISTS new_agent_notifyON workspace_agents;`
`7`		`-DROPFUNCTION new_agent_notify;`
	`7`	`+DROPFUNCTIONIF EXISTSnew_agent_notify;`

Lines changed: 7 additions & 5 deletions

Original file line number	Diff line number	Diff line change
`@@ -8,15 +8,18 @@ CREATE FUNCTION new_workspace_notify() RETURNS trigger`
`8`	`8`	`AS $$`
`9`	`9`	`DECLARE`
`10`	`10`	`BEGIN`
`11`		--- Write to the notification channel `new_workspace:owner_id`
`12`		`--- with the workspace id as the payload.`
`13`		`-PERFORM pg_notify('new_workspace:'\|\|NEW.owner_id,NEW.id::text);`
	`11`	`+-- Notify for new workspaces & ownership transfers`
	`12`	`+IF TG_OP='INSERT'OR (TG_OP='UPDATE'ANDNEW.owner_id<>OLD.owner_id) THEN`
	`13`	+-- Write to the notification channel `new_workspace:owner_id`
	`14`	`+-- with the workspace id as the payload.`
	`15`	`+PERFORM pg_notify('new_workspace:'\|\|NEW.owner_id,NEW.id::text);`
	`16`	`+END IF;`
`14`	`17`	`RETURN NEW;`
`15`	`18`	`END;`
`16`	`19`	`$$;`
`17`	`20`
`18`	`21`	`CREATETRIGGERnew_workspace_notify`
`19`		`-AFTER INSERTON workspaces`
	`22`	`+AFTER INSERTORUPDATEON workspaces`
`20`	`23`	`FOR EACH ROW`
`21`	`24`	`EXECUTE FUNCTION new_workspace_notify();`
`22`	`25`
`@@ -68,4 +71,3 @@ CREATE TRIGGER new_agent_notify`
`68`	`71`	`AFTER INSERTON workspace_agents`
`69`	`72`	`FOR EACH ROW`
`70`	`73`	`EXECUTE FUNCTION new_agent_notify();`
`71`		`-`

Comments

(0)