「Php/fuelphp/migration/model crud」の版間の差分
提供: 初心者エンジニアの簡易メモ
(ページの作成:「==migrationを使ってmodelを作成する== php oil g model test name:varchar[50] created_at:datetime --crud *fuel/app/classes/model/test.php <?php class Model_Test...」) |
(→migrationを使ってmodelを作成する) |
||
行1: | 行1: | ||
==migrationを使ってmodelを作成する== | ==migrationを使ってmodelを作成する== | ||
− | php oil g model | + | php oil g model user name:varchar[31] email:string[63] password:string[31] msg:text created_at:datetime updated_at:datetime --crud |
*fuel/app/classes/model/test.php | *fuel/app/classes/model/test.php | ||
行14: | 行14: | ||
protected static $_table_name = 'tests'; | protected static $_table_name = 'tests'; | ||
} | } | ||
+ | |||
+ | *fuel/app/migrations/002_create_users.php | ||
+ | namespace Fuel\Migrations; | ||
+ | class Create_users | ||
+ | { | ||
+ | public function up() | ||
+ | { | ||
+ | \DBUtil::create_table('users', array( | ||
+ | 'id' => array('constraint' => 11, 'type' => 'int', 'auto_increment' => true, 'unsigned' => true), | ||
+ | 'name' => array('constraint' => 31, 'type' => 'varchar'), | ||
+ | 'email' => array('constraint' => 63, 'type' => 'varchar'), | ||
+ | 'password' => array('constraint' => 31, 'type' => 'varchar'), | ||
+ | 'msg' => array('type' => 'text'), | ||
+ | 'created_at' => array('type' => 'datetime'), | ||
+ | 'updated_at' => array('type' => 'datetime'), | ||
+ | |||
+ | ), array('id')); | ||
+ | } | ||
+ | |||
+ | public function down() | ||
+ | { | ||
+ | \DBUtil::drop_table('users'); | ||
+ | } | ||
+ | } |
2015年10月25日 (日) 01:46時点における版
migrationを使ってmodelを作成する
php oil g model user name:varchar[31] email:string[63] password:string[31] msg:text created_at:datetime updated_at:datetime --crud
- fuel/app/classes/model/test.php
<?php class Model_Test extends \Model_Crud { protected static $_properties = array( 'id', 'name', 'created_at', 'updated_at' ); protected static $_table_name = 'tests'; }
- fuel/app/migrations/002_create_users.php
namespace Fuel\Migrations; class Create_users { public function up() { \DBUtil::create_table('users', array( 'id' => array('constraint' => 11, 'type' => 'int', 'auto_increment' => true, 'unsigned' => true), 'name' => array('constraint' => 31, 'type' => 'varchar'), 'email' => array('constraint' => 63, 'type' => 'varchar'), 'password' => array('constraint' => 31, 'type' => 'varchar'), 'msg' => array('type' => 'text'), 'created_at' => array('type' => 'datetime'), 'updated_at' => array('type' => 'datetime'),
), array('id')); }
public function down() { \DBUtil::drop_table('users'); } }