CustomMenuItemRepositoryImpl.java

package edu.ucsb.cs156.dining.repositories;

import edu.ucsb.cs156.dining.entities.MenuItem;
import edu.ucsb.cs156.dining.models.Entree;
import jakarta.persistence.EntityManager;
import jakarta.persistence.criteria.CriteriaBuilder;
import jakarta.persistence.criteria.CriteriaQuery;
import jakarta.persistence.criteria.JoinType;
import jakarta.persistence.criteria.Predicate;
import jakarta.persistence.criteria.Root;
import java.util.List;

/*
 * Custom repository implementation for MenuItem entity
 * Allows us to write a wider range of queries than those possible with Spring Data JPA
 */
public class CustomMenuItemRepositoryImpl implements CustomMenuItemRepository {

  private final EntityManager manager;

  public CustomMenuItemRepositoryImpl(EntityManager manager) {
    this.manager = manager;
  }

  @Override
  public List<MenuItem> findExistingEntrees(
      String diningCommonCode, String mealCode, List<Entree> entrees) {
    CriteriaBuilder cb = manager.getCriteriaBuilder();
    CriteriaQuery<MenuItem> cq = cb.createQuery(MenuItem.class);
    Root<MenuItem> mi = cq.from(MenuItem.class);
    mi.fetch("reviews", JoinType.LEFT);
    cq.select(mi)
        .distinct(true)
        .where(
            cb.and(
                cb.equal(mi.get("diningCommonsCode"), diningCommonCode),
                cb.equal(mi.get("mealCode"), mealCode),
                cb.or(
                    entrees.stream()
                        .map(
                            entree ->
                                cb.and(
                                    cb.equal(mi.get("name"), entree.getName()),
                                    cb.equal(mi.get("station"), entree.getStation())))
                        .toArray(Predicate[]::new))));

    return manager.createQuery(cq).getResultList();
  }
}