add 子查询Where Exists

kvnZero · kvnZero · commit b1fdfe52cc46 · 2021-11-16T15:55:25.000+08:00
diff --git a/test/Cases/GetTest.php b/test/Cases/GetTest.php
@@ -23,7 +23,7 @@ class GetTest extends TestCase
 {
     protected string $method = 'GET';
 
-    public function testWhereExist()
+    public function testWhereExists()
     {
         $json = [
             "[]" => [
@@ -229,4 +229,100 @@ public function testWhereInUseSubQuery()
             ]
         ], $result);
     }
+
+    public function testWhereExistsUseSubQuery()
+    {
+        $json = [
+            "subquery@" => [
+                "from" =>"Comment",
+                "Comment" => [
+                    "momentId" =>15,
+                    "@column" =>"userId"
+                ]
+            ],
+            "[]" => [
+                "User" => [
+                    "id}{@" =>"subquery",
+                    "@column" =>"id,sex,name"
+                ]
+            ]
+        ];
+        $parse = new Parse($json, $this->method, '');
+        $result = $parse->handle();
+
+        $this->assertSame([
+            "[]" =>[
+                [
+                    "User" => [
+                        "id" =>38710,
+                        "sex" =>0,
+                        "name" =>"TommyLemon"
+                    ]
+                ],
+                [
+                    "User" => [
+                        "id" =>70793,
+                        "sex" =>0,
+                        "name" =>"Strong"
+                    ]
+                ],
+                [
+                    "User" => [
+                        "id" =>82001,
+                        "sex" =>0,
+                        "name" =>"测试账号"
+                    ]
+                ],
+                [
+                    "User" => [
+                        "id" =>82002,
+                        "sex" =>1,
+                        "name" =>"Happy~"
+                    ]
+                ],
+                [
+                    "User" => [
+                        "id" =>82003,
+                        "sex" =>0,
+                        "name" =>"Wechat"
+                    ]
+                ],
+                [
+                    "User" => [
+                        "id" =>82004,
+                        "sex" =>0,
+                        "name" =>"Tommy"
+                    ]
+                ],
+                [
+                    "User" => [
+                        "id" =>82005,
+                        "sex" =>1,
+                        "name" =>"Jan"
+                    ]
+                ],
+                [
+                    "User" => [
+                        "id" =>82006,
+                        "sex" =>1,
+                        "name" =>"Meria"
+                    ]
+                ],
+                [
+                    "User" => [
+                        "id" =>82009,
+                        "sex" =>0,
+                        "name" =>"God"
+                    ]
+                ],
+                [
+                    "User" => [
+                        "id" =>82012,
+                        "sex" =>0,
+                        "name" =>"Steve"
+                    ]
+                ]
+            ],
+        ], $result);
+    }
 }
