function smtp_drush_sql_sync_sanitize in SMTP Authentication Support 7.2

Same name and namespace in other branches

1. 7 smtp.drush.inc \smtp_drush_sql_sync_sanitize()

Implements hook_sql_sync_sanitize().

File

./smtp.drush.inc, line 6

Code

function smtp_drush_sql_sync_sanitize($site) {

  // List of smtp variables to delete from database.
  $smtp_variables = array(
    'smtp_default_provider',
    'smtp_host',
    'smtp_hostbackup',
    'smtp_on',
    'smtp_password',
    'smtp_providers',
    'smtp_reroute_address',
    'smtp_username',
  );

  // Deletes listed smtp variables
  $sql = "DELETE FROM variable WHERE name IN ('" . implode("','", $smtp_variables) . "');";
  drush_sql_register_post_sync_op('smtp_variables', dt('Remove sensitive SMTP variables'), $sql);

  // Remove all selection criterias, because there will be no providers for them.
  $sql = 'DELETE FROM smtp_selection_criteria;';
  drush_sql_register_post_sync_op('smtp_variables', dt('Remove SMTP selection criterias'), $sql);

  // Also clears all mail queues.
  $sql = "DELETE FROM queue WHERE name IN ('smtp_send_queue', 'smtp_failure_queue');";
  drush_sql_register_post_sync_op('smtp_variables', dt('Remove items from SMTP queues'), $sql);

  // As all providers will be deleted, restore the default mail system.
  $sql = "DELETE FROM variable WHERE name = 'mail_system';";
  drush_sql_register_post_sync_op('smtp_mail_system', dt('Restore default Mail System'), $sql);
}