private LogLevel GetLogLevelFromNpgsqlLogLevel(NpgsqlLogLevel level)
{
switch (level)
{
case NpgsqlLogLevel.Trace:
return(LogLevel.Trace);
case NpgsqlLogLevel.Debug:
return(LogLevel.Debug);
case NpgsqlLogLevel.Info:
return(LogLevel.Information);
case NpgsqlLogLevel.Warn:
return(LogLevel.Warning);
case NpgsqlLogLevel.Error:
return(LogLevel.Error);
case NpgsqlLogLevel.Fatal:
return(LogLevel.Critical);
default:
throw new Exception("Unknown Npgsql Log Level: " + level);
}
}
public override void Log(NpgsqlLogLevel level, int connectorId, string msg, Exception exception = null)
{
switch (level)
{
case NpgsqlLogLevel.Debug:
this.logger.Debug(msg, exception);
break;
case NpgsqlLogLevel.Info:
this.logger.Info(msg, exception);
break;
case NpgsqlLogLevel.Warn:
this.logger.Warn(msg, exception);
break;
case NpgsqlLogLevel.Error:
this.logger.Error(msg, exception);
break;
case NpgsqlLogLevel.Fatal:
this.logger.Fatal(msg, exception);
break;
}
}
public override void Log(NpgsqlLogLevel level, int connectorId, string msg, Exception exception = null)
{
_logger
.ForContext("ConnectorId", connectorId)
.ForContext("NpgsqlLogLevel", level)
.Debug(exception, "{PostgreSqlMessage}", msg);
}
public override void Log(NpgsqlLogLevel level, int connectorId, string msg, Exception exception = null)
{
if (_Source.IsEnabled("Log"))
{
_Source.Write("Log", new LogEventArgs(level, msg, connectorId, exception));
}
}
static LogEventLevel ConvertLevel(NpgsqlLogLevel level)
{
switch (level)
{
case NpgsqlLogLevel.Trace:
return(LogEventLevel.Verbose);
case NpgsqlLogLevel.Debug:
return(LogEventLevel.Debug);
case NpgsqlLogLevel.Info:
return(LogEventLevel.Information);
case NpgsqlLogLevel.Warn:
return(LogEventLevel.Warning);
case NpgsqlLogLevel.Error:
return(LogEventLevel.Error);
case NpgsqlLogLevel.Fatal:
return(LogEventLevel.Fatal);
default:
throw new ArgumentOutOfRangeException("level");
}
}
public override void Log(NpgsqlLogLevel level, int connectorId, string msg, Exception exception = null)
{
if (!IsEnabled(level)) {
return;
}
var sb = new StringBuilder();
if (_printLevel) {
sb.Append(level.ToString().ToUpper());
sb.Append(' ');
}
if (_printConnectorId && connectorId != 0)
{
sb.Append("[");
sb.Append(connectorId);
sb.Append("] ");
}
sb.AppendLine(msg);
if (exception != null)
{
sb.AppendLine(exception.ToString());
}
Console.Error.Write(sb.ToString());
}
static LogLevel ToNLogLogLevel(NpgsqlLogLevel level)
{
switch (level)
{
case NpgsqlLogLevel.Trace:
return(LogLevel.Trace);
case NpgsqlLogLevel.Debug:
return(LogLevel.Debug);
case NpgsqlLogLevel.Info:
return(LogLevel.Info);
case NpgsqlLogLevel.Warn:
return(LogLevel.Warn);
case NpgsqlLogLevel.Error:
return(LogLevel.Error);
case NpgsqlLogLevel.Fatal:
return(LogLevel.Fatal);
default:
throw new ArgumentOutOfRangeException("level");
}
}
internal LogEventArgs(NpgsqlLogLevel level, string msg, int connectorId, Exception exception)
{
Level = level;
Message = msg;
ConnectorId = connectorId;
Exception = exception;
}
public override void Log(NpgsqlLogLevel level, int connectorId, string msg, Exception exception = null)
{
if (!IsEnabled(level))
{
return;
}
var sb = new StringBuilder();
if (_printLevel)
{
sb.Append(level.ToString().ToUpper());
sb.Append(' ');
}
if (_printConnectorId && connectorId != 0)
{
sb.Append("[");
sb.Append(connectorId);
sb.Append("] ");
}
sb.AppendLine(msg);
if (exception != null)
{
sb.AppendLine(exception.ToString());
}
Console.Error.Write(sb.ToString());
}
public override void Log(NpgsqlLogLevel level, int connectorId, string msg, Exception exception = null)
{
var ev = new LogEventInfo(ToNLogLogLevel(level), "", msg);
if (exception != null)
ev.Exception = exception;
if (connectorId != 0)
ev.Properties["ConnectorId"] = connectorId;
_log.Log(ev);
}
public override void Log(NpgsqlLogLevel level, int connectorId, string msg, Exception exception = null)
{
if (level >= MinimumLogLevel)
{
Serilog.Log
.ForContext("ConnectorId", connectorId)
.Write(MapLevel(level), exception, "Npgsql: {Message}", msg);
}
}
public PostgresLogEvent(DateTime now, string name, NpgsqlLogLevel level, int connectorId, string msg,
Exception exception)
{
this.now = now;
this.level = level;
this.connectorId = connectorId;
this.msg = msg;
this.exception = exception;
this.loggerName = name;
}
public override void Log(NpgsqlLogLevel level, int connectorId, string msg, Exception exception = null)
{
lock (locker)
{
currentFileName = $"Logs/PostgresLog{DateTime.Today.ToString("yyyyMMdd")}.txt";
fStream = new FileStream(currentFileName, FileMode.Append, FileAccess.Write);
using (StreamWriter streamWriter = new StreamWriter(fStream, Encoding.UTF8))
{
streamWriter.Write(Environment.NewLine + msg + Environment.NewLine);
}
}
}
public override bool IsEnabled(NpgsqlLogLevel level)
{
return(level switch
{
NpgsqlLogLevel.Trace => this.logger.IsEnabled(LogLevel.Trace),
NpgsqlLogLevel.Debug => this.logger.IsEnabled(LogLevel.Debug),
NpgsqlLogLevel.Info => this.logger.IsEnabled(LogLevel.Information),
NpgsqlLogLevel.Warn => this.logger.IsEnabled(LogLevel.Warning),
NpgsqlLogLevel.Error => this.logger.IsEnabled(LogLevel.Error),
NpgsqlLogLevel.Fatal => this.logger.IsEnabled(LogLevel.Critical),
_ => false
});
private static LogLevel ToVostokLogLevel(NpgsqlLogLevel level)
{
return(level switch
{
NpgsqlLogLevel.Trace => LogLevel.Debug,
NpgsqlLogLevel.Debug => LogLevel.Debug,
NpgsqlLogLevel.Info => LogLevel.Info,
NpgsqlLogLevel.Warn => LogLevel.Warn,
NpgsqlLogLevel.Error => LogLevel.Error,
NpgsqlLogLevel.Fatal => LogLevel.Fatal,
_ => throw new ArgumentOutOfRangeException(nameof(level))
});
// string _Name;
public DiagnosticNpgsqlLogger(NpgsqlLogLevel level, string name)
{
_Level = level;
// _Name = name;
_Source = _SourceDictionary.GetOrAdd(name, (x) => new DiagnosticListener($"{DiagnosticNpgsqlLoggingProvider.ProviderName}.{x}"));
if (_Source.IsEnabled(CreateLoggerEventArgs.EventName))
{
_Source.Write(CreateLoggerEventArgs.EventName, new CreateLoggerEventArgs()
{
Name = name, Level = level
});
}
}
public override void Log(NpgsqlLogLevel level, int connectorId, string msg, Exception exception = null)
{
var ev = new LogEventInfo(ToNLogLogLevel(level), "", msg);
if (exception != null)
{
ev.Exception = exception;
}
if (connectorId != 0)
{
ev.Properties["ConnectorId"] = connectorId;
}
_log.Log(ev);
}
public override void Log(NpgsqlLogLevel level, int connectorId, string msg, Exception exception = null)
{
_logger.Write((Serilog.Events.LogEventLevel)level, msg);
if (msg.StartsWith("Query duration"))
{
string digits = new String(msg.Where(Char.IsDigit).ToArray());
int ms = Convert.ToInt32(digits);
if (ms > highest_ms)
{
highest_ms = ms;
_logger.Information("Query duration high water mark is now " + digits);
}
}
}
public override bool IsEnabled(NpgsqlLogLevel level)
{
if ((int)level < (int)minLevel)
{
return(false);
}
return(level switch
{
NpgsqlLogLevel.Trace => logger.IsEnabled(LogEventLevel.Verbose),
NpgsqlLogLevel.Debug => logger.IsEnabled(LogEventLevel.Debug),
NpgsqlLogLevel.Info => logger.IsEnabled(LogEventLevel.Information),
NpgsqlLogLevel.Warn => logger.IsEnabled(LogEventLevel.Warning),
NpgsqlLogLevel.Error => logger.IsEnabled(LogEventLevel.Error),
NpgsqlLogLevel.Fatal => logger.IsEnabled(LogEventLevel.Fatal),
_ => throw new ArgumentOutOfRangeException(nameof(level), level, null)
});
static LogLevel ToNLogLogLevel(NpgsqlLogLevel level)
{
switch (level)
{
case NpgsqlLogLevel.Trace:
return LogLevel.Trace;
case NpgsqlLogLevel.Debug:
return LogLevel.Debug;
case NpgsqlLogLevel.Info:
return LogLevel.Info;
case NpgsqlLogLevel.Warn:
return LogLevel.Warn;
case NpgsqlLogLevel.Error:
return LogLevel.Error;
case NpgsqlLogLevel.Fatal:
return LogLevel.Fatal;
default:
throw new ArgumentOutOfRangeException("level");
}
}
public override void Log(NpgsqlLogLevel level, int connectorId, string msg, Exception exception = null)
{
if (IsEnabled(level))
{
if (exception != null)
{
logger.Error(exception, $"Connector: {connectorId}; {msg} - {{@error}}");
}
else
{
switch (level)
{
case NpgsqlLogLevel.Trace:
logger.Verbose($"Connector: {connectorId}; {msg}");
break;
case NpgsqlLogLevel.Debug:
logger.Debug($"Connector: {connectorId}; {msg}");
break;
case NpgsqlLogLevel.Info:
logger.Information($"Connector: {connectorId}; {msg}");
break;
case NpgsqlLogLevel.Warn:
logger.Warning($"Connector: {connectorId}; {msg}");
break;
case NpgsqlLogLevel.Error:
logger.Error(exception, $"Connector: {connectorId}; {msg} - {{@error}}");
break;
case NpgsqlLogLevel.Fatal:
logger.Fatal(exception, $"Connector: {connectorId}; {msg} - {{@error}}");
break;
}
}
}
}
public override bool IsEnabled(NpgsqlLogLevel level)
{
switch (level)
{
case NpgsqlLogLevel.Debug:
return(this.logger.IsDebugEnabled);
case NpgsqlLogLevel.Info:
return(this.logger.IsInfoEnabled);
case NpgsqlLogLevel.Warn:
return(this.logger.IsWarnEnabled);
case NpgsqlLogLevel.Error:
return(this.logger.IsErrorEnabled);
case NpgsqlLogLevel.Fatal:
return(this.logger.IsFatalEnabled);
}
return(false);
}
private static LogEventLevel MapLevel(NpgsqlLogLevel level)
{
switch (level)
{
case NpgsqlLogLevel.Fatal:
return(LogEventLevel.Fatal);
case NpgsqlLogLevel.Error:
return(LogEventLevel.Error);
case NpgsqlLogLevel.Warn:
return(LogEventLevel.Warning);
case NpgsqlLogLevel.Info:
return(LogEventLevel.Information);
case NpgsqlLogLevel.Debug:
return(LogEventLevel.Debug);
default:
return(LogEventLevel.Verbose);
}
}
public override bool IsEnabled(NpgsqlLogLevel level)
{
return(_log.IsEnabled(ToNLogLogLevel(level)));
}
public abstract void Log(NpgsqlLogLevel level, int connectorId, string msg, Exception exception = null);
public abstract bool IsEnabled(NpgsqlLogLevel level);
public abstract void Log(NpgsqlLogLevel level, int connectorId, string msg, Exception exception = null);
public abstract bool IsEnabled(NpgsqlLogLevel level);
public override bool IsEnabled(NpgsqlLogLevel level)
{
return _log.IsEnabled(ToNLogLogLevel(level));
}
public override bool IsEnabled(NpgsqlLogLevel level) => level >= _minLevel;
/// <summary>
/// Constructs a new <see cref="ConsoleLoggingProvider"/>
/// </summary>
/// <param name="minLevel">Only messages of this level of higher will be logged</param>
/// <param name="printLevel">If true, will output the log level (e.g. WARN). Defaults to false.</param>
/// <param name="printConnectorId">If true, will output the connector ID. Defaults to false.</param>
public ConsoleLoggingProvider(NpgsqlLogLevel minLevel = NpgsqlLogLevel.Info, bool printLevel = false, bool printConnectorId = false)
{
_minLevel = minLevel;
_printLevel = printLevel;
_printConnectorId = printConnectorId;
}
public override bool IsEnabled(NpgsqlLogLevel level)
{
return false;
}
public override bool IsEnabled(NpgsqlLogLevel level)
{
return level >= _minLevel;
}
public override bool IsEnabled(NpgsqlLogLevel level)
{
return(level >= _minLevel);
}
public override void Log(NpgsqlLogLevel level, int connectorId, string msg, Exception exception = null)
{
}
internal ConsoleLogger(NpgsqlLogLevel minLevel, bool printLevel, bool printConnectorId)
{
_minLevel = minLevel;
_printLevel = printLevel;
_printConnectorId = printConnectorId;
}
/// <summary>
/// Constructs a new <see cref="ConsoleLoggingProvider"/>
/// </summary>
/// <param name="minLevel">Only messages of this level of higher will be logged</param>
/// <param name="printLevel">If true, will output the log level (e.g. WARN). Defaults to false.</param>
/// <param name="printConnectorId">If true, will output the connector ID. Defaults to false.</param>
public ConsoleLoggingProvider(NpgsqlLogLevel minLevel=NpgsqlLogLevel.Info, bool printLevel=false, bool printConnectorId=false)
{
_minLevel = minLevel;
_printLevel = printLevel;
_printConnectorId = printConnectorId;
}
/// <inheritdoc />
public override bool IsEnabled(NpgsqlLogLevel level)
{
return(_minimumLevel != LogEventLevel.Off &&
_logger.IsEnabled(LogLevelSwitcher.Switch(level)));
}
internal ConsoleLogger(NpgsqlLogLevel minLevel, bool printLevel, bool printConnectorId)
{
_minLevel = minLevel;
_printLevel = printLevel;
_printConnectorId = printConnectorId;
}
/// <summary>
/// Convert a <see cref="NpgsqlLogLevel"/> to a <see cref="LogEventLevel"/>
/// </summary>
/// <param name="level"></param>
public static Maybe <LogEventLevel> ConvertToSerilogLevel(NpgsqlLogLevel level) =>
level switch
{
/// <inheritdoc />
public override void Log(NpgsqlLogLevel level, int connectorId, string msg, Exception exception = null)
{
_logger.Log(LogLevelSwitcher.Switch(level), exception, msg, ctx => ctx.AddData("ConnectorId", connectorId));
}
