function uc_shipping_update_7301 in Ubercart 7.3

Remove orphaned package and shipment records.

File

shipping/uc_shipping/uc_shipping.install, line 502

Install, update and uninstall functions for the uc_shipping module.

Code

function uc_shipping_update_7301() {
  $subquery = db_select('uc_orders', 'o')
    ->fields('o', array(
    'order_id',
  ));
  db_delete('uc_shipments')
    ->condition('order_id', $subquery, 'NOT IN')
    ->execute();
  db_delete('uc_packages')
    ->condition('order_id', $subquery, 'NOT IN')
    ->execute();
  $subquery = db_select('uc_packages', 'p')
    ->fields('p', array(
    'package_id',
  ));
  db_delete('uc_packaged_products')
    ->condition('package_id', $subquery, 'NOT IN')
    ->execute();
}