/**
* @test
*/
public function shouldOptimizeDuplicatedJoins()
{
//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::join('product->category')->join('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(1, 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);
}
