source UUID now available through API

[dthonon]

In GitLab by @fred.lpo07 on Apr 6, 2021, 00:12

Data UUIDs are now available in the faune-france API, they should be used preferably if available.

path: item #>> '{observers,0,uuid}'

[dthonon]

In fact, created UUID are stored in import.uuid_xref table. I am not sure this has been really used to transmit observations.

The pseudo_id_sighting in observations table is an encoding of the sightings id: encode(hmac(NEW.id::text, '{{ cfg.db_secret_key }}', 'sha1'), 'hex').

I propose to :

• Remove import.uuid_xref, if unused. To be confirmed.
• Keep pseudo_id_sighting as the identifier that can be exported to other parties.
• Add uuid from JSON

[dthonon]

mentioned in commit fd7f077