search

PecanProject / BETYdb-YABA

Yet Another BETYdb API (for metadata upload)
BSD 3-Clause "New" or "Revised" License
5 stars 18 forks source link

Removed requirement for `design` column from experiments endpoint #35

Closed im-prakher closed 4 years ago

im-prakher commented 4 years ago

Fixed #32

KristinaRiemer commented 4 years ago

I'm getting this error when I run the curl statement for the experiments endpoint: 

{
  "Message": "(psycopg2.errors.UniqueViolation) duplicate key value violates unique constraint \"unique_name_per_species\""
}

Some more info about the error: 

yaba_api_1     | psycopg2.errors.NotNullViolation: null value in column "description" violates not-null constraint
yaba_api_1     | DETAIL:  Failing row contains (99000000025, MAC Season 8: Border , 2019-01-01, 2019-03-31, null, , 99000000036, 2020-03-05 17:50:18.732026, 2020-03-05 17:50:18.732026).
im-prakher commented 4 years ago

Sorry for catching up so late, got involved in some health issues but now I am fine. I think this will work now

dlebauer commented 4 years ago

@im-prakher could you please confirm that this makes the design column optional rather than removing it?

im-prakher commented 4 years ago

Yeah! I will look into this

On Thu 7 May, 2020, 3:27 AM David LeBauer, notifications@github.com wrote:

@im-prakher https://github.com/im-prakher could you please confirm that this makes the design column optional rather than removing it?

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/PecanProject/BETYdb-YABA/pull/35#issuecomment-624912380, or unsubscribe https://github.com/notifications/unsubscribe-auth/AKJGR5VQKQOTWJBLMHK2YC3RQHMLVANCNFSM4LAS2WWQ .

im-prakher commented 4 years ago

I have finally removed the requirement for the design column, earlier there was an issue with CSV format of experiments.csv now I have fixed it.