internal void FillByStringParsedData(EventLogLGFReader reader, string[] parseResult)
{
string transactionSourceString = parseResult[2].RemoveBraces();
RowId = reader.CurrentFileEventNumber;
Period = DateTime.ParseExact(parseResult[0], "yyyyMMddHHmmss", CultureInfo.InvariantCulture);
TransactionStatus = reader.GetTransactionStatus(parseResult[1]);
TransactionDate = GetTransactionDate(transactionSourceString);
TransactionId = GetTransactionId(transactionSourceString);
User = reader.GetUserByCode(parseResult[3]);
Computer = reader.GetComputerByCode(parseResult[4]);
Application = reader.GetApplicationByCode(parseResult[5]);
ConnectId = parseResult[6].ToInt32();
Event = reader.GetEventByCode(parseResult[7]);
Severity = reader.GetSeverityByCode(parseResult[8]);
Comment = parseResult[9].RemoveQuotes();
Metadata = reader.GetMetadataByCode(parseResult[10]);
Data = GetData(parseResult[11]);
DataPresentation = parseResult[12].RemoveQuotes();
WorkServer = reader.GetWorkServerByCode(parseResult[13]);
PrimaryPort = reader.GetPrimaryPortByCode(parseResult[14]);
SecondaryPort = reader.GetSecondaryPortByCode(parseResult[15]);
Session = parseResult[16].ToInt64();
DataUuid = GetDataUuid(Data);
}
private void GetCountLogFiles_Test(string eventLogPath)
{
long countLogFiles = 0;
using (EventLogReader reader = EventLogReader.CreateReader(eventLogPath))
{
reader.Reset();
if (reader is EventLogLGFReader)
{
EventLogLGFReader readerLGF = (EventLogLGFReader)reader;
while (readerLGF.CurrentFile != null)
{
reader.NextFile();
countLogFiles += 1;
}
}
else if (reader is EventLogLGDReader)
{
countLogFiles = 1;
}
}
Assert.NotEqual(0, countLogFiles);
}
private void ReadRefferences_IfChanged_Test(string eventLogPath)
{
DateTime lastReadReferencesDateBeforeRead = DateTime.MinValue;
DateTime lastReadReferencesDate = DateTime.MinValue;
using (EventLogReader reader = EventLogReader.CreateReader(eventLogPath))
{
lastReadReferencesDateBeforeRead = reader.ReferencesReadDate;
Thread.Sleep(2000);
if (reader is EventLogLGFReader)
{
#region LGF
EventLogLGFReader lgfReader = (EventLogLGFReader)reader;
using (StreamWriter sw = File.AppendText(lgfReader.CurrentFile))
{
string descriptionNewEvent = "Новое событие в процессе чтения!";
DateTime newLogRecordPeriod = DateTime.Now;
string newLogRecordPeriodAsString = newLogRecordPeriod.ToString("yyyyMMddHHmmss");
sw.WriteLine(",");
sw.WriteLine($"{{{newLogRecordPeriodAsString},N,");
sw.WriteLine($"{{0,0}},1,1,2,2,3,N,\"{descriptionNewEvent}\",3,");
sw.WriteLine($"{{\"S\",\"{descriptionNewEvent}\"}},\"\",1,1,0,2,0,");
sw.WriteLine("{0}");
sw.WriteLine("}");
}
#endregion
}
else if (reader is EventLogLGDReader)
{
#region LGD
string lgdConnectionString = SQLiteExtensions.GetConnectionString(eventLogPath, false);
using (SQLiteConnection connection = new SQLiteConnection(lgdConnectionString))
{
connection.Open();
string queryText = String.Format(
"Select\n" +
" el.RowId,\n" +
" el.Date AS Date,\n" +
" el.ConnectId,\n" +
" el.Session,\n" +
" el.TransactionStatus,\n" +
" el.TransactionDate,\n" +
" el.TransactionId,\n" +
" el.UserCode AS UserCode,\n" +
" el.ComputerCode AS ComputerCode,\n" +
" el.appCode AS ApplicationCode,\n" +
" el.eventCode AS EventCode,\n" +
" el.primaryPortCode AS PrimaryPortCode,\n" +
" el.secondaryPortCode AS SecondaryPortCode,\n" +
" el.workServerCode AS WorkServerCode,\n" +
" el.Severity AS SeverityCode,\n" +
" el.Comment AS Comment,\n" +
" el.Data AS Data,\n" +
" el.DataPresentation AS DataPresentation,\n" +
" elm.metadataCode AS MetadataCode\n" +
"From\n" +
" EventLog el\n" +
" left join EventLogMetadata elm on el.RowId = elm.eventLogID\n" +
" left join MetadataCodes mc on elm.metadataCode = mc.code\n" +
"Where RowID = (SELECT MAX(RowID) from EventLog)\n");
using (SQLiteCommand sqliteCmd = new SQLiteCommand(queryText, connection))
{
long RowID = 0, ConnectId = 0, Session = 0,
TransactionStatus = 0, TransactionDate = 0, TransactionId = 0,
User = 0, Computer = 0, Application = 0, Event = 0, PrimaryPort = 0,
SecondaryPort = 0, WorkServer = 0, Severity = 0, Metadata = 0;
string Comment = string.Empty, Data = string.Empty, DataPresentation = string.Empty;
using (SQLiteDataReader sqliteReader = sqliteCmd.ExecuteReader())
{
while (sqliteReader.Read())
{
RowID = sqliteReader.GetInt64OrDefault(0);
ConnectId = sqliteReader.GetInt64OrDefault(2);
Session = sqliteReader.GetInt64OrDefault(3);
TransactionStatus = sqliteReader.GetInt64OrDefault(4);
TransactionDate = sqliteReader.GetInt64OrDefault(5);
TransactionId = sqliteReader.GetInt64OrDefault(6);
User = sqliteReader.GetInt64OrDefault(7);
Computer = sqliteReader.GetInt64OrDefault(8);
Application = sqliteReader.GetInt64OrDefault(9);
Event = sqliteReader.GetInt64OrDefault(10);
PrimaryPort = sqliteReader.GetInt64OrDefault(11);
SecondaryPort = sqliteReader.GetInt64OrDefault(12);
WorkServer = sqliteReader.GetInt64OrDefault(13);
Severity = sqliteReader.GetInt64OrDefault(14);
Comment = sqliteReader.GetStringOrDefault(15);
Data = sqliteReader.GetStringOrDefault(16);
DataPresentation = sqliteReader.GetStringOrDefault(17);
Metadata = sqliteReader.GetInt64OrDefault(18);
}
}
string queryInsertLog =
"INSERT INTO EventLog " +
"(" +
" RowId, " +
" Date, " +
" ConnectId, " +
" Session, " +
" TransactionStatus, " +
" TransactionDate, " +
" TransactionId, " +
" UserCode, " +
" ComputerCode, " +
" appCode, " +
" eventCode, " +
" primaryPortCode, " +
" secondaryPortCode, " +
" workServerCode, " +
" Severity, " +
" Comment, " +
" Data, " +
" DataPresentation " +
") " +
"VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
using (SQLiteCommand insertSQL = new SQLiteCommand(queryInsertLog, connection))
{
long newRowId = RowID + 1;
long newPeriod = DateTime.Now.ToLongDateTimeFormat();
insertSQL.Parameters.Add(new SQLiteParameter(DbType.Int64, newRowId));
insertSQL.Parameters.Add(new SQLiteParameter(DbType.Int64, newPeriod));
insertSQL.Parameters.Add(new SQLiteParameter(DbType.Int64, ConnectId));
insertSQL.Parameters.Add(new SQLiteParameter(DbType.Int64, Session));
insertSQL.Parameters.Add(new SQLiteParameter(DbType.Int64, TransactionStatus));
insertSQL.Parameters.Add(new SQLiteParameter(DbType.Int64, TransactionDate));
insertSQL.Parameters.Add(new SQLiteParameter(DbType.Int64, TransactionId));
insertSQL.Parameters.Add(new SQLiteParameter(DbType.Int64, User));
insertSQL.Parameters.Add(new SQLiteParameter(DbType.Int64, Computer));
insertSQL.Parameters.Add(new SQLiteParameter(DbType.Int64, Application));
insertSQL.Parameters.Add(new SQLiteParameter(DbType.Int64, Event));
insertSQL.Parameters.Add(new SQLiteParameter(DbType.Int64, PrimaryPort));
insertSQL.Parameters.Add(new SQLiteParameter(DbType.Int64, SecondaryPort));
insertSQL.Parameters.Add(new SQLiteParameter(DbType.Int64, WorkServer));
insertSQL.Parameters.Add(new SQLiteParameter(DbType.Int64, Severity));
insertSQL.Parameters.Add(new SQLiteParameter(DbType.String, Comment));
insertSQL.Parameters.Add(new SQLiteParameter(DbType.String, Data));
insertSQL.Parameters.Add(new SQLiteParameter(DbType.String, DataPresentation));
insertSQL.ExecuteNonQuery();
}
}
}
#endregion
}
while (reader.Read())
{
;
}
lastReadReferencesDate = reader.ReferencesReadDate;
}
Assert.NotEqual(DateTime.MinValue, lastReadReferencesDate);
Assert.NotEqual(DateTime.MinValue, lastReadReferencesDateBeforeRead);
Assert.True(lastReadReferencesDateBeforeRead < lastReadReferencesDate);
}
