PHP Migration::initDB方法代码示例

 public function handleApply($p)
 {
     if ($p[2] == 'migrations') {
         $type = 'migration';
     } else {
         if ($p[2] == 'seeds') {
             $type = 'seed';
         } else {
             trigger_error("invalid migration type: " . $p[2]);
         }
     }
     SqlBeginTransaction();
     //	make sure the migrations table exists
     Migration::initDB($type);
     //	have it scan the migrations directory for all available migrations
     $versions = Migration::getAllMigrationNames($type);
     //	query the db for applied migrations
     $applied = Migration::getAllAppiedMigrationNames($type);
     //	apply anything that hasn't been done yet, in the proper order
     $unapplied = array_diff($versions, $applied);
     foreach ($unapplied as $key => $needsApplied) {
         Migration::apply($key, $needsApplied, $type);
     }
     SqlCommitTransaction();
 }

 function subMigrations($p, $s)
 {
     SqlBeginTransaction();
     //	make sure the migrations table exists
     Migration::initDB();
     //	have it scan the migrations directory for all available migrations
     $versions = Migration::getAllMigrationNames();
     //	query the db for applied migrations
     $applied = Migration::getAllAppiedMigrationNames();
     //	apply anything that hasn't been done yet, in the proper order
     $unapplied = array_diff($versions, $applied);
     foreach ($unapplied as $key => $needsApplied) {
         Migration::apply($key, $needsApplied);
     }
     SqlCommitTransaction();
 }

 function subMigrations($p, $s)
 {
     SqlBeginTransaction();
     //	make sure the migrations table exists
     Migration::initDB();
     //	have it scan the migrations directory for all available migrations
     $versions = Migration::getAllMigrationNames();
     // print_r($versions);
     $flipped = array_flip($versions);
     //	query the db for applied migrations in reverse order
     $applied = Migration::getAllAppiedMigrationNames();
     // print_r($applied);
     print_r($versions);
     print_r($applied);
     //	undo all of the migrations
     foreach ($applied as $key => $migration) {
         Migration::undo($flipped[$migration], $migration);
     }
     //	now, reapply all of them
     foreach ($versions as $key => $migration) {
         Migration::apply($key, $migration);
     }
     SqlCommitTransaction();
     //	apply anything that hasn't been done yet, in the proper order
     // $unapplied = array_diff($versions, $applied);
     // print_r($unapplied);die();
     // foreach($unapplied as $key => $needsApplied)
     // {
     // 	Migration::apply($key, $needsApplied);
     // }
     /*
     //	make sure the migrations table exists
     $schema = SqlGetSchema();
     if(!$schema->tableExists('migrations'))
     {
     	SqlAlterSchema("create table migrations (
     				id serial primary key, 
     				name text not null,
     				applied int2 not null default 0)");
     }
     
     //	have it scan the migrations directory for all available migrations
     $filenames = ListDir(getcwd() . '/migrations', array('extentions' => array('php')));
     $versions = array();
     foreach($filenames as $thisFilename)
     {
     	$parts = explode('_', $thisFilename);
     	$version = $parts[0];
     	$versions[$thisFilename] = $version;
     }
     
     //	query the db for applied migrations
     $applied = SqlFetchColumn("select name from migrations where applied = 1", array());
     
     //	apply anything that hasn't been done yet, in the proper order
     $unapplied = array_diff($versions, $applied);
     print_r($unapplied);
     foreach($unapplied as $key => $needsApplied)
     {
     	//	apply the migration
     	include_once(getcwd() . '/migrations/' . $key);
     	$className = 'Migration_' . str_replace('.', '_', $needsApplied);
     	$migration = new $className();
     	$migration->up();
     	
     	//	mark it as applied
     	SqlUpsertRow('migrations', array('name' => $needsApplied), array('applied' => 1));
     	
     	print_r($migration);
     }
     */
 }