/// <summary>
/// Asynchronously inserts the <paramref name="record"/>'s data into the data store defined
/// by the <paramref name="groupName"/>.
/// </summary>
/// <param name="record">The data to insert into the data store (INOSQLRecord)</param>
/// <param name="groupName">The name of the group to create (string)</param>
/// <returns>Task(bool) whether the function executed without exception</returns>
public bool Create(INOSQLRecord record, string groupName)
{
// Convert the record to LogRecord.
LogRecord logRecord;
try
{
logRecord = (LogRecord)record;
}
catch
{
throw new ArgumentException(Constants.LogCreateInvalidArgument);
}
// If the group name already exists
if (Logs.ContainsKey(groupName))
{
// Add the log and the unique ID to the group name in the datastore.
Logs[groupName].Add(counter, logRecord);
counter++;
}
else
{
// Create a log dictionary.
Dictionary <int, LogRecord> logDictionary = new Dictionary <int, LogRecord>();
// Add the log and the unique ID to the group name in the datastore.
logDictionary.Add(counter, logRecord);
Logs.Add(groupName, logDictionary);
counter++;
}
return(true);
}
/// <summary>
/// Asynchronously inserts the <paramref name="record"/>'s data into the data store defined
/// by the <paramref name="groupName"/>.
/// </summary>
/// <param name="record">The data to insert into the data store (INOSQLRecord)</param>
/// <param name="groupName">The name of the group to create (string)</param>
/// <returns>Task(bool) whether the function executed without exception</returns>
public async Task <bool> CreateAsync(INOSQLRecord record, string groupName)
{
// Try converting the INOSQLRecord to a LogRecord, if it failed throw an argument exception.
try
{
LogRecord temp = (LogRecord)record;
}
catch
{
throw new ArgumentException(Constants.LogCreateInvalidArgument);
}
LogRecord logRecord = (LogRecord)record;
// Get the session inside a using statement to properly dispose/close.
using (Session session = MySQLX.GetSession(NOSQLConnection))
{
// Create the schema if it doesn't exist.
Schema schema;
try
{
schema = session.CreateSchema(Constants.LogsSchemaName);
}
catch
{
schema = session.GetSchema(Constants.LogsSchemaName);
}
// Create the collection if it doesn't exist, then store the result in a variable.
var collection = schema.CreateCollection(Constants.LogsCollectionPrefix + groupName, ReuseExisting: true);
// Create json string to insert into the data store.
string document = $@"{{""{Constants.LogsTimestampField}"": ""{logRecord.Timestamp}"", " +
$@"""{Constants.LogsOperationField}"": ""{logRecord.Operation}"", " +
$@"""{Constants.LogsIdentifierField}"": ""{logRecord.Identifier}"", " +
$@"""{Constants.LogsIPAddressField}"": ""{logRecord.IPAddress}"", " +
$@"""{Constants.LogsErrorTypeField}"": ""{logRecord.ErrorType}""}}";
// Asynchronously add the document to the data store.
await collection.Add(document).ExecuteAsync().ConfigureAwait(false);
return(true);
}
}
/// <summary>
/// Find the id of the record that was inserted into the data store.
/// </summary>
/// <param name="record">The record to find (INOSQLRecord)</param>
/// <param name="groupName">The name of the group where the record is located (string)</param>
/// <returns>Task (string), the id of the record</returns>
public async Task <string> FindIdFieldAsync(INOSQLRecord record, string groupName)
{
// Try converting the INOSQLRecord to a LogRecord, if it failed throw an argument exception.
try
{
LogRecord temp = (LogRecord)record;
}
catch
{
throw new ArgumentException(Constants.LogFindInvalidArgument);
}
LogRecord logRecord = (LogRecord)record;
// Get the session inside a using statement to properly dispose/close.
using (Session session = MySQLX.GetSession(NOSQLConnection))
{
// Get the schema and collection.
Schema schema = session.GetSchema(Constants.LogsSchemaName);
var collection = schema.GetCollection(Constants.LogsCollectionPrefix + groupName);
// The items of the log record which all need to be found.
var documentParams = new DbDoc(new { timestamp = logRecord.Timestamp, operation = logRecord.Operation, identifier = logRecord.Identifier, ip = logRecord.IPAddress });
// Asynchronously execute a find on the fields that correspond to the parameter values above.
DocResult result = await collection.Find($"{Constants.LogsTimestampField} = :timestamp && {Constants.LogsOperationField} = :operation && {Constants.LogsIdentifierField} = :identifier && {Constants.LogsIPAddressField} = :ip").Bind(documentParams).ExecuteAsync().ConfigureAwait(false);
// Prepare string to be returned
string resultstring = "";
while (result.Next())
{
resultstring = (string)result.Current[Constants.LogsIdField];
}
if (resultstring.Equals(""))
{
throw new ArgumentException(Constants.LogFindDNE);
}
return(resultstring);
}
}
/// <summary>
/// Find the id of the record that was inserted into the data store.
/// </summary>
/// <param name="record">The record to find (INOSQLRecord)</param>
/// <param name="groupName">The name of the group where the record is located (string)</param>
/// <returns>Task (string), the id of the record</returns>
public string FindIdField(INOSQLRecord record, string groupName)
{
// Convert the record to LogRecord.
LogRecord logRecord;
try
{
logRecord = (LogRecord)record;
}
catch
{
throw new ArgumentException(Constants.LogFindInvalidArgument);
}
foreach (KeyValuePair <int, LogRecord> pair in Logs[groupName])
{
if (pair.Value.IsEqual(logRecord))
{
// If the log matches the given LogRecord, return its unique ID.
return(pair.Key.ToString());
}
}
// If the specific log is not found, throw an exception.
throw new ArgumentException(Constants.LogFindDNE);
}