Sha256: 1ec0303bfb2b282560fe2a7d746b128a054f6b6e5a85cd546c432236eeb121db
Contents?: true
Size: 1.1 KB
Versions: 21
Compression:
Stored size: 1.1 KB
Contents
require 'jdbc_common' require 'db/postgres' class CreateSchema < ActiveRecord::Migration def self.up execute "CREATE SCHEMA test" execute "CREATE TABLE test.people (id serial, name text)" execute "INSERT INTO test.people (name) VALUES ('Alex')" execute "CREATE TABLE public.people (id serial, wrongname text)" end def self.down execute "DROP SCHEMA test CASCADE" execute "DROP TABLE people" end end class Person < ActiveRecord::Base establish_connection POSTGRES_CONFIG.merge(:schema_search_path => 'test,public') end class PostgresSchemaSearchPathTest < Test::Unit::TestCase def setup CreateSchema.up end def teardown CreateSchema.down end def test_columns assert_equal(%w{id name}, Person.column_names) end def test_find_right assert_not_nil Person.find_by_name("Alex") end def test_find_wrong assert_raise NoMethodError do Person.find_by_wrongname("Alex") end end def test_column_information assert Person.columns.map{|col| col.name}.include?("name") assert !Person.columns.map{|col| col.name}.include?("wrongname") end end
Version data entries
21 entries across 21 versions & 6 rubygems