<?php

if( php_sapi_name() !== 'cli' ) {
    die("Meant to be run from command line");
}

if (!empty($argv[1])) {
    define('APPLICATION_ENV', $argv[1]);
} else {
    define('APPLICATION_ENV', 'production');
}

define( 'BASE_PATH', './public/' );
define('WP_USE_THEMES', false);
global $wp, $wp_query, $wp_the_query, $wp_rewrite, $wp_did_header, $wpdb;
require(BASE_PATH . 'wp-load.php');
require(BASE_PATH . 'wp-content/plugins/custom-search/custom-search.php');

$results = $wpdb->get_results('SELECT * FROM products p WHERE p.brand_id = 6');

foreach($results as $result) {
    $groups = json_decode($result->group, true);
    $update = false;

    foreach($groups as $key => $group) {
        foreach($group as $paramName => $dimension) {
            if ($dimension == 'KHz') {
                $groups[$key][$paramName] = 'kHz';
                $update = true;
            }
        }
    }

    if ($update) {
        $wpdb->update('products', [
            'group' => json_encode($groups)
        ], [
            'id' => $result->id
        ]);
    }
}

echo 'DONE' . PHP_EOL . PHP_EOL;