コード例 #1
0
ファイル: WhereMatcher.cs プロジェクト: sharwell/elfie-arriba
        public static WhereResult Where(ITabularReader reader, string columnIdentifier, string operatorString, string valueString, ITabularWriter writer)
        {
            int         colIndex = reader.ColumnIndex(columnIdentifier);
            WhereResult result   = new WhereResult()
            {
                ColumnIndex = colIndex, ColumnName = reader.Columns[colIndex], Op = OperatorExtensions.Parse(operatorString), Value = ConvertToBestType(valueString)
            };

            Type t = result.Value.GetType();

            if (t == typeof(bool))
            {
                MatchBoolCompare(reader, writer, result);
            }
            else if (t == typeof(int))
            {
                MatchIntCompare(reader, writer, result);
            }
            else if (t == typeof(DateTime))
            {
                MatchDateTimeCompare(reader, writer, result);
            }
            else if (result.Op == Operator.Contains)
            {
                MatchContains(reader, writer, result);
            }
            else if (result.Op == Operator.StartsWith)
            {
                MatchStartsWith(reader, writer, result);
            }
            else
            {
                MatchStringCompare(reader, writer, result);
            }

            result.RowCount = reader.RowCountRead;
            return(result);
        }
コード例 #2
0
ファイル: WhereMatcher.cs プロジェクト: sharwell/elfie-arriba
        private static void MatchBoolCompare(ITabularReader reader, ITabularWriter writer, WhereResult result)
        {
            bool value = (bool)result.Value;

            while (reader.NextRow())
            {
                // Ensure the row has enough columns
                if (reader.CurrentRowColumns <= result.ColumnIndex)
                {
                    continue;
                }

                // Ensure the value converts
                bool columnValue;
                if (!reader.Current(result.ColumnIndex).ToString8().TryToBoolean(out columnValue))
                {
                    continue;
                }

                int compareResult = columnValue.CompareTo(value);
                if (!result.Op.Matches(compareResult))
                {
                    continue;
                }

                result.MatchCount++;

                // If this is the matching row, write it
                EchoRow(reader, writer);
            }
        }
コード例 #3
0
ファイル: WhereMatcher.cs プロジェクト: sharwell/elfie-arriba
        private static void MatchContains(ITabularReader reader, ITabularWriter writer, WhereResult result)
        {
            string  valueString = (string)result.Value;
            String8 value       = String8.Convert(valueString, new byte[String8.GetLength(valueString)]);

            while (reader.NextRow())
            {
                // Ensure the row has enough columns
                if (reader.CurrentRowColumns <= result.ColumnIndex)
                {
                    continue;
                }

                // Match the value
                if (reader.Current(result.ColumnIndex).ToString8().IndexOf(value) == -1)
                {
                    continue;
                }

                result.MatchCount++;

                // If this is the matching row, write it
                EchoRow(reader, writer);
            }
        }