aboutsummaryrefslogblamecommitdiffstats
path: root/activerecord/test/query_cache_test.rb
blob: 12b52f6a35bc045423c04acbf4f7d63f86ca5219 (plain) (tree)
1
2
3
4
5
6
7
8
9
10



                        
                         
 
 
                                              

                          
                       
                                                    



                                  
                                                      

       


                                   
                                                  


       









                                             
 
                        
                 
                                            
                                                         
       
 
                               
                                                      

       



                                                                                                        

       

   
                                    
 
                                                    


                 




                                                        
                  






                                                   
       
                                               

     




                                                        



                  


                                                        



                          

                                                                      
 

                  



       
   
require 'abstract_unit'
require 'fixtures/topic'
require 'fixtures/reply'
require 'fixtures/task'
require 'fixtures/course'


class QueryCacheTest < ActiveSupport::TestCase
  fixtures :tasks, :topics

  def test_find_queries
    assert_queries(2) { Task.find(1); Task.find(1) }
  end

  def test_find_queries_with_cache
    Task.cache do
      assert_queries(1) { Task.find(1); Task.find(1) }
    end
  end

  def test_count_queries_with_cache
    Task.cache do
      assert_queries(1) { Task.count; Task.count }
    end
  end

  def test_query_cache_dups_results_correctly
    Task.cache do
      now  = Time.now.utc
      task = Task.find 1
      assert_not_equal now, task.starting
      task.starting = now
      task.reload
      assert_not_equal now, task.starting
    end
  end

  def test_cache_is_flat
    Task.cache do
      Topic.columns # don't count this query
      assert_queries(1) { Topic.find(1); Topic.find(1); }
    end

    ActiveRecord::Base.cache do
      assert_queries(1) { Task.find(1); Task.find(1) }
    end
  end

  def test_cache_does_not_wrap_string_results_in_arrays
    Task.cache do
      assert_instance_of String, Task.connection.select_value("SELECT count(*) AS count_all FROM tasks")
    end
  end
end

uses_mocha 'QueryCacheExpiryTest' do

class QueryCacheExpiryTest < ActiveSupport::TestCase
  fixtures :tasks

  def test_find
    Task.connection.expects(:clear_query_cache).times(1)

    assert !Task.connection.query_cache_enabled
    Task.cache do
      assert Task.connection.query_cache_enabled
      Task.find(1)

      Task.uncached do
        assert !Task.connection.query_cache_enabled
        Task.find(1)
      end

      assert Task.connection.query_cache_enabled
    end
    assert !Task.connection.query_cache_enabled
  end

  def test_update
    Task.connection.expects(:clear_query_cache).times(2)

    Task.cache do
      Task.find(1).save!
    end
  end

  def test_destroy
    Task.connection.expects(:clear_query_cache).times(2)

    Task.cache do
      Task.find(1).destroy
    end
  end

  def test_insert
    ActiveRecord::Base.connection.expects(:clear_query_cache).times(2)

    Task.cache do
      Task.create!
    end
  end
end

end