protected function loadPage() { $table = new PhabricatorProjectColumn(); $conn_r = $table->establishConnection('r'); $data = queryfx_all($conn_r, 'SELECT * FROM %T %Q %Q %Q', $table->getTableName(), $this->buildWhereClause($conn_r), $this->buildOrderClause($conn_r), $this->buildLimitClause($conn_r)); return $table->loadAllFromArray($data); }
<?php // Was PhabricatorEdgeConfig::TYPE_COLUMN_HAS_OBJECT $type_has_object = 44; $column = new PhabricatorProjectColumn(); $conn_w = $column->establishConnection('w'); $rows = queryfx_all($conn_w, 'SELECT src, dst FROM %T WHERE type = %d', PhabricatorEdgeConfig::TABLE_NAME_EDGE, $type_has_object); $cols = array(); foreach ($rows as $row) { $cols[$row['src']][] = $row['dst']; } $sql = array(); foreach ($cols as $col_phid => $obj_phids) { echo pht("Migrating column '%s'...", $col_phid) . "\n"; $column = id(new PhabricatorProjectColumn())->loadOneWhere('phid = %s', $col_phid); if (!$column) { echo pht("Column '%s' does not exist.", $col_phid) . "\n"; continue; } $sequence = 0; foreach ($obj_phids as $obj_phid) { $sql[] = qsprintf($conn_w, '(%s, %s, %s, %d)', $column->getProjectPHID(), $column->getPHID(), $obj_phid, $sequence++); } } echo pht('Inserting rows...') . "\n"; foreach (PhabricatorLiskDAO::chunkSQL($sql) as $chunk) { queryfx($conn_w, 'INSERT INTO %T (boardPHID, columnPHID, objectPHID, sequence) VALUES %Q', id(new PhabricatorProjectColumnPosition())->getTableName(), $chunk); } echo pht('Done.') . "\n";
<?php $table = new PhabricatorProjectColumn(); $conn_w = $table->establishConnection('w'); foreach (new LiskMigrationIterator($table) as $column) { $id = $column->getID(); echo pht('Adjusting column %d...', $id) . "\n"; if ($column->getSequence() == 0) { $properties = $column->getProperties(); $properties['isDefault'] = true; queryfx($conn_w, 'UPDATE %T SET properties = %s WHERE id = %d', $table->getTableName(), json_encode($properties), $id); } } echo pht('Done.') . "\n";