Contents

module PostgresqlTests
  def test_support_select_into_table_should_return_false
    # TODO: mock connection adapter?
    assert connection.support_select_into_table?
  end

  def blank_slate!
    connection.truncate('truncate_test', 'RESTART IDENTITY')
    assert_equal "0", connection.select_value("SELECT count(*) FROM truncate_test")
  end
  
  def test_truncate_should_not_reset_identity_by_default
    blank_slate!

    connection.execute("insert into truncate_test (x) values ('a')")
    connection.truncate('truncate_test')

    connection.execute("insert into truncate_test (x) values ('a')")
    # in this case the id should not be reset to 1
    assert_equal "2", connection.select_value("SELECT id FROM truncate_test")
  end
  
  def test_truncate_should_reset_identity_if_requested
    blank_slate!

    connection.execute("insert into truncate_test (x) values ('a')")
    connection.truncate('truncate_test', 'RESTART IDENTITY')

    connection.execute("insert into truncate_test (x) values ('a')")
    # when using RESTART IDENTITY the id should be reset to 1
    assert_equal "1", connection.select_value("SELECT id FROM truncate_test")
  end
  
end

Version data entries

3 entries across 3 versions & 1 rubygems

Version	Path
adapter_extensions-1.0.0	test/integration/postgresql_tests.rb
adapter_extensions-1.0.0.rc1	test/integration/postgresql_tests.rb
adapter_extensions-0.9.5	test/integration/postgresql_tests.rb