dbmigrate_clearing-event.php

Go to the documentation of this file.

<?php
/*
 SPDX-FileCopyrightText: © 2015 Siemens AG
 
 SPDX-License-Identifier: GPL-2.0-only
*/
 
echo "Ensure that every user had chosen an active group";
$dbManager->queryOnce('UPDATE users SET group_fk=gum.group_fk FROM group_user_member gum WHERE users.group_fk is null and user_pk=user_fk');
        
echo "Link decisions with groups\n";
$dbManager->queryOnce('UPDATE clearing_decision cd SET group_fk=u.group_fk FROM users u WHERE cd.user_fk=u.user_pk');
 
echo "Fill clearing event table with old decisions...";
$dbManager->queryOnce('
  INSERT INTO clearing_event (  uploadtree_fk,
  rf_fk,
  removed,
  user_fk,
  group_fk,
  job_fk,
  type_fk,
  comment,
  reportinfo,
  date_added)
  SELECT 
  cd.uploadtree_fk,
  cl.rf_fk,
  (0=1) removed,
  cd.user_fk,
  cd.group_fk,
  null job_fk,
  type_fk,
  cd.comment,
  cd.reportinfo,
  cd.date_added
  FROM clearing_decision cd, clearing_licenses cl
  WHERE cd.clearing_pk=cl.clearing_fk');
 
echo " and link them with decisions\n";
$dbManager->queryOnce('
  INSERT INTO clearing_decision_event
  SELECT cd.clearing_pk clearing_fk,ce.clearing_event_pk clearing_event_fk
  FROM clearing_decision cd, clearing_event ce
  WHERE cd.date_added=ce.date_added');