ass1-jpa/src/test/java/dst/ass1/jpa/tests/Ass1_3_3Test.java

   1 package dst.ass1.jpa.tests;
   2
   3 import static org.junit.Assert.assertEquals;
   4
   5 import javax.persistence.Query;
   6
   7 import org.junit.Test;
   8
   9 import dst.ass1.jpa.interceptor.SQLInterceptor;
  10 import dst.ass1.jpa.util.Constants;
  11
  12 public class Ass1_3_3Test extends Ass1_TestBase {
  13
  14     @Test
  15     public void sqlInterceptor_countsSelectsCorrectly() {
  16         em.getTransaction().begin();
  17         SQLInterceptor.resetCounter();
  18         assertEquals(0, SQLInterceptor.getSelectCount());
  19
  20         Query c = em.createQuery("select c from " + Constants.T_LECTURER + " c");
  21         c.getResultList();
  22
  23         assertEquals(1, SQLInterceptor.getSelectCount());
  24
  25         c = em.createQuery("select distinct c from " + Constants.T_LECTURER + " c");
  26         c.getResultList();
  27
  28         assertEquals(2, SQLInterceptor.getSelectCount());
  29
  30         c = em.createQuery("select e from " + Constants.T_LESSON + " e");
  31         c.getResultList();
  32         assertEquals(3, SQLInterceptor.getSelectCount());
  33     }
  34
  35 }