Example #1
0
 public void AddToUrlTable(UrlEntity url)
 {
     urlTable.Execute(TableOperation.InsertOrReplace(url));
     recentUrls.AddUrl(UrlEntity.DecodeFromTableKey(url.PartitionKey) + ": " + UrlEntity.DecodeFromTableKey(url.RowKey));
     statsTable.Execute(TableOperation.InsertOrReplace(recentUrls));
     IncrementUrlTableLength();
 }
Example #2
0
        public DisplayUrl[] SearchForPhrase(string phrase)
        {
            if (phrase == null || phrase == string.Empty)
            {
                return(null);
            }
            // remove non-alphanumeric and split before using linq (get us a collection)
            string[] words = UrlEntity.CleanFullTitle(phrase).ToLower().Split(' ');
            if (words.Length <= 0)
            {
                return(null);
            }
            // query the db. This should be in multiple parts due to the maximum limit on filter params for azure tables
            // also since we're using different partition keys it doesn't really speed anything up
            List <UrlEntity> allEntites = new List <UrlEntity>();

            foreach (string param in words)
            {
                var results = urlTable.ExecuteQuery <UrlEntity>(new TableQuery <UrlEntity>().Where(
                                                                    TableQuery.GenerateFilterCondition("PartitionKey", QueryComparisons.Equal, param)
                                                                    ));
                allEntites.AddRange(results);
            }
            // group by full title, then order by the number of matches for that title
            // ending with a date sort and making new display URLs for the items
            var res = allEntites
                      .GroupBy(x => x.Title)
                      .OrderByDescending(x => x.Count())
                      .ThenByDescending(x => x.First().Date)
                      .Select(x => new DisplayUrl(x.First().URL, x.First().Title, x.First().Date))
                      .Take(20);

            ;
            return(res.ToArray());
        }
Example #3
0
        public string GetPageTitle(string url)
        {
            TableQuery <UrlEntity> query = new TableQuery <UrlEntity>().Where(
                TableQuery.GenerateFilterCondition("PartitionKey", QueryComparisons.Equal, UrlEntity.EncodeToTableKey(url))
                );
            var result = urlTable.ExecuteQuery(query);

            if (result.Count() == 0)
            {
                return("No results found");
            }
            else
            {
                return(result.First().Title);
            }
        }