<?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');

$toMigrate = [
    'params_motor' => [
        'program', 'commutation'
    ],
    'params_gear' => [
        'program', 'version'
    ],
    'params_controller' => [
        'program'
    ],
    'params_accessories' => [
        'program'
    ],
    'params_sensor' => [
        'program', 'output_signal', 'line_driver', 'steps_per_turn'
    ]
];

foreach($toMigrate as $table => $values) {
    echo $table . PHP_EOL . PHP_EOL;
    $results = $wpdb->get_results('SELECT * FROM ' . $table);
    $total = count($results);
    $counter = 0;
    foreach($results as $result) {
        $toUpdate = [];
        foreach($values as $name) {
            $toUpdate[$name] = prepareValue($result->{$name});
        }
        $wpdb->update($table, $toUpdate, [
           'id' => $result->id
        ]);
        $counter++;
        echo $counter . ' / ' . $total . PHP_EOL;
    }
    echo ' - complete' . PHP_EOL . PHP_EOL;
}