public void Start()
{
bool firstCall = true;
while (true)
{
var conn = _rethinkDbFactory.CreateConnection();
try
{
//var srv = conn.Server();
//_logger.LogDebug(902, $"Connected to RethinkDB server {srv.Name}");
var result = R.Db(_rethinkDbFactory.GetOptions().Database).TableList().RunAtom <List <string> >(conn);
if (firstCall)
{
_logger.LogDebug(902, $"Connected to RethinkDB server {_rethinkDbFactory.GetOptions().Host}");
}
firstCall = false;
}
catch (Exception ex)
{
_logger.LogDebug(1001, ex, $"RethinkDbKeepAlive error {ex.Message}. Connection open {conn.Open}.");
conn.Reconnect();
}
Thread.Sleep(TimeSpan.FromSeconds(60));
}
}
public dynamic Load(int limit)
{
var conn = _rethinkDbFactory.CreateConnection();
var logs = R.Db(_rethinkDbFactory.GetOptions().Database)
.Table("Logs")
.OrderBy()[new { index = R.Desc(nameof(LogEntry.Timestamp)) }]
.Limit(limit)
.RunCursor <LogEntry>(conn);
var result = logs.ToList();
logs.Close();
return(result);
}
public RethinkDbManager(IRethinkDbConnectionFactory connectionFactory)
{
_connection = connectionFactory.CreateConnection();
_connection.CheckOpen();
_dbName = connectionFactory.GetOptions().Database;
}
private void InsertLog(RethinkDb.Driver.Net.Connection conn, string categoryName, string logLevel, int eventId, string eventName, string message, Exception exception)
{
string exceptionId = null;
if (exception != null)
{
// insert exception
var result = R.Db(_dbName).Table(ExceptionTable)
.Insert(exception)
.RunResult(conn);
exceptionId = result.GeneratedKeys.First().ToString();
}
var logEntry = new LogEntry
{
Application = _connectionFactory.GetOptions().Application,
Category = categoryName,
Event = eventName,
EventId = eventId,
ExceptionId = exceptionId,
Host = Environment.MachineName,
Level = logLevel,
Message = message,
Timestamp = DateTime.UtcNow
};
R.Db(_dbName).Table(LogTable)
.Insert(logEntry)
.RunResult(conn);
}
protected Store(
IRethinkDbConnectionFactory connectionFactory,
IRethinkDbDelegateBus rethinkDbDelegateBus
)
{
Connection = connectionFactory.CreateConnection();
Connection.CheckOpen();
DbName = connectionFactory.GetOptions().Database;
TableName = typeof(TDocument).Name;
_rethinkDbDelegateBus = rethinkDbDelegateBus;
}
public RethinkDbStore(IRethinkDbConnectionFactory connectionFactory)
{
_connectionFactory = connectionFactory;
_dbName = connectionFactory.GetOptions().Database;
}
public RethinkDbLoggerService(IRethinkDbConnectionFactory connectionFactory)
{
_connectionFactory = connectionFactory;
_dbName = _connectionFactory.GetOptions().Database;
}
