YII Framework框架使用YIIC快速创建YII应用之migrate用法实例详解

/*/www/yii_dev/yii/framework# php yiic migrate helpError: Unknown action: helpUSAGE yiic migrate [action] [parameter]DESCRIPTION This command provides support for database migrations. The optional 'action' parameter specifies which specific migration task to perform. It can take these values: up, down, to, create, history, new, mark. If the 'action' parameter is not given, it defaults to 'up'. Each action takes different parameters. Their usage can be found in the following examples.EXAMPLES* yiic migrateApplies ALL new migrations. This is equivalent to 'yiic migrate to'.* yiic migrate create create_user_tableCreates a new migration named 'create_user_table'.* yiic migrate up 3Applies the next 3 new migrations.* yiic migrate downReverts the last applied migration.* yiic migrate down 3Reverts the last 3 applied migrations.* yiic migrate to 101129_185401Migrates up or down to version 101129_185401.* yiic migrate mark 101129_185401Modifies the migration history up or down to version 101129_185401.No actual migration will be performed.* yiic migrate historyShows all previously applied migration information.* yiic migrate history 10Shows the last 10 applied migrations.* yiic migrate newShows all new migrations.* yiic migrate new 10Shows the next 10 migrations that have not been applied.*/

use yii/db/Schema;use yii/db/Migration;class m130524_201442_init extends Migration{  const TBL_NAME = '{{%admin}}';  public function safeUp()  {    $tableOptions = null;    if ($this->db->driverName === 'mysql') {      // http://stackoverflow.com/questions/766809/whats-the-difference-between-utf8-general-ci-and-utf8-unicode-ci      $tableOptions = 'CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE=InnoDB';    }    $this->createTable(self::TBL_NAME, [      'id' => Schema::TYPE_PK,      'username' => Schema::TYPE_STRING . ' NOT NULL',      'auth_key' => Schema::TYPE_STRING . '(32) NOT NULL',      'password_hash' => Schema::TYPE_STRING . ' NOT NULL', //密码      'password_reset_token' => Schema::TYPE_STRING,      'email' => Schema::TYPE_STRING . ' NOT NULL',      'role' => Schema::TYPE_SMALLINT . ' NOT NULL DEFAULT 10',      'status' => Schema::TYPE_SMALLINT . ' NOT NULL DEFAULT 10',      'created_at' => Schema::TYPE_INTEGER . ' NOT NULL',      'updated_at' => Schema::TYPE_INTEGER . ' NOT NULL',    ], $tableOptions);    $this->createIndex('username', self::TBL_NAME, ['username'],true);    $this->createIndex('email', self::TBL_NAME, ['email'],true);  }  public function safeDown()  {    $this->dropTable(self::TBL_NAME);  }}

namespace backend/models;use Yii;use yii/base/NotSupportedException;use yii/behaviors/TimestampBehavior;use yii/db/ActiveRecord;use yii/web/IdentityInterface;/** * This is the model class for table "{{%admin}}". * * @property integer $id * @property string $username * @property string $auth_key * @property string $password_hash * @property string $password_reset_token * @property string $email * @property integer $role * @property integer $status * @property integer $created_at * @property integer $updated_at */class AgAdmin extends ActiveRecord implements IdentityInterface{  const STATUS_DELETED = 0;  const STATUS_ACTIVE = 10;  const ROLE_USER = 10;  const AUTH_KEY = '123456';  /**   * @inheritdoc   */  public static function tableName()  {    return '{{%admin}}';  }  /**   * @inheritdoc   */  public function behaviors()  {    return [      TimestampBehavior::className(),    ];  }  /**   * @inheritdoc   */  public function rules()  {    return [      [['username', 'email',], 'required'],      [['username', 'email'], 'string', 'max' => 255],      [['username'], 'unique'],      [['username'], 'match', 'pattern'=>'/^[a-z]/w*$/i'],      [['email'], 'unique'],      [['email'], 'email'],      ['status', 'default', 'value' => self::STATUS_ACTIVE],      ['status', 'in', 'range' => [self::STATUS_ACTIVE, self::STATUS_DELETED]],      ['role', 'default', 'value' => self::ROLE_USER],      ['auth_key', 'default', 'value' => self::AUTH_KEY],      ['role', 'in', 'range' => [self::ROLE_USER]],    ];  }  /**   * @inheritdoc   */  public static function findIdentity($id)  {    return static::findOne(['id' => $id, 'status' => self::STATUS_ACTIVE]);  }  /**   * @inheritdoc   */  public static function findIdentityByAccessToken($token, $type = null)  {    return static::findOne(['access_token' => $token]);    //throw new NotSupportedException('"findIdentityByAccessToken" is not implemented.');  }  /**   * Finds user by username   *   * @param string $username   * @return static|null   */  public static function findByUsername($username)  {    return static::findOne(['username' => $username, 'status' => self::STATUS_ACTIVE]);  }  /**   * Finds user by password reset token   *   * @param string $token password reset token   * @return static|null   */  public static function findByPasswordResetToken($token)  {    if (!static::isPasswordResetTokenValid($token)) {      return null;    }    return static::findOne([      'password_reset_token' => $token,      'status' => self::STATUS_ACTIVE,    ]);  }  /**   * Finds out if password reset token is valid   *   * @param string $token password reset token   * @return boolean   */  public static function isPasswordResetTokenValid($token)  {    if (empty($token)) {      return false;    }    $expire = Yii::$app->params['user.passwordResetTokenExpire'];    $parts = explode('_', $token);    $timestamp = (int) end($parts);    return $timestamp + $expire >= time();  }  /**   * @inheritdoc   */  public function getId()  {    return $this->getPrimaryKey();  }  /**   * @inheritdoc   */  public function getAuthKey()  {    return $this->auth_key;  }  /**   * @inheritdoc   */  public function validateAuthKey($authKey)  {    return $this->getAuthKey() === $authKey;  }  /**   * Validates password   *   * @param string $password password to validate   * @return boolean if password provided is valid for current user   */  public function validatePassword($password)  {    return Yii::$app->security->validatePassword($password, $this->password_hash);  }  /**   * Generates password hash from password and sets it to the model   *   * @param string $password   */  public function setPassword($password)  {    $this->password_hash = Yii::$app->security->generatePasswordHash($password);  }  /**   * Generates "remember me" authentication key   */  public function generateAuthKey()  {    $this->auth_key = Yii::$app->security->generateRandomString();  }  /**   * Generates new password reset token   */  public function generatePasswordResetToken()  {    $this->password_reset_token = Yii::$app->security->generateRandomString() . '_' . time();  }  /**   * Removes password reset token   */  public function removePasswordResetToken()  {    $this->password_reset_token = null;  }}

/** * * @author chan <maclechan@qq.com> */namespace console/controllers;use backend/models/Admin ;class InitController extends /yii/console/Controller{  /**   * Create init user   */  public function actionAdmin()  {    echo "创建一个新用户 .../n";         // 提示当前操作    $username = $this->prompt('User Name:');    // 接收用户名    $email = $this->prompt('Email:');        // 接收Email    $password = $this->prompt('Password:');     // 接收密码    $model = new AgAdmin();              // 创建一个新用户    $model->username = $username;          // 完成赋值    $model->email = $email;    $model->password = $password;    if (!$model->save())              // 保存新的用户    {      foreach ($model->getErrors() as $error)   // 如果保存失败，说明有错误，那就输出错误信息。      {        foreach ($error as $e)        {          echo "$e/n";        }      }      return 1;                  // 命令行返回1表示有异常    }    return 0;                    // 返回0表示一切OK  }}

public function getUser(){    if ($this->_user === false) {      $this->_user = Admin::findByUsername($this->username);    }    return $this->_user;}

'user' => [  'identityClass' => 'backend/models/Admin',  'enableAutoLogin' => true,],