#!/bin/bash

PLATFORMS=$(drush @hostmaster sqlq "select c.name from hosting_context c JOIN hosting_platform p on c.nid = p.nid where p.nid NOT IN (SELECT platform FROM hosting_site WHERE status != '-2')" | grep -v name)

for platform in ${PLATFORMS[@]}; do
  echo "Deleting platform $platform"
  drush @hostmaster hosting-task @$platform delete
done