GroupRepository.java

/*
 * Copyright (C) 2023 B3Partners B.V.
 *
 * SPDX-License-Identifier: MIT
 */
package org.tailormap.api.repository;

import java.util.Collection;
import java.util.List;
import java.util.Objects;
import java.util.Set;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.history.RevisionRepository;
import org.springframework.data.repository.query.Param;
import org.springframework.data.rest.core.annotation.RepositoryRestResource;
import org.tailormap.api.persistence.Group;
import org.tailormap.api.security.TailormapAdditionalProperty;

@RepositoryRestResource
public interface GroupRepository extends JpaRepository<Group, String>, RevisionRepository<Group, String, Long> {
  default List<TailormapAdditionalProperty> findAdditionalPropertiesByGroups(List<String> groups) {
    return this.findAllById(groups).stream()
        .map(Group::getAdditionalProperties)
        .filter(Objects::nonNull)
        .flatMap(List::stream)
        .map(p -> new TailormapAdditionalProperty(p.getKey(), p.getIsPublic(), p.getValue()))
        .toList();
  }

  @Query(
      "select g.aliasForGroup from Group g where g.name in :groups and g.aliasForGroup is not null and g.aliasForGroup <> ''")
  Set<String> findAliasesForGroups(@Param("groups") Collection<String> groups);
}