Add ORCID to annotations where it's available

[kimrutherford]

In pombase/canto#2594 / 71e9c2ce28ae4185a46f940ce39af3764cd5fb51 Canto was changed to store the ORCID with annotations when they are created. Annotations created before that change in August 2022 don't have the ORCID attached so they won't be correctly attributed.

I'll write a short script to fill in the ORCID on annotations bases on who the session was assigned to when the annotation was made. The script will also need to to check if the session was in approval and then add the ORCID of the approver to annotations made after approval started.

Needed for:

• pombase/pombase-chado#787

[kimrutherford]

I've updated the comment because I hit submit by accident. I've also labelled this with high priority because I think it's good to get this fixed soon.

[kimrutherford]

I'm working on this a bit today. I plan to make a script that we can re-run as necessary. For example we'll need to re-run after completing this:

• pombase/canto#1269

[kimrutherford]

That's done now. The command is:

./script/canto_admin.pl --update-annotation-curators

I will run it over the weekend as it will cause a few minutes of Canto downtime.

[kimrutherford]

After testing this locally there are 59 unique ORCIDs attached to annotations. That's a good start.

[kimrutherford]

I will run it over the weekend as it will cause a few minutes of Canto downtime.

That's done now. We can re-run as needed once we add more ORCIDs of community curators.

Command:

./script/canto_admin.pl --update-annotation-curators

(in the Canto app directory: ~pomcur/apps/canto)