require 'abstract_unit' class SchemaThing < ActiveRecord::Base end class SchemaAuthorizationTest < ActiveSupport::TestCase self.use_transactional_fixtures = false TABLE_NAME = 'schema_things' COLUMNS = [ 'id serial primary key', 'name character varying(50)' ] USERS = ['rails_pg_schema_user1', 'rails_pg_schema_user2'] def setup @connection = ActiveRecord::Base.connection @connection.execute "SET search_path TO '$user',public" set_session_auth USERS.each do |u| @connection.execute "CREATE ROLE #{u}" @connection.execute "CREATE SCHEMA AUTHORIZATION #{u}" set_session_auth u @connection.execute "CREATE TABLE #{TABLE_NAME} (#{COLUMNS.join(',')})" @connection.execute "INSERT INTO #{TABLE_NAME} (name) VALUES ('#{u}')" set_session_auth end end def teardown set_session_auth @connection.execute "RESET search_path" USERS.each do |u| @connection.execute "DROP SCHEMA #{u} CASCADE" @connection.execute "DROP ROLE #{u}" end end def test_schema_invisible assert_raise(ActiveRecord::StatementInvalid) do set_session_auth @connection.execute "SELECT * FROM #{TABLE_NAME}" end end def test_schema_uniqueness assert_nothing_raised do set_session_auth USERS.each do |u| set_session_auth u assert_equal u, @connection.select_value("SELECT name FROM #{TABLE_NAME} WHERE id = 1") set_session_auth end end end def test_sequence_schema_caching assert_nothing_raised do USERS.each do |u| set_session_auth u st = SchemaThing.new :name => 'TEST1' st.save! st = SchemaThing.new :id => 5, :name => 'TEST2' st.save! set_session_auth end end end private def set_session_auth auth = nil @connection.execute "SET SESSION AUTHORIZATION #{auth || 'default'}" end end