Scalr\Upgrade\Updates\Update20150610175922::run1 PHP Method

    protected function run1($stage)
    {
        $this->console->out('Updating `scaling_metrics`.`env_id`; Deleting broken records.');
        $this->db->Execute('UPDATE `scaling_metrics` SET `env_id` = NULL WHERE `env_id` = 0');
        $affected = $this->db->Affected_Rows();
        $this->console->out("Updated {$affected} metrics.");
        $this->db->Execute("\n            DELETE FROM scaling_metrics\n            WHERE env_id > 0 AND NOT EXISTS (\n                SELECT 1 FROM client_environments\n                WHERE client_environments.id = scaling_metrics.env_id\n            )\n        ");
        $affected = $this->db->Affected_Rows();
        $this->console->out("Deleted {$affected} outdated metrics.");
    }