internal RequestDebugInfo Transform(IEnumerable<LogStatistic> messages)
{
var selects = 0;
var updates = 0;
var deletes = 0;
var inserts = 0;
var batchCommands = 0;
if (messages == null) return null;
var info = new RequestDebugInfo
{
GlimpseKey = Guid.NewGuid()
};
foreach (var loggingEvent in messages)
{
if (!string.IsNullOrEmpty(loggingEvent.Sql) && loggingEvent.Sql.Trim() != string.Empty)
{
var detail = loggingEvent.Sql.TrimStart(' ', '\n', '\r');
if (detail.StartsWith("select", StringComparison.OrdinalIgnoreCase)) selects++;
if (detail.StartsWith("update", StringComparison.OrdinalIgnoreCase)) updates++;
if (detail.StartsWith("delete", StringComparison.OrdinalIgnoreCase)) deletes++;
if (detail.StartsWith("insert", StringComparison.OrdinalIgnoreCase)) inserts++;
if (detail.StartsWith("batch commands:", StringComparison.OrdinalIgnoreCase)) batchCommands++;
}
}
info.Selects = selects;
info.Inserts = inserts;
info.Updates = updates;
info.Deletes = deletes;
info.Batch = batchCommands;
return info;
}
internal RequestDebugInfo Transform(IEnumerable <LogStatistic> messages)
{
var selects = 0;
var updates = 0;
var deletes = 0;
var inserts = 0;
var batchCommands = 0;
if (messages == null)
{
return(null);
}
var info = new RequestDebugInfo
{
GlimpseKey = Guid.NewGuid()
};
foreach (var loggingEvent in messages)
{
if (!string.IsNullOrEmpty(loggingEvent.Sql) && loggingEvent.Sql.Trim() != string.Empty)
{
var detail = loggingEvent.Sql.TrimStart(' ', '\n', '\r');
if (detail.StartsWith("select", StringComparison.OrdinalIgnoreCase))
{
selects++;
}
if (detail.StartsWith("update", StringComparison.OrdinalIgnoreCase))
{
updates++;
}
if (detail.StartsWith("delete", StringComparison.OrdinalIgnoreCase))
{
deletes++;
}
if (detail.StartsWith("insert", StringComparison.OrdinalIgnoreCase))
{
inserts++;
}
if (detail.StartsWith("batch commands:", StringComparison.OrdinalIgnoreCase))
{
batchCommands++;
}
}
}
info.Selects = selects;
info.Inserts = inserts;
info.Updates = updates;
info.Deletes = deletes;
info.Batch = batchCommands;
return(info);
}