PHP Windwalker\DataMapper RelationDataMapper::findAll Examples

Example #1

File: RelationDataMapperTest.php Project: lyrasoft/lyrasoft.github.io

    /**
     * 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));
    }