blocks|key|30546|text|\Yii::$app->runAction('migrate',+['migrationPath'+=>+'@yii/rbac/migrations/']);|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|30547|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>\Yii::$app-&gt;runAction('migrate', ['migrationPath' =&gt; '@yii/rbac/migrations/']);
</code></pre>

blocks|key|30598|text|您可以使用加载控制台配置来创建控制台应用程序来运行迁移：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|30599|public+function+actionMigrate()
{
++++//+Keep+current+application
++++$oldApp+=+\Yii::$app;
++++//+Load+Console+Application+config
++++$config+=+require+\Yii::getAlias('@app').+'/config/console.php';
++++new+\yii\console\Application($config);
++++$result+=+\Yii::$app->runAction('migrate',+['migrationPath'+=>+'@app/migrations/',+'interactive'+=>+false]);
++++//+Revert+application
++++\Yii::$app+=+$oldApp;
++++return;
}|code-block|syntax|javascript|30600|上面的示例代码是针对is+i2-app-basic模板的，您可以更改is+i2-app-advanced模板的路径。|30601|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

You could create Console Application with loading Console config to run migration:

<pre><code>public function actionMigrate()
{
 // Keep current application
 $oldApp = \Yii::$app;
 // Load Console Application config
 $config = require \Yii::getAlias('@app'). '/config/console.php';
 new \yii\console\Application($config);
 $result = \Yii::$app-&gt;runAction('migrate', ['migrationPath' =&gt; '@app/migrations/', 'interactive' =&gt; false]);
 // Revert application
 \Yii::$app = $oldApp;
 return;
}
</code></pre>

Above sample code is for yii2-app-basic template, you could change path for yii2-app-advanced template.

blocks|key|4538180|text|对于这样的情况，我使用这个解决方案。我只实现了migrate/up的情况。要执行任何其他migrate命令，您必须配置runAction()的参数。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|4538181|use+yii\console\controllers\MigrateController;

/*Suppose+that+config+is+an+array+with+the+following+structure
[
++++'class'+=>+'yii\db\Connection',
++++'dsn'+=>+"$dsn",
++++'username'+=>+"$username",
++++'password'+=>+"$password",
++++'charset'+=>+'utf8',
]
*/
public+function+migrateUp($config){
++++$migrate+=+new+MigrateController('migrate',+\Yii::$app);
++++/*The+name+of+the+table+for+keeping+applied+migration+information*/
++++$migrate->migrationTable+=+'migration';
++++/*At+least+one+of+`migrationPath`+or+`migrationNamespaces`+should+be+specified.
++++For+this+example+I+use+`migrationNamespaces`+to+find+a+specific+set+of+migrations+I+want+to+execute.*/
++++$migrate->migrationNamespaces+=+[
++++++++'app\modules\v1\migrations'
++++];
++++$migrate->migrationPath+=+null;
++++/*The+DB+connection+object+to+use+when+applying+migrations*/
++++$migrate->db+=+$config;
++++/*Run+migrations+without+asking+questions*/
++++$migrate->interactive+=+false;
++++/*The+individual+commands+ran+within+the+migration+will+not+be+output+to+the+console*/
++++$migrate->compact+=+true;
++++/*php://temp+is+a+read-write+stream+that+allow+temporary+data+to+be+stored+in+a+file-like+wrapper+*/
++++define('STDOUT',+$fp=+fopen('php://temp',+'r%2B'));
++++/*run+migrate/up+*/
++++$status+=+$migrate->runAction('up');
++++/*Rewind+the+position+of+the+file+pointer*/
++++rewind($fp);
++++$migrationOutput+=+stream_get_contents($fp);
++++if+(isset($status)){
++++++++ob_get_clean();
++++++++return+['Errors+when+executing+migrations',+$migrationOutput];
++++}
++++return+['Everything+ok',+$migrationOutput];
}|code-block|syntax|javascript|4538182|entityMap^0|N|A|18|7|1N|B|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@$9|N|A|O|B|C]|$9|P|A|Q|B|C]|$9|R|A|S|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|T|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|U|8|@]|D|@]|E|$]]]|L|$]]

For cases like this, I use this solution. I only implement the <code>migrate/up</code> case. To execute any other <code>migrate</code> command, you must configure the parameters of <code>runAction()</code>.

<pre><code>use yii\console\controllers\MigrateController;

/*Suppose that config is an array with the following structure
[
 'class' =&gt; 'yii\db\Connection',
 'dsn' =&gt; "$dsn",
 'username' =&gt; "$username",
 'password' =&gt; "$password",
 'charset' =&gt; 'utf8',
]
*/
public function migrateUp($config){
 $migrate = new MigrateController('migrate', \Yii::$app);
 /*The name of the table for keeping applied migration information*/
 $migrate-&gt;migrationTable = 'migration';
 /*At least one of `migrationPath` or `migrationNamespaces` should be specified.
 For this example I use `migrationNamespaces` to find a specific set of migrations I want to execute.*/
 $migrate-&gt;migrationNamespaces = [
 'app\modules\v1\migrations'
 ];
 $migrate-&gt;migrationPath = null;
 /*The DB connection object to use when applying migrations*/
 $migrate-&gt;db = $config;
 /*Run migrations without asking questions*/
 $migrate-&gt;interactive = false;
 /*The individual commands ran within the migration will not be output to the console*/
 $migrate-&gt;compact = true;
 /*php://temp is a read-write stream that allow temporary data to be stored in a file-like wrapper */
 define('STDOUT', $fp= fopen('php://temp', 'r+'));
 /*run migrate/up */
 $status = $migrate-&gt;runAction('up');
 /*Rewind the position of the file pointer*/
 rewind($fp);
 $migrationOutput = stream_get_contents($fp);
 if (isset($status)){
 ob_get_clean();
 return ['Errors when executing migrations', $migrationOutput];
 }
 return ['Everything ok', $migrationOutput];
}
</code></pre>

I want to <code>migrate</code> <code>up</code>/<code>down</code> the database using the <code>code</code> instead of the console window. I have looked into the <code>framework</code>. I have tried the following code:

<pre><code>$runner = new yii\console\Application([
 'id' =&gt; 'auto-migrate',
 'basePath' =&gt; dirname(__DIR__)
 ]); 

 $runner-&gt;runAction('migrate');
 ob_start();
 return htmlentities(ob_get_clean(), null, Yii::$app-&gt;charset);
</code></pre>

It gives the <code>Internal Server Error</code>. And doesn't even migrates the files to the database.
But if the directory doesn't exists, it creates the directory. It is behaving the way it should but if the migration file exist in that same directory it gives <code>Internal Server Error</code>.

Yii2 Migrate Command Programmatically

我想使用code而不是控制台窗口来migrate up/down数据库。我已经调查过framework了。我已经尝试了以下代码：$runner = new yii\console\Application([                                          'id'       => '...

问Yii2以编程方式迁移命令
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Yii2以编程方式迁移命令EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Yii2以编程方式迁移命令
EN