Joe Abley wrote:
Hey,
Perhaps someone who has stuck with the Domainz/Glazier testing for longer than me could tell me how to do this:
I want to update my contact details in all the domain records for which I am listed as technical contact. I don't have an accurate list of domains that fit that criteria; I just want to change _all_ of them.
In the old system, accomplishing this would be a case of performing a zone transfer, enumerating every possible domain I could be associated with, pulling the registry data for each domain in turn and discarding those that don't match a proscribed regular expression on the tech_contact field (or whatever it was called).
The other method of doing this, would be to send an email to the relevant support contact (4service(a)domainz, or soa(a)waikato), who would of handed the request on to myself or Rex, and we would have run one of our 'mass_modify' perl scripts that would open up every record in the database, inspect it, and modify it if needed.
Does the new system provide anything better than this?
Probably a piece of SQL that can do the same???
I have an inkling that holder_contact fields are normalised, but I don't think the tech contact fields are.
No idea, but the old system was so flat, that (.... thinking of a flat joke....)
If anybody can tell me an easy way to do this, I'd be keen to hear it.
Oh, ok. Send an email to Domainz, and they'll tell you if they can do it.... If they don't provide the interface for you to use, one of their people behind the scenes can probably come up with the appropriate SQL, and put your required changes into it.
[Interesting to note that this is a trivial exercise in the original InterNIC and RIPE database schemas, which featured published database keys for person/contact objects (NIC handles) and were designed more or less by accident twenty years ago :)]
Oh, a normalised data schema....
Geoff.
----------------------------------
Geoff Thompson