Argentini.Halide.H3Search.GetQuery C# (CSharp) Method

GetQuery() public method

Assemble the query fields and search terms into a SQL WHERE clause fragment.
public GetQuery ( ) : string
return string
        public string GetQuery()
        {
            StringBuilder query = new StringBuilder("");

            if (_searchTerms.Count > 0 && _fields.Count > 0)
            {
                for (int x = 0; x < _fields.Count; x++)
                {
                    if (x > 0)
                    {
                        query.Append(" OR ");
                    }

                    query.Append("(");

                    for (int y = 0; y < _searchTerms.Count; y++)
                    {
                        if (Array.IndexOf(_noisewords, _searchTerms[y]) < 0 || !_ignoreNoiseWords)
                        {
                            if (y > 0)
                            {
                                query.Append(" AND ");
                            }

                            query.Append("[" + _fields[x] + "] LIKE '%" + _searchTerms[y] + "%'");
                        }
                    }

                    query.Append(")");
                }
            }

            return query.ToString();
        }

Usage Example

コード例 #1
0
ファイル: UnitTest1.cs プロジェクト: argentini/Halide
 public void TestSearch()
 {
     H3Search search = new H3Search("guardians of the galaxy", false);
     search.AddAddFieldName("summary");
     search.AddAddFieldName("description");
     Console.WriteLine(search.GetQuery());
 }