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