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