Return proper value instead of _id on QueryBuilder

Dan Jones · Dan Jones · commit 20c6093eb7f5 · 2019-04-09T08:06:59.000-05:00
Fixes mongodb#1741
diff --git a/src/Jenssegers/Mongodb/Query/Builder.php b/src/Jenssegers/Mongodb/Query/Builder.php
@@ -203,6 +203,16 @@ public function find($id, $columns = [])
         return $this->where('_id', '=', $this->convertKey($id))->first($columns);
     }
 
+    /**
+     * @inheritdoc
+     */
+    public function value($column)
+    {
+        $result = (array) $this->first([$column]);
+
+        return Arr::get($result, $column);
+    }
+
     /**
      * @inheritdoc
      */
diff --git a/tests/QueryBuilderTest.php b/tests/QueryBuilderTest.php
@@ -701,4 +701,16 @@ public function testProjections()
             $this->assertEquals(1, count($result['tags']));
         }
     }
+
+    public function testValue()
+    {
+        DB::collection('books')->insert([
+            ['title' => 'Moby-Dick', 'author' => ['first_name' => 'Herman', 'last_name' => 'Melville']]
+        ]);
+
+        $this->assertEquals('Moby-Dick', DB::collection('books')->value('title'));
+        $this->assertEquals(['first_name' => 'Herman', 'last_name' => 'Melville'], DB::collection('books')->value('author'));
+        $this->assertEquals('Herman', DB::collection('books')->value('author.first_name'));
+        $this->assertEquals('Melville', DB::collection('books')->value('author.last_name'));
+    }
 }

Original file line number	Diff line number	Diff line change
`@@ -701,4 +701,16 @@ public function testProjections()`
`701`	`701`	`$this->assertEquals(1, count($result['tags']));`
`702`	`702`	`}`
`703`	`703`	`}`
	`704`	`+`
	`705`	`+ public function testValue()`
	`706`	`+ {`
	`707`	`+ DB::collection('books')->insert([`
	`708`	`+ ['title' => 'Moby-Dick', 'author' => ['first_name' => 'Herman', 'last_name' => 'Melville']]`
	`709`	`+ ]);`
	`710`	`+`
	`711`	`+ $this->assertEquals('Moby-Dick', DB::collection('books')->value('title'));`
	`712`	`+ $this->assertEquals(['first_name' => 'Herman', 'last_name' => 'Melville'], DB::collection('books')->value('author'));`
	`713`	`+ $this->assertEquals('Herman', DB::collection('books')->value('author.first_name'));`
	`714`	`+ $this->assertEquals('Melville', DB::collection('books')->value('author.last_name'));`
	`715`	`+ }`
`704`	`716`	`}`