private bool Run_BulkLoader(Worker_BulkLoader Prebuilder, bool Verbose)
{
try
{
bool returnValue = Prebuilder.Perform_BulkLoader(Verbose);
if (Prebuilder.Aborted)
{
aborted = true;
}
return(returnValue);
}
catch (Exception ee)
{
return(false);
}
}
private void Run_BulkLoader( bool Verbose )
{
// Create the local log directories
if (!Directory.Exists(Engine_ApplicationCache_Gateway.Settings.Local_Log_Directory))
{
Console.WriteLine("Creating local log directory: " + Engine_ApplicationCache_Gateway.Settings.Local_Log_Directory);
Directory.CreateDirectory(Engine_ApplicationCache_Gateway.Settings.Local_Log_Directory);
}
// Determine the new log name
string log_name = "incoming_" + controllerStarted.Year + "_" + controllerStarted.Month.ToString().PadLeft(2, '0') + "_" + controllerStarted.Day.ToString().PadLeft(2, '0') + ".html";
string local_log_name = Engine_ApplicationCache_Gateway.Settings.Local_Log_Directory + "\\" + log_name;
// Create the new log file
LogFileXhtml preloader_logger = new LogFileXhtml(local_log_name, "SobekCM Incoming Packages Log", "UFDC_Builder.exe", true);
// Step through each database instance
foreach (Database_Instance_Configuration dbConfig in Engine_ApplicationCache_Gateway.Settings.Database_Connections)
{
try
{
if (!dbConfig.Is_Active)
{
Console.WriteLine( dbConfig.Name + " is set to INACTIVE");
preloader_logger.AddNonError(dbConfig.Name + " is set to INACTIVE");
}
else
{
SobekCM_Database.Connection_String = dbConfig.Connection_String;
Library.Database.SobekCM_Database.Connection_String = dbConfig.Connection_String;
Worker_BulkLoader newLoader = new Worker_BulkLoader(preloader_logger, verbose, dbConfig, (instances.Count > 1), logFileDirectory);
newLoader.Perform_BulkLoader(Verbose);
// Save information about this last run
Library.Database.SobekCM_Database.Set_Setting("Builder Version", Engine_ApplicationCache_Gateway.Settings.Current_Builder_Version);
Library.Database.SobekCM_Database.Set_Setting("Builder Last Run Finished", DateTime.Now.ToString());
Library.Database.SobekCM_Database.Set_Setting("Builder Last Message", newLoader.Final_Message);
}
}
catch
{
}
}
}
private bool Run_BulkLoader(Worker_BulkLoader Prebuilder, bool Verbose)
{
try
{
bool returnValue = Prebuilder.Perform_BulkLoader( Verbose );
// Save information about this last run
Library.Database.SobekCM_Database.Set_Setting("Builder Version", Engine_ApplicationCache_Gateway.Settings.Current_Builder_Version);
Library.Database.SobekCM_Database.Set_Setting("Builder Last Run Finished", DateTime.Now.ToString());
Library.Database.SobekCM_Database.Set_Setting("Builder Last Message", Prebuilder.Final_Message);
if (Prebuilder.Aborted)
aborted = true;
return returnValue;
}
catch ( Exception )
{
return false;
}
}
/// <summary> Continuously execute the processes in a recurring background thread </summary>
public void Execute_In_Background()
{
// Set the variable which will control background execution
int time_between_polls = Engine_ApplicationCache_Gateway.Settings.Builder_Override_Seconds_Between_Polls;
if (( time_between_polls < 0 ) || ( Engine_ApplicationCache_Gateway.Settings.Database_Connections.Count == 1 ))
time_between_polls = Convert.ToInt32(Engine_ApplicationCache_Gateway.Settings.Builder.Seconds_Between_Polls);
// Determine the new log name
string log_name = "incoming_" + controllerStarted.Year + "_" + controllerStarted.Month.ToString().PadLeft(2, '0') + "_" + controllerStarted.Day.ToString().PadLeft(2, '0') + ".html";
string local_log_name = Engine_ApplicationCache_Gateway.Settings.Local_Log_Directory + "\\" + log_name;
if (String.IsNullOrEmpty(Engine_ApplicationCache_Gateway.Settings.Local_Log_Directory))
{
local_log_name = logFileDirectory + "\\" + log_name;
}
// Create the new log file
LogFileXhtml preloader_logger = new LogFileXhtml(local_log_name, "SobekCM Incoming Packages Log", "UFDC_Builder.exe", true);
// start with warnings on imagemagick and ghostscript not being installed
if ((String.IsNullOrEmpty(MultiInstance_Builder_Settings.ImageMagick_Executable)) || (!File.Exists(MultiInstance_Builder_Settings.ImageMagick_Executable)))
{
Console.WriteLine("WARNING: Could not find ImageMagick installed. Some image processing will be unavailable.");
preloader_logger.AddNonError("WARNING: Could not find ImageMagick installed. Some image processing will be unavailable.");
}
if ((String.IsNullOrEmpty(MultiInstance_Builder_Settings.Ghostscript_Executable)) || (!File.Exists(MultiInstance_Builder_Settings.Ghostscript_Executable)))
{
Console.WriteLine("WARNING: Could not find GhostScript installed. Some PDF processing will be unavailable.");
preloader_logger.AddNonError("WARNING: Could not find GhostScript installed. Some PDF processing will be unavailable.");
}
// Set the time for the next feed building event to 10 minutes from now
feedNextBuildTime = DateTime.Now.Add(new TimeSpan(0, 10, 0));
// First, step through each active configuration and see if building is currently aborted
// while doing very minimal processes
aborted = false;
Console.WriteLine("Checking for initial abort condition");
preloader_logger.AddNonError("Checking for initial abort condition");
string abort_message = String.Empty;
Builder_Operation_Flag_Enum abort_flag = Builder_Operation_Flag_Enum.STANDARD_OPERATION;
foreach (Database_Instance_Configuration dbConfig in instances)
{
if ((!aborted) && (dbConfig.Is_Active) && (dbConfig.Can_Abort))
{
SobekCM_Database.Connection_String = dbConfig.Connection_String;
Library.Database.SobekCM_Database.Connection_String = dbConfig.Connection_String;
// Check that this should not be skipped or aborted
Builder_Operation_Flag_Enum operationFlag = Abort_Database_Mechanism.Builder_Operation_Flag;
switch (operationFlag)
{
case Builder_Operation_Flag_Enum.ABORT_REQUESTED:
case Builder_Operation_Flag_Enum.ABORTING:
abort_message = "PREVIOUS ABORT flag found in " + dbConfig.Name;
abort_flag = Builder_Operation_Flag_Enum.LAST_EXECUTION_ABORTED;
Console.WriteLine(abort_message);
preloader_logger.AddNonError(abort_message);
aborted = true;
Abort_Database_Mechanism.Builder_Operation_Flag = Builder_Operation_Flag_Enum.LAST_EXECUTION_ABORTED;
break;
case Builder_Operation_Flag_Enum.NO_BUILDING_REQUESTED:
abort_message = "PREVIOUS NO BUILDING flag found in " + dbConfig.Name;
Console.WriteLine(abort_message);
preloader_logger.AddNonError(abort_message);
aborted = true;
break;
}
}
}
// If initially aborted, step through each instance and set a message
if (aborted)
{
// Add messages in each active instance
foreach (Database_Instance_Configuration dbConfig in instances)
{
if (dbConfig.Is_Active)
{
Console.WriteLine("Setting previous abort flag message in " + dbConfig.Name);
preloader_logger.AddNonError("Setting previous abort flag message in " + dbConfig.Name);
SobekCM_Database.Connection_String = dbConfig.Connection_String;
Library.Database.SobekCM_Database.Connection_String = dbConfig.Connection_String;
Library.Database.SobekCM_Database.Builder_Add_Log_Entry(-1, String.Empty, "Standard", abort_message, String.Empty);
// Save information about this last run
Library.Database.SobekCM_Database.Set_Setting("Builder Version", Engine_ApplicationCache_Gateway.Settings.Current_Builder_Version);
Library.Database.SobekCM_Database.Set_Setting("Builder Last Run Finished", DateTime.Now.ToString());
Library.Database.SobekCM_Database.Set_Setting("Builder Last Message", abort_message);
// Finally, set the builder flag appropriately
if (abort_flag != Builder_Operation_Flag_Enum.STANDARD_OPERATION)
Abort_Database_Mechanism.Builder_Operation_Flag = abort_flag;
}
}
// Do nothing else
return;
}
// Build all the bulk loader objects
List<Worker_BulkLoader> loaders = new List<Worker_BulkLoader>();
bool activeInstanceFound = false;
foreach (Database_Instance_Configuration dbConfig in instances)
{
if (!dbConfig.Is_Active)
{
loaders.Add(null);
Console.WriteLine(dbConfig.Name + " is set to INACTIVE");
preloader_logger.AddNonError(dbConfig.Name + " is set to INACTIVE");
}
else
{
activeInstanceFound = true;
SobekCM_Database.Connection_String = dbConfig.Connection_String;
Library.Database.SobekCM_Database.Connection_String = dbConfig.Connection_String;
// At this point warn on mossing the Ghostscript and ImageMagick, to get it into each instances database logs
if ((String.IsNullOrEmpty(MultiInstance_Builder_Settings.ImageMagick_Executable)) || (!File.Exists(MultiInstance_Builder_Settings.ImageMagick_Executable)))
{
Library.Database.SobekCM_Database.Builder_Add_Log_Entry(-1, String.Empty, "Standard", "WARNING: Could not find ImageMagick installed. Some image processing will be unavailable.", String.Empty);
}
if ((String.IsNullOrEmpty(MultiInstance_Builder_Settings.Ghostscript_Executable)) || (!File.Exists(MultiInstance_Builder_Settings.Ghostscript_Executable)))
{
Library.Database.SobekCM_Database.Builder_Add_Log_Entry(-1, String.Empty, "Standard", "WARNING: Could not find GhostScript installed. Some PDF processing will be unavailable.", String.Empty);
}
Console.WriteLine(dbConfig.Name + " - Preparing to begin polling");
preloader_logger.AddNonError(dbConfig.Name + " - Preparing to begin polling");
Library.Database.SobekCM_Database.Builder_Add_Log_Entry(-1, String.Empty, "Standard", "Preparing to begin polling", String.Empty);
Worker_BulkLoader newLoader = new Worker_BulkLoader(preloader_logger, verbose, dbConfig, (instances.Count > 1), logFileDirectory);
loaders.Add(newLoader);
}
}
// If no active instances, just exit
if (!activeInstanceFound)
{
Console.WriteLine("No active databases in the config file");
preloader_logger.AddError("No active databases in config file... Aborting");
return;
}
// Set the maximum number of packages to process before moving to the next instance
if (loaders.Count > 1)
MultiInstance_Builder_Settings.Instance_Package_Limit = 100;
bool firstRun = true;
// Loop continually until the end hour is achieved
do
{
// Is it time to build any RSS/XML feeds?
if (DateTime.Compare(DateTime.Now, feedNextBuildTime) >= 0)
{
feedNextBuildTime = DateTime.Now.Add(new TimeSpan(0, 10, 0));
}
bool skip_sleep = false;
// Step through each instance
for (int i = 0; i < instances.Count; i++)
{
if (loaders[i] != null)
{
// Get the instance
Database_Instance_Configuration dbInstance = instances[i];
// Set the database connection strings
Engine_Database.Connection_String = dbInstance.Connection_String;
SobekCM_Database.Connection_String = dbInstance.Connection_String;
Library.Database.SobekCM_Database.Connection_String = dbInstance.Connection_String;
// Look for abort
if ((dbInstance.Can_Abort) && (CheckForAbort()))
{
aborted = true;
if (Abort_Database_Mechanism.Builder_Operation_Flag != Builder_Operation_Flag_Enum.NO_BUILDING_REQUESTED)
{
abort_flag = Builder_Operation_Flag_Enum.LAST_EXECUTION_ABORTED;
Abort_Database_Mechanism.Builder_Operation_Flag = Builder_Operation_Flag_Enum.ABORTING;
}
break;
}
// Refresh all settings, etc..
loaders[i].Refresh_Settings_And_Item_List();
// Pull the abort/pause flag
Builder_Operation_Flag_Enum currentPauseFlag = Abort_Database_Mechanism.Builder_Operation_Flag;
// If not paused, run the prebuilder
if (currentPauseFlag != Builder_Operation_Flag_Enum.PAUSE_REQUESTED)
{
if (firstRun)
{
// // Always build an endeca feed first (so it occurs once a day)
// if (Engine_ApplicationCache_Gateway.Settings.Build_MARC_Feed_By_Default)
// {
// Create_Complete_MarcXML_Feed(false);
// }
//}
// CLear the old logs
Console.WriteLine(dbInstance.Name + " - Expiring old log entries");
preloader_logger.AddNonError(dbInstance.Name + " - Expiring old log entries");
Library.Database.SobekCM_Database.Builder_Add_Log_Entry(-1, String.Empty, "Standard", "Expiring old log entries", String.Empty);
Library.Database.SobekCM_Database.Builder_Expire_Log_Entries(Engine_ApplicationCache_Gateway.Settings.Builder.Log_Expiration_Days);
// Rebuild all the static pages
Console.WriteLine(dbInstance.Name + " - Rebuilding all static pages");
preloader_logger.AddNonError(dbInstance.Name + " - Rebuilding all static pages");
long staticRebuildLogId = Library.Database.SobekCM_Database.Builder_Add_Log_Entry(-1, String.Empty, "Standard", "Rebuilding all static pages", String.Empty);
Static_Pages_Builder builder = new Static_Pages_Builder(Engine_ApplicationCache_Gateway.Settings.Servers.Application_Server_URL, Engine_ApplicationCache_Gateway.Settings.Servers.Static_Pages_Location, Engine_ApplicationCache_Gateway.URL_Portals.Default_Portal.Default_Web_Skin);
builder.Rebuild_All_Static_Pages(preloader_logger, false, Engine_ApplicationCache_Gateway.Settings.Local_Log_Directory, dbInstance.Name, staticRebuildLogId);
}
skip_sleep = skip_sleep || Run_BulkLoader(loaders[i], verbose);
// Look for abort
if ((!aborted) && (dbInstance.Can_Abort) && (CheckForAbort()))
{
aborted = true;
if (Abort_Database_Mechanism.Builder_Operation_Flag != Builder_Operation_Flag_Enum.NO_BUILDING_REQUESTED)
{
abort_flag = Builder_Operation_Flag_Enum.LAST_EXECUTION_ABORTED;
Abort_Database_Mechanism.Builder_Operation_Flag = Builder_Operation_Flag_Enum.ABORTING;
}
break;
}
}
else
{
preloader_logger.AddNonError( dbInstance.Name + " - Building paused");
Library.Database.SobekCM_Database.Builder_Add_Log_Entry(-1, String.Empty, "Standard", "Building temporarily PAUSED", String.Empty);
}
}
}
if (aborted)
break;
// No longer the first run
firstRun = false;
// Publish the log
publish_log_file(local_log_name);
// Sleep for correct number of milliseconds
if ( !skip_sleep )
Thread.Sleep(1000 * time_between_polls);
} while (DateTime.Now.Hour < BULK_LOADER_END_HOUR);
// Do the final work for all of the different dbInstances
if (!aborted)
{
for (int i = 0; i < instances.Count; i++)
{
if (loaders[i] != null)
{
// Get the instance
Database_Instance_Configuration dbInstance = instances[i];
// Set the database flag
SobekCM_Database.Connection_String = dbInstance.Connection_String;
Library.Database.SobekCM_Database.Connection_String = dbInstance.Connection_String;
// Pull the abort/pause flag
Builder_Operation_Flag_Enum currentPauseFlag2 = Abort_Database_Mechanism.Builder_Operation_Flag;
// If not paused, run the prebuilder
if (currentPauseFlag2 != Builder_Operation_Flag_Enum.PAUSE_REQUESTED)
{
// Initiate the recreation of the links between metadata and collections
Library.Database.SobekCM_Database.Admin_Update_Cached_Aggregation_Metadata_Links();
}
// Clear the memory
loaders[i].ReleaseResources();
}
}
}
else
{
// Mark the aborted in each instance
foreach (Database_Instance_Configuration dbConfig in instances )
{
if (dbConfig.Is_Active)
{
Console.WriteLine("Setting abort flag message in " + dbConfig.Name);
preloader_logger.AddNonError("Setting abort flag message in " + dbConfig.Name);
SobekCM_Database.Connection_String = dbConfig.Connection_String;
Library.Database.SobekCM_Database.Connection_String = dbConfig.Connection_String;
Library.Database.SobekCM_Database.Builder_Add_Log_Entry(-1, String.Empty, "Standard", "Building ABORTED per request from database key", String.Empty);
// Save information about this last run
Library.Database.SobekCM_Database.Set_Setting("Builder Version", Engine_ApplicationCache_Gateway.Settings.Current_Builder_Version);
Library.Database.SobekCM_Database.Set_Setting("Builder Last Run Finished", DateTime.Now.ToString());
Library.Database.SobekCM_Database.Set_Setting("Builder Last Message", "Building ABORTED per request");
// Finally, set the builder flag appropriately
if ( abort_flag == Builder_Operation_Flag_Enum.LAST_EXECUTION_ABORTED )
Abort_Database_Mechanism.Builder_Operation_Flag = Builder_Operation_Flag_Enum.LAST_EXECUTION_ABORTED;
}
}
}
// Publish the log
publish_log_file(local_log_name);
//// Initiate a solr/lucene index optimization since we are done loading for a while
//if (DateTime.Now.Day % 2 == 0)
//{
// if (Engine_ApplicationCache_Gateway.Settings.Document_Solr_Index_URL.Length > 0)
// {
// Console.WriteLine("Initiating Solr/Lucene document index optimization");
// Solr_Controller.Optimize_Document_Index(Engine_ApplicationCache_Gateway.Settings.Document_Solr_Index_URL);
// }
//}
//else
//{
// if (Engine_ApplicationCache_Gateway.Settings.Page_Solr_Index_URL.Length > 0)
// {
// Console.WriteLine("Initiating Solr/Lucene page index optimization");
// Solr_Controller.Optimize_Page_Index(Engine_ApplicationCache_Gateway.Settings.Page_Solr_Index_URL);
// }
//}
//// Sleep for twenty minutes to end this (the index rebuild might take some time)
//Thread.Sleep(1000 * 20 * 60);
}
/// <summary> Continuously execute the processes in a recurring background thread </summary>
public void Execute_In_Background()
{
// Set the variable which will control background execution
int time_between_polls = Engine_ApplicationCache_Gateway.Settings.Builder.Override_Seconds_Between_Polls.HasValue ? Engine_ApplicationCache_Gateway.Settings.Builder.Override_Seconds_Between_Polls.Value : 60;
if ((time_between_polls < 0) || (MultiInstance_Builder_Settings.Instances.Count == 1))
{
time_between_polls = Convert.ToInt32(Engine_ApplicationCache_Gateway.Settings.Builder.Seconds_Between_Polls);
}
// Determine the new log name
string log_name = "incoming_" + controllerStarted.Year + "_" + controllerStarted.Month.ToString().PadLeft(2, '0') + "_" + controllerStarted.Day.ToString().PadLeft(2, '0') + ".html";
string local_log_name = Path.Combine(logFileDirectory, log_name);
// Create the new log file
LogFileXhtml preloader_logger = new LogFileXhtml(local_log_name, "SobekCM Incoming Packages Log", "UFDC_Builder.exe", true);
// start with warnings on imagemagick and ghostscript not being installed
if ((String.IsNullOrEmpty(MultiInstance_Builder_Settings.ImageMagick_Executable)) || (!File.Exists(MultiInstance_Builder_Settings.ImageMagick_Executable)))
{
Console.WriteLine("WARNING: Could not find ImageMagick installed. Some image processing will be unavailable.");
preloader_logger.AddNonError("WARNING: Could not find ImageMagick installed. Some image processing will be unavailable.");
}
if ((String.IsNullOrEmpty(MultiInstance_Builder_Settings.Ghostscript_Executable)) || (!File.Exists(MultiInstance_Builder_Settings.Ghostscript_Executable)))
{
Console.WriteLine("WARNING: Could not find GhostScript installed. Some PDF processing will be unavailable.");
preloader_logger.AddNonError("WARNING: Could not find GhostScript installed. Some PDF processing will be unavailable.");
}
// Set the time for the next feed building event to 10 minutes from now
feedNextBuildTime = DateTime.Now.Add(new TimeSpan(0, 10, 0));
// First, step through each active configuration and see if building is currently aborted
// while doing very minimal processes
aborted = false;
Console.WriteLine("Checking for initial abort condition");
preloader_logger.AddNonError("Checking for initial abort condition");
string abort_message = String.Empty;
int build_instances = 0;
foreach (Single_Instance_Configuration dbConfig in instances)
{
if (!dbConfig.Is_Active)
{
Console.WriteLine(dbConfig.Name + " is set to INACTIVE");
preloader_logger.AddNonError(dbConfig.Name + " is set to INACTIVE");
}
else
{
SobekCM_Item_Database.Connection_String = dbConfig.DatabaseConnection.Connection_String;
Engine_Database.Connection_String = dbConfig.DatabaseConnection.Connection_String;
// Check that this should not be skipped or aborted
Builder_Operation_Flag_Enum operationFlag = Abort_Database_Mechanism.Builder_Operation_Flag;
switch (operationFlag)
{
case Builder_Operation_Flag_Enum.ABORT_REQUESTED:
case Builder_Operation_Flag_Enum.ABORTING:
// Since this was an abort request at the very beginning, switch back to standard
Abort_Database_Mechanism.Builder_Operation_Flag = Builder_Operation_Flag_Enum.STANDARD_OPERATION;
build_instances++;
break;
case Builder_Operation_Flag_Enum.NO_BUILDING_REQUESTED:
abort_message = "PREVIOUS NO BUILDING flag found in " + dbConfig.Name;
Console.WriteLine(abort_message);
preloader_logger.AddNonError(abort_message);
break;
default:
build_instances++;
break;
}
}
}
// If no instances to run just abort
if (build_instances == 0)
{
// Add messages in each active instance
foreach (Single_Instance_Configuration dbConfig in instances)
{
if (dbConfig.Is_Active)
{
Console.WriteLine("No active databases set for building in the config file");
preloader_logger.AddError("No active databases set for building in config file... Aborting");
SobekCM_Item_Database.Connection_String = dbConfig.DatabaseConnection.Connection_String;
Engine_Database.Connection_String = dbConfig.DatabaseConnection.Connection_String;
Engine_Database.Builder_Add_Log_Entry(-1, String.Empty, "Standard", abort_message, String.Empty);
// Save information about this last run
Engine_Database.Set_Setting("Builder Version", Engine_ApplicationCache_Gateway.Settings.Static.Current_Builder_Version);
Engine_Database.Set_Setting("Builder Last Run Finished", DateTime.Now.ToString());
Engine_Database.Set_Setting("Builder Last Message", abort_message);
}
}
// Do nothing else
return;
}
// Build all the bulk loader objects
List <Worker_BulkLoader> loaders = new List <Worker_BulkLoader>();
foreach (Single_Instance_Configuration dbConfig in instances)
{
if (!dbConfig.Is_Active)
{
loaders.Add(null);
continue;
}
SobekCM_Item_Database.Connection_String = dbConfig.DatabaseConnection.Connection_String;
Engine_Database.Connection_String = dbConfig.DatabaseConnection.Connection_String;
// At this point warn on mossing the Ghostscript and ImageMagick, to get it into each instances database logs
if ((String.IsNullOrEmpty(MultiInstance_Builder_Settings.ImageMagick_Executable)) || (!File.Exists(MultiInstance_Builder_Settings.ImageMagick_Executable)))
{
Engine_Database.Builder_Add_Log_Entry(-1, String.Empty, "Standard", "WARNING: Could not find ImageMagick installed. Some image processing will be unavailable.", String.Empty);
}
if ((String.IsNullOrEmpty(MultiInstance_Builder_Settings.Ghostscript_Executable)) || (!File.Exists(MultiInstance_Builder_Settings.Ghostscript_Executable)))
{
Engine_Database.Builder_Add_Log_Entry(-1, String.Empty, "Standard", "WARNING: Could not find GhostScript installed. Some PDF processing will be unavailable.", String.Empty);
}
Console.WriteLine(dbConfig.Name + " - Preparing to begin polling");
preloader_logger.AddNonError(dbConfig.Name + " - Preparing to begin polling");
Engine_Database.Builder_Add_Log_Entry(-1, String.Empty, "Standard", "Preparing to begin polling", String.Empty);
// Create the new bulk loader
Worker_BulkLoader newLoader = new Worker_BulkLoader(preloader_logger, dbConfig, verbose, logFileDirectory, pluginRootDirectory);
// Try to refresh to test database and engine connectivity
if (newLoader.Refresh_Settings_And_Item_List())
{
loaders.Add(newLoader);
}
else
{
Console.WriteLine(dbConfig.Name + " - Error pulling setting of configuration information");
preloader_logger.AddError(dbConfig.Name + " - Error pulling setting of configuration information");
}
}
// If no loaders past the tests above, done
if (loaders.Count == 0)
{
Console.WriteLine("Aborting since no valid instances found to process");
preloader_logger.AddError("Aborting since no valid instances found to process");
return;
}
// Set the maximum number of packages to process before moving to the next instance
if (loaders.Count > 1)
{
MultiInstance_Builder_Settings.Instance_Package_Limit = 100;
}
bool firstRun = true;
// Loop continually until the end hour is achieved
Builder_Operation_Flag_Enum abort_flag = Builder_Operation_Flag_Enum.STANDARD_OPERATION;
do
{
// Is it time to build any RSS/XML feeds?
if (DateTime.Compare(DateTime.Now, feedNextBuildTime) >= 0)
{
feedNextBuildTime = DateTime.Now.Add(new TimeSpan(0, 10, 0));
}
bool skip_sleep = false;
// Step through each instance
for (int i = 0; i < loaders.Count; i++)
{
if (loaders[i] != null)
{
// Get the instance
Single_Instance_Configuration dbInstance = instances[i];
// Set the database connection strings
Engine_Database.Connection_String = dbInstance.DatabaseConnection.Connection_String;
SobekCM_Item_Database.Connection_String = dbInstance.DatabaseConnection.Connection_String;
// Look for abort
if (CheckForAbort())
{
aborted = true;
if (Abort_Database_Mechanism.Builder_Operation_Flag != Builder_Operation_Flag_Enum.NO_BUILDING_REQUESTED)
{
abort_flag = Builder_Operation_Flag_Enum.LAST_EXECUTION_ABORTED;
Abort_Database_Mechanism.Builder_Operation_Flag = Builder_Operation_Flag_Enum.ABORTING;
}
break;
}
// Refresh all settings, etc..
loaders[i].Refresh_Settings_And_Item_List();
// Pull the abort/pause flag
Builder_Operation_Flag_Enum currentPauseFlag = Abort_Database_Mechanism.Builder_Operation_Flag;
// If not paused, run the prebuilder
if (currentPauseFlag != Builder_Operation_Flag_Enum.PAUSE_REQUESTED)
{
skip_sleep = skip_sleep || Run_BulkLoader(loaders[i], verbose);
// Look for abort
if ((!aborted) && (CheckForAbort()))
{
aborted = true;
if (Abort_Database_Mechanism.Builder_Operation_Flag != Builder_Operation_Flag_Enum.NO_BUILDING_REQUESTED)
{
abort_flag = Builder_Operation_Flag_Enum.LAST_EXECUTION_ABORTED;
Abort_Database_Mechanism.Builder_Operation_Flag = Builder_Operation_Flag_Enum.ABORTING;
}
break;
}
}
else
{
preloader_logger.AddNonError(dbInstance.Name + " - Building paused");
Engine_Database.Builder_Add_Log_Entry(-1, String.Empty, "Standard", "Building temporarily PAUSED", String.Empty);
}
}
}
if (aborted)
{
break;
}
// Publish the log
publish_log_file(local_log_name);
// Sleep for correct number of milliseconds
if (!skip_sleep)
{
Thread.Sleep(1000 * time_between_polls);
}
} while (DateTime.Now.Hour < BULK_LOADER_END_HOUR);
// Do the final work for all of the different dbInstances
if (!aborted)
{
for (int i = 0; i < instances.Count; i++)
{
if (loaders[i] != null)
{
// Get the instance
Single_Instance_Configuration dbInstance = instances[i];
// Set the database flag
SobekCM_Item_Database.Connection_String = dbInstance.DatabaseConnection.Connection_String;
Engine_Database.Connection_String = dbInstance.DatabaseConnection.Connection_String;
// Pull the abort/pause flag
Builder_Operation_Flag_Enum currentPauseFlag2 = Abort_Database_Mechanism.Builder_Operation_Flag;
// If not paused, run the prebuilder
if (currentPauseFlag2 != Builder_Operation_Flag_Enum.PAUSE_REQUESTED)
{
// Initiate the recreation of the links between metadata and collections
Engine_Database.Admin_Update_Cached_Aggregation_Metadata_Links();
}
// Clear the memory
loaders[i].ReleaseResources();
}
}
}
else
{
// Mark the aborted in each instance
foreach (Single_Instance_Configuration dbConfig in instances)
{
if (dbConfig.Is_Active)
{
Console.WriteLine("Setting abort flag message in " + dbConfig.Name);
preloader_logger.AddNonError("Setting abort flag message in " + dbConfig.Name);
SobekCM_Item_Database.Connection_String = dbConfig.DatabaseConnection.Connection_String;
Engine_Database.Connection_String = dbConfig.DatabaseConnection.Connection_String;
Engine_Database.Builder_Add_Log_Entry(-1, String.Empty, "Standard", "Building ABORTED per request from database key", String.Empty);
// Save information about this last run
Engine_Database.Set_Setting("Builder Version", Engine_ApplicationCache_Gateway.Settings.Static.Current_Builder_Version);
Engine_Database.Set_Setting("Builder Last Run Finished", DateTime.Now.ToString());
Engine_Database.Set_Setting("Builder Last Message", "Building ABORTED per request");
// Finally, set the builder flag appropriately
if (abort_flag == Builder_Operation_Flag_Enum.LAST_EXECUTION_ABORTED)
{
Abort_Database_Mechanism.Builder_Operation_Flag = Builder_Operation_Flag_Enum.LAST_EXECUTION_ABORTED;
}
}
}
}
// Publish the log
publish_log_file(local_log_name);
//// Initiate a solr/lucene index optimization since we are done loading for a while
//if (DateTime.Now.Day % 2 == 0)
//{
// if (Engine_ApplicationCache_Gateway.Settings.Document_Solr_Index_URL.Length > 0)
// {
// Console.WriteLine("Initiating Solr/Lucene document index optimization");
// Solr_Controller.Optimize_Document_Index(Engine_ApplicationCache_Gateway.Settings.Document_Solr_Index_URL);
// }
//}
//else
//{
// if (Engine_ApplicationCache_Gateway.Settings.Page_Solr_Index_URL.Length > 0)
// {
// Console.WriteLine("Initiating Solr/Lucene page index optimization");
// Solr_Controller.Optimize_Page_Index(Engine_ApplicationCache_Gateway.Settings.Page_Solr_Index_URL);
// }
//}
//// Sleep for twenty minutes to end this (the index rebuild might take some time)
//Thread.Sleep(1000 * 20 * 60);
}
private bool Configure_Builders_To_Run(LogFileXhtml PreloaderLogger)
{
// Verify connectivity and rights on the logs subfolder
if (!Directory.Exists(logFileDirectory))
{
try
{
Directory.CreateDirectory(logFileDirectory);
}
catch
{
Console.WriteLine("Error creating necessary logs subfolder under the application folder.\n");
Console.WriteLine("Please create manually.\n");
Console.WriteLine(logFileDirectory);
return(false);
}
}
try
{
StreamWriter testWriter = new StreamWriter(Path.Combine(logFileDirectory, "test.log"), false);
testWriter.WriteLine("TEST");
testWriter.Flush();
testWriter.Close();
File.Delete(Path.Combine(logFileDirectory, "test.log"));
}
catch
{
Console.WriteLine("The service account needs modify rights on the logs subfolder.\n");
Console.WriteLine("Please correct manually.\n");
Console.WriteLine(logFileDirectory);
return(false);
}
// Verify connectivity and rights on the plugins subfolder
if (!Directory.Exists(pluginRootDirectory))
{
try
{
Directory.CreateDirectory(pluginRootDirectory);
}
catch
{
Console.WriteLine("Error creating necessary plugins subfolder under the application folder.\n");
Console.WriteLine("Please create manually.\n");
Console.WriteLine(pluginRootDirectory);
return(false);
}
}
try
{
StreamWriter testWriter = new StreamWriter(Path.Combine(pluginRootDirectory, "test.log"), false);
testWriter.WriteLine("TEST");
testWriter.Flush();
testWriter.Close();
File.Delete(Path.Combine(pluginRootDirectory, "test.log"));
}
catch
{
Console.WriteLine("The service account needs modify rights on the plugins subfolder.\n");
Console.WriteLine("Please correct manually.\n");
Console.WriteLine(pluginRootDirectory);
return(false);
}
// Now, veryify the configuration file exists
configurationFile = Path.Combine(MultiInstance_Builder_Settings.Builder_Executable_Directory, "config", "sobekcm.config");
if (!File.Exists(configurationFile))
{
write_error("The configuration file is missing!!", PreloaderLogger);
write_error("Execution aborted due to missing configuration file.", PreloaderLogger);
return(false);
}
// Should be a config file now, so read it
if (!MultiInstance_Builder_Settings_Reader.Read_Config(configurationFile))
{
write_error("Error encountered reading the configuration file!!", PreloaderLogger);
write_error("Execution aborted due to incorrect configuration file.", PreloaderLogger);
return(false);
}
// Since the configuration was read, save the time
configReadTime = DateTime.Now;
// If no instances exist, then the builder has nothing to do
if ((MultiInstance_Builder_Settings.Instances.Count == 0) || (String.IsNullOrEmpty(MultiInstance_Builder_Settings.Instances[0].DatabaseConnection.Connection_String)))
{
write_error("No instances listed in the congfiguration file", PreloaderLogger);
write_error("Execution aborted due to configuration file not including any instances to process", PreloaderLogger);
return(false);
}
// This is a bit of shortcut in the case there is only one instance
if (MultiInstance_Builder_Settings.Instances.Count == 1)
{
// If no database connection on the single instance, return
if (String.IsNullOrEmpty(MultiInstance_Builder_Settings.Instances[0].DatabaseConnection.Connection_String))
{
write_error("Single instance configuration is missing the database connection string", PreloaderLogger);
write_error("Execution aborted", PreloaderLogger);
return(false);
}
Engine_Database.Connection_String = MultiInstance_Builder_Settings.Instances[0].DatabaseConnection.Connection_String;
if (!Engine_Database.Test_Connection())
{
write_error("Unable to connect to the database using provided connection string:", PreloaderLogger);
write_error(Engine_Database.Connection_String, PreloaderLogger);
write_error("Execution aborted", PreloaderLogger);
return(false);
}
}
// Look for the valid Image magick file information in the registry and configuration
if ((String.IsNullOrEmpty(Engine_ApplicationCache_Gateway.Settings.Builder.ImageMagick_Executable)) || (!File.Exists(Engine_ApplicationCache_Gateway.Settings.Builder.ImageMagick_Executable)))
{
string possible_imagemagick = Look_For_Variable_Registry_Key("SOFTWARE\\ImageMagick", "BinPath");
if ((!String.IsNullOrEmpty(possible_imagemagick)) && (Directory.Exists(possible_imagemagick)) && (File.Exists(Path.Combine(possible_imagemagick, "convert.exe"))))
{
MultiInstance_Builder_Settings.ImageMagick_Executable = Path.Combine(possible_imagemagick, "convert.exe");
}
}
else
{
MultiInstance_Builder_Settings.ImageMagick_Executable = Engine_ApplicationCache_Gateway.Settings.Builder.ImageMagick_Executable;
}
// If no ImageMagick file found, add a warning
if ((String.IsNullOrEmpty(MultiInstance_Builder_Settings.ImageMagick_Executable)) || (!File.Exists(MultiInstance_Builder_Settings.ImageMagick_Executable)))
{
write_nonerror("WARNING: Could not find ImageMagick installed. Some image processing will be unavailable.", PreloaderLogger);
}
// Look for a valid ghostscript file information in the registry and configuration
if ((String.IsNullOrEmpty(Engine_ApplicationCache_Gateway.Settings.Builder.Ghostscript_Executable)) || (!File.Exists(Engine_ApplicationCache_Gateway.Settings.Builder.Ghostscript_Executable)))
{
string possible_ghost = Look_For_Variable_Registry_Key("SOFTWARE\\GPL Ghostscript", "GS_DLL");
if (!String.IsNullOrEmpty(possible_ghost))
{
string gsPath = Path.GetDirectoryName(possible_ghost);
if ((!String.IsNullOrEmpty(gsPath)) && (Directory.Exists(gsPath)) && ((File.Exists(Path.Combine(gsPath, "gswin32c.exe"))) || (File.Exists(Path.Combine(gsPath, "gswin64c.exe")))))
{
if (File.Exists(Path.Combine(gsPath, "gswin64c.exe")))
{
MultiInstance_Builder_Settings.Ghostscript_Executable = Path.Combine(gsPath, "gswin64c.exe");
}
else
{
MultiInstance_Builder_Settings.Ghostscript_Executable = Path.Combine(gsPath, "gswin32c.exe");
}
}
}
}
else
{
MultiInstance_Builder_Settings.Ghostscript_Executable = Engine_ApplicationCache_Gateway.Settings.Builder.Ghostscript_Executable;
}
// If no Ghostscript file found, add a warning
if ((String.IsNullOrEmpty(MultiInstance_Builder_Settings.Ghostscript_Executable)) || (!File.Exists(MultiInstance_Builder_Settings.Ghostscript_Executable)))
{
write_nonerror("WARNING: Could not find GhostScript installed. Some PDF processing will be unavailable.", PreloaderLogger);
}
// Save the list of instances
instances.Clear();
foreach (Single_Instance_Configuration dbInfo in MultiInstance_Builder_Settings.Instances)
{
instances.Add(dbInfo);
}
// First, step through each active configuration and see if building is currently aborted
// while doing very minimal processes
aborted = false;
write_nonerror("Checking for initial abort condition", PreloaderLogger);
string abort_message = String.Empty;
int build_instances = 0;
foreach (Single_Instance_Configuration dbConfig in instances)
{
if (!dbConfig.Is_Active)
{
write_nonerror(dbConfig.Name + " is set to INACTIVE", PreloaderLogger);
}
else
{
SobekCM_Item_Database.Connection_String = dbConfig.DatabaseConnection.Connection_String;
Engine_Database.Connection_String = dbConfig.DatabaseConnection.Connection_String;
// Check that this should not be skipped or aborted
Builder_Operation_Flag_Enum operationFlag = Abort_Database_Mechanism.Builder_Operation_Flag;
switch (operationFlag)
{
case Builder_Operation_Flag_Enum.ABORT_REQUESTED:
case Builder_Operation_Flag_Enum.ABORTING:
// Since this was an abort request at the very beginning, switch back to standard
Abort_Database_Mechanism.Builder_Operation_Flag = Builder_Operation_Flag_Enum.STANDARD_OPERATION;
build_instances++;
break;
case Builder_Operation_Flag_Enum.NO_BUILDING_REQUESTED:
abort_message = "PREVIOUS NO BUILDING flag found in " + dbConfig.Name;
write_nonerror(abort_message, PreloaderLogger);
break;
default:
build_instances++;
break;
}
}
}
// If no instances to run just abort
if (build_instances == 0)
{
// Add messages in each active instance
foreach (Single_Instance_Configuration dbConfig in instances)
{
if (dbConfig.Is_Active)
{
write_error("No active databases set for building in config file... Aborting", PreloaderLogger);
SobekCM_Item_Database.Connection_String = dbConfig.DatabaseConnection.Connection_String;
Engine_Database.Connection_String = dbConfig.DatabaseConnection.Connection_String;
Engine_Database.Builder_Add_Log_Entry(-1, String.Empty, "Standard", abort_message, String.Empty);
// Save information about this last run
Engine_Database.Set_Setting("Builder Version", Engine_ApplicationCache_Gateway.Settings.Static.Current_Builder_Version);
Engine_Database.Set_Setting("Builder Last Run Finished", DateTime.Now.ToString());
Engine_Database.Set_Setting("Builder Last Message", abort_message);
}
}
// Do nothing else
return(false);
}
// Build all the bulk loader objects
loaders.Clear();
foreach (Single_Instance_Configuration dbConfig in instances)
{
if (!dbConfig.Is_Active)
{
loaders.Add(null);
continue;
}
SobekCM_Item_Database.Connection_String = dbConfig.DatabaseConnection.Connection_String;
Engine_Database.Connection_String = dbConfig.DatabaseConnection.Connection_String;
// At this point warn on mossing the Ghostscript and ImageMagick, to get it into each instances database logs
if ((String.IsNullOrEmpty(MultiInstance_Builder_Settings.ImageMagick_Executable)) || (!File.Exists(MultiInstance_Builder_Settings.ImageMagick_Executable)))
{
Engine_Database.Builder_Add_Log_Entry(-1, String.Empty, "Standard", "WARNING: Could not find ImageMagick installed. Some image processing will be unavailable.", String.Empty);
}
if ((String.IsNullOrEmpty(MultiInstance_Builder_Settings.Ghostscript_Executable)) || (!File.Exists(MultiInstance_Builder_Settings.Ghostscript_Executable)))
{
Engine_Database.Builder_Add_Log_Entry(-1, String.Empty, "Standard", "WARNING: Could not find GhostScript installed. Some PDF processing will be unavailable.", String.Empty);
}
write_nonerror(dbConfig.Name + " - Preparing to begin polling", PreloaderLogger);
Engine_Database.Builder_Add_Log_Entry(-1, String.Empty, "Standard", "Preparing to begin polling", String.Empty);
// Create the new bulk loader
Worker_BulkLoader newLoader = new Worker_BulkLoader(PreloaderLogger, dbConfig, verbose, logFileDirectory, pluginRootDirectory);
// Try to refresh to test database and engine connectivity
if (newLoader.Refresh_Settings_And_Item_List())
{
loaders.Add(newLoader);
}
else
{
write_error(dbConfig.Name + " - Error pulling setting of configuration information", PreloaderLogger);
}
}
// If no loaders past the tests above, done
if (loaders.Count == 0)
{
write_error("Aborting since no valid instances found to process", PreloaderLogger);
return(false);
}
// Set the maximum number of packages to process before moving to the next instance
if (loaders.Count > 1)
{
MultiInstance_Builder_Settings.Instance_Package_Limit = 100;
}
return(true);
}
private bool Run_BulkLoader(Worker_BulkLoader Prebuilder, bool Verbose)
{
try
{
bool returnValue = Prebuilder.Perform_BulkLoader( Verbose );
if (Prebuilder.Aborted)
aborted = true;
return returnValue;
}
catch ( Exception ee )
{
return false;
}
}