public function testSave() { $everywhere = Location::find(1); $bulgaria = Location::findByName('Bulgaria'); $children = $everywhere->getChildren()->add($bulgaria); Location::save($everywhere); $this->assertQueries(['SELECT Location.class, Location.* FROM Location WHERE (id = 1) LIMIT 1', 'SELECT Location.class, Location.* FROM Location WHERE (name = "Bulgaria") LIMIT 1', 'SELECT Location.class, Location.* FROM Location WHERE (parentId IN (1))', 'SELECT Location.class, Location.* FROM Location WHERE (path LIKE "1/3/10%")', 'UPDATE Location SET parentId = CASE id WHEN 10 THEN 1 ELSE parentId END, path = CASE id WHEN 11 THEN "1/10" ELSE path END WHERE (id IN (10, 11))']); }
/** * @covers ::findByCode */ public function testFindByCode() { $model = Location::findByCode('BG'); $expected = Location::findByName('Bulgaria'); $this->assertSame($model, $expected); }