July 20, 2017 Software Open Access

PecanProject/bety: BETYdb 4.18

Scott Rohde; Carl Crott; David LeBauer; mulroony; Jeremy Kemball; Rob Kooper; Jimmy Chen; andrewshirk; Zhengqi Yang; Max Burnette; MarvinJ; phenolphtalein; Uday Saraf; The Gitter Badger; Michael Dietze; Chris Black

Implements API query of sites by geographical coordinates; fixes constraints and sequence numbering of sites_cultivars table Changes Pertinent to PEcAn Users

Administrators will need to do a database migration.

Summary of Changes New Features

• Querying sites by geographical coordinates

  It is now possibly to query sites by geographical coordinates. For example, a URL of the form [hostname]/api/beta/sites?containing=40.064,-88.195 will return the site or sites containing the point at latitude 40.064 and longitude -88.195.

Bug fixes

• Issue #521 (Two bugs in sites_cultivars)

  The migration SitesCultivarsUniqueness guarantees that site_id is unique in the sites_cultivars table. This means sites referenced by that table uniquely determine a cultivar.

Steps Needed for Upgrade Database Changes

Administrators will need to do a database migration.

The database version for this release is 20170712171513.

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.