public void InsertOneLogRecord()
{
using (var db = new Database(new ConfigManager()))
{
db.InitializeDatabase();
var log = new LogEntity(DateTime.Now, TimeSpan.FromMilliseconds(300), false, new byte[] { 3, 30, 255 });
var id = db.InsertLogs(new LogEntity[] { log });
Assert.That(id, Is.Not.Null);
Assert.That(id, Has.Count.GreaterThan(0));
Assert.That(id.First(), Is.GreaterThanOrEqualTo(0));
}
}
public void InitializeNewDatabase()
{
using (var db = new Database(new ConfigManager()))
{
if (Directory.Exists(db.GetDatabaseDirectory()))
{
Directory.Delete(db.GetDatabaseDirectory(), true);
}
db.InitializeDatabase();
Assert.That(File.Exists(db.DatabaseFullPath));
var log = new LogEntity(DateTime.Now, TimeSpan.FromMilliseconds(300), false, new byte[] { 4, 4, 4 });
db.InsertLogs(new LogEntity[] { log });
}
}
// DateTime createdDateTime, long elapsed, byte[] data)
public long InsertLog(JET_SESID session, Transaction tran, IndexTableSchema idxSchema, LogEntity log)
{
long ret = 0;
using (var updt = new Update(session, logTable, JET_prep.Insert))
{
ret = (long)Api.RetrieveColumnAsInt64(session, logTable, colID_ID, RetrieveColumnGrbit.RetrieveCopy);
Api.SetColumn(session, logTable, colID_Created, log.CreatedDateTime.Ticks);
Api.SetColumn(session, logTable, colID_Elapsed, log.Elapsed.Ticks);
Api.SetColumn(session, logTable, colID_Exception, log.Exception);
Api.SetColumn(session, logTable, colID_Data, log.Data);
updt.Save();
}
idxSchema.InsertIndexRow(session, tran, ret);
return ret;
}
public void RetrieveRecordsByDate()
{
using (var db = new Database(new ConfigManager()))
{
db.InitializeDatabase();
var log = new LogEntity(new DateTime(2011, 11, 9, 0, 0, 0), TimeSpan.FromMilliseconds(300), false, new byte[] { 3, 30, 25 });
db.InsertLogs(new LogEntity[] { log });
var search = new LogQueryResults() { IncludeData = true };
search.DateTime_From = new DateTime(2011, 11, 5, 0, 0, 0, DateTimeKind.Utc);
search.DateTime_To = new DateTime(2011, 11, 10, 0, 0, 0, DateTimeKind.Utc);
search.IncludeData = true;
db.RetrieveLogsBySearchResults(search);
Assert.That(search.LogIDs, Is.Not.Null);
Assert.That(search.LogIDs.Count, Is.GreaterThan(0));
}
}
public void TestInsertPerformance()
{
using (var db = new Database(new ConfigManager()))
{
db.InitializeDatabase();
var size = db.Size();
var start = DateTime.UtcNow;
DateTime stop;
TimeSpan ts;
var ts1 = TimeSpan.FromMilliseconds(300).Ticks;
var insertStart = new DateTime(2011, 11, 1);
var numOfRows = 50000;
var interval = (long)((DateTime.Now - insertStart).Ticks / numOfRows);
var rndElapsed = new Random();
for (int i = 0; i < numOfRows; i++)
{
var createdDT = insertStart.AddTicks(interval * i);
var elapsed = TimeSpan.FromMilliseconds((long)rndElapsed.Next(1, 30000)).Ticks;
var log = new NAppProfiler.Client.DTO.Log()
{
ClientIP = new byte[] { 10, 26, 10, 142 },
CreatedDateTime = createdDT,
Details = new List<NAppProfiler.Client.DTO.LogDetail>(),
Elapsed = elapsed,
IsError = Convert.ToBoolean(rndElapsed.Next(0, 1)),
Method = "Method",
Service = "Service",
};
log.Details.Add(new Client.DTO.LogDetail()
{
CreatedDateTime = createdDT,
Description = "Description " + i.ToString(),
Elapsed = 100,
});
log.Details.Add(new Client.DTO.LogDetail()
{
CreatedDateTime = createdDT,
Description = "Description2 " + i.ToString(),
Elapsed = 100,
});
var logEnt = new LogEntity(createdDT, new TimeSpan(elapsed), log.IsError, NAppProfiler.Client.DTO.Log.SerializeLog(log));
db.InsertLogs(new LogEntity[] { logEnt });
}
stop = DateTime.UtcNow;
ts = stop - start;
Console.WriteLine("Total Milliseconds (Insert " + numOfRows.ToString() + " Rows): " + ts.TotalMilliseconds.ToString("#,##0"));
start = DateTime.UtcNow;
for (int i = 1; i < 200001; i++)
{
var search = new LogQueryResults(){IncludeData = true};
search.LogIDs = new List<LogQueryResultDetail>();
search.LogIDs.Add(new LogQueryResultDetail(){ID = i});
db.RetrieveLogsBySearchResults(search);
var logDe = search.LogIDs[0].Log;
}
stop = DateTime.UtcNow;
ts = stop - start;
Console.WriteLine("Total Milliseconds (Retrieve 200,000 Logs)" + ts.TotalMilliseconds.ToString("#,##0"));
start = DateTime.UtcNow;
var count = db.Count(new DateTime(2011, 11, 24), new DateTime(2011, 11, 26));
stop = DateTime.UtcNow;
ts = stop - start;
Console.WriteLine("Total Milliseconds " + ts.TotalMilliseconds.ToString("#,##0"));
Console.WriteLine("Total Date Range Count " + count.ToString("#,##0"));
start = DateTime.UtcNow;
count = db.Count();
stop = DateTime.UtcNow;
ts = stop - start;
Console.WriteLine("Total Milliseconds " + ts.TotalMilliseconds.ToString("#,##0"));
Console.WriteLine("Total All Count " + count.ToString("#,##0"));
}
}
private void ProcessSendLog(byte[] data)
{
var item = new JobItem(JobMethods.Database_InsertLogs);
var log = Log.DeserializeLog(data);
var entity = new LogEntity(log.CreatedDateTime, TimeSpan.FromTicks(log.Elapsed), log.IsError, data);
item.LogEntityItems = new List<LogEntity>(1);
item.LogEntityItems.Add(entity);
AddJob(item);
}