[ckan-dev] one bulk query needed for data migration on thedatahub.org

Tue Sep 13 21:46:24 UTC 2011

One bulk query that we do need to do asap (form of data migration) is
something like:

UPDATE resource SET resource_type = "file" WHERE format not ILIKE "api/%"
UPDATE resource SET resource_type = "api" WHERE format ILIKE "api/%"

Alternative is to leave it and allow resource_type to be editable (at
the moment it isn't) -- probably do want to allow this to be editable
(but not by default and with a warning about editing ...)

Rufus