Contents

require 'test_helper'
require 'db/h2'

class H2OffsetTest < Test::Unit::TestCase

  class Persona < ActiveRecord::Base
  end

  class CreatePersonasTable < ActiveRecord::Migration
    def self.up
      create_table :personas do |t|
        t.string :firstname
        t.string :lastname
      end
    end

    def self.down
      drop_table :personas
    end
  end

  def setup
    CreatePersonasTable.up
    Persona.create(:firstname => "John",     :lastname => "Smith")
    Persona.create(:firstname => "Jill",     :lastname => "Smith")
    Persona.create(:firstname => "Joan",     :lastname => "Smith")
    Persona.create(:firstname => "Jason",    :lastname => "Smith")
    Persona.create(:firstname => "Jack",     :lastname => "Smith")
    Persona.create(:firstname => "Jenssen",  :lastname => "Smith")
    Persona.create(:firstname => "Joe",      :lastname => "Smith")
    Persona.create(:firstname => "Johanna",  :lastname => "Smith")
    Persona.create(:firstname => "James",    :lastname => "Smith")
    Persona.create(:firstname => "Jim",      :lastname => "Smith")
    Persona.create(:firstname => "Jody",     :lastname => "Smith")
  end

  def teardown
    CreatePersonasTable.down
  end

  def test_offset
    query = Arel::Table.new(:persons).skip(3)
    assert_nothing_raised do
      sql = query.to_sql
      assert_equal "SELECT LIMIT 3", sql[0..13], "SQL statement was not generated, properly"
    end
  end if ar_version('3.0')
  
end

Version data entries

1 entries across 1 versions & 1 rubygems

Version	Path
activerecord-jdbc-adapter-1.3.0.beta2	test/db/h2/offset_test.rb