[BioSQL-l] Re: [Bioperl-l] Error in loading into biosql database

[Yves Bastide]

Hilmar Lapp wrote:
[...]
> 
>     1) use PubMed instead of Medline if the latter is undef
> 
>     2) look-up references by CRC rather than dbxref (medline or pubmed)
> 
>     3) look-up, in this or any other order, by CRC, if not found by 
> medline, if not found by pubmed, omitting those look-ups where the key 
> value is undefined.
> 

Option 3).  The right order, if one is used, is first by ID 
(pubmed/medline), then CRC, as references fetched from different sources 
have their authors, location, title formatted differently.
(The Python code used here is, with old fields names:
   sql = "SELECT reference_id FROM reference WHERE reference_docid = %s"
   if medline:
       sql += " or reference_medline = %d"
)

> 
>     -hilmar

yves