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 $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";