The dump.bety.sh script does the following:
dumps all data except:
traits or yields where access_level < 3 or checked = -1
runs and workflows contents (After implementing benchmarking, we will need to dump reference runs.)
sets user1 to carya/illinois with access_level =1, page_access_level = 1,
other users get access_level = 3, page_access_level = 4.
Users id's are preserved in order to allow admin to identify issues that are uncovered in anonymized version of db.
schema as .sql file, named after the most recent value in migrations table, to ensure that the data can be loaded (schema versions must match in order to sync)
each table exported as a csv file, and tar-zipped. (psql function '\copy')
You can sync a local instance of the BETYdb database with other instances. The load.bety.sh script will import data from other servers.
MYSITE=X REMOTESITE=Y load.bety.sh
This will set the number range based on the
(1,000,000,000 × MYSITE) to ((1,000,000,000 × (MYSITE + 1)) - 1)
Assigning a unique set of primary key values to each instance of BETYdb allows each distributed system to create new records that can later be shared, and to import new records from other databases. Ranges with no server listed are reserved but may not be deployed or are used offline.
Any changes to existing records should be done on the server that owns that record.
allocated primary key values
Energy Biosciences Institute / University of Illinois
Brookhaven National Lab
University of Wisconsin
TERRA MEPP UIUC
University of Arizona
10,000,000,001 - 11,000,000,000
Development / Virtual Machine
New users and 'feedback tab' submissions are sent to all users with Admin privileges (gh-56).
As of BETYdb v 4.1.3 it is possible to customize the user interface with project-specific design elements including. To do this, it is necessary to create a new file called
config/application.yml. Details are in config/application.template.yml. See also https://github.com/PecanProject/bety/issues/368).
Customizable elements include:
Database name and descriptions
Images found on the home page
Sponsor logos and links in footer
Database citation and data use policy
to get latest data, have to query each server (or can get full dump from one server, but this is as out of date as the last sync)
to edit data from records owned by another server, must edit on that server (or risk loosing this on next update)