YII Framework框架使用YIIC快速創(chuàng)建YII應(yīng)用之migrate用

2020-03-22 20:02:12

字體：大中小

供稿：網(wǎng)友

PHP YII Framework框架使用YIIC快速創(chuàng)建YII應(yīng)用之migrate用法實(shí)例詳解
本文實(shí)例講述了YII Framework框架使用YIIC快速創(chuàng)建YII應(yīng)用之migrate用法。分享給大家供大家參考，具體如下：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 html' target='_blank'>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.在我們開(kāi)發(fā)程序的過(guò)程中，數(shù)據(jù)庫(kù)的結(jié)構(gòu)也是不斷調(diào)整的。我們的開(kāi)發(fā)中要保證代碼和數(shù)據(jù)庫(kù)庫(kù)的同步。因?yàn)槲覀兊膽?yīng)用離不開(kāi)數(shù)據(jù)庫(kù)。例如: 在開(kāi)發(fā)過(guò)程中，我們經(jīng)常需要增加一個(gè)新的表，或者我們后期投入運(yùn)營(yíng)的產(chǎn)品，可能需要為某一列添加索引。我們必須保持?jǐn)?shù)據(jù)結(jié)構(gòu)和代碼的一致性。如果代碼和數(shù)據(jù)庫(kù)不同步，可能整個(gè)系統(tǒng)將無(wú)法正常運(yùn)行。出于這個(gè)原因。yii提供了一個(gè)數(shù)據(jù)庫(kù)遷移工具，可以保持代碼和數(shù)據(jù)庫(kù)是同步。方便數(shù)據(jù)庫(kù)的回滾和更新。功能正如描述。主要提供了數(shù)據(jù)庫(kù)遷移功能。命令格式y(tǒng)iic migrate [action] [parameter]action參數(shù)用來(lái)制定執(zhí)行哪一個(gè)遷移任務(wù)。可以一使用up, down, to, create, history, new, mark.這些命令如果沒(méi)有action參數(shù)，默認(rèn)為upparameter根據(jù)action的不同而有所變化。上述例子中給出了說(shuō)明。官方也給出了詳細(xì)的例子。http://www.yiiframework.com/doc/guide/1.1/zh_cn/database.migration#creating-migrations這里不再詳細(xì)累述。用到的時(shí)候參考使用就可以了。補(bǔ)充：yii2.0使用migrate創(chuàng)建后臺(tái)登陸重新創(chuàng)建一張數(shù)據(jù)表來(lái)完成后臺(tái)登陸驗(yàn)證為了大家看得明白，直接貼代碼一、使用Migration創(chuàng)建表adminconsole/migrations/m130524_201442_init.phpuse 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);使用命令行來(lái)創(chuàng)建admin數(shù)據(jù)庫(kù)1、win7下使用命令：在項(xiàng)目根目下，右鍵選擇User composer here(前提是安裝了全局的composer)，
yii migrate即創(chuàng)建數(shù)據(jù)表 admin成功2、linux下命令一樣（此處略）二、使用gii創(chuàng)建模型此處略，很簡(jiǎn)單的步聚。注：把a(bǔ)dmin模型創(chuàng)在 backend/models下面（放哪里看個(gè)人喜好）
代碼如下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_atclass 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;三、使用migrate 為后如初使化一個(gè)登陸帳號(hào)1、console/controllers創(chuàng)建InitController.php * @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 "創(chuàng)建一個(gè)新用戶 .../n"; // 提示當(dāng)前操作 $username = $this- prompt('User Name:'); // 接收用戶名 $email = $this- prompt('Email:'); // 接收Email $password = $this- prompt('Password:'); // 接收密碼 $model = new AgAdmin(); // 創(chuàng)建一個(gè)新用戶 $model- username = $username; // 完成賦值 $model- email = $email; $model- password = $password; if (!$model- save()) // 保存新的用戶 foreach ($model- getErrors() as $error) // 如果保存失敗，說(shuō)明有錯(cuò)誤，那就輸出錯(cuò)誤信息。 foreach ($error as $e) echo "$e/n"; return 1; // 命令行返回1表示有異常 return 0; // 返回0表示一切OK2、使用命令：在項(xiàng)目根目下，右鍵選擇User composer here(前提是安裝了全局的composer)，
yii init/admin到此，打開(kāi)數(shù)據(jù)表看下，己經(jīng)有了數(shù)據(jù)。四、后臺(tái)登陸驗(yàn)證1、backend/controllers/SiteController.php 里actionLogin方法不用變2、把common/models/LoginForm.php復(fù)制到backend/models只要把LoginForm.php里面的方法getUser()修改一個(gè)單詞即可，如下public function getUser() if ($this- _user === false) { $this- _user = Admin::findByUsername($this- username); return $this- _user;3、backend/config/main.php 只要修改'user' = [ 'identityClass' = 'backend/models/Admin', 'enableAutoLogin' = true,此外，在作修改時(shí)，請(qǐng)注意下命令空不要搞亂了。到此，結(jié)束。更多關(guān)于Yii相關(guān)內(nèi)容感興趣的讀者可查看本站專題：《Yii框架入門及常用技巧總結(jié)》、《php優(yōu)秀開(kāi)發(fā)框架總結(jié)》、《smarty模板入門基礎(chǔ)教程》、《php日期與時(shí)間用法總結(jié)》、《php面向?qū)ο?/u>程序設(shè)計(jì)入門教程》、《php字符串(string)用法總結(jié)》、《php+mysql數(shù)據(jù)庫(kù)操作入門教程》及《php常見(jiàn)數(shù)據(jù)庫(kù)操作技巧匯總》希望本文所述對(duì)大家基于Yii框架的PHP程序設(shè)計(jì)有所幫助。PHP教程

鄭重聲明：本文版權(quán)歸原作者所有，轉(zhuǎn)載文章僅為傳播更多信息之目的，如作者信息標(biāo)記有誤，請(qǐng)第一時(shí)間聯(lián)系我們修改或刪除，多謝。

上一篇：PHP協(xié)程初體驗(yàn)

下一篇：使用PHP生成二維碼的方法匯總