SoundSoftware Code Site

require File.dirname(__FILE__) + '/helper'

require File.dirname(__FILE__) + '/../init'

class PaginationTest < ActiveRecordTestCase

  fixtures :topics, :replies, :developers, :projects, :developers_projects

  class PaginationController < ActionController::Base

    if respond_to? :view_paths=

      self.view_paths = [ "#{File.dirname(__FILE__)}/../fixtures/" ]

    else

      self.template_root = [ "#{File.dirname(__FILE__)}/../fixtures/" ]

    end

    def simple_paginate

      @topic_pages, @topics = paginate(:topics)

      render :nothing => true

    end

    def paginate_with_per_page

      @topic_pages, @topics = paginate(:topics, :per_page => 1)

      render :nothing => true

    end

    def paginate_with_order

      @topic_pages, @topics = paginate(:topics, :order => 'created_at asc')

      render :nothing => true

    end

    def paginate_with_order_by

      @topic_pages, @topics = paginate(:topics, :order_by => 'created_at asc')

      render :nothing => true

    end

    def paginate_with_include_and_order

      @topic_pages, @topics = paginate(:topics, :include => :replies, :order => 'replies.created_at asc, topics.created_at asc')

      render :nothing => true

    end

    def paginate_with_conditions

      @topic_pages, @topics = paginate(:topics, :conditions => ["created_at > ?", 30.minutes.ago])

      render :nothing => true

    end

    def paginate_with_class_name

      @developer_pages, @developers = paginate(:developers, :class_name => "DeVeLoPeR")

      render :nothing => true

    end

    def paginate_with_singular_name

      @developer_pages, @developers = paginate()

      render :nothing => true

    end

    def paginate_with_joins

      @developer_pages, @developers = paginate(:developers, 

                                             :joins => 'LEFT JOIN developers_projects ON developers.id = developers_projects.developer_id',

                                             :conditions => 'project_id=1')        

      render :nothing => true

    end

    def paginate_with_join

      @developer_pages, @developers = paginate(:developers, 

                                             :join => 'LEFT JOIN developers_projects ON developers.id = developers_projects.developer_id',

                                             :conditions => 'project_id=1')        

      render :nothing => true

    end

    def paginate_with_join_and_count

      @developer_pages, @developers = paginate(:developers, 

                                             :join => 'd LEFT JOIN developers_projects ON d.id = developers_projects.developer_id',

                                             :conditions => 'project_id=1',

                                             :count => "d.id")        

      render :nothing => true

    end

    def paginate_with_join_and_group

      @developer_pages, @developers = paginate(:developers, 

                                             :join => 'INNER JOIN developers_projects ON developers.id = developers_projects.developer_id',

                                             :group => 'developers.id')

      render :nothing => true

    end

    def rescue_errors(e) raise e end

    def rescue_action(e) raise end

  end

  def setup

    @controller = PaginationController.new

    @request    = ActionController::TestRequest.new

    @response   = ActionController::TestResponse.new

    super

  end

  # Single Action Pagination Tests

  def test_simple_paginate

    get :simple_paginate

    assert_equal 1, assigns(:topic_pages).page_count

    assert_equal 3, assigns(:topics).size

  end

  def test_paginate_with_per_page

    get :paginate_with_per_page

    assert_equal 1, assigns(:topics).size

    assert_equal 3, assigns(:topic_pages).page_count

  end

  def test_paginate_with_order

    get :paginate_with_order

    expected = [topics(:futurama),

               topics(:harvey_birdman),

               topics(:rails)]

    assert_equal expected, assigns(:topics)

    assert_equal 1, assigns(:topic_pages).page_count

  end

  def test_paginate_with_order_by

    get :paginate_with_order

    expected = assigns(:topics)

    get :paginate_with_order_by

    assert_equal expected, assigns(:topics)  

    assert_equal 1, assigns(:topic_pages).page_count    

  end

  def test_paginate_with_conditions

    get :paginate_with_conditions

    expected = [topics(:rails)]

    assert_equal expected, assigns(:topics)

    assert_equal 1, assigns(:topic_pages).page_count

  end

  def test_paginate_with_class_name

    get :paginate_with_class_name

    assert assigns(:developers).size > 0

    assert_equal DeVeLoPeR, assigns(:developers).first.class

  end

  def test_paginate_with_joins

    get :paginate_with_joins

    assert_equal 2, assigns(:developers).size

    developer_names = assigns(:developers).map { |d| d.name }

    assert developer_names.include?('David')

    assert developer_names.include?('Jamis')

  end

  def test_paginate_with_join_and_conditions

    get :paginate_with_joins

    expected = assigns(:developers)

    get :paginate_with_join

    assert_equal expected, assigns(:developers)

  end

  def test_paginate_with_join_and_count

    get :paginate_with_joins

    expected = assigns(:developers)

    get :paginate_with_join_and_count

    assert_equal expected, assigns(:developers)

  end

  def test_paginate_with_include_and_order

    get :paginate_with_include_and_order

    expected = Topic.find(:all, :include => 'replies', :order => 'replies.created_at asc, topics.created_at asc', :limit => 10)

    assert_equal expected, assigns(:topics)

  end

  def test_paginate_with_join_and_group

    get :paginate_with_join_and_group

    assert_equal 2, assigns(:developers).size

    assert_equal 2, assigns(:developer_pages).item_count

    developer_names = assigns(:developers).map { |d| d.name }

    assert developer_names.include?('David')

    assert developer_names.include?('Jamis')

  end

end