vendor/doctrine/dbal/tests/Doctrine/Tests/DBAL/Functional/Schema/SQLServerSchemaManagerTest.php

   1 <?php
   2
   3 namespace Doctrine\Tests\DBAL\Functional\Schema;
   4
   5 use Doctrine\DBAL\Schema\Table;
   6 use Doctrine\DBAL\Schema\TableDiff;
   7 use Doctrine\DBAL\Schema\ColumnDiff;
   8 use Doctrine\DBAL\Schema\Column;
   9 use Doctrine\DBAL\Types\Type;
  10
  11 class SQLServerSchemaManagerTest extends SchemaManagerFunctionalTestCase
  12 {
  13         protected function getPlatformName()
  14         {
  15                 return "mssql";
  16         }
  17
  18     /**
  19      * @group DBAL-255
  20      */
  21     public function testDropColumnConstraints()
  22     {
  23         $table = new Table('sqlsrv_drop_column');
  24         $table->addColumn('id', 'integer');
  25         $table->addColumn('todrop', 'decimal', array('default' => 10.2));
  26
  27         $this->_sm->createTable($table);
  28
  29         $diff = new TableDiff('sqlsrv_drop_column', array(), array(), array(
  30             new Column('todrop', Type::getType('decimal'))
  31         ));
  32         $this->_sm->alterTable($diff);
  33
  34         $columns = $this->_sm->listTableColumns('sqlsrv_drop_column');
  35         $this->assertEquals(1, count($columns));
  36     }
  37 }