コード例 #1
0
 /** @test */
 public function it_can_combine_with_and_joins()
 {
     $bar = Bar::with('foo', 'baz')->references('baz')->where('baz.id', '=', 2)->first();
     $this->assertEquals('First Foo Second Baz Bar', $bar->title);
     $this->assertEquals('First Foo', $bar->foo->title);
     $this->assertEquals('Second Baz', $bar->baz->title);
     $this->assertQuery('select "baz"."id" as "__f__baz---id", "baz"."title" as "__f__baz---title", "baz"."created_at" as "__f__baz---created_at", "baz"."updated_at" as "__f__baz---updated_at", "bars".* from "bars" left join "bazs" as "baz" on "baz"."id" = "bars"."baz_id" where "baz"."id" = ? limit 1');
     $this->assertQuery('select * from "foos" where "foos"."id" in (?)');
     $this->assertQueryCount(2);
 }