/** * @test */ public function shouldOptimizeDuplicatedRelationFetches() { //given $category = Category::create(array('name' => 'phones')); $manufacturer = Manufacturer::create(array('name' => 'sony')); $product = Product::create(array('name' => 'sony', 'id_category' => $category->getId(), 'id_manufacturer' => $manufacturer->id)); OrderProduct::create(array('id_product' => $product->getId())); Stats::reset(); //when $orderProduct = OrderProduct::where()->with('product->category')->with('product->manufacturer')->fetch(); //then $this->assertEquals($product->id, $orderProduct->product->id); $this->assertEquals($category, $orderProduct->product->category); $this->assertEquals($manufacturer, $orderProduct->product->manufacturer); $this->assertEquals(4, Stats::getNumberOfQueries()); }
/** * @test */ public function shouldJoinMultipleModels() { //given $category1 = Category::create(array('name' => 'phones')); $product1 = Product::create(array('name' => 'sony', 'id_category' => $category1->getId())); $order1 = Order::create(array('name' => 'order#1')); OrderProduct::create(array('id_order' => $order1->getId(), 'id_product' => $product1->getId())); $category2 = Category::create(array('name' => 'phones')); $product2 = Product::create(array('name' => 'sony', 'id_category' => $category2->getId())); $order2 = Order::create(array('name' => 'order#2')); OrderProduct::create(array('id_order' => $order2->getId(), 'id_product' => $product2->getId())); //when $orderProducts = OrderProduct::join('product')->join('order')->where(array('products.id' => $product1->getId()))->fetchAll(); //then $this->assertCount(1, $orderProducts); $find = Arrays::first($orderProducts); $this->assertEquals('order#1', $find->order->name); $this->assertEquals('sony', $find->product->name); $this->assertEquals('phones', $find->product->category->name); }