aboutsummaryrefslogtreecommitdiffstats
path: root/activerecord/test/cases
diff options
context:
space:
mode:
authorJuan M. Cuello <juanmacuello@gmail.com>2011-10-05 14:42:15 -0300
committerJuan M. Cuello <juanmacuello@gmail.com>2011-10-05 14:44:50 -0300
commitac659b8ed3d3a12f9cce67bf0eeacb4c231c2c08 (patch)
treec1c01b97d22be75223d823dba2055fdc7e1c635a /activerecord/test/cases
parentcfc95d89aeffba5a026afcf272bdf3ff231a8983 (diff)
downloadrails-ac659b8ed3d3a12f9cce67bf0eeacb4c231c2c08.tar.gz
rails-ac659b8ed3d3a12f9cce67bf0eeacb4c231c2c08.tar.bz2
rails-ac659b8ed3d3a12f9cce67bf0eeacb4c231c2c08.zip
refs #3232. Prepared statements and postgreSQL schemas.
Add tests for prepared statements with multiple schemas in postgreSQL.
Diffstat (limited to 'activerecord/test/cases')
-rw-r--r--activerecord/test/cases/adapters/postgresql/schema_test.rb19
1 files changed, 19 insertions, 0 deletions
diff --git a/activerecord/test/cases/adapters/postgresql/schema_test.rb b/activerecord/test/cases/adapters/postgresql/schema_test.rb
index 76c73e9dfa..b01eabc840 100644
--- a/activerecord/test/cases/adapters/postgresql/schema_test.rb
+++ b/activerecord/test/cases/adapters/postgresql/schema_test.rb
@@ -38,6 +38,10 @@ class SchemaTest < ActiveRecord::TestCase
set_table_name 'test_schema."Things"'
end
+ class Thing5 < ActiveRecord::Base
+ set_table_name 'things'
+ end
+
def setup
@connection = ActiveRecord::Base.connection
@connection.execute "CREATE SCHEMA #{SCHEMA_NAME} CREATE TABLE #{TABLE_NAME} (#{COLUMNS.join(',')})"
@@ -236,6 +240,21 @@ class SchemaTest < ActiveRecord::TestCase
end
end
+ def test_prepared_statements_with_multiple_schemas
+
+ @connection.schema_search_path = SCHEMA_NAME
+ Thing5.create(:id => 1, :name => "thing inside #{SCHEMA_NAME}", :email => "thing1@localhost", :moment => Time.now)
+
+ @connection.schema_search_path = SCHEMA2_NAME
+ Thing5.create(:id => 1, :name => "thing inside #{SCHEMA2_NAME}", :email => "thing1@localhost", :moment => Time.now)
+
+ @connection.schema_search_path = SCHEMA_NAME
+ assert_equal 1, Thing5.count
+
+ @connection.schema_search_path = SCHEMA2_NAME
+ assert_equal 1, Thing5.count
+ end
+
def test_schema_exists?
{
'public' => true,