public static void DatabaseUpdater(LogInformation informations)
{
DatabaseConfiguration databaseConfiguration = LoadDatabaseConfiguration();
throw new NotImplementedException("Function is not yet implemented!");
}
public static void WriteLogToDatabase(LogInformation information)
{
DatabaseConfiguration configuration = LoadDatabaseConfiguration();
string SQLCommand = "USE " + configuration.databaseName + ";";
SQLCommand += "INSERT INTO " + configuration.tableName + " (";
SQLCommand += "UserID, " +
"RequestTime, " +
"ProcessedVideoLocation, " +
"IsDeleteWhenCompleteRequested, " +
"IsOriginalFileDeleted, " +
"TotalProcessingDuration, " +
"AudioProcessingDuration, " +
"VideoProcessingDuration, " +
"OriginalVideoWidth, " +
"OriginalVideoHeight, " +
"OriginalFrameRate, " +
"FPSRequest, " +
"Scaled, " +
"ScaledVideoWidth, " +
"ScaledVideoHeight, " +
"WithAudio, " +
"VideoStartFrame, " +
"VideoEndFrame, " +
"VideoDuration, " +
"VideoStatus, " +
"ErrorCode, " +
"ErrorMessage, " +
"ProgramArguments, " +
"FFmpegLocation, " +
"FFProbeLocation, " +
" VALUES " +
information.userID + ", " +
information.requestTime + ", " +
//information.finishedTime + ", " +
information.processedVideoLocation + ", ";
if (information.isDeleteWhenCompleteRequested)
{
SQLCommand += "1, ";
}
else
{
SQLCommand += "0, ";
}
SQLCommand += information.isOriginalFileDeleted + ", " +
information.originalVideoWidth + ", " +
information.originalVideoHeight + ", " +
information.originalFrameRate + ", " +
information.scaled + ", " +
information.withAudio + ", " +
information.scaledVideoWidth + ", " +
information.scaledVideoHeight + ", " +
information.totalProcessingDuration.TotalSeconds + ", " +
information.videoStartFrame + ", " +
information.videoEndFrame + ", " +
information.videoDuration + ", " +
information.status + ", 0, " +
information.errorMessage + ", " +
information.programArguments + ", " +
information.FFmpegLocation + ", " +
information.FFProbeLocation + ";";
Peralatan.TambahKeDatabase(SQLCommand, configuration.databaseConnectionString);
throw new NotImplementedException("Function is not completed yet");
}
public static LogInformation GenerateLog(ProcessedVideoInformation videoInfo, VideoInformation processedVideoInformation, ProcessingInformation processingInfo, UserInformation userInfo, Requester requester)
{
#region Preparation
DatabaseConfiguration configuration = LoadDatabaseConfiguration();
LogInformation logInformation = new LogInformation();
FFmpegConfiguration applicationConfiguration = LoadApplicationConfiguration();
#endregion Preparation
#region FFmpeg's log
if (applicationConfiguration.useCustomFFmpeg)
{
logInformation.FFmpegLocation = applicationConfiguration.FFmpegLocation;
}
else
{
logInformation.FFmpegLocation = string.Empty;
}
#endregion FFmpeg's log
#region FFProbe's log
if (applicationConfiguration.useCustomFFProbe)
{
logInformation.FFProbeLocation = applicationConfiguration.FFProbeLocation;
}
else
{
logInformation.FFProbeLocation = string.Empty;
}
#endregion FFProbe's log
#region Request time
logInformation.requestTime = processingInfo.processingStartTime;
logInformation.finishedTime = processingInfo.processingEndTime;
#endregion Request time
#region UserID
string userID = string.Empty;
if (Peralatan.PeriksaDataDatabase(userInfo.UserSessionID, "SessionID", configuration.databaseName, configuration.userTableName, configuration.databaseConnectionString))
{
userID = Peralatan.MintaDataDatabase(configuration.databaseName, "UserID", configuration.userTableName, "SessionID", userInfo.UserSessionID, configuration.databaseConnectionString);
}
logInformation.userID = userID;
#endregion UserID
#region Processed video location
logInformation.processedVideoLocation = videoInfo.target;
#endregion Processed video location
#region Delete original file
logInformation.isDeleteWhenCompleteRequested = videoInfo.deleteOriginal;
#endregion Delete original file
#region Processing duration
logInformation.totalProcessingDuration = processingInfo.totalVideoDuration;
logInformation.audioProcessingDuration = processingInfo.processedAudioDuration;
logInformation.videoProcessingDuration = processingInfo.processedVideoDuration;
#endregion Processing duration
#region Video information
logInformation.originalVideoWidth = processedVideoInformation.videoHeight;
logInformation.originalVideoHeight = processedVideoInformation.videoHeight;
logInformation.videoDuration = processedVideoInformation.videoDuration;
logInformation.scaledVideoWidth = videoInfo.width;
logInformation.scaledVideoHeight = videoInfo.height;
#endregion Video information
return(logInformation);
}
