/** * Test findAll() * * @covers Windwalker\DataMapper\RelationDataMapper::findAll * * @return void */ public function testFindAll() { $dataset = $this->instance->findAll('flower.title DESC', 1, 3); $sql = <<<SQL SELECT `flower`.`id`, \t`flower`.`catid`, \t`flower`.`title`, \t`flower`.`meaning`, \t`flower`.`ordering`, \t`flower`.`state`, \t`flower`.`params`, \t`category`.`id` AS `category_id`, \t`category`.`title` AS `category_title`, \t`category`.`ordering` AS `category_ordering`, \t`category`.`params` AS `category_params` FROM `ww_flower` AS `flower` \tLEFT JOIN `ww_categories` AS `category` ON flower.catid = category.id ORDER BY flower.title DESC LIMIT 1, 3 SQL; $this->assertEquals($dataset, $this->loadToDataset($sql)); }