BETYdb 4.18
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 thatsite_id
is unique in thesites_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.