Is there a way to delete a platform from the command line?

10:20am May 15, 2013

#1

Building off of comment #8,

here's a drush script which will automatically add a delete task to hostmaster and delete all platforms with a certain name, which are older than 2 days.

We use this as part of our "lite" continuous integration approach (which runs entirely using shell scripts) http://community.aegirproject.org/discuss/our-zero-touch-build-setup-con...

cleanup.drush

#!/usr/bin/env drush

<?php

//Cleanup script to delete empty autogenerated platforms older than 2 days

//Provide the platform location via the command line
$platform_location = drush_shift();

$sql = "SELECT n.nid FROM hosting_platform AS p 
  INNER JOIN node AS n ON (p.nid=n.nid) 
  LEFT JOIN hosting_site AS s ON (p.nid=s.platform) 
  WHERE s.platform IS NULL AND n.created < (UNIX_TIMESTAMP() - 172800) AND p.publish_path LIKE '%%%s%%' AND p.status = 1;";

$result = db_query($sql, $platform_location);
while ($row = db_fetch_array($result)) {
  hosting_add_task($row['nid'], 'delete');
}

?>

Here's how to call it from the command line (make sure you're running it from a place where the @hostmaster context is available, like /var/aegir

cleanup.drush @hostmaster PREFIX

(where "PREFIX" is whatever name prefix you give your platforms that you want to automatically delete)

Login or register to post comments

drush fan

1:36pm May 15, 2013

#2

@Gmania

Pretty cool, thanks

Login or register to post comments

FMB

10:03pm Dec 7, 2013

#3

Thanks for sharing!

Login or register to post comments

Pol

7:35pm Mar 27, 2015

#6

I'm using this for Aegir 7.x-3.x, here's the code:

<?php
function hosting_cron_delete_platforms_cron() {

  $sql = "SELECT n.nid FROM hosting_platform AS p INNER JOIN node AS n ON (p.nid=n.nid) LEFT JOIN hosting_site AS s ON (p.nid=s.platform) WHERE s.platform IS NULL AND n.created < (UNIX_TIMESTAMP() - 86400) AND p.status = 1;";
  $result = db_query($sql);

  foreach($result as $row) {
    watchdog('hostmaster', 'Platform ' . $row->nid . ' will be deleted.');
    hosting_add_task($row->nid, 'delete');
  }

  $sql = "SELECT * FROM hosting_site_backups WHERE timestamp < (UNIX_TIMESTAMP() - 86400)";
  $result = db_query($sql);

  foreach($result as $row) {
    if (file_exists($row->filename)) {
      watchdog('hostmaster', 'Site backup ' . $row->filename . ' will be deleted.');
      hosting_add_task($row->site, 'backup-delete', array($row->filename));
      hosting_site_delete_backup($row->bid);
    }
  }
}
?>