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))']);
}
