REPP: domain details are missing admin and tech contact codes for old objects

[vohmar]

repp response:
"contacts": [
{
"code": null,
"type": "AdminDomainContact"
},
{
"code": null,
"type": "TechDomainContact"
}
],

code is null when the contact object's code has the old prefix 'CID' in front. CID was used as contact object prefix in previous registry system.
Registrant object does not have this issue.

[vohmar]

the problem is caused by empty value of contact_code_cache in domain_contacts table. The value is missing from older records about 70k records in production.

we have two options here

• stop using contact_code_cache and take the code from respective records in contacts table - this will impact performance
• fill the missing values with a script

latter one being the preferred approach

task: write db script that takes the contact codes from the contacts table and adds the value to the domain_contacts table where contact_code_cache is missing

[vohmar]

contact_code_cache is updated for all the records that did not have it set already, but there are about 3k records where the value of code_cache differs from the contact objects' one. Needs some research to see if it's a problem