public static function getPlaylistSegmentsFromDatabase($dbConn, $playlistId)
{
$segmentIds = readFromDatabase::readFilteredColumnFromTable($dbConn, array(self::SEGMENT_COLUMN_NAME), self::PLAYLIST_SEGMENTS_TABLE_NAME, array(self::PLAYLIST_COLUMN_NAME), array($playlistId));
$segments = array();
$count = 0;
//make Segments for each segment id and store in an array (segments)
if (count($segmentIds)) {
foreach ($segmentIds as $segmentId) {
$segments[$count++] = new Segment($dbConn, $segmentId[self::SEGMENT_COLUMN_NAME]);
}
}
usort($segments, function ($a, $b) {
return $a->getStartTime() > $b->getStartTime();
});
return $segments;
}
/**
* @param PDO $dbConn
* @param int $episodeId
* @param Episode $episodeObject
*/
public static function getEpisodeAttributesFromDatabase($dbConn, $episodeId, $episodeObject)
{
$databaseResults = readFromDatabase::readFilteredColumnFromTable($dbConn, array(self::PROGRAM_COLUMN_NAME, self::PLAYLIST_COLUMN_NAME, self::PROGRAMMER_COLUMN_NAME, self::START_TIME_COLUMN_NAME, self::END_TIME_COLUMN_NAME), self::TABLE_NAME, array(self::ID_COLUMN_NAME), array($episodeId));
$programId = $databaseResults[0][self::PROGRAM_COLUMN_NAME];
$playlistId = $databaseResults[0][self::PLAYLIST_COLUMN_NAME];
$programmerId = $databaseResults[0][self::PROGRAMMER_COLUMN_NAME];
$episodeObject->setProgram(new Program($dbConn, $programId));
$episodeObject->setPlaylist(new Playlist($dbConn, $playlistId));
$episodeObject->setProgrammer(new Programmer($dbConn, $programmerId));
$startTimeString = $databaseResults[0][self::START_TIME_COLUMN_NAME];
$startDateTime = formatDateStringFromDatabase($startTimeString);
$endTimeString = $databaseResults[0][self::END_TIME_COLUMN_NAME];
$endDateTime = formatDateStringFromDatabase($endTimeString);
$episodeObject->setStartTime($startDateTime);
$episodeObject->setEndTime($endDateTime);
}
/**
* @param PDO $dbConn
*
* @param int $segmentId
*
* @param Segment $segmentObject
*
*/
public static function getSegmentAttributesFromDatabase($dbConn, $segmentId, $segmentObject)
{
$databaseResult = readFromDatabase::readFilteredColumnFromTable($dbConn, null, self::TABLE_NAME, array(self::ID_COLUMN_NAME), array($segmentId));
$segmentName = $databaseResult[0][self::SEGMENT_NAME_COLUMN_NAME];
$segmentObject->setName($segmentName);
$segmentAlbum = $databaseResult[0][self::ALBUM_COLUMN_NAME];
$segmentObject->setAlbum($segmentAlbum);
$segmentAuthor = $databaseResult[0][self::AUTHOR_COLUMN_NAME];
$segmentObject->setAuthor($segmentAuthor);
$segmentCategory = $databaseResult[0][self::CATEGORY_COLUMN_NAME];
$segmentObject->setCategory($segmentCategory);
$segmentDuration = $databaseResult[0][self::DURATION_COLUMN_NAME];
$segmentObject->setDuration($segmentDuration);
$segmentCanCon = $databaseResult[0][self::CAN_CON_COLUMN_NAME];
$segmentObject->setIsCanCon($segmentCanCon);
$segmentNewRelease = $databaseResult[0][self::NEW_RELEASE_COLUMN_NAME];
$segmentObject->setIsNewRelease($segmentNewRelease);
$segmentFrenchVocalMusic = $databaseResult[0][self::FRENCH_VOCAL_MUSIC_COLUMN_NAME];
$segmentObject->setIsFrenchVocalMusic($segmentFrenchVocalMusic);
$dbStartTimeString = $databaseResult[0][self::START_TIME_COLUMN_NAME];
$startDateTime = formatDateStringFromDatabase($dbStartTimeString);
$segmentObject->setStartTime($startDateTime);
}
