bety

bety copied to clipboard

Provide a convenient method of adding SQL comments

2

Currently, updates to the database schema is effected primarily through the use of Rails migrations. This helps to ensure that different BETYdb database instances conform to the same database schema....

gsrohde

Import (sync) mechanism does not maintain database invariants.

2

The `load.bety.sh` script circumvents database triggers (which enforce constraints) by using doing `ALTER TABLE ${T} DISABLE TRIGGER ALL;` before adding new rows from the server being imported from. Re-enabling the...

gsrohde

The BETYdb Rails code for the Bulk Upload Wizard relies on compliance with the foreign-key constraints on the `trait_covariate_associations` table that ensure that the referred-to variables exist. Unfortunately, the `load.bety.sh`...

gsrohde

Covariate and Species edit pages and Covariate show page need to be re-styled

2

- [x] Covariates and Species edit pages and covariates show page have no left-margin and are hard to read. - [x] Fix edit pages - [x] Fix covariate show page...

gsrohde

The `normalize_whitespace` function treats NO-BREAK SPACE characters as white space on some systems in some configurations and ignores it on others. This can lead to the following problem: Several check...

gsrohde

Issue when creating new formats: Some variable information doesn't stick

4

I am noticing that when creating formats via BETYdb web often when defining a variable if you don't put in Name, Unit, Storage Type in at the right time, the...

serbinsh

* [x] Decide on names for customization templates and check them in (e.g. `terraref-application.yml`). * [x] Check in custom images referred to by customization templates. * [ ] Decide whether...

gsrohde

error in citations.url constraint

1

Trying to create a citation for the CLM technical manual http://www.cesm.ucar.edu/models/cesm1.0/clm/ and BETY's yelling at me that `Url is not a valid URL. Use a schema-qualified URL. To use arbitrary...

mdietze

Unhelpful error message for bulk upload

3

When the `trait_covariate_associations` table contains references to non-existent trait ids (CORRECTION: variable ids?; this table only refers to the variables table; see UPDATE below), the bulk upload will fail with...

gsrohde

orphaned treatments?

7

This search shows that there treatment_ids 1-10 exist in management_treatments, but 2-10 do not have referents in traits or yields. ``` sql select distinct treatment_id from managements_treatments order by treatment_id...

dlebauer