ModelSEED/Model-SEED-core — Issue #59: Indexing of fields in compound_alias
Author: samseaver
Created: 2011-10-18 21:09:49+00:00
State: open

I got a new problem which I wasn't getting before.

If my code tries to insert these two set of records:

'cpd00306','D-xylitol','nameTestModel.45632'
'cpd00306','D-Xylitol','nameTestModel.45632'

It will fail. This is a new error for me, and I'm not sure what I wasn't getting it before. I take it that the indexes for the compound_alias table disregard the case of the letters in the alias field.

I would like to insert a try/catch statement for these attempted duplicates, so that the code doesn't crash on me, is there an established code for this when trying to insert into the database?