X-Git-Url: https://git.arvados.org/arvados.git/blobdiff_plain/6951a378515a726fa178e0d1554c72044a7f5f88..efcfd2cdc9a9ed6ab3af54e9a4e149d4bdf1f8d3:/services/api/app/models/user.rb diff --git a/services/api/app/models/user.rb b/services/api/app/models/user.rb index 78ec7bea1e..d944474712 100644 --- a/services/api/app/models/user.rb +++ b/services/api/app/models/user.rb @@ -10,7 +10,7 @@ class User < ArvadosModel has_many :api_client_authorizations validates(:username, format: { - with: /^[A-Za-z][A-Za-z0-9]*$/, + with: /\A[A-Za-z][A-Za-z0-9]*\z/, message: "must begin with a letter and contain only alphanumerics", }, uniqueness: true, @@ -144,33 +144,20 @@ class User < ArvadosModel # and perm_hash[:write] are true if this user can read and write # objects owned by group_uuid. def calculate_group_permissions - conn = ActiveRecord::Base.connection - self.class.transaction do - # Check whether the temporary view has already been created - # during this connection. If not, create it. - conn.exec_query 'SAVEPOINT check_permission_view' - begin - conn.exec_query('SELECT 1 FROM permission_view LIMIT 0') - rescue - conn.exec_query 'ROLLBACK TO SAVEPOINT check_permission_view' - sql = File.read(Rails.root.join('lib', 'create_permission_view.sql')) - conn.exec_query(sql) - ensure - conn.exec_query 'RELEASE SAVEPOINT check_permission_view' - end - end + install_view('permission') group_perms = {} - conn.exec_query('SELECT target_owner_uuid, max(perm_level) - FROM permission_view - WHERE user_uuid = $1 - AND target_owner_uuid IS NOT NULL - GROUP BY target_owner_uuid', - # "name" arg is a query label that appears in logs: - "group_permissions for #{uuid}", - # "binds" arg is an array of [col_id, value] for '$1' vars: - [[nil, uuid]], - ).rows.each do |group_uuid, max_p_val| + ActiveRecord::Base.connection. + exec_query('SELECT target_owner_uuid, max(perm_level) + FROM permission_view + WHERE user_uuid = $1 + AND target_owner_uuid IS NOT NULL + GROUP BY target_owner_uuid', + # "name" arg is a query label that appears in logs: + "group_permissions for #{uuid}", + # "binds" arg is an array of [col_id, value] for '$1' vars: + [[nil, uuid]], + ).rows.each do |group_uuid, max_p_val| group_perms[group_uuid] = PERMS_FOR_VAL[max_p_val.to_i] end Rails.cache.write "groups_for_user_#{self.uuid}", group_perms @@ -475,9 +462,9 @@ class User < ArvadosModel # Send admin notifications def send_admin_notifications - AdminNotifier.new_user(self).deliver + AdminNotifier.new_user(self).deliver_now if not self.is_active then - AdminNotifier.new_inactive_user(self).deliver + AdminNotifier.new_inactive_user(self).deliver_now end end @@ -502,7 +489,7 @@ class User < ArvadosModel if self.prefs_changed? if self.prefs_was.andand.empty? || !self.prefs_was.andand['profile'] profile_notification_address = Rails.configuration.user_profile_notification_address - ProfileNotifier.profile_created(self, profile_notification_address).deliver if profile_notification_address + ProfileNotifier.profile_created(self, profile_notification_address).deliver_now if profile_notification_address end end end