/** * @param Queue * @return array */ public function fetchMediaItemsByQueue(Queue $queue) { if (!$this->isQueueCached($queue->getId())) { $this->queues[$queue->getId()] = $this->_dataMapper->fetchMediaItemsByQueue($queue); foreach ($this->queues[$queue->getId()] as $video) { if ($this->isMediaItemCached($video->getId())) { $video = $this->videos[$video->getId()]; } else { $this->videos[$video->getId()] = $video; } } } return $this->queues[$queue->getId()]; }
/** * @param Queue * @return array */ public function fetchMediaItemsByQueue(Queue $queue) { $results = $this->_dbCon->query('SELECT * FROM `video` WHERE `id` = ?', array($queue->getId())); if ($results->count()) { $videos = array(); foreach ($results as $row) { $video = new MediaItem(); $video->setId($row['id'])->setTitle($row['title'])->setLink($row['link'])->setThumbsUp($row['thumbs_up'])->setThumbsDown($row['thumbs_down'])->setChannelId($row['channel_id'])->setChannelTitle($row['channel_title'])->setThumbnail($row['thumbnail'])->setDescription($row['description'])->setDuration($row['duration']); $videos[] = $video; } return $videos; } else { throw new Exception("MediaItems not found", 404); } }
/** * @param Queue * @return void */ public function deleteQueue(Queue $queue) { $statement = $this->_dbCon->query('DELETE FROM `queue` WHERE `id` = ?', array($queue->getId())); }