/**
* @test
*/
public function shouldAliasTables()
{
//given
$category = Category::create(array('name' => 'phones'));
Product::create(array('name' => 'a', 'id_category' => $category->getId()));
//when
$product = Product::alias('p')->join('category', 'c')->where("p.name = 'a' and c.name = 'phones'")->fetch();
//then
$this->assertNotNull($product);
$this->assertEquals($category, self::getNoLazy($product, 'category'));
Assert::thatArray($product->attributes())->containsKeyAndValue(array('name' => 'a', 'id_category' => $category->getId()));
}
