コード例 #1
0
 /** @test */
 public function it_support_multiple_flat_joins()
 {
     $bar = Bar::includes('foo', 'baz')->where('foo.id', '=', 1)->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 "foo"."id" as "__f__foo---id", "foo"."title" as "__f__foo---title", "foo"."created_at" as "__f__foo---created_at", "foo"."updated_at" as "__f__foo---updated_at", "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 "foos" as "foo" on "foo"."id" = "bars"."foo_id" left join "bazs" as "baz" on "baz"."id" = "bars"."baz_id" where "foo"."id" = ? and "baz"."id" = ? limit 1');
     $this->assertQueryCount(1);
 }