首页 \ 问答 \ 写下与Eloquent ORM / Laravel的很多关系(Write to hasMany relationship with Eloquent ORM/Laravel)

写下与Eloquent ORM / Laravel的很多关系(Write to hasMany relationship with Eloquent ORM/Laravel)

关于Laravel的雄辩ORM的问题。 我已经看过SO了,如果我错过了类似的问题,我会道歉。

我有一个User模型,我正在尝试通过User模型中的关系将一组权限写回UserPermissions模型。

我已经设置了hasMany链接,并且可以从User对象( $user->roles )中检索正确的数据,但是如果可能的话,无法解决如何回写的问题。

这是我的基本用户模型:

class User extends Eloquent {

    protected $table = 'users';

    public $timestamps = false;

    protected function roles() {

        return $this->hasMany('UserPermission');

    }

}

和UserPermission模型:

class UserPermission extends Eloquent {

    protected $table = 'users_permissions';

    public $timestamps = false;

    protected $fillable = ['role_id', 'user_id'];

}

在这个阶段,我已经恢复保存用户,然后运行UserPermission::insert() ,它允许传递一个数组,但如果可能的话,我宁愿一步完成。

有人知道这是否可行?

谢谢!


更新

表格结构如下:

用户表

+------------------+------------------+------+-----+---------+----------------+
| Field            | Type             | Null | Key | Default | Extra          |
+------------------+------------------+------+-----+---------+----------------+
| id               | int(10) unsigned | NO   | PRI | 0       | auto_increment |
| username         | varchar(255)     | NO   |     |         |                |
+------------------+------------------+------+-----+---------+----------------+

users_roles表

+------------------+------------------+------+-----+---------+----------------+
| Field            | Type             | Null | Key | Default | Extra          |
+------------------+------------------+------+-----+---------+----------------+
| id               | int(10) unsigned | NO   | PRI | 0       | auto_increment |
| name             | varchar(255)     | NO   |     |         |                |
| description      | varchar(255)     | YES  |     | NULL    |                |
| url_access       | varchar(255)     | NO   |     |         |                |
+------------------+------------------+------+-----+---------+----------------+

users_permissions表

+------------------+------------------+------+-----+---------+----------------+
| Field            | Type             | Null | Key | Default | Extra          |
+------------------+------------------+------+-----+---------+----------------+
| id               | int(10) unsigned | NO   | PRI | 0       | auto_increment |
| role_id          | int(10) unsigned | NO   |     |         |                |
| user_id          | int(10) unsigned | NO   |     |         |                |
+------------------+------------------+------+-----+---------+----------------+

role_idusers_roles.iduser_idusers.id

作为后台逻辑, users_roles表有一个url_access列,其中包含一个url。 如果将用户分配给该角色,则他们可以从该URL访问子页面。


Question about Laravel's Eloquent ORM. I've had a look on SO already, apologies if I've missed a similar question.

I have a User model, and I'm trying to write an array of Permissions back to the UserPermissions model, via the relationship in the User model.

I've setup the hasMany link already, and can retrieve the correct data from the User object ($user->roles), but can't work out how to write back if it is at all possible.

This is my basic user model:

class User extends Eloquent {

    protected $table = 'users';

    public $timestamps = false;

    protected function roles() {

        return $this->hasMany('UserPermission');

    }

}

and the UserPermission model:

class UserPermission extends Eloquent {

    protected $table = 'users_permissions';

    public $timestamps = false;

    protected $fillable = ['role_id', 'user_id'];

}

At this stage, I've reverted to saving the User, and then running UserPermission::insert(), which allows an array to be passed, but I'd prefer to do it in one step if possible.

Anyone know if this is possible?

Thanks!


UPDATE:

Table structure is below for your perusal:

users table

+------------------+------------------+------+-----+---------+----------------+
| Field            | Type             | Null | Key | Default | Extra          |
+------------------+------------------+------+-----+---------+----------------+
| id               | int(10) unsigned | NO   | PRI | 0       | auto_increment |
| username         | varchar(255)     | NO   |     |         |                |
+------------------+------------------+------+-----+---------+----------------+

users_roles table

+------------------+------------------+------+-----+---------+----------------+
| Field            | Type             | Null | Key | Default | Extra          |
+------------------+------------------+------+-----+---------+----------------+
| id               | int(10) unsigned | NO   | PRI | 0       | auto_increment |
| name             | varchar(255)     | NO   |     |         |                |
| description      | varchar(255)     | YES  |     | NULL    |                |
| url_access       | varchar(255)     | NO   |     |         |                |
+------------------+------------------+------+-----+---------+----------------+

users_permissions table

+------------------+------------------+------+-----+---------+----------------+
| Field            | Type             | Null | Key | Default | Extra          |
+------------------+------------------+------+-----+---------+----------------+
| id               | int(10) unsigned | NO   | PRI | 0       | auto_increment |
| role_id          | int(10) unsigned | NO   |     |         |                |
| user_id          | int(10) unsigned | NO   |     |         |                |
+------------------+------------------+------+-----+---------+----------------+

role_id relates to users_roles.id and user_id relates to users.id

As background logic, the users_roles table has a url_access column which contains a url. If the user is assigned to that role, they have access to the subpages from that url.


原文:https://stackoverflow.com/questions/21295850
更新时间:2022-05-09 22:05

最满意答案

正如Apple Docs所述:

automaticallyMergesChangesFromParent

一个布尔值,指示上下文是否自动合并保存到其持久性存储协调器或父上下文的更改。

尝试将其设置为true

container.viewContext.automaticallyMergesChangesFromParent = true

至少那解决了类似的问题。


As Apple Docs states:

automaticallyMergesChangesFromParent

A Boolean value that indicates whether the context automatically merges changes saved to its persistent store coordinator or parent context.

Try setting it to true

container.viewContext.automaticallyMergesChangesFromParent = true

At least that solved similar problem for me.

相关问答

更多

相关文章

更多

最新问答

更多
  • python的访问器方法有哪些
  • 使用Zend Framework 2中的JOIN sql检索数据(Retrieve data using JOIN sql in Zend Framework 2)
  • 透明度错误IE11(Transparency bug IE11)
  • linux的基本操作命令。。。
  • 响应navi重叠h1和nav上的h1链接不起作用(Responsive navi overlaps h1 and navi links on h1 isn't working)
  • 在C中读取文件:“r”和“a +”标志的不同行为(Reading a File in C: different behavior for “r” and “a+” flags)
  • NFC提供什么样的带宽?(What Kind of Bandwidth does NFC Provide?)
  • 元素上的盒子阴影行为(box-shadow behaviour on elements)
  • Laravel检查是否存在记录(Laravel Checking If a Record Exists)
  • 设置base64图像的大小javascript - angularjs(set size of a base64 image javascript - angularjs)
  • 想学Linux 运维 深圳有哪个培训机构好一点
  • 为什么有时不需要在lambda中捕获一个常量变量?(Why is a const variable sometimes not required to be captured in a lambda?)
  • 在Framework 3.5中使用服务器标签<%=%>设置Visible属性(Set Visible property with server tag <%= %> in Framework 3.5)
  • AdoNetAppender中的log4net连接类型无效(log4net connection type invalid in AdoNetAppender)
  • 错误:发送后无法设置标题。(Error: Can't set headers after they are sent. authentication system)
  • 等待EC2实例重启(Wait for an EC2 instance to reboot)
  • 如何在红宝石中使用正则表达式?(How to do this in regex in ruby?)
  • 使用鼠标在OpenGL GLUT中绘制多边形(Draw a polygon in OpenGL GLUT with mouse)
  • 江民杀毒软件的KSysnon.sys模块是什么东西?
  • 处理器在传递到add_xpath()或add_value()时调用了什么顺序?(What order are processors called when passed into add_xpath() or add_value()?)
  • sp_updatestats是否导致SQL Server 2005中无法访问表?(Does sp_updatestats cause tables to be inaccessible in SQL Server 2005?)
  • 如何创建一个可以与持续运行的服务交互的CLI,类似于MySQL的shell?(How to create a CLI that can interact with a continuously running service, similar to MySQL's shell?)
  • AESGCM解密失败的MAC(AESGCM decryption failing with MAC)
  • SQL查询,其中字段不包含$ x(SQL Query Where Field DOES NOT Contain $x)
  • PerSession与PerCall(PerSession vs. PerCall)
  • C#:有两个构造函数的对象:如何限制哪些属性设置在一起?(C#: Object having two constructors: how to limit which properties are set together?)
  • 平衡一个精灵(Balancing a sprite)
  • n2cms Asp.net在“文件”菜单上给出错误(文件管理器)(n2cms Asp.net give error on Files menu (File Manager))
  • Zurb Foundation 4 - 嵌套网格对齐问题(Zurb Foundation 4 - Nested grid alignment issues)
  • 湖北京山哪里有修平板计算机的