Page MenuHomePhabricator
Files F13957128

D15637.id.diff
No OneTemporary
Actions

D15637.id.diff
View Options

diff --git a/resources/sql/autopatches/20160406.columns.1.php b/resources/sql/autopatches/20160406.columns.1.php
new file mode 100644
--- /dev/null
+++ b/resources/sql/autopatches/20160406.columns.1.php
@@ -0,0 +1,84 @@
+<?php
+
+$table = new ManiphestTransaction();
+$conn_w = $table->establishConnection('w');
+
+foreach (new LiskMigrationIterator($table) as $xaction) {
+ $type = $xaction->getTransactionType();
+ $id = $xaction->getID();
+
+ // This is an old ManiphestTransaction::TYPE_COLUMN. It did not do anything
+ // on its own and was hidden from the UI, so we're just going to remove it.
+ if ($type == 'column') {
+ queryfx(
+ $conn_w,
+ 'DELETE FROM %T WHERE id = %d',
+ $table->getTableName(),
+ $id);
+ continue;
+ }
+
+ // This is an old ManiphestTransaction::TYPE_PROJECT_COLUMN. It moved
+ // tasks between board columns; we're going to replace it with a modern
+ // PhabricatorTransactions::TYPE_COLUMNS transaction.
+ if ($type == 'projectcolumn') {
+ try {
+ $new = $xaction->getNewValue();
+ if (!$new || !is_array($new)) {
+ continue;
+ }
+
+ $column_phids = idx($new, 'columnPHIDs');
+ if (!is_array($column_phids) || !$column_phids) {
+ continue;
+ }
+
+ $column_phid = head($column_phids);
+ if (!$column_phid) {
+ continue;
+ }
+
+ $board_phid = idx($new, 'projectPHID');
+ if (!$board_phid) {
+ continue;
+ }
+
+ $before_phid = idx($new, 'beforePHID');
+ $after_phid = idx($new, 'afterPHID');
+
+ $old = $xaction->getOldValue();
+ if ($old && is_array($old)) {
+ $from_phids = idx($old, 'columnPHIDs');
+ $from_phids = array_values($from_phids);
+ } else {
+ $from_phids = array();
+ }
+
+ $replacement = array(
+ 'columnPHID' => $column_phid,
+ 'boardPHID' => $board_phid,
+ 'fromColumnPHIDs' => $from_phids,
+ );
+
+ if ($before_phid) {
+ $replacement['beforePHID'] = $before_phid;
+ } else if ($after_phid) {
+ $replacement['afterPHID'] = $after_phid;
+ }
+
+ queryfx(
+ $conn_w,
+ 'UPDATE %T SET transactionType = %s, oldValue = %s, newValue = %s
+ WHERE id = %d',
+ $table->getTableName(),
+ PhabricatorTransactions::TYPE_COLUMNS,
+ 'null',
+ phutil_json_encode(array($replacement)),
+ $id);
+ } catch (Exception $ex) {
+ // If anything went awry, just move on.
+ }
+ }
+
+
+}

File Metadata

Mime Type
text/plain
Expires
Oct 15 2024, 8:40 AM (4 w, 6 d ago)
Storage Engine
blob
Storage Format
Encrypted (AES-256-CBC)
Storage Handle
6712108
Default Alt Text
D15637.id.diff (2 KB)

Event Timeline

Phabricator · Built by Phacility