# frozen_string_literal: true

module FacultyRBAC
  class Group
    # RBAC-schema modifications
    module Modify
      def add_members(*users)
        _db[:rbac_user_group].insert_ignore.returning(:username).import(
          %i[username group_id],
          users.map { |user| [user.to_s, @id] }
        )
      end

      def own_members=(users)
        add_members(*users)
        usernames = Array(users).map(&:to_s)
        _db[:rbac_user_group].where(group_id: @id).exclude(username: usernames).delete
      end

      def remove_members(*users)
        usernames = users.map(&:to_s)
        _db[:rbac_user_group].where(username: usernames, group_id: @id).delete
      end

      def add_member_groups(*group_ids)
        _db[:rbac_group_group].insert_ignore.returning(:member_group_id).import(
          %i[member_group_id group_id],
          group_ids.map { |group_id| [group_id.to_i, @id] }
        )
      end

      def own_member_groups=(group_ids)
        add_member_groups(*group_ids)
        member_gids = Array(group_ids).map(&:to_i)
        _db[:rbac_group_group].where(group_id: @id).exclude(member_group_id: member_gids).delete
      end

      def remove_member_groups(*group_ids)
        member_gids = group_ids.map(&:to_i)
        _db[:rbac_group_group].where(member_group_id: member_gids, group_id: @id).delete
      end
    end
  end
end