Postgres

#!/usr/bin/env ruby
 
require 'rubygems'
require 'dm-core'
 
class Zoo
  include DataMapper::Resource
  
  property :id, Serial
end
 
# DataMapper.setup(:default,   'sqlite3::memory:')
# DataMapper.setup(:secondary, 'sqlite3::memory:')

DataMapper.setup(:default,   'postgres://localhost/dm_core_repo1')
DataMapper.setup(:secondary, 'postgres://localhost/dm_core_repo2')
 
DataMapper.auto_migrate!
repository(:secondary) {
  DataMapper.auto_migrate!
}
 
repository(:default) do
  Zoo.create
end
 
repository(:secondary) { |r| puts Zoo.first(:repository => r).inspect }
# PostgresError: ERROR: relation "zoos" does not exist

Sqlite3

#!/usr/bin/env ruby

require 'rubygems'
require 'dm-core'

class Zoo
  include DataMapper::Resource
  
  property :id, Serial
end

DataMapper.setup(:default,   'sqlite3::memory:')
DataMapper.setup(:secondary, 'sqlite3::memory:')

DataMapper.auto_migrate!
repository(:secondary) {
  DataMapper.auto_migrate!
}

repository(:default) do
  Zoo.create
end

repository(:secondary) { |r| puts Zoo.first(:repository => r).inspect }