/// <summary>
/// Adds a sink that writes audit events to MariaDB/MySQL table
/// </summary>
/// <param name="loggerAuditConfiguration">Options for the sink</param>
/// <param name="options">Additional options for audit sink</param>
/// <param name="tableName">Name of the database table used for storing events</param>
/// <param name="autoCreateTable">If true the sink will create a SQL table if it doesn't exist</param>
/// <param name="restrictedToMinimumLevel">The minimum log event level required in order to write an event to the sink</param>
public static LoggerConfiguration MariaDB(
this LoggerAuditSinkConfiguration loggerAuditConfiguration,
string connectionString,
IFormatProvider formatProvider = null,
MariaDBSinkOptions options = null,
string tableName = "Logs",
bool autoCreateTable = false,
LogEventLevel restrictedToMinimumLevel = LevelAlias.Minimum
)
{
if (loggerAuditConfiguration == null)
{
throw new ArgumentNullException(nameof(loggerAuditConfiguration));
}
return(loggerAuditConfiguration.Sink(
new MariaDBAuditSink(
connectionString,
formatProvider,
options ?? new MariaDBSinkOptions(),
tableName,
autoCreateTable
),
restrictedToMinimumLevel
));
}
/// <summary>
/// Adds a sink that writes log events to MariaDB/MySQL table
/// </summary>
/// <param name="loggerConfiguration">Options for the sink</param>
/// <param name="batchPostingLimit">The maximum number of events to include in a single batch</param>
/// <param name="queueSizeLimit">The maximum number of events that will be held in-memory while waiting to store them to SQL. Beyond this limit, events will be dropped. Default is 10000</param>
/// <param name="period">The time to wait between checking for event batches</param>
/// <param name="options">Additional options for the sink</param>
/// <param name="tableName">Name of the database table used for storing events</param>
/// <param name="autoCreateTable">If true the sink will create a SQL table if it doesn't exist</param>
/// <param name="useBulkInsert">If true, tries to insert whole buffer of event collected per <paramref name="period"/> with a single command (more efficient, but less reliable)</param>
/// <param name="restrictedToMinimumLevel">The minimum log event level required in order to write an event to the sink</param>
public static LoggerConfiguration MariaDB(
this LoggerSinkConfiguration loggerConfiguration,
string connectionString,
IFormatProvider formatProvider = null,
int batchPostingLimit = MariaDBSink.DefaultBatchPostingLimit,
int queueSizeLimit = 10000,
TimeSpan?period = null,
MariaDBSinkOptions options = null,
string tableName = "Logs",
bool autoCreateTable = false,
bool useBulkInsert = true,
LogEventLevel restrictedToMinimumLevel = LevelAlias.Minimum
)
{
if (loggerConfiguration == null)
{
throw new ArgumentNullException(nameof(loggerConfiguration));
}
return(loggerConfiguration.Sink(
new MariaDBSink(
connectionString,
formatProvider,
batchPostingLimit,
queueSizeLimit,
period ?? MariaDBSink.DefaultPeriod,
options ?? new MariaDBSinkOptions(),
tableName,
autoCreateTable,
useBulkInsert
),
restrictedToMinimumLevel
));
}
public MariaDBAuditSink(
string connectionString,
IFormatProvider formatProvider,
MariaDBSinkOptions options,
string tableName,
bool autoCreateTable
)
{
ConnectionString = connectionString;
Core = new MariaDBSinkCore(connectionString, formatProvider, options, tableName, autoCreateTable);
}
public MariaDBSinkCore(
string connectionString,
IFormatProvider formatProvider,
MariaDBSinkOptions options,
string tableName,
bool autoCreateTable
)
{
if (string.IsNullOrWhiteSpace(connectionString))
{
throw new ArgumentNullException(nameof(connectionString));
}
if (string.IsNullOrWhiteSpace(tableName))
{
throw new ArgumentNullException(nameof(tableName));
}
_tableName = tableName;
_formatProvider = formatProvider;
_options = options ?? throw new ArgumentNullException(nameof(options));
_options.PropertiesToColumnsMapping = _options.PropertiesToColumnsMapping
.Where(i => i.Value != null)
.ToDictionary(k => k.Key, v => v.Value);
if (autoCreateTable)
{
try
{
var tableCreator = new SqlTableCreator(connectionString, _tableName, _options.PropertiesToColumnsMapping.Values);
tableCreator.CreateTable();
}
catch (Exception ex)
{
SelfLog.WriteLine($"Exception creating table {_tableName}:\n{ex}");
}
}
if (_options.LogRecordsExpiration.HasValue && _options.LogRecordsExpiration > TimeSpan.Zero && _options.LogRecordsCleanupFrequency > TimeSpan.Zero)
{
_cleaner = new PeriodicCleanup(connectionString,
tableName,
_options.PropertiesToColumnsMapping["Timestamp"],
_options.LogRecordsExpiration.Value,
_options.LogRecordsCleanupFrequency,
_options.TimestampInUtc,
_options.DeleteChunkSize);
_cleaner.Start();
}
}
public MariaDBSink(string connectionString,
IFormatProvider formatProvider,
int batchPostingLimit,
int queueSizeLimit,
TimeSpan period,
MariaDBSinkOptions options,
string tableName,
bool autoCreateTable,
bool useBulkInsert) : base(batchPostingLimit, period, queueSizeLimit)
{
ConnectionString = connectionString;
UseBulkInsert = useBulkInsert;
Core = new MariaDBSinkCore(connectionString, formatProvider, options, tableName, autoCreateTable);
}