Wednesday 15 February 2012

sqlite - Migration Error When setting up rspec -



sqlite - Migration Error When setting up rspec -

i'm trying add together rspec testing app i've been working on. i've been next tutorial: http://everydayrails.com/2012/03/19/testing-series-rspec-models-factory-girl.html 2012, i'm sure done using rails 3. installed rspec , capybara, ran bundle, , ran rails g rspec:install. started writing test of question model below, , when ran rspec spec/models/question_spec.rb

i received error: migrations pending; run 'bin/rake db:migrate rails_env=test' resolve issue. tried run , received error 1 of previous migrations:

== changetesttypeinscores: migrating ========================================= -- change_column(:scores, :test_type, "boolean using cast(test_type boolean)") rake aborted! standarderror: error has occurred, , later migrations canceled: sqlite3::sqlexception: near "using": syntax error: create table "scores" ("id" integer primary key autoincrement not null, "test_type" boolean using cast(test_type boolean), "name" varchar(255), "created_at" datetime, "updated_at" datetime, "user_id" integer, "month" varchar(255), "year" varchar(255))

how can correctly set rspec without messing database, works fine otherwise?

rails_helper.rb:

env["rails_env"] ||= 'test' require 'spec_helper' require file.expand_path("../../config/environment", __file__) require 'rspec/rails' require 'capybara/rspec' activerecord::migration.check_pending!

.rspec:

--color --require spec_helper --require rails_helper --format documentation

question_spec.rb:

require 'spec_helper' describe question "has valid factory" "is invalid without body" "is invalid without answer" end

i assume there's issue changing :test_type in scores model boolean based on error, works great locally , on heroku, don't want mess database in order run tests. help appreciated.

update: added test.rb file:

config.active_record.maintain_test_schema = false

also, updated version of rails 4.1.6 after seeing many other related stack overflow issues. error:

/users/tambe257/.rvm/gems/ruby-2.0.0-p353/gems/activesupport-4.1.6/lib/active_support/dependencies.rb:241:in `load': cannot load such file -- /users/tambe257/programming/rails_projects/fast_track/spec/models/question.rb (loaderror)

it looks problem dependencies, i've been googling error no luck.

on update above added test.rb file, cleared things up:

config.active_record.maintain_test_schema = false

i getting (loaderror), due file name not beingness correct. when come in below, sure route , file name correct!

rspec spec/models/question_spec.rb

sqlite ruby-on-rails-4 rspec

No comments:

Post a Comment