/*
* Created on 2005-apr-25
*
* TODO To change the template for this generated file go to
* Window - Preferences - Java - Code Style - Code Templates
*/
package org.hibernate.test.filter;

import org.hibernate.Session;
import org.hibernate.cfg.Configuration;
import org.hibernate.cfg.Environment;
import org.hibernate.stat.QueryStatistics;
import org.hibernate.test.TestCase;

/**
*TestCase that shows that secondlevelcache and filters dont work together.
*
*The parameter to the filter is not passed on to the cache so we get false hits in it.
*
*/
public class FilterCacheBugTest extends TestCase {

   /**
    * @param x
    */
   public FilterCacheBugTest(String x) {
      super(x);
      // TODO Auto-generated constructor stub
   }

      
   public void testFilterCacheBug(){
      Session s = openSession();
      
      QueryStatistics qs = s.getSessionFactory()
      .getStatistics()
      .getQueryStatistics("from org.hibernate.test.filter.Order");
      
      
      s= openSession();
      s.enableFilter("region").setParameter("region","ABC");
      s.createQuery("from Order").setCacheable(true).list();
      assertEquals(0,qs.getCacheHitCount());
      
      
      s.enableFilter("region").setParameter("region","ABC");
      s.createQuery("from Order").setCacheable(true).list();
      assertEquals(1,qs.getCacheHitCount());
      
      
      s.enableFilter("region").setParameter("region","DEF");
      s.createQuery("from Order").setCacheable(true).list();
//      Setting filter to another value should make query run again but it fails with another cachehit (value will be 2)
      assertEquals(1,qs.getCacheHitCount());
      
      
      s.close();
   }
   
   protected void configure(Configuration cfg) {
      super.configure( cfg );
      cfg.setProperty( Environment.USE_QUERY_CACHE, "true" );
      cfg.setProperty( Environment.CACHE_REGION_PREFIX, "foo" );
      cfg.setProperty( Environment.USE_SECOND_LEVEL_CACHE, "true" );
      cfg.setProperty( Environment.GENERATE_STATISTICS, "true" );
   }
   
   /* (non-Javadoc)
    * @see org.hibernate.test.TestCase#getMappings()
    */
   protected String[] getMappings() {
      return new String[] {
            "filter/defs.hbm.xml",
            "filter/LineItem.hbm.xml",
            "filter/Order.hbm.xml",
            "filter/Product.hbm.xml",
            "filter/Salesperson.hbm.xml",
            "filter/Department.hbm.xml"
         };
   }


}