add migration for cw_blocks, fixes #6378biest-6378

1 files changed, 20 insertions, 0 deletions

diff --git a/db/migrations/6.0.40_add_vips_module.php b/db/migrations/6.0.40_add_vips_module.php
index 8fa2d21..e01f071 100644
--- a/db/migrations/6.0.40_add_vips_module.php
+++ b/db/migrations/6.0.40_add_vips_module.php
@@ -291,6 +291,26 @@ class AddVipsModule extends Migration
             }
         }
 
+        // cw_blocks
+        $sql = 'UPDATE cw_blocks SET payload = :payload, chdate = :chdate WHERE id = :id';
+        $stmt = $db->prepare($sql);
+        $data = $db->query("SELECT id, payload FROM cw_blocks WHERE block_type = 'test'");
+
+        while ($row = $data->fetch(PDO::FETCH_ASSOC)) {
+            $payload = json_decode($row['payload'], true);
+
+            if ($payload && isset($assignment_id[$payload['assignment']])) {
+                $payload['assignment'] = $assignment_id[$payload['assignment']];
+
+                $values = [
+                    'id'          => $row['id'],
+                    'payload'     => json_encode($payload),
+                    'chdate'      => $now
+                ];
+                $stmt->execute($values);
+            }
+        }
+
         // statusgruppen
         $sql = 'INSERT INTO statusgruppen (statusgruppe_id, name, range_id, position, size, mkdate, chdate)
                 VALUES (:statusgruppe_id, :name, :range_id, :position, :size, :mkdate, :chdate)';