CountryCodeUpdateTask.php

<?php

namespace Foo\Bar\Baz;

use SilverStripe\Dev\BuildTask;
use SilverStripe\ORM\DB;

/**
 * Class CountryCodeUpdateTask
 * @package Dynamic\Jasna\Tasks
 */
class CountryCodeUpdateTask extends BuildTask
{
    /**
     * @var string
     */
    protected $title = 'Country Code Update Task';

    /**
     * @var string
     */
    private static $segment = 'country-code-update-task';

    /**
     * Table and Column mapping for updating SS3 country codes to SS4 country codes (lower case)
     * [
     *   'MyFirstTable' => 'MyColumnName',
     * ]
     * @var array
     */
    private $update_mapping = [
        'MyTable' => 'MyCountryColumn',
    ];

    /**
     * @param \SilverStripe\Control\HTTPRequest $request
     */
    public function run($request)
    {
        $this->updateCountryCodes();
    }

    /**
     *
     */
    protected function updateCountryCodes()
    {
        foreach ($this->update_mapping as $table => $column) {
            $updateQuery = "UPDATE \"{$table}\" SET \"{$column}\" = LOWER(\"{$column}\")";
            DB::query($updateQuery);
        }
    }
}