Travis is failing with 'relation "experiments" does not exist'.

PecanProject / bety

Web-interface to the Biofuel Ecophysiological Traits and Yields Database (used by PEcAn and TERRA REF)

https://www.betydb.org

BSD 3-Clause "New" or "Revised" License

16 stars 38 forks source link

Travis is failing with 'relation "experiments" does not exist'. #501

Closed gsrohde closed 7 years ago

gsrohde commented 7 years ago

[x] Update test_structure.sql to match production_structure.sql.
[ ] Put a note in the documentation for upgrading the canonical (EBI) BETYdb Rails site that both production_structure.sql and test_structure.sql need to be updated whenever the database schema changes.

@robkooper Can you look at this when you get a chance. For now, I made a branch called travis_kludge which is like master with the experiments controllers removed. This makes Travis pass.

robkooper commented 7 years ago

Can you link to the failing build?

gsrohde commented 7 years ago

https://travis-ci.org/PecanProject/bety/builds/219465407

This is the first build on master that fails for this reason, I believe. The problem is that the file app/controllers/api/beta/experiments_controller.rb requires the experiments table to be there: On my own copy of BETYdb, if I remove the experiments table, RSpec will crash. If I then remove this file, RSpec will run again.

robkooper commented 7 years ago

Looks like that bundle exec rake db:structure:load does not create the experiments table?

gsrohde commented 7 years ago

Updated test_structure.sql. This can be closed but issue #544 is still a problem.