Ejemplo n.º 1
0
 /**
  */
 public function testAddColumn()
 {
     try {
         $this->object->addColumn('', '', '');
         $this->fail('addColumn does not accept empty string for table name!');
     } catch (Phigrate_Exception_Argument $ex) {
         $msg = 'Missing table name parameter';
         $this->assertEquals($msg, $ex->getMessage());
     }
     try {
         $this->object->addColumn('users', '', '');
         $this->fail('addColumn does not accept empty string for column name!');
     } catch (Phigrate_Exception_Argument $ex) {
         $msg = 'Missing column name parameter';
         $this->assertEquals($msg, $ex->getMessage());
     }
     try {
         $this->object->addColumn('users', 'name', '');
         $this->fail('addColumn does not accept empty string for type!');
     } catch (Phigrate_Exception_Argument $ex) {
         $msg = 'Missing type parameter';
         $this->assertEquals($msg, $ex->getMessage());
     }
     //create it
     $this->object->executeDdl('CREATE TABLE `users` (name varchar(20));');
     $col = $this->object->columnInfo('users', 'name');
     $this->assertEquals('name', $col['field']);
     //add column
     $this->object->addColumn('users', 'fav_color', 'string', array('limit' => 32));
     $col = $this->object->columnInfo('users', 'fav_color');
     $this->assertEquals('fav_color', $col['field']);
     $this->assertEquals('varchar(32)', $col['type']);
     //add column
     $this->object->addColumn('users', 'latitude', 'decimal', array('precision' => 10, 'scale' => 2));
     $col = $this->object->columnInfo('users', 'latitude');
     $this->assertEquals('latitude', $col['field']);
     $this->assertEquals('decimal(10,2)', $col['type']);
     //add column with unsigned parameter
     $this->object->addColumn('users', 'age', 'integer', array('unsigned' => true));
     $col = $this->object->columnInfo('users', 'age');
     $this->assertEquals('age', $col['field']);
     $this->assertEquals('int(11) unsigned', $col['type']);
     //add column with biginteger datatype
     $this->object->addColumn('users', 'weight', 'biginteger', array('limit' => 20));
     $col = $this->object->columnInfo('users', 'weight');
     $this->assertEquals('weight', $col['field']);
     $this->assertEquals('bigint(20)', $col['type']);
 }