Laravel MongoDB库'jenssegers/laravel-mongodb'hasMany关系不起作用 [英] Laravel MongoDB library 'jenssegers/laravel-mongodb' hasMany relationship is not working

查看：126 发布时间：2020/4/23 10:20:06 mongodb laravel orm laravel-5.3 jenssegers-mongodb

本文介绍了Laravel MongoDB库'jenssegers/laravel-mongodb'hasMany关系不起作用的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

问题描述

我正在使用MongoDB库 https://github.com/jenssegers/laravel-mongodb Laravel 5.3.28中的version 3.1.0-alpha我在MongoDB中有两个集合，我想与它们建立hasMany关系.意味着每个员工执行许多任务.我已使用参考并在任务集合中添加了employee_ids.

I am using MongoDB library https://github.com/jenssegers/laravel-mongodb version 3.1.0-alpha in Laravel 5.3.28 I have two collections in MongoDB and I want to make a hasMany relation b/w them. Means each Employee performs many tasks. I have used reference and added employee_ids in the task collection.

下面是我的代码:

MongoDB:

第一个集合:员工

{
    "_id" : ObjectId("586ca8c71a72cb07a681566d"),
    "employee_name" : "John",
    "employee_description" : "test description",
    "employee_email" : "john@email.com",
    "updated_at" : "2017-01-04 11:45:20",
    "created_at" : "2017-01-04 11:45:20"
},
{
    "_id" : ObjectId("586ca8d31a72cb07a6815671"),
    "employee_name" : "Carlos",
    "employee_description" : "test description",
    "employee_email" : "carlos@email.com",
    "updated_at" : "2017-01-04 11:45:20",
    "created_at" : "2017-01-04 11:45:20"
}

第二个收藏集:任务

{
    "_id" : ObjectId("586ccbcf1a72cb07a6815b04"),
    "task_name" : "New Task",
    "task_description" : "test description",
    "task_status" : 1,
    "task_start" : "2017-04-01 12:00:00",
    "task_end" : "2017-04-01 02:00:00",
    "task_created_at" : "2017-04-01 02:17:00",
    "task_updated_at" : "2017-04-01 02:17:00",
    "employee_id" : [ 
        ObjectId("586ca8c71a72cb07a681566d"), 
        ObjectId("586ca8d31a72cb07a6815671")
    ]
},
{
    "_id" : ObjectId("586cd3261a72cb07a6815c69"),
    "task_name" : "2nd Task",
    "task_description" : "test description",
    "task_status" : 1,
    "task_start" : "2017-04-01 12:00:00",
    "task_end" : "2017-04-01 02:00:00",
    "task_created_at" : "2017-04-01 02:17:00",
    "task_updated_at" : "2017-04-01 02:17:00",
    "employee_id" : ObjectId("586ca8c71a72cb07a681566d")
}

Laravel: 模型: 员工:

Laravel: Model: Employee:

<?php
namespace App\Models;

use Jenssegers\Mongodb\Eloquent\Model as Eloquent;

class Employee extends Eloquent {

    protected $collection = 'employee';
    protected $primaryKey = '_id';

    public function tasks()
    {
        return $this->hasMany('App\Models\Task');
    }
}

Laravel: 模型: 任务:

Laravel: Model: Task:

<?php
namespace App\Models;

use Jenssegers\Mongodb\Eloquent\Model as Eloquent;

class Task extends Eloquent {

    protected $collection = 'task';
    protected $primaryKey = '_id';

    public function employees()
    {
        return $this->belongsTo('App\Models\Employee');
    }
}

我想将任务分配给特定员工.

I want to get tasks assigned to the specific employee.

控制器:

public function EmployeeData($data)
{
    $employees = Employee::with('tasks')->where('_id', new \MongoDB\BSON\ObjectID('586ca8d31a72cb07a6815671'))->get();
        echo "<pre>";
        print_r($employees);exit;
}

输出:

在输出中，关系任务项为空.

In the output, relation tasks items are empty.

有人可以建议我说黑白收藏是正确的吗?

Can anyone suggest me that the relation b/w collections are correct?

更新

我在关系中使用了belongsToMany.现在我的模型是:

I have used belongsToManyin the relation. Now my models are:

在员工模型中:

    public function tasks()
    {
        return $this->belongsToMany('App\Models\Task');
    }

在任务模型中:

    public function employees()
    {
        return $this->belongsToMany('App\Models\Employee');
    }

这些是文件:

员工集合

{
    "_id" : ObjectId("586ca8c71a72cb07a681566d"),
    "employee_name" : "Carlos",
    "employee_description" : "test description",
    "employee_email" : "carlos@email.com",
    "updated_at" : "2017-01-04 11:45:20",
    "created_at" : "2017-01-04 11:45:20",
    "task_ids" : [ 
        ObjectId("586ccbcf1a72cb07a6815b04"), 
        ObjectId("586cd3261a72cb07a6815c69")
    ]
}, 
{
    "_id" : ObjectId("586ca8d31a72cb07a6815671"),
    "employee_name" : "John",
    "employee_description" : "test description",
    "employee_email" : "john@email.com",
    "updated_at" : "2017-01-04 11:45:20",
    "created_at" : "2017-01-04 11:45:20"
}

任务集合

{
    "_id" : ObjectId("586ccbcf1a72cb07a6815b04"),
    "task_name" : "New Task",
    "task_description" : "test description",
    "task_status" : 1,
    "task_start" : "2017-04-01 12:00:00",
    "task_end" : "2017-04-01 02:00:00",
    "task_created_at" : "2017-04-01 02:17:00",
    "task_updated_at" : "2017-04-01 02:17:00",
    "employee_ids" : [ 
        ObjectId("586ca8c71a72cb07a681566d"), 
        ObjectId("586ca8d31a72cb07a6815671")
    ]
},
{
    "_id" : ObjectId("586cd3261a72cb07a6815c69"),
    "task_name" : "2nd Task",
    "task_description" : "test description",
    "task_status" : 1,
    "task_start" : "2017-04-01 12:00:00",
    "task_end" : "2017-04-01 02:00:00",
    "task_created_at" : "2017-04-01 02:17:00",
    "task_updated_at" : "2017-04-01 02:17:00",
    "employee_ids" : ObjectId("586ca8c71a72cb07a681566d")
}

我拥有这些文件的第一位员工:

I get the first employee with these documents:

$employee = Employee::with('tasks')->first();
dd($employee);

我得到了带有空关系的输出:

And I gotthe output with empty relation:

Employee {#176
  #connection: "mongodb"
  #collection: "employee"
  #primaryKey: "_id"
  -employee_id: null
  -employee_name: null
  -employee_description: null
  -employee_email: null
  -employee_created_at: null
  -employee_updated_at: null
  #parentRelation: null
  #table: null
  #keyType: "int"
  #perPage: 15
  +incrementing: true
  +timestamps: true
  #attributes: array:10 [
    "_id" => ObjectID {#170}
    "employee_name" => "Carlos"
    "employee_description" => "test description"
    "employee_email" => "carlos@email.com"
    "updated_at" => "2017-01-04 11:45:20"
    "created_at" => "2017-01-04 11:45:20"
    "task_ids" => array:2 [
      0 => ObjectID {#174}
      1 => ObjectID {#175}
    ]
  ]
  #original: array:10 [
    "_id" => ObjectID {#170}
    "employee_name" => "Carlos"
    "employee_description" => "test description"
    "employee_email" => "carlos@email.com"
    "updated_at" => "2017-01-04 11:45:20"
    "created_at" => "2017-01-04 11:45:20"
    "task_ids" => array:2 [
      0 => ObjectID {#174}
      1 => ObjectID {#175}
    ]
  ]
  #relations: array:1 [
    "tasks" => Collection {#173
      #items: []
    }
  ]
  #hidden: []
  #visible: []
  #appends: []
  #fillable: []
  #guarded: array:1 [
    0 => "*"
  ]
  #dates: []
  #dateFormat: null
  #casts: []
  #touches: []
  #observables: []
  #with: []
  +exists: true
  +wasRecentlyCreated: false
}

推荐答案

我的另一个问题是我理解一个任务可以属于许多员工，对吗?因此，您应该在Task模型中使用belongsToMany关系.同样，您的示例任务"集合还显示，在一个文档employee_id中，它是一个数组，而在另一文档中，它是一个ObjectId，而两个文档都应该是数组.

I understood by your other question, that a task can belong to many employees, right? So you should be using belongsToMany relationship in your Task model. Also your example "task" collection shows that in one document employee_id is an array and in the other document it is an ObjectId, when both should be arrays.

无论如何，我一直很难尝试解决这个问题，但是我发现您不能将hasMany用作belongsToMany的反函数，因为belongsToMany创建了一个id数组，和hasMany不适用于数组.我会说我们需要类似hasManyInArray的东西，但是当我关联belongsToMany关系时，父"文档会创建一个ID数组，这使我认为父级甚至应该使用belongsToMany尽管它不是属于"，但实际上是具有".因此，当您将员工与这样的任务相关联时:

Anyway, I've had a hard time trying to figure this out, but I've seen that you can't use hasMany as the inverse of belongsToMany, because belongsToMany creates an array of ids, and hasMany doesn't work well with arrays. I would say that we would need something like hasManyInArray, but when I associate a belongsToMany relationship, the "parent" document gets created an array of ids, which leads me to think that the parent should also use belongsToMany even though it doesn't "belong to" but actually "has". So when you would associate an employee to a task like this:

$task->employees()->save($employee);

员工"文档最终将具有"task_ids"属性，该属性应具有唯一的任务ID.因此，这似乎就是Jenssegers的处理方式:在两个模型中都使用belongsToMany:

The "employee" document will end up having a "task_ids" attribute with the only task id it should have. So that seems to be the way to go with Jenssegers: to use belongsToMany in both models:

Laravel:型号:员工:

<?php
namespace App\Models;

use Jenssegers\Mongodb\Eloquent\Model as Eloquent;

class Employee extends Eloquent
{
    protected $collection = 'employee';

    public function tasks()
    {
        return $this->belongsToMany(Task::class);
    }
}

Laravel:模型:任务:

<?php
namespace App\Models;

use Jenssegers\Mongodb\Eloquent\Model as Eloquent;

class Task extends Eloquent
{
    protected $collection = 'task';

    public function employees()
    {
        return $this->belongsToMany(Employee::class);
    }
}

您将这样使用:

// Give a task a new employee
$task->employees()->save($employee);

// Or give an employee a new task
$employee->tasks()->save($task);

唯一的问题是，当您查看数据库时，您将看到您的员工文档具有一个名为"task_ids"的数组，并且在其中包含每个员工唯一的任务的ID.希望对您有所帮助.

The only thing about this is that when you look at the database, you will see that your employee documents have an array called "task_ids", and inside it, the id of the only task each employee have. I hope this helped.

只有一些注意事项，您知道不必在每个模型上都定义主键的名称，对吗?您不需要这个:

Just some side notes, you know that you don't have to define the name of the primary key on each model, right? You don't need this:

protected $primaryKey = '_id';

也不必定义集合的名称(即protected $collection = 'employee';)，除非您真的希望它们为单数形式(默认情况下为复数形式).

Also you don't have to define the name of the collection (i.e. protected $collection = 'employee';), unless you really want them to be in singular (by default they are in plural).

我半夜起床(这里是凌晨3:52)，在计算机上检查了一下内容，然后检查了一下，看到了您的问题，希望这次我能尽快为您答复，我们似乎在不同的时区.

I got up in the middle of the night (it's 3:52AM here) and checked something on the computer and then checked SO an saw your question, I hope this time I answered soon enough for you, we seem to be in different timezones.

更新

这些是我创建的用于测试的文档:

These are the documents I created for testing:

员工集合

{
    "_id" : ObjectId("5870ba1973b55b03d913ba54"),
    "name" : "Jon",
    "updated_at" : ISODate("2017-01-07T09:51:21.316Z"),
    "created_at" : ISODate("2017-01-07T09:51:21.316Z"),
    "task_ids" : [ 
        "5870ba1973b55b03d913ba56"
    ]
},
{
    "_id" : ObjectId("5870ba1973b55b03d913ba55"),
    "name" : "Doe",
    "updated_at" : ISODate("2017-01-07T09:51:21.317Z"),
    "created_at" : ISODate("2017-01-07T09:51:21.317Z"),
    "task_ids" : [ 
        "5870ba1973b55b03d913ba56"
    ]
}

任务收集

{
    "_id" : ObjectId("5870ba1973b55b03d913ba56"),
    "name" : "New Task",
    "updated_at" : ISODate("2017-01-07T09:51:21.317Z"),
    "created_at" : ISODate("2017-01-07T09:51:21.317Z"),
    "employee_ids" : [ 
        "5870ba1973b55b03d913ba54", 
        "5870ba1973b55b03d913ba55"
    ]
}

有了这些文件，我得到了这样的第一位员工:

With these documents I get the first employee like this:

$employee = Employee::with('tasks')->first();
dd($employee);

在输出中，我们可以看到Relationships属性是一个数组:

And in the output we can see the relations attribute is an array:

Employee {#186 ▼
  #collection: "employee"
  #primaryKey: "_id"
  // Etc.....
  #relations: array:1 [▼
    "tasks" => Collection {#199 ▼
      #items: array:1 [▼
        0 => Task {#198 ▼
          #collection: "task"
          #primaryKey: "_id"
          // Etc....
          #attributes: array:5 [▼
            "_id" => ObjectID {#193}
            "name" => "New Task"
            "updated_at" => UTCDateTime {#195}
            "created_at" => UTCDateTime {#197}
            "employee_ids" => array:2 [▶]
          ]
        }
      ]
    }
  ]
}

更新2

belongsToMany方法不在您提到的文件中，因为该类(即Jenssegers\Mongodb\Eloquent\Model)扩展了Laravel的Eloquent Model类，而这正是belongsToMany方法所在的地方.

The belongsToMany method isn't in the file you mention because that class (i.e. Jenssegers\Mongodb\Eloquent\Model) extends Laravel's Eloquent Model class, and that's where the belongsToMany method is.

好吧，这一定是为什么它对您不起作用的原因，因为数组必须是字符串而不是ObjectIds.为什么是这样?因为这就是Jenssegers库的工作方式，所以它将Ids保存为字符串.我也发现这种行为很奇怪，但这就是它的工作原理.请记住，应该使用使用Jenssegers库来关联对象，而不是通过在数据库中手动创建数据来实现. 您如何索引ID?只需在MongoDB中创建一个普通索引，例如tasks.createIndex({task_ids: 1}).以下是有关如何创建索引的文档: https://docs. mongodb.com/manual/reference/method/db.collection.createIndex/.您也可以创建有关迁移的索引，此处是有关迁移的文档，请务必阅读<还有href ="https://github.com/jenssegers/laravel-mongodb#schema" rel ="nofollow noreferrer"> Jenssegers关于迁移的说明.

Ok so that must be why it's not working for you, because the arrays have to be strings instead of ObjectIds. Why is this? Because that's how the Jenssegers library work, it saves the Ids as strings. I've also found this behaviour strange, but that's how it works. Remember that you are supposed to relate objects using the Jenssegers library, not by creating the data manually in the database. How can you index the ids? Just create a normal index in MongoDB, like tasks.createIndex({task_ids: 1}). Here's the documentation on how to create indexes: https://docs.mongodb.com/manual/reference/method/db.collection.createIndex/. You can also create indexes on migrations, here are the docs on migrations, make sure to read Jenssegers notes on migrations too.

您可以像这样访问tasks区域:$employee->tasks;.您可以通过获取与声明您的关系的方法名称相同的属性来访问关系，因此如果您拥有:

You can access the tasks realtion like this: $employee->tasks;. You access relations by getting a property with the same name of the method you declared your relation with, so if you have:

class Post { public function owner() { return $this->belongsTo(User::class); } }

您将得到的关系为$post->owner;.以下是有关关系的文档: https://laravel.com/docs/5.3/eloquent-relationships

You get the relation as $post->owner;. Here's the documentation on relations: https://laravel.com/docs/5.3/eloquent-relationships

这篇关于Laravel MongoDB库'jenssegers/laravel-mongodb'hasMany关系不起作用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！

查看全文

Laravel MongoDB库'jenssegers/laravel-mongodb'hasMany关系不起作用 [英] Laravel MongoDB library 'jenssegers/laravel-mongodb' hasMany relationship is not working

问题描述

推荐答案

相关文章

其他开发最新文章

热门教程

热门工具

登录关闭

Laravel MongoDB库'jenssegers/laravel-mongodb'hasMany关系不起作用 [英] Laravel MongoDB library &#39;jenssegers/laravel-mongodb&#39; hasMany relationship is not working

问题描述

推荐答案

相关文章

其他开发最新文章

热门教程

热门工具

登录 关闭

Laravel MongoDB库'jenssegers/laravel-mongodb'hasMany关系不起作用 [英] Laravel MongoDB library 'jenssegers/laravel-mongodb' hasMany relationship is not working

登录关闭