PHP Column::toArray方法代碼示例

 /**
  * Creates a column replacement, which has a quoted name.
  *
  * @param Column $column
  *
  * @return Column
  */
 private function createColumnReplacement(Column $column)
 {
     $columnConfig = $column->toArray();
     $columnConfig['platformOptions'] = $column->getPlatformOptions();
     $columnConfig['customSchemaOptions'] = $column->getCustomSchemaOptions();
     return new Column($this->platform->quoteIdentifier($column->getName()), $column->getType(), $columnConfig);
 }

 /**
  * @group DBAL-42
  */
 public function testColumnComment()
 {
     $column = new Column("bar", Type::getType('string'));
     $this->assertNull($column->getComment());
     $column->setComment("foo");
     $this->assertEquals("foo", $column->getComment());
     $columnArray = $column->toArray();
     $this->assertArrayHasKey('comment', $columnArray);
     $this->assertEquals('foo', $columnArray['comment']);
 }

 /**
  * Maps only needed definitions defined as __CLASS__ properties
  * @param Column $column
  */
 public function __construct(Column $column)
 {
     foreach ($column->toArray() as $type => $value) {
         if (array_key_exists($type, get_class_vars(__CLASS__))) {
             if ($value instanceof Type) {
                 $this->{$type} = $value->getName();
                 continue;
             }
             $this->{$type} = $value;
         }
     }
     return $this;
 }

 /**
  * Returns the SQL clause for creating a column in a table alteration.
  *
  * @param Column $column The column to add.
  *
  * @return string
  */
 protected function getAlterTableAddColumnClause(Column $column)
 {
     return 'ADD ' . $this->getColumnDeclarationSQL($column->getQuotedName($this), $column->toArray());
 }

 /**
  * Set the renamed columns on the table diff.
  *
  * @param  \Doctrine\DBAL\Schema\TableDiff  $tableDiff
  * @param  \Illuminate\Support\Fluent  $command
  * @param  \Doctrine\DBAL\Schema\Column  $column
  * @return \Doctrine\DBAL\Schema\TableDiff
  */
 protected function setRenamedColumns(TableDiff $tableDiff, Fluent $command, Column $column)
 {
     $newColumn = new Column($command->to, $column->getType(), $column->toArray());
     $tableDiff->renamedColumns = array($command->from => $newColumn);
     return $tableDiff;
 }

 /**
  * Returns the SQL clause for adding a default constraint in an ALTER TABLE statement.
  *
  * @param  string $tableName The name of the table to generate the clause for.
  * @param  Column $column    The column to generate the clause for.
  *
  * @return string
  */
 private function getAlterTableAddDefaultConstraintClause($tableName, Column $column)
 {
     $columnDef = $column->toArray();
     $columnDef['name'] = $column->getQuotedName($this);
     return 'ADD' . $this->getDefaultConstraintDeclarationSQL($tableName, $columnDef);
 }

 /**
  * Returns the difference between the fields $field1 and $field2.
  *
  * If there are differences this method returns $field2, otherwise the
  * boolean false.
  *
  * @param \Doctrine\DBAL\Schema\Column $column1
  * @param \Doctrine\DBAL\Schema\Column $column2
  *
  * @return array
  */
 public function diffColumn(Column $column1, Column $column2)
 {
     $properties1 = $column1->toArray();
     $properties2 = $column2->toArray();
     $changedProperties = array();
     foreach (array('type', 'notnull', 'unsigned', 'autoincrement') as $property) {
         if ($properties1[$property] != $properties2[$property]) {
             $changedProperties[] = $property;
         }
     }
     if ($properties1['default'] != $properties2['default'] || null === $properties1['default'] && null !== $properties2['default'] || null === $properties2['default'] && null !== $properties1['default']) {
         $changedProperties[] = 'default';
     }
     if ($properties1['type'] instanceof Types\StringType && !$properties1['type'] instanceof Types\GuidType || $properties1['type'] instanceof Types\BinaryType) {
         // check if value of length is set at all, default value assumed otherwise.
         $length1 = $properties1['length'] ?: 255;
         $length2 = $properties2['length'] ?: 255;
         if ($length1 != $length2) {
             $changedProperties[] = 'length';
         }
         if ($properties1['fixed'] != $properties2['fixed']) {
             $changedProperties[] = 'fixed';
         }
     } elseif ($properties1['type'] instanceof Types\DecimalType) {
         if (($properties1['precision'] ?: 10) != ($properties2['precision'] ?: 10)) {
             $changedProperties[] = 'precision';
         }
         if ($properties1['scale'] != $properties2['scale']) {
             $changedProperties[] = 'scale';
         }
     }
     // A null value and an empty string are actually equal for a comment so they should not trigger a change.
     if ($properties1['comment'] !== $properties2['comment'] && !(null === $properties1['comment'] && '' === $properties2['comment']) && !(null === $properties2['comment'] && '' === $properties1['comment'])) {
         $changedProperties[] = 'comment';
     }
     $customOptions1 = $column1->getCustomSchemaOptions();
     $customOptions2 = $column2->getCustomSchemaOptions();
     // Remove option-as-object
     foreach ($customOptions2 as $k => $v) {
         if (is_object($v)) {
             unset($customOptions2[$k]);
         }
     }
     foreach (array_merge(array_keys($customOptions1), array_keys($customOptions2)) as $key) {
         if (!array_key_exists($key, $properties1) || !array_key_exists($key, $properties2)) {
             $changedProperties[] = $key;
         } elseif ($properties1[$key] !== $properties2[$key]) {
             $changedProperties[] = $key;
         }
     }
     $platformOptions1 = $column1->getPlatformOptions();
     $platformOptions2 = $column2->getPlatformOptions();
     foreach (array_keys(array_intersect_key($platformOptions1, $platformOptions2)) as $key) {
         if ($properties1[$key] !== $properties2[$key]) {
             $changedProperties[] = $key;
         }
     }
     return array_unique($changedProperties);
 }

 /**
  * Returns the difference between the fields $field1 and $field2.
  *
  * If there are differences this method returns $field2, otherwise the
  * boolean false.
  *
  * @param \Doctrine\DBAL\Schema\Column $column1
  * @param \Doctrine\DBAL\Schema\Column $column2
  *
  * @return array
  */
 public function diffColumn(Column $column1, Column $column2)
 {
     $properties1 = $column1->toArray();
     $properties2 = $column2->toArray();
     $changedProperties = array();
     foreach (array('type', 'notnull', 'unsigned', 'autoincrement') as $property) {
         if ($properties1[$property] != $properties2[$property]) {
             $changedProperties[] = $property;
         }
     }
     if ($properties1['default'] != $properties2['default'] || null === $properties1['default'] && null !== $properties2['default'] || null === $properties2['default'] && null !== $properties1['default']) {
         $changedProperties[] = 'default';
     }
     if ($properties1['type'] instanceof Types\StringType || $properties1['type'] instanceof Types\BinaryType) {
         // check if value of length is set at all, default value assumed otherwise.
         $length1 = $properties1['length'] ?: 255;
         $length2 = $properties2['length'] ?: 255;
         if ($length1 != $length2) {
             $changedProperties[] = 'length';
         }
         if ($properties1['fixed'] != $properties2['fixed']) {
             $changedProperties[] = 'fixed';
         }
     } elseif ($properties1['type'] instanceof Types\DecimalType) {
         if (($properties1['precision'] ?: 10) != ($properties2['precision'] ?: 10)) {
             $changedProperties[] = 'precision';
         }
         if ($properties1['scale'] != $properties2['scale']) {
             $changedProperties[] = 'scale';
         }
     }
     // only allow to delete comment if its set to '' not to null.
     if ($properties1['comment'] !== null && $properties1['comment'] != $properties2['comment']) {
         $changedProperties[] = 'comment';
     }
     $customOptions1 = $column1->getCustomSchemaOptions();
     $customOptions2 = $column2->getCustomSchemaOptions();
     foreach (array_merge(array_keys($customOptions1), array_keys($customOptions2)) as $key) {
         if (!array_key_exists($key, $properties1) || !array_key_exists($key, $properties2)) {
             $changedProperties[] = $key;
         } elseif ($properties1[$key] !== $properties2[$key]) {
             $changedProperties[] = $key;
         }
     }
     $platformOptions1 = $column1->getPlatformOptions();
     $platformOptions2 = $column2->getPlatformOptions();
     foreach (array_keys(array_intersect_key($platformOptions1, $platformOptions2)) as $key) {
         if ($properties1[$key] !== $properties2[$key]) {
             $changedProperties[] = $key;
         }
     }
     return array_unique($changedProperties);
 }

 /**
  * Accept a column in a table
  *
  * @param Table  $table  a table object
  * @param Column $column a column object
  * 
  * @return void
  */
 public function acceptColumn(Table $table, Column $column)
 {
     $this->schemaArray['tables'][$table->getName()]['columns'][$column->getName()] = $column->toArray();
     $this->schemaArray['tables'][$table->getName()]['columns'][$column->getName()]['type'] = $column->getType()->getName();
 }