PHP Schema\Identifier类代码示例

OGeek|极客世界-中国程序员成长平台 › 门户 › 编程› PHP›PHP编程经验

原作者: [db:作者] 来自: [db:来源] 收藏邀请

本文整理汇总了PHP中Doctrine\DBAL\Schema\Identifier类的典型用法代码示例。如果您正苦于以下问题：PHP Identifier类的具体用法？PHP Identifier怎么用？PHP Identifier使用的例子？那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。

在下文中一共展示了Identifier类的20个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于我们的系统推荐出更棒的PHP代码示例。

示例1: getSql

 public function getSql(Column $column, $table)
 {
     if (!$table instanceof Table) {
         $table = new Identifier($table);
     }
     $sql = array();
     $normalized = $column->getType()->getNormalizedPostGISColumnOptions($column->getCustomSchemaOptions());
     $srid = $normalized['srid'];
     // PostGIS 1.5 uses -1 for undefined SRID's
     if ($srid <= 0) {
         $srid = -1;
     }
     $type = strtoupper($normalized['geometry_type']);
     if ('ZM' === substr($type, -2)) {
         $dimension = 4;
         $type = substr($type, 0, -2);
     } elseif ('M' === substr($type, -1)) {
         $dimension = 3;
     } elseif ('Z' === substr($type, -1)) {
         $dimension = 3;
         $type = substr($type, 0, -1);
     } else {
         $dimension = 2;
     }
     // Geometry columns are created by the AddGeometryColumn stored procedure
     $sql[] = sprintf("SELECT AddGeometryColumn('%s', '%s', %d, '%s', %d)", $table->getName(), $column->getName(), $srid, $type, $dimension);
     if ($column->getNotnull()) {
         // Add a NOT NULL constraint to the field
         $sql[] = sprintf('ALTER TABLE %s ALTER %s SET NOT NULL', $table->getQuotedName($this->platform), $column->getQuotedName($this->platform));
     }
     return $sql;
 }

开发者ID:novikovsergey，项目名称:doctrine-postgis，代码行数:32，代码来源:SpatialColumnSqlGenerator.php

示例2: getAlterTableSQL

 /**
  * {@inheritDoc}
  */
 public function getAlterTableSQL(TableDiff $diff)
 {
     $sql = array();
     $commentsSQL = array();
     $columnSql = array();
     foreach ($diff->addedColumns as $column) {
         if ($this->onSchemaAlterTableAddColumn($column, $diff, $columnSql)) {
             continue;
         }
         $query = 'ADD ' . $this->getColumnDeclarationSQL($column->getQuotedName($this), $column->toArray());
         $sql[] = 'ALTER TABLE ' . $diff->getName()->getQuotedName($this) . ' ' . $query;
         if ($comment = $this->getColumnComment($column)) {
             $commentsSQL[] = $this->getCommentOnColumnSQL($diff->name, $column->getName(), $comment);
         }
     }
     foreach ($diff->removedColumns as $column) {
         if ($this->onSchemaAlterTableRemoveColumn($column, $diff, $columnSql)) {
             continue;
         }
         $query = 'DROP ' . $column->getQuotedName($this);
         $sql[] = 'ALTER TABLE ' . $diff->getName()->getQuotedName($this) . ' ' . $query;
     }
     foreach ($diff->changedColumns as $columnDiff) {
         /** @var $columnDiff \Doctrine\DBAL\Schema\ColumnDiff */
         if ($this->onSchemaAlterTableChangeColumn($columnDiff, $diff, $columnSql)) {
             continue;
         }
         if ($this->isUnchangedBinaryColumn($columnDiff)) {
             continue;
         }
         $oldColumnName = $columnDiff->getOldColumnName()->getQuotedName($this);
         $column = $columnDiff->column;
         if ($columnDiff->hasChanged('type') || $columnDiff->hasChanged('precision') || $columnDiff->hasChanged('scale')) {
             $type = $column->getType();
             // here was a server version check before, but DBAL API does not support this anymore.
             $query = 'ALTER ' . $oldColumnName . ' TYPE ' . $type->getSqlDeclaration($column->toArray(), $this);
             $sql[] = 'ALTER TABLE ' . $diff->getName()->getQuotedName($this) . ' ' . $query;
         }
         if ($columnDiff->hasChanged('default') || $columnDiff->hasChanged('type')) {
             $defaultClause = null === $column->getDefault() ? ' DROP DEFAULT' : ' SET' . $this->getDefaultValueDeclarationSQL($column->toArray());
             $query = 'ALTER ' . $oldColumnName . $defaultClause;
             $sql[] = 'ALTER TABLE ' . $diff->getName()->getQuotedName($this) . ' ' . $query;
         }
         if ($columnDiff->hasChanged('notnull')) {
             $query = 'ALTER ' . $oldColumnName . ' ' . ($column->getNotNull() ? 'SET' : 'DROP') . ' NOT NULL';
             $sql[] = 'ALTER TABLE ' . $diff->getName()->getQuotedName($this) . ' ' . $query;
         }
         if ($columnDiff->hasChanged('autoincrement')) {
             if ($column->getAutoincrement()) {
                 // add autoincrement
                 $seqName = $this->getIdentitySequenceName($diff->name, $oldColumnName);
                 $sql[] = "CREATE SEQUENCE " . $seqName;
                 $sql[] = "SELECT setval('" . $seqName . "', (SELECT MAX(" . $oldColumnName . ") FROM " . $diff->getName()->getQuotedName($this) . "))";
                 $query = "ALTER " . $oldColumnName . " SET DEFAULT nextval('" . $seqName . "')";
                 $sql[] = "ALTER TABLE " . $diff->getName()->getQuotedName($this) . " " . $query;
             } else {
                 // Drop autoincrement, but do NOT drop the sequence. It might be re-used by other tables or have
                 $query = "ALTER " . $oldColumnName . " " . "DROP DEFAULT";
                 $sql[] = "ALTER TABLE " . $diff->getName()->getQuotedName($this) . " " . $query;
             }
         }
         if ($columnDiff->hasChanged('comment')) {
             $commentsSQL[] = $this->getCommentOnColumnSQL($diff->name, $column->getName(), $this->getColumnComment($column));
         }
         if ($columnDiff->hasChanged('length')) {
             $query = 'ALTER ' . $column->getName() . ' TYPE ' . $column->getType()->getSqlDeclaration($column->toArray(), $this);
             $sql[] = 'ALTER TABLE ' . $diff->getName()->getQuotedName($this) . ' ' . $query;
         }
     }
     foreach ($diff->renamedColumns as $oldColumnName => $column) {
         if ($this->onSchemaAlterTableRenameColumn($oldColumnName, $column, $diff, $columnSql)) {
             continue;
         }
         $oldColumnName = new Identifier($oldColumnName);
         $sql[] = 'ALTER TABLE ' . $diff->getName()->getQuotedName($this) . ' RENAME COLUMN ' . $oldColumnName->getQuotedName($this) . ' TO ' . $column->getQuotedName($this);
     }
     $tableSql = array();
     if (!$this->onSchemaAlterTable($diff, $tableSql)) {
         if ($diff->newName !== false) {
             $sql[] = 'ALTER TABLE ' . $diff->getName()->getQuotedName($this) . ' RENAME TO ' . $diff->getNewName()->getQuotedName($this);
         }
         $sql = array_merge($this->getPreAlterTableIndexForeignKeySQL($diff), $sql, $this->getPostAlterTableIndexForeignKeySQL($diff), $commentsSQL);
     }
     return array_merge($sql, $tableSql, $columnSql);
 }

开发者ID:tamboer，项目名称:LaravelOctober，代码行数:88，代码来源:PostgreSqlPlatform.php

示例3: getPostAlterTableIndexForeignKeySQL

 /**
  * @param \Doctrine\DBAL\Schema\TableDiff $diff
  *
  * @return array
  */
 protected function getPostAlterTableIndexForeignKeySQL(TableDiff $diff)
 {
     $tableName = false !== $diff->newName ? $diff->getNewName()->getQuotedName($this) : $diff->getName()->getQuotedName($this);
     $sql = array();
     if ($this->supportsForeignKeyConstraints()) {
         foreach ($diff->addedForeignKeys as $foreignKey) {
             $sql[] = $this->getCreateForeignKeySQL($foreignKey, $tableName);
         }
         foreach ($diff->changedForeignKeys as $foreignKey) {
             $sql[] = $this->getCreateForeignKeySQL($foreignKey, $tableName);
         }
     }
     foreach ($diff->addedIndexes as $index) {
         $sql[] = $this->getCreateIndexSQL($index, $tableName);
     }
     foreach ($diff->changedIndexes as $index) {
         $sql[] = $this->getCreateIndexSQL($index, $tableName);
     }
     foreach ($diff->renamedIndexes as $oldIndexName => $index) {
         $oldIndexName = new Identifier($oldIndexName);
         $sql = array_merge($sql, $this->getRenameIndexSQL($oldIndexName->getQuotedName($this), $index, $tableName));
     }
     return $sql;
 }

开发者ID:aleguisf，项目名称:fvdev1，代码行数:29，代码来源:AbstractPlatform.php

示例4: getAlterTableSQL

 /**
  * {@inheritDoc}
  */
 public function getAlterTableSQL(TableDiff $diff)
 {
     $sql = array();
     $commentsSQL = array();
     $columnSql = array();
     $fields = array();
     foreach ($diff->addedColumns as $column) {
         if ($this->onSchemaAlterTableAddColumn($column, $diff, $columnSql)) {
             continue;
         }
         $fields[] = $this->getColumnDeclarationSQL($column->getQuotedName($this), $column->toArray());
         if ($comment = $this->getColumnComment($column)) {
             $commentsSQL[] = $this->getCommentOnColumnSQL($diff->name, $column->getName(), $comment);
         }
     }
     if (count($fields)) {
         $sql[] = 'ALTER TABLE ' . $diff->getName()->getQuotedName($this) . ' ADD (' . implode(', ', $fields) . ')';
     }
     $fields = array();
     foreach ($diff->changedColumns as $columnDiff) {
         if ($this->onSchemaAlterTableChangeColumn($columnDiff, $diff, $columnSql)) {
             continue;
         }
         /* @var $columnDiff \Doctrine\DBAL\Schema\ColumnDiff */
         $column = $columnDiff->column;
         // Do not generate column alteration clause if type is binary and only fixed property has changed.
         // Oracle only supports binary type columns with variable length.
         // Avoids unnecessary table alteration statements.
         if ($column->getType() instanceof BinaryType && $columnDiff->hasChanged('fixed') && count($columnDiff->changedProperties) === 1) {
             continue;
         }
         $columnHasChangedComment = $columnDiff->hasChanged('comment');
         /**
          * Do not add query part if only comment has changed
          */
         if (!($columnHasChangedComment && count($columnDiff->changedProperties) === 1)) {
             $columnInfo = $column->toArray();
             if (!$columnDiff->hasChanged('notnull')) {
                 $columnInfo['notnull'] = false;
             }
             $fields[] = $column->getQuotedName($this) . $this->getColumnDeclarationSQL('', $columnInfo);
         }
         if ($columnHasChangedComment) {
             $commentsSQL[] = $this->getCommentOnColumnSQL($diff->name, $column->getName(), $this->getColumnComment($column));
         }
     }
     if (count($fields)) {
         $sql[] = 'ALTER TABLE ' . $diff->getName()->getQuotedName($this) . ' MODIFY (' . implode(', ', $fields) . ')';
     }
     foreach ($diff->renamedColumns as $oldColumnName => $column) {
         if ($this->onSchemaAlterTableRenameColumn($oldColumnName, $column, $diff, $columnSql)) {
             continue;
         }
         $oldColumnName = new Identifier($oldColumnName);
         $sql[] = 'ALTER TABLE ' . $diff->getName()->getQuotedName($this) . ' RENAME COLUMN ' . $oldColumnName->getQuotedName($this) . ' TO ' . $column->getQuotedName($this);
     }
     $fields = array();
     foreach ($diff->removedColumns as $column) {
         if ($this->onSchemaAlterTableRemoveColumn($column, $diff, $columnSql)) {
             continue;
         }
         $fields[] = $column->getQuotedName($this);
     }
     if (count($fields)) {
         $sql[] = 'ALTER TABLE ' . $diff->getName()->getQuotedName($this) . ' DROP (' . implode(', ', $fields) . ')';
     }
     $tableSql = array();
     if (!$this->onSchemaAlterTable($diff, $tableSql)) {
         if ($diff->newName !== false) {
             $sql[] = 'ALTER TABLE ' . $diff->getName()->getQuotedName($this) . ' RENAME TO ' . $diff->getNewName()->getQuotedName($this);
         }
         $sql = array_merge($sql, $this->_getAlterTableIndexForeignKeySQL($diff), $commentsSQL);
     }
     return array_merge($sql, $tableSql, $columnSql);
 }

开发者ID:CynthiaAlwenge，项目名称:Todo-App，代码行数:78，代码来源:OraclePlatform.php

示例5: getTruncateTableSQL

 /**
  * Generates a Truncate Table SQL statement for a given table.
  *
  * Cascade is not supported on many platforms but would optionally cascade the truncate by
  * following the foreign keys.
  *
  * @param string  $tableName
  * @param boolean $cascade
  *
  * @return string
  */
 public function getTruncateTableSQL($tableName, $cascade = false)
 {
     $tableIdentifier = new Identifier($tableName);
     return 'TRUNCATE ' . $tableIdentifier->getQuotedName($this);
 }

开发者ID:asgrim，项目名称:dbal，代码行数:16，代码来源:AbstractPlatform.php

示例6: onSchemaAlterTableChangeColumn

 public function onSchemaAlterTableChangeColumn(SchemaAlterTableChangeColumnEventArgs $args)
 {
     $columnDiff = $args->getColumnDiff();
     $column = $columnDiff->column;
     if (!$this->isSpatialColumnType($column)) {
         return;
     }
     $diff = $args->getTableDiff();
     $table = new Identifier(false !== $diff->newName ? $diff->newName : $diff->name);
     if ($columnDiff->hasChanged('type')) {
         throw new \RuntimeException('The type of a spatial column cannot be changed (Requested changing type from "' . $columnDiff->fromColumn->getType()->getName() . '" to "' . $column->getType()->getName() . '" for column "' . $column->getName() . '" in table "' . $table->getName() . '")');
     }
     if ($columnDiff->hasChanged('geometry_type')) {
         throw new \RuntimeException('The geometry_type of a spatial column cannot be changed (Requested changing type from "' . strtoupper($columnDiff->fromColumn->getCustomSchemaOption('geometry_type')) . '" to "' . strtoupper($column->getCustomSchemaOption('geometry_type')) . '" for column "' . $column->getName() . '" in table "' . $table->getName() . '")');
     }
     if ($columnDiff->hasChanged('srid')) {
         $args->addSql(sprintf("SELECT UpdateGeometrySRID('%s', '%s', %d)", $table->getName(), $column->getName(), $column->getCustomSchemaOption('srid')));
     }
 }

开发者ID:novikovsergey，项目名称:doctrine-postgis，代码行数:19，代码来源:DBALSchemaEventSubscriber.php

示例7: getAlterTableSQL

 /**
  * {@inheritDoc}
  */
 public function getAlterTableSQL(TableDiff $diff)
 {
     $columnSql = array();
     $queryParts = array();
     if ($diff->newName !== false) {
         $queryParts[] = 'RENAME TO ' . $diff->getNewName()->getQuotedName($this);
     }
     foreach ($diff->addedColumns as $column) {
         if ($this->onSchemaAlterTableAddColumn($column, $diff, $columnSql)) {
             continue;
         }
         $columnArray = $column->toArray();
         $columnArray['comment'] = $this->getColumnComment($column);
         $queryParts[] = 'ADD ' . $this->getColumnDeclarationSQL($column->getQuotedName($this), $columnArray);
     }
     foreach ($diff->removedColumns as $column) {
         if ($this->onSchemaAlterTableRemoveColumn($column, $diff, $columnSql)) {
             continue;
         }
         $queryParts[] = 'DROP ' . $column->getQuotedName($this);
     }
     foreach ($diff->changedColumns as $columnDiff) {
         if ($this->onSchemaAlterTableChangeColumn($columnDiff, $diff, $columnSql)) {
             continue;
         }
         /* @var $columnDiff \Doctrine\DBAL\Schema\ColumnDiff */
         $column = $columnDiff->column;
         $columnArray = $column->toArray();
         // Don't propagate default value changes for unsupported column types.
         if ($columnDiff->hasChanged('default') && count($columnDiff->changedProperties) === 1 && ($columnArray['type'] instanceof TextType || $columnArray['type'] instanceof BlobType)) {
             continue;
         }
         $columnArray['comment'] = $this->getColumnComment($column);
         $queryParts[] = 'CHANGE ' . $columnDiff->getOldColumnName()->getQuotedName($this) . ' ' . $this->getColumnDeclarationSQL($column->getQuotedName($this), $columnArray);
     }
     foreach ($diff->renamedColumns as $oldColumnName => $column) {
         if ($this->onSchemaAlterTableRenameColumn($oldColumnName, $column, $diff, $columnSql)) {
             continue;
         }
         $oldColumnName = new Identifier($oldColumnName);
         $columnArray = $column->toArray();
         $columnArray['comment'] = $this->getColumnComment($column);
         $queryParts[] = 'CHANGE ' . $oldColumnName->getQuotedName($this) . ' ' . $this->getColumnDeclarationSQL($column->getQuotedName($this), $columnArray);
     }
     if (isset($diff->addedIndexes['primary'])) {
         $keyColumns = array_unique(array_values($diff->addedIndexes['primary']->getColumns()));
         $queryParts[] = 'ADD PRIMARY KEY (' . implode(', ', $keyColumns) . ')';
         unset($diff->addedIndexes['primary']);
     }
     $sql = array();
     $tableSql = array();
     if (!$this->onSchemaAlterTable($diff, $tableSql)) {
         if (count($queryParts) > 0) {
             $sql[] = 'ALTER TABLE ' . $diff->getName()->getQuotedName($this) . ' ' . implode(", ", $queryParts);
         }
         $sql = array_merge($this->getPreAlterTableIndexForeignKeySQL($diff), $sql, $this->getPostAlterTableIndexForeignKeySQL($diff));
     }
     return array_merge($sql, $tableSql, $columnSql);
 }

开发者ID:tamboer，项目名称:LaravelOctober，代码行数:62，代码来源:MySqlPlatform.php

示例8: generateIdentifierName

 /**
  * Returns a hash value for a given identifier.
  *
  * @param string $identifier Identifier to generate a hash value for.
  *
  * @return string
  */
 private function generateIdentifierName($identifier)
 {
     // Always generate name for unquoted identifiers to ensure consistency.
     $identifier = new Identifier($identifier);
     return strtoupper(dechex(crc32($identifier->getName())));
 }

开发者ID:aleguisf，项目名称:fvdev1，代码行数:13，代码来源:SQLServerPlatform.php

示例9: getIdentitySequenceName

 /**
  * {@inheritdoc}
  */
 public function getIdentitySequenceName($tableName, $columnName)
 {
     $table = new Identifier($tableName);
     // No usage of column name to preserve BC compatibility with <2.5
     $identitySequenceName = $table->getName() . '_SEQ';
     if ($table->isQuoted()) {
         $identitySequenceName = '"' . $identitySequenceName . '"';
     }
     $identitySequenceIdentifier = $this->normalizeIdentifier($identitySequenceName);
     return $identitySequenceIdentifier->getQuotedName($this);
 }

开发者ID:Kevin-ZK，项目名称:vaneDisk，代码行数:14，代码来源:OraclePlatform.php

示例10: getStopDatabaseSQL

 /**
  * Returns the SQL statement for stopping a running database.
  *
  * In SQL Anywhere you can start and stop databases on a
  * database server instance.
  * This is a required statement before dropping an existing database
  * as it has to be explicitly stopped before it can be dropped.
  *
  * @param string $database Name of the database to stop.
  *
  * @return string
  */
 public function getStopDatabaseSQL($database)
 {
     $database = new Identifier($database);
     return 'STOP DATABASE "' . $database->getName() . '" UNCONDITIONALLY';
 }

开发者ID:betes-curieuses-design，项目名称:ElieJosiePhotographie，代码行数:17，代码来源:SQLAnywherePlatform.php

示例11: getAlterTableRenameTableClause

 /**
  * Returns the SQL clause for renaming a table in a table alteration.
  *
  * @param Identifier $newTableName The quoted name of the table to rename to.
  *
  * @return string
  */
 protected function getAlterTableRenameTableClause(Identifier $newTableName)
 {
     return 'RENAME ' . $newTableName->getQuotedName($this);
 }

开发者ID:tamboer，项目名称:LaravelOctober，代码行数:11，代码来源:SQLAnywherePlatform.php

示例12: getAlterTableSQL

 /**
  * {@inheritDoc}
  */
 public function getAlterTableSQL(TableDiff $diff)
 {
     $queryParts = array();
     $sql = array();
     $columnSql = array();
     $commentsSql = array();
     /** @var \Doctrine\DBAL\Schema\Column $column */
     foreach ($diff->addedColumns as $column) {
         if ($this->onSchemaAlterTableAddColumn($column, $diff, $columnSql)) {
             continue;
         }
         $columnDef = $column->toArray();
         $queryParts[] = 'ADD ' . $this->getColumnDeclarationSQL($column->getQuotedName($this), $columnDef);
         if (isset($columnDef['default'])) {
             $queryParts[] = $this->getAlterTableAddDefaultConstraintClause($diff->name, $column);
         }
         $comment = $this->getColumnComment($column);
         if (!empty($comment) || is_numeric($comment)) {
             $commentsSql[] = $this->getCreateColumnCommentSQL($diff->name, $column->getQuotedName($this), $comment);
         }
     }
     foreach ($diff->removedColumns as $column) {
         if ($this->onSchemaAlterTableRemoveColumn($column, $diff, $columnSql)) {
             continue;
         }
         $queryParts[] = 'DROP COLUMN ' . $column->getQuotedName($this);
     }
     /* @var $columnDiff \Doctrine\DBAL\Schema\ColumnDiff */
     foreach ($diff->changedColumns as $columnDiff) {
         if ($this->onSchemaAlterTableChangeColumn($columnDiff, $diff, $columnSql)) {
             continue;
         }
         $column = $columnDiff->column;
         $comment = $this->getColumnComment($column);
         $hasComment = !empty($comment) || is_numeric($comment);
         if ($columnDiff->fromColumn instanceof Column) {
             $fromComment = $this->getColumnComment($columnDiff->fromColumn);
             $hasFromComment = !empty($fromComment) || is_numeric($fromComment);
             if ($hasFromComment && $hasComment && $fromComment != $comment) {
                 $commentsSql[] = $this->getAlterColumnCommentSQL($diff->name, $column->getQuotedName($this), $comment);
             } elseif ($hasFromComment && !$hasComment) {
                 $commentsSql[] = $this->getDropColumnCommentSQL($diff->name, $column->getQuotedName($this));
             } elseif ($hasComment) {
                 $commentsSql[] = $this->getCreateColumnCommentSQL($diff->name, $column->getQuotedName($this), $comment);
             }
         } else {
             // todo: Original comment cannot be determined. What to do? Add, update, drop or skip?
         }
         // Do not add query part if only comment has changed.
         if ($columnDiff->hasChanged('comment') && count($columnDiff->changedProperties) === 1) {
             continue;
         }
         $requireDropDefaultConstraint = $this->alterColumnRequiresDropDefaultConstraint($columnDiff);
         if ($requireDropDefaultConstraint) {
             $queryParts[] = $this->getAlterTableDropDefaultConstraintClause($diff->name, $columnDiff->oldColumnName);
         }
         $columnDef = $column->toArray();
         $queryParts[] = 'ALTER COLUMN ' . $this->getColumnDeclarationSQL($column->getQuotedName($this), $columnDef);
         if (isset($columnDef['default']) && ($requireDropDefaultConstraint || $columnDiff->hasChanged('default'))) {
             $queryParts[] = $this->getAlterTableAddDefaultConstraintClause($diff->name, $column);
         }
     }
     foreach ($diff->renamedColumns as $oldColumnName => $column) {
         if ($this->onSchemaAlterTableRenameColumn($oldColumnName, $column, $diff, $columnSql)) {
             continue;
         }
         $oldColumnName = new Identifier($oldColumnName);
         $sql[] = "sp_RENAME '" . $diff->name . "." . $oldColumnName->getQuotedName($this) . "', '" . $column->getQuotedName($this) . "', 'COLUMN'";
         // Recreate default constraint with new column name if necessary (for future reference).
         if ($column->getDefault() !== null) {
             $queryParts[] = $this->getAlterTableDropDefaultConstraintClause($diff->name, $oldColumnName);
             $queryParts[] = $this->getAlterTableAddDefaultConstraintClause($diff->name, $column);
         }
     }
     $tableSql = array();
     if ($this->onSchemaAlterTable($diff, $tableSql)) {
         return array_merge($tableSql, $columnSql);
     }
     foreach ($queryParts as $query) {
         $sql[] = 'ALTER TABLE ' . $diff->getName()->getQuotedName($this) . ' ' . $query;
     }
     $sql = array_merge($sql, $this->_getAlterTableIndexForeignKeySQL($diff), $commentsSql);
     if ($diff->newName !== false) {
         $sql[] = "sp_RENAME '" . $diff->getName()->getQuotedName($this) . "', '" . $diff->getNewName()->getQuotedName($this) . "'";
         /**
          * Rename table's default constraints names
          * to match the new table name.
          * This is necessary to ensure that the default
          * constraints can be referenced in future table
          * alterations as the table name is encoded in
          * default constraints' names.
          */
         $sql[] = "DECLARE @sql NVARCHAR(MAX) = N''; " . "SELECT @sql += N'EXEC sp_rename N''' + dc.name + ''', N''' " . "+ REPLACE(dc.name, '" . $this->generateIdentifierName($diff->name) . "', " . "'" . $this->generateIdentifierName($diff->newName) . "') + ''', ''OBJECT'';' " . "FROM sys.default_constraints dc " . "JOIN sys.tables tbl ON dc.parent_object_id = tbl.object_id " . "WHERE tbl.name = '" . $diff->getNewName()->getQuotedName($this) . "';" . "EXEC sp_executesql @sql";
     }
     return array_merge($sql, $tableSql, $columnSql);
 }

开发者ID:tamboer，项目名称:LaravelOctober，代码行数:99，代码来源:SQLServerPlatform.php

示例13: getIndexDeclarationSQL

 /**
  * Generate table index column declaration
  * @codeCoverageIgnore
  */
 public function getIndexDeclarationSQL($name, Index $index)
 {
     $columns = $index->getQuotedColumns($this);
     $name = new Identifier($name);
     if (count($columns) == 0) {
         throw new \InvalidArgumentException("Incomplete definition. 'columns' required.");
     }
     return 'INDEX ' . $name->getQuotedName($this) . ' USING FULLTEXT (' . $this->getIndexFieldDeclarationListSQL($columns) . ')';
 }

开发者ID:crate，项目名称:crate-dbal，代码行数:13，代码来源:CratePlatform.php

示例14: getSimpleAlterTableSQL

 /**
  * @param \Doctrine\DBAL\Schema\TableDiff $diff
  *
  * @return array|bool
  */
 private function getSimpleAlterTableSQL(TableDiff $diff)
 {
     // Suppress changes on integer type autoincrement columns.
     foreach ($diff->changedColumns as $oldColumnName => $columnDiff) {
         if (!$columnDiff->fromColumn instanceof Column || !$columnDiff->column instanceof Column || !$columnDiff->column->getAutoincrement() || !(string) $columnDiff->column->getType() === 'Integer') {
             continue;
         }
         if (!$columnDiff->hasChanged('type') && $columnDiff->hasChanged('unsigned')) {
             unset($diff->changedColumns[$oldColumnName]);
             continue;
         }
         $fromColumnType = (string) $columnDiff->fromColumn->getType();
         if ($fromColumnType === 'SmallInt' || $fromColumnType === 'BigInt') {
             unset($diff->changedColumns[$oldColumnName]);
         }
     }
     if (!empty($diff->renamedColumns) || !empty($diff->addedForeignKeys) || !empty($diff->addedIndexes) || !empty($diff->changedColumns) || !empty($diff->changedForeignKeys) || !empty($diff->changedIndexes) || !empty($diff->removedColumns) || !empty($diff->removedForeignKeys) || !empty($diff->removedIndexes) || !empty($diff->renamedIndexes)) {
         return false;
     }
     $table = new Table($diff->name);
     $sql = array();
     $tableSql = array();
     $columnSql = array();
     foreach ($diff->addedColumns as $column) {
         if ($this->onSchemaAlterTableAddColumn($column, $diff, $columnSql)) {
             continue;
         }
         $field = array_merge(array('unique' => null, 'autoincrement' => null, 'default' => null), $column->toArray());
         $type = (string) $field['type'];
         switch (true) {
             case isset($field['columnDefinition']) || $field['autoincrement'] || $field['unique']:
             case $type == 'DateTime' && $field['default'] == $this->getCurrentTimestampSQL():
             case $type == 'Date' && $field['default'] == $this->getCurrentDateSQL():
             case $type == 'Time' && $field['default'] == $this->getCurrentTimeSQL():
                 return false;
         }
         $field['name'] = $column->getQuotedName($this);
         if (strtolower($field['type']) == 'string' && $field['length'] === null) {
             $field['length'] = 255;
         }
         $sql[] = 'ALTER TABLE ' . $table->getQuotedName($this) . ' ADD COLUMN ' . $this->getColumnDeclarationSQL($field['name'], $field);
     }
     if (!$this->onSchemaAlterTable($diff, $tableSql)) {
         if ($diff->newName !== false) {
             $newTable = new Identifier($diff->newName);
             $sql[] = 'ALTER TABLE ' . $table->getQuotedName($this) . ' RENAME TO ' . $newTable->getQuotedName($this);
         }
     }
     return array_merge($sql, $tableSql, $columnSql);
 }

开发者ID:betes-curieuses-design，项目名称:ElieJosiePhotographie，代码行数:55，代码来源:SqlitePlatform.php

示例15: getAlterTableSQL

 /**
  * {@inheritDoc}
  */
 public function getAlterTableSQL(TableDiff $diff)
 {
     $sql = array();
     $columnSql = array();
     $commentsSQL = array();
     $queryParts = array();
     foreach ($diff->addedColumns as $column) {
         if ($this->onSchemaAlterTableAddColumn($column, $diff, $columnSql)) {
             continue;
         }
         $columnDef = $column->toArray();
         $queryPart = 'ADD COLUMN ' . $this->getColumnDeclarationSQL($column->getQuotedName($this), $columnDef);
         // Adding non-nullable columns to a table requires a default value to be specified.
         if (!empty($columnDef['notnull']) && !isset($columnDef['default']) && empty($columnDef['autoincrement'])) {
             $queryPart .= ' WITH DEFAULT';
         }
         $queryParts[] = $queryPart;
         $comment = $this->getColumnComment($column);
         if (null !== $comment && '' !== $comment) {
             $commentsSQL[] = $this->getCommentOnColumnSQL($diff->getName($this)->getQuotedName($this), $column->getQuotedName($this), $comment);
         }
     }
     foreach ($diff->removedColumns as $column) {
         if ($this->onSchemaAlterTableRemoveColumn($column, $diff, $columnSql)) {
             continue;
         }
         $queryParts[] = 'DROP COLUMN ' . $column->getQuotedName($this);
     }
     foreach ($diff->changedColumns as $columnDiff) {
         if ($this->onSchemaAlterTableChangeColumn($columnDiff, $diff, $columnSql)) {
             continue;
         }
         if ($columnDiff->hasChanged('comment')) {
             $commentsSQL[] = $this->getCommentOnColumnSQL($diff->getName($this)->getQuotedName($this), $columnDiff->column->getQuotedName($this), $this->getColumnComment($columnDiff->column));
             if (count($columnDiff->changedProperties) === 1) {
                 continue;
             }
         }
         $this->gatherAlterColumnSQL($diff->fromTable, $columnDiff, $sql, $queryParts);
     }
     foreach ($diff->renamedColumns as $oldColumnName => $column) {
         if ($this->onSchemaAlterTableRenameColumn($oldColumnName, $column, $diff, $columnSql)) {
             continue;
         }
         $oldColumnName = new Identifier($oldColumnName);
         $queryParts[] = 'RENAME COLUMN ' . $oldColumnName->getQuotedName($this) . ' TO ' . $column->getQuotedName($this);
     }
     $tableSql = array();
     if (!$this->onSchemaAlterTable($diff, $tableSql)) {
         if (count($queryParts) > 0) {
             $sql[] = 'ALTER TABLE ' . $diff->getName($this)->getQuotedName($this) . ' ' . implode(" ", $queryParts);
         }
         // Some table alteration operations require a table reorganization.
         if (!empty($diff->removedColumns) || !empty($diff->changedColumns)) {
             $sql[] = "CALL SYSPROC.ADMIN_CMD ('REORG TABLE " . $diff->getName($this)->getQuotedName($this) . "')";
         }
         $sql = array_merge($sql, $commentsSQL);
         if ($diff->newName !== false) {
             $sql[] = 'RENAME TABLE ' . $diff->getName($this)->getQuotedName($this) . ' TO ' . $diff->getNewName()->getQuotedName($this);
         }
         $sql = array_merge($this->getPreAlterTableIndexForeignKeySQL($diff), $sql, $this->getPostAlterTableIndexForeignKeySQL($diff));
     }
     return array_merge($sql, $tableSql, $columnSql);
 }

开发者ID:doctrine，项目名称:dbal，代码行数:67，代码来源:DB2Platform.php

示例16: getTruncateTableSQL

 /**
  * {@inheritDoc}
  */
 public function getTruncateTableSQL($tableName, $cascade = false)
 {
     $tableIdentifier = new Identifier($tableName);
     $sql = 'TRUNCATE ' . $tableIdentifier->getQuotedName($this);
     if ($cascade) {
         $sql .= ' CASCADE';
     }
     return $sql;
 }

开发者ID:asgrim，项目名称:dbal，代码行数:12，代码来源:PostgreSqlPlatform.php

示例17: getCommentOnColumnSQL

 /**
  * {@inheritdoc}
  */
 public function getCommentOnColumnSQL($tableName, $columnName, $comment)
 {
     $tableName = new Identifier($tableName);
     $columnName = new Identifier($columnName);
     $comment = $comment === null ? 'NULL' : $this->quoteStringLiteral($comment);
     return "COMMENT ON COLUMN " . $tableName->getQuotedName($this) . "." . $columnName->getQuotedName($this) . " IS {$comment}";
 }

开发者ID:cuppyzh，项目名称:go_laundry，代码行数:10，代码来源:PostgreSqlPlatform.php

示例18: getAlterTableSQL

 /**
  * {@inheritDoc}
  */
 public function getAlterTableSQL(TableDiff $diff)
 {
     $columnSql = array();
     $queryParts = array();
     if ($diff->newName !== false) {
         $queryParts[] = 'RENAME TO ' . $diff->getNewName()->getQuotedName($this);
     }
     foreach ($diff->addedColumns as $column) {
         if ($this->onSchemaAlterTableAddColumn($column, $diff, $columnSql)) {
             continue;
         }
         $columnArray = $column->toArray();
         $columnArray['comment'] = $this->getColumnComment($column);
         $queryParts[] = 'ADD ' . $this->getColumnDeclarationSQL($column->getQuotedName($this), $columnArray);
     }
     foreach ($diff->removedColumns as $column) {
         if ($this->onSchemaAlterTableRemoveColumn($column, $diff, $columnSql)) {
             continue;
         }
         $queryParts[] = 'DROP ' . $column->getQuotedName($this);
     }
     foreach ($diff->changedColumns as $columnDiff) {
         if ($this->onSchemaAlterTableChangeColumn($columnDiff, $diff, $columnSql)) {
             continue;
         }
         /* @var $columnDiff \Doctrine\DBAL\Schema\ColumnDiff */
         $column = $columnDiff->column;
         $columnArray = $column->toArray();
         // Do not generate column alteration clause if type is binary and only fixed property has changed.
         // Drizzle only supports binary type columns with variable length.
         // Avoids unnecessary table alteration statements.
         if ($columnArray['type'] instanceof BinaryType && $columnDiff->hasChanged('fixed') && count($columnDiff->changedProperties) === 1) {
             continue;
         }
         $columnArray['comment'] = $this->getColumnComment($column);
         $queryParts[] = 'CHANGE ' . $columnDiff->getOldColumnName()->getQuotedName($this) . ' ' . $this->getColumnDeclarationSQL($column->getQuotedName($this), $columnArray);
     }
     foreach ($diff->renamedColumns as $oldColumnName => $column) {
         if ($this->onSchemaAlterTableRenameColumn($oldColumnName, $column, $diff, $columnSql)) {
             continue;
         }
         $oldColumnName = new Identifier($oldColumnName);
         $columnArray = $column->toArray();
         $columnArray['comment'] = $this->getColumnComment($column);
         $queryParts[] = 'CHANGE ' . $oldColumnName->getQuotedName($this) . ' ' . $this->getColumnDeclarationSQL($column->getQuotedName($this), $columnArray);
     }
     $sql = array();
     $tableSql = array();
     if (!$this->onSchemaAlterTable($diff, $tableSql)) {
         if (count($queryParts) > 0) {
             $sql[] = 'ALTER TABLE ' . $diff->getName()->getQuotedName($this) . ' ' . implode(", ", $queryParts);
         }
         $sql = array_merge($this->getPreAlterTableIndexForeignKeySQL($diff), $sql, $this->getPostAlterTableIndexForeignKeySQL($diff));
     }
     return array_merge($sql, $tableSql, $columnSql);
 }

开发者ID:CynthiaAlwenge，项目名称:Todo-App，代码行数:59，代码来源:DrizzlePlatform.php

示例19: getTableConstraintDeclarationSQL

 /**
  * Returns the SQL snippet for creating a table constraint.
  *
  * @param Constraint  $constraint The table constraint to create the SQL snippet for.
  * @param string|null $name       The table constraint name to use if any.
  *
  * @return string
  *
  * @throws \InvalidArgumentException if the given table constraint type is not supported by this method.
  */
 protected function getTableConstraintDeclarationSQL(Constraint $constraint, $name = null)
 {
     if ($constraint instanceof ForeignKeyConstraint) {
         return $this->getForeignKeyDeclarationSQL($constraint);
     }
     if (!$constraint instanceof Index) {
         throw new \InvalidArgumentException('Unsupported constraint type: ' . get_class($constraint));
     }
     if (!$constraint->isPrimary() && !$constraint->isUnique()) {
         throw new \InvalidArgumentException('Can only create primary, unique or foreign key constraint declarations, no common index declarations ' . 'with getTableConstraintDeclarationSQL().');
     }
     $constraintColumns = $constraint->getQuotedColumns($this);
     if (empty($constraintColumns)) {
         throw new \InvalidArgumentException("Incomplete definition. 'columns' required.");
     }
     $sql = '';
     $flags = '';
     if (!empty($name)) {
         $name = new Identifier($name);
         $sql .= 'CONSTRAINT ' . $name->getQuotedName($this) . ' ';
     }
     if ($constraint->hasFlag('clustered')) {
         $flags = 'CLUSTERED ';
     }
     if ($constraint->isPrimary()) {
         return $sql . 'PRIMARY KEY ' . $flags . '(' . $this->getIndexFieldDeclarationListSQL($constraintColumns) . ')';
     }
     return $sql . 'UNIQUE ' . $flags . '(' . $this->getIndexFieldDeclarationListSQL($constraintColumns) . ')';
 }

开发者ID:Kevin-ZK，项目名称:vaneDisk，代码行数:39，代码来源:SQLAnywherePlatform.php

示例20: getUniqueConstraintDeclarationSQL

鲜花

握手

雷人

路过

鸡蛋

该文章已有0人参与评论

请发表评论

全部评论

专题导读

More+

10-27 六六分期app的软件客服如何联系？(六六分期

11-06 可心卡盟:win10系统火狐flash插件崩溃怎么

11-06 亲亲特价:怎么删除回收站图标

11-06 济南大学虚拟社区:鲁大师节能降温的具体办

11-06 xlueops.exe:无线网络安装向导

11-06 女斗合众国:win7系统cf与主机连接不稳定怎

11-06 0xc000022-[cf烟雾头]cf怎么调烟雾头

11-06 qizideyouhuo:应用程序无法正常启动0xc0000

11-06 ipz-185:win7系统vcf文件怎么打开

11-06 傻哥蹦迪:win10系统s4怎么打开usb调试

11-06 八神浩树gtaste:回收站清空了怎么恢复

11-06 妖尾之黑色守护:win10系统电脑没有1440x900

11-06 校园至尊魔王小说:win7系统浏览网页时字体

11-06 女斗合众国:win10系统访问共享文件夹提示请

11-06 tokyo hot n0654:恢复win7系统默认字体一招

11-06 雨酷仙境:设置win7系统转移临时文件夹腾出

11-06 阿穆纳伊之杖:win7系统开始菜单在右边还原

11-06 tunespotting:win10系统火狐flash插件总是

11-06 甘尔葛分析师：计谋网站seo关键词暴涨有什

11-06 蔡贵霖: 计谋网站seo关键词暴涨有什么秘密

11-06 博益网首页:ao3网页版进入不了解决方法

11-06 漏斗子专栏: 网站数据分析小白易懂精华篇

11-06 见证双虹怎么做:win7系统开启telnet命令的

11-06 颾狐蝶蜋:系统资源不足无法完成请求的服务

11-06 国光中学校歌:提交网站到alexa查询详细步骤

11-06 西安有情天:静态网页和动态网页的区别

11-06 红木雅尚斋:外部链接构造对网站的好处

11-06 前官礼遇：防止域名劫持–增强域安全性的10

11-06 密传二转答案: 中文分词算法有哪些

11-06 金泉家园邮编:百度快照劫持的表现及应对方

PHP Schema\Index类代码示例发布时间：2022-05-23

PHP Schema\ForeignKeyConstraint类代码示例发布时间：2022-05-23

hackl/tikz-network: A tool to visualize

krishnaik06/Machine-Learning-in-90-days

2022-08-18

joaomh/curso-de-matlab

2022-08-17

美元符号为什么是“$”

2022-11-06

rugk/mastodon-simplified-federation: Sim

2022-08-17

CVE-2022-25858

2022-07-29

阅读排行榜

1 librespeed/speedtest: Self-hosted Speedt

librespeed/speedtest: Self-hosted Speedtest for HTML5 and more. Easy setup, exam

阅读：1218|2022-08-30

2 小程序-页面传值

1 wxml文件某一段 2amp;#160;js文件 3.接受参数的页面JS

阅读：603|2022-07-18

3 avehtari/BDA_m_demos: Bayesian Data Anal

avehtari/BDA_m_demos: Bayesian Data Analysis demos for Matlab/Octave

阅读：1130|2022-08-17

4 四维彩超怎么看性别？四维看男孩女孩诀窍

女人怀孕后，为了有一个健康聪明的宝宝，经历各种体检、筛查。其实这些体检和筛查中的

阅读：938|2022-11-06

5 CVE-2022-0977

Use after free in Browser UI in Google Chrome on Chrome OS prior to 99.0.4844.74

阅读：713|2022-07-29

6 medfreeman/markdown-it-toc-and-anchor: m

medfreeman/markdown-it-toc-and-anchor: markdown-it plugin to add a toc and ancho

阅读：1334|2022-08-18

7 揭秘神秘的北京风水布局，附北京风水图

北京是我国著名的六朝古都。春秋时期燕国始建古蓟城，后经三千多年不断兴建、完善，逐

阅读：483|2022-07-30

8 touchlab/Kermit: Kermit by Touchlab is a

touchlab/Kermit: Kermit by Touchlab is a Kotlin Multiplatform centralized loggin

阅读：981|2022-08-13

9 sydney0zq/covid-19-detection: The implem

sydney0zq/covid-19-detection: The implementation of A Weakly-supervised Framewor

阅读：484|2022-08-16

10 世界上哪个国家离中国最远？

离中国最远的国家是阿根廷。从太平洋直线计算，即往东线走，北京到阿根廷的布宜诺斯艾

阅读：637|2022-11-06

客服电话

电子邮件