/**
* @return array
*/
public function fetchAll()
{
$sql = <<<SQL
SELECT version
FROM migrations.migrations
ORDER BY version
SQL;
$versions = [];
$row_generator = $this->yo_pdo->getSelectRowGenerator($sql);
foreach ($row_generator as $row) {
$versions[] = $row['version'];
}
return $versions;
}
/**
* @covers ::getSelectRowGenerator
* @dataProvider dbProvider
* @param YoPdo $yo_pdo
*/
public function testARowGeneratorCanBeUsed(YoPdo $yo_pdo)
{
$sql = <<<SQL
SELECT :param_a AS col UNION
SELECT :param_b AS col UNION
SELECT :last_param AS col
ORDER BY col
SQL;
$result = $yo_pdo->getSelectRowGenerator($sql, array('param_a' => 1, 'param_b' => 2, 'last_param' => 3));
$count = 1;
foreach ($result as $row) {
$this->assertEquals($count, $row['col']);
++$count;
}
}
