Batch-update Heroku dataclip databases using js console

readme.md

If you have many dataclips pointing to a database, and upgrade that database to a different plan, those dataclips will continue pointing to the old database. This will show you how to update all of those dataclips to point to the new database.

Step 1. Log in to Heroku

• Go to https://dataclips.heroku.com
• Log in if prompted to

Step 2. Find heroku_resource_id for each databases

• Open up https://dataclips.heroku.com/api/v1/heroku_resources
• Search by heroku app name using Cmd+F. Resource ID should look something like [email protected]
• Record this ID for the databases you're transferring from and to.

Step 3. In JS console, get the list of dataclips to update

Replace [email protected] with the resource ID of the database you are moving away from.

var clips;
$.getJSON("https://dataclips.heroku.com/api/v1/clips", function(response) {
  clips = response.filter(function(clip) {
    return clip.heroku_resource_id === "[email protected]";
  });
  console.log("Found this many dataclips: " + clips.length);
});

Step 4. Update those dataclips to point to the new resource

Replace [email protected] with the resource ID of the new database.

var postData = JSON.stringify({
  heroku_resource_id: "[email protected]"
});
clips.forEach(function(clip) {
  var url = "https://dataclips.heroku.com/api/v1/clips/" + clip.slug + "/move";
  $.ajax({
    type: "POST",
    url: url,
    data: postData,
    success: function() {
      console.log("Migrated:" + clip.slug);
    }
  });
});