package tutorial;

import static org.junit.jupiter.api.Assertions.*;

import jakarta.persistence.*;
import org.hibernate.SessionFactory;
import org.junit.jupiter.api.Test;
import org.springframework.boot.test.context.SpringBootTest;
import org.springframework.transaction.annotation.Transactional;

@SpringBootTest
@Transactional
class LessonTest {

  @PersistenceContext
  EntityManager em;

  @Test
  void fetchJoinAvoidsExtraStatements() {
    for (long i = 1; i <= 3; i++) {
      var v = new Vehicle(i, "Vehicle " + i);
      em.persist(v);
      em.persist(new RecordEntry(i, v));
    }
    em.flush();
    em.clear();
    var stats = em
      .getEntityManagerFactory()
      .unwrap(SessionFactory.class)
      .getStatistics();
    stats.clear();
    var slow = em
      .createQuery(
        "select e from RecordEntry e order by e.id",
        RecordEntry.class
      )
      .getResultList();
    var names = slow
      .stream()
      .map(e -> e.vehicle.getName())
      .toList();
    assertEquals(3, names.size());
    assertEquals(4, stats.getPrepareStatementCount());
    em.clear();
    stats.clear();
    var fast = em
      .createQuery(
        "select e from RecordEntry e join fetch e.vehicle order by e.id",
        RecordEntry.class
      )
      .getResultList();
    assertEquals(
      names,
      fast
        .stream()
        .map(e -> e.vehicle.getName())
        .toList()
    );
    assertEquals(1, stats.getPrepareStatementCount());
  }
}
