#!/bin/bash

cat > install/upgrade/php/delivery_option_1_6_1_21.php << EOF
<?php

function delivery_option_1_6_1_21()
{
    // Update each order with a number
    $result = Db::getInstance()->executeS('
        SELECT * 
        FROM '._DB_PREFIX_.'cart
        WHERE delivery_option LIKE "a:%"');
    foreach ($result as $row) {
        $delivery_option = Tools::unserialize($row['delivery_option']);
        $row['delivery_options'] = json_encode($row['delivery_option']);
        Db::getInstance()->execute('UPDATE '._DB_PREFIX_.'cart SET delivery_option = \''.pSQL($row['delivery_option']).'\' WHERE id_cart = '.(int)($row['id_cart']));
    }
}
EOF

cat >> install/upgrade/sql/1.6.1.21.sql << EOF
/ PHP:delivery_option_1_6_1_21(); /;
EOF