Implement /programs, /studies, /trials

[dlebauer]

• breeding program

  • one or more trials
  • one or more studies per trial, each study corresponds to a single location

• Program A Program can contain multiple Trials. A Trial can contain multiple Studies.

• Trial Corresponds to the "investigation" concept in MIAPPE (Minimal Information about a Plant Phenotyping Experiment).

• Study a phenotyping experiment conducted at a single geographic location. One Trial can have multiple studies conducted (e.g. multi location international trials).

What breeding programs do we have?

1. Sorghum Biomass Association Panel
2. Durum Wheat
3. Sorghum recombinant inbred lines

[robkooper]

@dlebauer how do these map to BETY?

[dlebauer]

Studies that map to the MIAPPE concept of the same name

create temporary table studies (
select 
  id as studyDbId,
  name as studyName,
  description as studyDescription,
  start_date as startDate,
  end_date as endDate
  design as statisticalDesign.description
  (today < end_date) as active #TRUE/FALSE
 from experiments);

Not sure how to join to locations schemas sitegroups_sites join sites join experiments_sites],

[dlebauer]

• generated inserts to link experiments with trials in contrib/studies.Rmd
• inserts as sql are here: https://gist.github.com/dlebauer/f96c5250b90d2f2d09ce03ccd3dea7ab
• the following has been applied to bety6

wget https://gist.githubusercontent.com/dlebauer/f96c5250b90d2f2d09ce03ccd3dea7ab/raw/4db4f8515c7eaeab7f3c288a0bbcdbd521db15e9/studies_inserts.sql
psql -U bety < studies_inserts.sql    

[robkooper]

studies is implemented, including germplasm and locations

[max-zilla]

implemented trials here: https://github.com/terraref/brapi/pull/33

[dlebauer]

these have all been implemented