1 # Copyright (C) The Arvados Authors. All rights reserved.
3 # SPDX-License-Identifier: AGPL-3.0
5 require 'can_be_an_owner'
8 class Group < ArvadosModel
11 include CommonApiTemplate
15 # Posgresql JSONB columns should NOT be declared as serialized, Rails 5
16 # already know how to properly treat them.
17 attribute :properties, :jsonbHash, default: {}
19 validate :ensure_filesystem_compatible_name
20 validate :check_group_class
21 validate :check_filter_group_filters
22 before_create :assign_name
23 after_create :after_ownership_change
24 after_create :update_trash
26 before_update :before_ownership_change
27 after_update :after_ownership_change
29 after_create :add_role_manage_link
31 after_update :update_trash
32 before_destroy :clear_permissions_and_trash
34 api_accessible :user, extend: :common do |t|
45 def ensure_filesystem_compatible_name
46 # project and filter groups need filesystem-compatible names, but others
48 super if group_class == 'project' || group_class == 'filter'
52 if group_class != 'project' && group_class != 'role' && group_class != 'filter'
53 errors.add :group_class, "value must be one of 'project', 'role' or 'filter', was '#{group_class}'"
55 if group_class_changed? && !group_class_was.nil?
56 errors.add :group_class, "cannot be modified after record is created"
60 def check_filter_group_filters
61 if group_class == 'filter'
62 if !self.properties.key?("filters")
65 if !self.properties["filters"].is_a?(Array)
66 errors.add :properties, "filters property must be an array of arrays, each with 3 elements"
69 self.properties["filters"].each do |filter|
70 if !filter.is_a?(Array)
71 errors.add :properties, "filters property must be an array of arrays, each with 3 elements"
74 if filter.length() != 3
75 errors.add :properties, "filters property must be an array of arrays, each with 3 elements"
78 if !filter[0].include?(".") and filter[0].downcase != "uuid"
79 errors.add :properties, "filter attribute must be 'uuid' or contain a dot (e.g. groups.name)"
82 if (filter[0].downcase != "uuid" and filter[1].downcase == "is_a")
83 errors.add :properties, "when filter operator is 'is_a', attribute must be 'uuid'"
86 if ! ["=","<","<=",">",">=","!=","like","ilike","in","not in","is_a"].include?(filter[1].downcase)
87 errors.add :properties, "filter operator is not valid (must be =,<,<=,>,>=,!=,like,ilike,in,not in,is_a)"
95 if saved_change_to_trash_at? or saved_change_to_owner_uuid?
96 # The group was added or removed from the trash.
99 # Compute project subtree, propagating trash_at to subprojects
100 # Remove groups that don't belong from trash
101 # Add/update groups that do belong in the trash
103 temptable = "group_subtree_#{rand(2**64).to_s(10)}"
104 ActiveRecord::Base.connection.exec_query %{
105 create temporary table #{temptable} on commit drop
106 as select * from project_subtree_with_trash_at($1, LEAST($2, $3)::timestamp)
108 'Group.update_trash.select',
110 [nil, TrashedGroup.find_by_group_uuid(self.owner_uuid).andand.trash_at],
111 [nil, self.trash_at]]
113 ActiveRecord::Base.connection.exec_delete %{
114 delete from trashed_groups where group_uuid in (select target_uuid from #{temptable} where trash_at is NULL);
116 "Group.update_trash.delete"
118 ActiveRecord::Base.connection.exec_query %{
119 insert into trashed_groups (group_uuid, trash_at)
120 select target_uuid as group_uuid, trash_at from #{temptable} where trash_at is not NULL
121 on conflict (group_uuid) do update set trash_at=EXCLUDED.trash_at;
123 "Group.update_trash.insert"
127 def before_ownership_change
128 if owner_uuid_changed? and !self.owner_uuid_was.nil?
129 MaterializedPermission.where(user_uuid: owner_uuid_was, target_uuid: uuid).delete_all
130 update_permissions self.owner_uuid_was, self.uuid, REVOKE_PERM
134 def after_ownership_change
135 if saved_change_to_owner_uuid?
136 update_permissions self.owner_uuid, self.uuid, CAN_MANAGE_PERM
140 def clear_permissions_and_trash
141 MaterializedPermission.where(target_uuid: uuid).delete_all
142 ActiveRecord::Base.connection.exec_delete %{
143 delete from trashed_groups where group_uuid=$1
144 }, "Group.clear_permissions_and_trash", [[nil, self.uuid]]
149 if self.new_record? and (self.name.nil? or self.name.empty?)
150 self.name = self.uuid
155 def ensure_owner_uuid_is_permitted
156 if group_class == "role"
157 @requested_manager_uuid = nil
159 @requested_manager_uuid = owner_uuid
160 self.owner_uuid = system_user_uuid
163 if self.owner_uuid != system_user_uuid
164 raise "Owner uuid for role must be system user"
166 raise PermissionDeniedError unless current_user.can?(manage: uuid)
173 def add_role_manage_link
174 if group_class == "role" && @requested_manager_uuid
175 act_as_system_user do
176 Link.create!(tail_uuid: @requested_manager_uuid,
177 head_uuid: self.uuid,
178 link_class: "permission",