PHP Lhm Lhm::changeTable Examples

Example #1

File: RenameMigration.php Project: tristanpemble/lhm_php

 public function up()
 {
     Lhm::setAdapter($this->getAdapter());
     Lhm::changeTable('ponies', function (Table $ponies) {
         $ponies->renameColumn('name', 'first_name')->save();
     });
 }

Example #2

File: IndexMigration.php Project: tristanpemble/lhm_php

 public function down()
 {
     Lhm::setAdapter($this->getAdapter());
     Lhm::changeTable('ponies', function (Table $ponies) {
         $ponies->removeIndex('age', ['name' => 'ponies_age_idx'])->removeColumn('age', 'integer', ['null' => true])->save();
     }, ['archive_name' => 'drop_the_ponies_age']);
 }

Example #3

File: HybridPhinxMigration.php Project: tristanpemble/lhm_php

 public function up()
 {
     $ponies = $this->table('ponies');
     $ponies->addColumn('location', 'string', ['null' => true, 'length' => 255, 'default' => 'Canada'])->save();
     Lhm::setAdapter($this->getAdapter());
     Lhm::changeTable('ponies', function (Table $ponies) {
         $ponies->addColumn('age', 'integer', ['null' => true])->save();
     });
 }

Example #4

File: LhmMigration.php Project: tristanpemble/lhm_php

 public function up()
 {
     Lhm::setAdapter($this->getAdapter());
     Lhm::changeTable('ponies', function (Table $ponies) {
         $ponies->addColumn('age', 'integer', ['default' => 1]);
         $ponies->addColumn('nickname', 'string', ['after' => 'name', 'length' => 20, 'null' => true, 'default' => 'derp']);
         $ponies->save();
     });
 }