/**
* @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);
}
$segmentTime = addDateToSegmentStartTime($episodeStartDateTime, $segmentTime);
$playlistId = $episode->getPlaylistId();
$segment = new Segment($db, $segmentId);
$segment->setCategory($category);
$segment->setPlaylistId($playlistId);
$segment->setDuration(null);
$segment->setStartTime($segmentTime);
switch ($category) {
case 2:
case 3:
$segment->setName($name);
$segment->setAuthor($author);
$segment->setAlbum($album);
$segment->setCategory($category);
$segment->setIsCanCon($canCon);
$segment->setIsNewRelease($newRelease);
$segment->setIsFrenchVocalMusic($frenchVocalMusic);
$segment->setAdNumber(null);
break;
case 5:
$segment->setName(null);
$segment->setAuthor(null);
$segment->setAlbum(null);
$segment->setIsCanCon(null);
$segment->setIsNewRelease(null);
$segment->setIsFrenchVocalMusic(null);
$segment->setAdNumber($adNumber);
break;
case 4:
$segment->setName($name);
$segment->setAuthor(null);