/**
* @dataProvider addMultiColumnProvider
*/
public function testAddMultiColumn($email, $album_id, $position, $resulting_order)
{
$favorite_album = new FavoriteAlbum();
$favorite_album->setAlbumId($album_id);
$favorite_album->setEmail($email);
$favorite_album->setPosition($position);
$favorite_album->store();
$expected_result = array();
foreach ($resulting_order as $index => $album_id) {
$expected_result[] = array('email' => $email, 'position' => $index + 1, 'album_id' => $album_id);
}
$actual_result = self::$db->translatedQuery("SELECT email, position, album_id FROM favorite_albums WHERE email = %s ORDER BY position ASC", $email)->fetchAllRows();
$this->assertEquals($expected_result, $actual_result);
}
