PecanProject/bety: BETYdb 4.14

Requested database changes; changes to the API

This release implements requested changes to the likelihoods table and fixes some problems with the API.

Changes Pertinent to PEcAn Users

Administrators need to do a database migration.

See "Database Changes" below.

Summary of Changes New Features

• The trait-insertion API now supports the use of a notes column in submitted CSV files.

Bug Fixes

• Issue #432 In API, 'associated <tablename> ids' should be removed or optional (off by default)

  Now, instead of a listing of all of the ids of associated rows in the associated table, a simple count of the number of associated rows is returned. (The option to get the associated ids if desired may be added at a later time.)

• Issue #456 Beta API response does not set charset setting in Content-Type header

  This bug showed up when a JSON API query was run in a browser and the results contained an item having a non-ASCII character. The character wasn't decoded properly as UTF-8. This has been fixed.

• Issue #461 Need "nicer" error handling when beta API data requests have a bad query string

  Fixed: The response will return the error in the requested format (XML or JSON).

• Issue #462 Need "unique_run_variable_input_combination" constraint to be removed

  In response to a user request, the included migration removes this constraint.

• Issue #463 schema change for likelihoods for more precision

  In response to a user request, all four likelihood columns of type numeric(10, 0) will be changed to floating-point type double precision by the included migration. There doesn't seem to be any advantage to preferring a numeric type to a float type for these columns.

• Issue #465 Some Rails tests depend on now-customizable portions of the Home page

  Now that many portions of the home page are customizable, tests that depend on seeing a certain textual item to test whether one is on the home page have been changed to a more robust method of testing for this.

Steps Needed for Upgrade Database Changes

Administrators need to do database migrations!

There is only one migration in this release. It affects only the likelihoods table, changing numeric types (which allowed only integral values) to floating-point types and removing a uniqueness constraint.

The database version for this release is 20161129192658.

Gem Installation

No new Gems need be installed.

Status of RSpec Tests

All non-pending tests pass when run in the default environment. (There is one pending test having to do with site-group editing permissions.) The tests can be run using the command

``` bundle exec rspec ```

Complete details for running the rspec tests are at https://pecan.gitbooks.io/betydb-documentation/content/automated_tests.html.