Ip\Internal\Update\Migration::update_12 PHP Метод

    public static function update_12()
    {
        $table = ipTable('widgetInstance');
        $sql = "\n            UPDATE\n                {$table}\n            SET\n                `data` = concat('{\"cols\":[\"column', `widgetId`, '_1\",\"column', `widgetId`, '_2\"]}')\n            WHERE\n                `name` = 'Columns' AND\n                `data` not like '%\"cols\":%'\n            ";
        ipDb()->execute($sql);
        $allRecords = ipDb()->selectAll('widgetInstance', '*');
        foreach ($allRecords as $record) {
            $sql = "\n            UPDATE\n                {$table}\n            SET\n                `data` = REPLACE(`data`, 'column" . (int) $record['widgetId'] . "_', 'column" . (int) $record['id'] . "_')\n            WHERE\n                `name` = 'Columns'\n            ";
            ipDb()->execute($sql);
            $sql = "\n            UPDATE\n                {$table}\n            SET\n                `blockName` = REPLACE(`blockName`, 'column" . (int) $record['widgetId'] . "_', 'column" . (int) $record['id'] . "_')\n            WHERE\n                1\n            ";
            ipDb()->execute($sql);
        }
    }