Beispiel #1
0
        /// <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);
        }
Beispiel #2
0
        /// <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);
            }
        }
Beispiel #3
0
        /// <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);
            }
        }
Beispiel #4
0
        /// <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);
        }