public NAppIndexUpdater(Configuration.ConfigManager config, Database currentDb)
{
indexFullPath = config.GetSetting(SettingKeys.Index_Directory, System.IO.Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "Index"));
indexFullPath = System.IO.Path.GetFullPath(indexFullPath);
directory = FSDirectory.Open(new System.IO.DirectoryInfo(indexFullPath));
this.currentDb = currentDb;
}
public JobProcessor(ConfigManager config, Database currentDb, JobQueueManager manager, NAppIndexUpdater indexUpdater, NAppIndexReader indexReader)
{
this.currentDb = currentDb;
this.manager = manager;
this.indexReader = indexReader;
this.indexUpdater = indexUpdater;
if (!int.TryParse(config.GetSetting(SettingKeys.Manager_ProcessorQueueSize), out this.processorQueueSize))
{
this.processorQueueSize = 64;
}
InitializeLists();
}
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 RetrieveRecordByID()
{
using (var db = new Database(new ConfigManager()))
{
db.InitializeDatabase();
var search = new LogQueryResults() { IncludeData = true };
search.LogIDs = new List<LogQueryResultDetail>();
search.LogIDs.Add(new LogQueryResultDetail() { ID = 1 });
db.RetrieveLogsBySearchResults(search);
Assert.AreEqual(1, search.LogIDs[0].ID);
Assert.That(search.LogIDs[0].Log, Is.Not.Null);
}
}
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 });
}
}
public Job(ConfigManager config, JobQueueManager manager, bool IsDatabaseTask, bool traceEnabled)
{
this.config = config;
this.manager = manager;
if (IsDatabaseTask)
{
currentDb = new Database(config);
currentDb.InitializeDatabase();
indexUpdater = new NAppIndexUpdater(config, currentDb);
indexUpdater.Initialize();
}
indexReader = new NAppIndexReader(config);
this.traceEnabled = traceEnabled;
}
public void GetDatabaseDefaultDirectory()
{
var expected = string.Empty;
var baseD = AppDomain.CurrentDomain.BaseDirectory;
if (baseD.IndexOf("bin\\Release", StringComparison.InvariantCultureIgnoreCase) >= 0 ||
baseD.IndexOf("bin\\Debug", StringComparison.InvariantCultureIgnoreCase) >= 0)
{
expected = Path.GetFullPath(Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "..", "..", "..", "DB", "current"));
}
else
{
expected = Path.GetFullPath(Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "DB", "current"));
}
using (var db = new Database(new ConfigManager()))
{
var filePath = db.GetDatabaseDirectory();
Assert.That(filePath, Is.EqualTo(expected));
//Assert.AreEqual(filePath, expected);
}
}
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"));
}
}