sqlite3 in test

rubyonrails-core
1

How can I setup sqlite3 backed database in test environment with the :memory: driver.

When I run rake test (or rake spec), of course I have no database file created, so there are no tables! rake test in the case of a :memory: backed database must first create the schema.

I seem to remember this was running a while back? thx

2

This list is for the development of Rails itself, so you may have better luck with these sorts of questions on rails-talk. That said,

How can I setup sqlite3 backed database in test environment with the :memory: driver.

# database.yml

development: &defaults   adapter: sqlite3   database: db/development.sqlite3   pool: 5   timeout: 5000

test:   <<: *defaults   database: ":memory:"

# test/test_helper.rb

if ":memory:" == ActiveRecord::Base.configurations[Rails.env]["database"]   ActiveRecord::Migration.verbose = false   load "db/schema.rb" end

This is on Rails 2.

~ j.