/// <summary> Process the IIS web logs to SQL insert commands </summary>
public void Process_IIS_Logs()
{
// **** READ THE LOOKUP TABLES FROM THE DATABASE **** //
DataSet lookupTables = SobekCM_Database.Get_Statistics_Lookup_Tables();
// ***** CODE BELOW READS ALL THE LOG FILES AND THEN WRITES THEM AS XML DATASETS *****//
SobekCM_Log_Reader ufdc_log_reader = new SobekCM_Log_Reader(lookupTables.Tables[0], sobekcm_web_location);
//string[] files = Directory.GetFiles(sobekcm_log_location, "*.log");
//foreach (string thisFile in files)
//{
// On_New_Status("Processing " + (new FileInfo(thisFile)).Name);
// ufdc_log_reader.Read_Log(thisFile).Write_XML(dataset_location);
//}
// ***** CODE BELOW READS ALL THE DAILY XML DATASETS AND COMBINES THEM INTO MONTHLY *****//
// ***** DATASETS WHICH ARE SUBSEQUENTLY WRITTEN AS XML DATASETS AS WELL *****//
On_New_Status("Combining daily datasets into a monthly dataset");
foreach (string year_month in year_months)
{
string[] year_month_files = Directory.GetFiles(dataset_location, year_month + "*.xml");
if (year_month_files.Length > 0)
{
SobekCM_Stats_DataSet combined = new SobekCM_Stats_DataSet();
foreach (string file in year_month_files)
{
if ((new FileInfo(file)).Name.IndexOf(year_month + ".xml") < 0)
{
SobekCM_Stats_DataSet daily = new SobekCM_Stats_DataSet();
daily.Read_XML(file);
combined.Merge(daily);
}
}
// Write the complete data set
combined.Write_XML(dataset_location, year_month + ".xml");
// Just write the highest users in a seperate, more readable, file
combined.Write_Highest_Users(dataset_location, "users_" + year_month + ".xml");
}
}
//// ***** CODE BELOW READS THE MONTHLY DATASETS AND THEN WRITES THE SQL INSERTION SCRIPTS ***** //
// Read all the data lists first for id lookups
Dictionary <string, int> aggregationHash = Table_To_Hash(lookupTables.Tables[2]);
Dictionary <string, int> bibHash = Table_To_Hash(lookupTables.Tables[1]);
Dictionary <string, int> portalHash = new Dictionary <string, int>();
foreach (DataRow thisRow in lookupTables.Tables[3].Rows)
{
if (!portalHash.ContainsKey(thisRow[2].ToString().ToUpper()))
{
portalHash[thisRow[2].ToString().ToUpper()] = Convert.ToInt32(thisRow[0]);
}
}
On_New_Status("Writing SQL insert commands");
foreach (string yearmonth in year_months)
{
SobekCM_Stats_DataSet monthly;
string thisFile = dataset_location + "\\" + yearmonth + ".xml";
if (File.Exists(thisFile))
{
monthly = new SobekCM_Stats_DataSet();
monthly.Read_XML(thisFile);
int year = Convert.ToInt32(yearmonth.Substring(0, 4));
int month = Convert.ToInt32(yearmonth.Substring(4));
monthly.Write_SQL_Inserts(sql_output_location + "\\" + yearmonth + ".sql", year, month, aggregationHash, bibHash, portalHash);
}
}
On_New_Status("COMPLETE!");
}
/// <summary> Process the IIS web logs to SQL insert commands </summary>
public void Process_IIS_Logs()
{
// **** READ THE LOOKUP TABLES FROM THE DATABASE **** //
DataSet lookupTables = new DataSet();
//lookupTables.ReadXml(@"C:\Users\mark.v.sullivan\Documents\Visual Studio 2012\Projects\SobekDbInfoSaver\SobekDbInfoSaver\bin\Release\uf\lookup.xml");
try
{
lookupTables = Engine_Database.Get_Statistics_Lookup_Tables();
On_New_Status("Retrieved statistics lookup tables from the database", false);
}
catch (Exception ee)
{
On_New_Status("Error getting statistics lookup tables from the database. " + ee.Message, true);
return;
}
// Ensure the lookup tables were not null
if (lookupTables == null)
{
On_New_Status("Error getting statistics lookup tables from the database. Table is NULL", true);
return;
}
// Determine, from the year_month, which logs to read
List <string> logs_start = new List <string>();
foreach (string thisYearMonth in year_months)
{
logs_start.Add("u_ex" + thisYearMonth.Substring(2, 2) + thisYearMonth.Substring(4, 2));
}
// ***** CODE BELOW READS ALL THE LOG FILES AND THEN WRITES THEM AS XML DATASETS *****//
On_New_Status("Read all needed log files and write them as XML datasets", false);
SobekCM_Log_Reader sobekcm_log_reader = new SobekCM_Log_Reader(lookupTables.Tables[0], sobekcm_web_location);
string[] files = Directory.GetFiles(sobekcm_log_location, "u_ex*.log");
foreach (string thisFile in files)
{
try
{
string filename_lower = Path.GetFileName(thisFile).ToLower().Substring(0, 8);
if (logs_start.Contains(filename_lower))
{
On_New_Status("Processing " + (new FileInfo(thisFile)).Name, false);
FileInfo fileInfo = new FileInfo(thisFile);
string name = fileInfo.Name.Replace(fileInfo.Extension, "");
DateTime logDate = new DateTime(Convert.ToInt32("20" + name.Substring(4, 2)),
Convert.ToInt32(name.Substring(6, 2)), Convert.ToInt32(name.Substring(8, 2)));
string resultant_file = dataset_location + "\\" + logDate.Year.ToString() + logDate.Month.ToString().PadLeft(2, '0') + logDate.Day.ToString().PadLeft(2, '0') + ".xml";
if (!File.Exists(resultant_file))
{
sobekcm_log_reader.Read_Log(thisFile).Write_XML(dataset_location);
}
}
}
catch (Exception ee)
{
On_New_Status("Error reading a log file and writing as XML dataset. " + ee.Message, true);
}
}
// ***** CODE BELOW READS ALL THE DAILY XML DATASETS AND COMBINES THEM INTO MONTHLY *****//
// ***** DATASETS WHICH ARE SUBSEQUENTLY WRITTEN AS XML DATASETS AS WELL *****//
On_New_Status("Combining daily datasets into monthly datasets", false);
try
{
foreach (string year_month in year_months)
{
On_New_Status("Combining " + year_month + " daily datasets into one month", false);
string[] year_month_files = Directory.GetFiles(dataset_location, year_month + "*.xml");
if (year_month_files.Length > 0)
{
SobekCM_Stats_DataSet combined = new SobekCM_Stats_DataSet();
foreach (string file in year_month_files)
{
if ((new FileInfo(file)).Name.IndexOf(year_month + ".xml") < 0)
{
SobekCM_Stats_DataSet daily = new SobekCM_Stats_DataSet();
daily.Read_XML(file);
combined.Merge(daily);
}
}
// Write the complete data set
combined.Write_XML(dataset_location, year_month + ".xml");
// Just write the highest users in a seperate, more readable, file
combined.Write_Highest_Users(dataset_location, "users_" + year_month + ".xml");
}
}
}
catch (Exception ee)
{
On_New_Status("Error combining daily datasets into monthly datasets. " + ee.Message, true);
return;
}
//// ***** CODE BELOW READS THE MONTHLY DATASETS AND THEN WRITES THE SQL INSERTION SCRIPTS ***** //
// Read all the data lists first for id lookups
Dictionary <string, int> aggregationHash = Table_To_Hash(lookupTables.Tables[2]);
Dictionary <string, int> bibHash = Table_To_Hash(lookupTables.Tables[1]);
Dictionary <string, int> portalHash = new Dictionary <string, int>();
foreach (DataRow thisRow in lookupTables.Tables[3].Rows)
{
if (!portalHash.ContainsKey(thisRow[2].ToString().ToUpper()))
{
portalHash[thisRow[2].ToString().ToUpper()] = Convert.ToInt32(thisRow[0]);
}
}
On_New_Status("Insert new statistics into database", false);
try
{
foreach (string yearmonth in year_months)
{
On_New_Status("Writing statistics for " + yearmonth, false);
SobekCM_Stats_DataSet monthly;
string thisFile = dataset_location + "\\" + yearmonth + ".xml";
if (File.Exists(thisFile))
{
monthly = new SobekCM_Stats_DataSet();
monthly.Read_XML(thisFile);
int year = Convert.ToInt32(yearmonth.Substring(0, 4));
int month = Convert.ToInt32(yearmonth.Substring(4));
monthly.Perform_SQL_Inserts(year, month, aggregationHash, bibHash, portalHash);
}
}
}
catch (Exception ee)
{
On_New_Status("Error saving new usage statistics into the database. " + ee.Message, true);
On_New_Status("Trace from previous error: " + ee.StackTrace, true);
return;
}
On_New_Status("COMPLETE!", false);
}