我正在使用Laravel构建一个认证系统,其中用户可以拥有不同的角色。我有三个表:users
、roles
、role_user
。
users
+----------------+------------------+------+-----+---------------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------------+------------------+------+-----+---------------------+----------------+
| id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| username | varchar(255) | NO | | NULL | |
| name | varchar(255) | NO | | NULL | |
| surname | varchar(255) | NO | | NULL | |
| email | varchar(255) | NO | | NULL | |
| role_id | int(10) unsigned | NO | MUL | NULL | |
| password | varchar(255) | NO | | NULL | |
| remember_token | varchar(100) | YES | | NULL | |
| created_at | timestamp | NO | | 0000-00-00 00:00:00 | |
| updated_at | timestamp | NO | | 0000-00-00 00:00:00 | |
+----------------+------------------+------+-----+---------------------+----------------+
roles
+-------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------+------------------+------+-----+---------+----------------+
| id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| role | varchar(255) | NO | | NULL | |
+-------+------------------+------+-----+---------+----------------+
role_user
+---------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------+------------------+------+-----+---------+----------------+
| id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| role_id | int(10) unsigned | NO | MUL | NULL | |
| user_id | int(10) unsigned | NO | MUL | NULL | |
+---------+------------------+------+-----+---------+----------------+
我想要填充我的表格:
class UserTableSeeder extends Seeder
{
public function run()
{
Schema::table('roles')->delete();
Role::create(array(
'role' => 'Superadmin'
));
Role::create(array(
'role' => 'Admin'
));
Role::create(array(
'role' => 'User'
));
Schema::table('users')->delete();
User::create(array(
'name' => 'John',
'surname' => 'Svensson',
'username' => 'John_superadmin',
'email' => 'john.svensson@gmail.com',
'role_id' => 1,
'password' => Hash::make('1234'),
));
User::create(array(
'name' => 'Carl',
'surname' => 'Svensson',
'username' => 'Calle S',
'email' => 'carl.svensson@gmail.com',
'role_id' => 2,
'password' => Hash::make('1111'),
));
}
}
针对我的问题:我如何填充role_user表格?我需要一个相应的模型吗?基于现有的用户和角色表,我已经拥有了User和Role模型。
class Role extends Eloquent{
public function users()
{
return $this->belongsToMany('User');
}
}
class User extends Eloquent implements UserInterface, RemindableInterface {
use UserTrait, RemindableTrait;
/**
* The database table used by the model.
*
* @var string
*/
protected $table = 'users';
/**
* The attributes excluded from the model's JSON form.
*
* @var array
*/
protected $hidden = array('password', 'remember_token');
public function roles()
{
return $this->belongsToMany('Role');
}
}
当我尝试进行种子操作时,出现的失败信息如下所示:
Argument 2 passed to Illuminate\Database\Schema\Builder::table() must be an instance of Closure, none given
role_id
字段。 - Jake Wilson