Contents

require "test_helper"

class PostgresHelperTest < ActiveSupport::TestCase
  include Roomer::Helpers::PostgresHelper

  setup do
    @connection = ActiveRecord::Base.connection
  end

  test 'create schema' do
    assert_nothing_raised { create_schema("test_schema") }
    assert schemas.include? "test_schema"
  end

  test 'drop schema' do
    assert_nothing_raised { create_schema("old_test_schema") }
    assert schemas.include? "old_test_schema"
    assert_nothing_raised { drop_schema("old_test_schema") }
    assert !(schemas.include?("old_test_schema"))
  end

  test 'ensure prefix' do
    ActiveRecord::Base.table_name_prefix = "old_prefix_"
    ensure_prefix(:global) do
      assert_equal ActiveRecord::Base.table_name_prefix, "global."
    end
    assert_equal ActiveRecord::Base.table_name_prefix, "old_prefix_"
  end

  test 'ensure schema migrations' do
    create_schema("test_schema")
    ensure_prefix(:test_schema) do
      ensure_schema_migrations
      assert @connection.table_exists?(ActiveRecord::Migrator.schema_migrations_table_name) 
    end
  end

  test 'ensure schema' do
    assert_raises(ArgumentError) do
      ensuring_schema {}
    end

    assert_nothing_raised do
      assert !(schemas.include?("new_tenant"))
      ensuring_schema(:new_tenant) do
        assert schemas.include? "new_tenant"
        assert_equal ActiveRecord::Base.table_name_prefix, "new_tenant."
      end
    end
  end

  test 'ensure schema with capital letters in the name' do
    assert_nothing_raised do
      create_schema("Testschema")
      ensuring_schema("Testschema") do
        assert schemas.include? "Testschema"
        assert_equal ActiveRecord::Base.table_name_prefix, "Testschema."
      end
    end
  end

end

Version data entries

2 entries across 2 versions & 1 rubygems

Version	Path
roomer-1.0.1	test/roomer/helpers/postgres_helper_test.rb
roomer-1.0.0	test/roomer/helpers/postgres_helper_test.rb