• 设为首页
  • 点击收藏
  • 手机版
    手机扫一扫访问
    迪恩网络手机版
  • 关注官方公众号
    微信扫一扫关注
    迪恩网络公众号

PHP Schema\Identifier类代码示例

原作者: [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人参与评论

请发表评论

全部评论

专题导读
上一篇:
PHP Schema\Index类代码示例发布时间:2022-05-23
下一篇:
PHP Schema\ForeignKeyConstraint类代码示例发布时间:2022-05-23
热门推荐
阅读排行榜

扫描微信二维码

查看手机版网站

随时了解更新最新资讯

139-2527-9053

在线客服(服务时间 9:00~18:00)

在线QQ客服
地址:深圳市南山区西丽大学城创智工业园
电邮:jeky_zhao#qq.com
移动电话:139-2527-9053

Powered by 互联科技 X3.4© 2001-2213 极客世界.|Sitemap