Esempio n. 1
0
        public async Task MultiplePagesAsync_PageSizeNotInOptions()
        {
            // We create the client using our user, but then access a dataset in a public data
            // project. We can't run a query "as" the public data project.
            var projectId = _fixture.ProjectId;
            var client    = BigQueryClient.Create(projectId);
            var table     = client.GetTable(PublicDatasetsProject, PublicDatasetsDataset, ShakespeareTable);
            var sql       = $"SELECT corpus as title, COUNT(word) as unique_words FROM {table} GROUP BY title ORDER BY unique_words DESC LIMIT 13";
            // Note that we don't specify any options. That means when we want to read a page at a time later, we'll need to perform the query again.
            var results = await client.ExecuteQueryAsync(sql, parameters : null);

            // Iterate over multiple pages automatically to get all results. The query has 13 results.
            var rows = await results.GetRowsAsync().ToListAsync();

            Assert.Equal(13, rows.Count);

            // Now try getting one page at a time, in the same way we would if we were in a web application.
            var page1 = await results.ReadPageAsync(5);

            var page2 = await client.GetQueryResults(results.JobReference, new GetQueryResultsOptions { PageToken = page1.NextPageToken }).ReadPageAsync(5);

            var page3 = await client.GetQueryResults(results.JobReference, new GetQueryResultsOptions { PageToken = page2.NextPageToken }).ReadPageAsync(5);

            var titleComparer = new TitleComparer();

            Assert.Equal(rows.Take(5), page1.Rows, titleComparer);
            Assert.Equal(rows.Skip(5).Take(5), page2.Rows, titleComparer);
            Assert.Equal(rows.Skip(10).Take(5), page3.Rows, titleComparer);
            Assert.Null(page3.NextPageToken);
        }
Esempio n. 2
0
        public void MultiplePagesWithStartIndex()
        {
            // We create the client using our user, but then access a dataset in a public data
            // project. We can't run a query "as" the public data project.
            var projectId = _fixture.ProjectId;
            var client    = BigQueryClient.Create(projectId);
            var table     = client.GetTable(PublicDatasetsProject, PublicDatasetsDataset, ShakespeareTable);

            var sql     = $"SELECT corpus as title, COUNT(word) as unique_words FROM {table} GROUP BY title ORDER BY unique_words DESC LIMIT 20";
            var results = client.ExecuteQuery(sql, parameters: null, resultsOptions: new GetQueryResultsOptions {
                PageSize = 5, StartIndex = 7
            });
            // Iterate over multiple pages automatically to get all results. The query has 20 results, but
            // we're asking to start at index 7, so we actually see 13.
            var rows = results.ToList();

            Assert.Equal(13, rows.Count);

            // Now try getting one page at a time, in the same way we would if we were in a web application.
            var page1 = results.ReadPage(5);
            var page2 = client.GetQueryResults(results.JobReference, new GetQueryResultsOptions {
                PageToken = page1.NextPageToken
            }).ReadPage(5);
            var page3 = client.GetQueryResults(results.JobReference, new GetQueryResultsOptions {
                PageToken = page2.NextPageToken
            }).ReadPage(5);

            var titleComparer = new TitleComparer();

            Assert.Equal(rows.Take(5), page1.Rows, titleComparer);
            Assert.Equal(rows.Skip(5).Take(5), page2.Rows, titleComparer);
            Assert.Equal(rows.Skip(10).Take(5), page3.Rows, titleComparer);
            Assert.Null(page3.NextPageToken);
        }
Esempio n. 3
0
        public void ExtractSeriesNameFromFilename()
        {
            TitleComparer comparer = new TitleComparer();
            string        fileName = @"the.chilling.adventures.of.sabrina.s01e07.720p.webrip.hevc.x265.rmteam.mkv";

            string expected = "the.chilling.adventures.of.sabrina";

            Assert.Equal(expected, comparer.ExtractSeriesNameFromFilename(fileName));
        }
Esempio n. 4
0
        public void ExtractSeasonNumberFromFilename_ReturnsSeason()
        {
            TitleComparer comparer = new TitleComparer();
            string        fileName = @"the.chilling.adventures.of.sabrina.s01e07.720p.webrip.hevc.x265.rmteam.mkv";

            int expected = 1;

            Assert.Equal(expected, comparer.ExtractSeasonNumberFromFilename(fileName));
        }
Esempio n. 5
0
        public void ExtractSeasonEpisodeFromFilenameAsEpisodeObject_ContainsSeasonEpisode_ReturnsEpObject()
        {
            TitleComparer comparer = new TitleComparer();
            string        fileName = @"the.chilling.adventures.of.sabrina.s01e07.720p.webrip.hevc.x265.rmteam.mkv";

            int expectedSeason  = 1;
            int expectedEpisode = 7;

            Assert.Equal(expectedSeason, comparer.ExtractSeasonEpisodeFromFilenameAsEpisodeObject(fileName).SeasonNumber);
            Assert.Equal(expectedEpisode, comparer.ExtractSeasonEpisodeFromFilenameAsEpisodeObject(fileName).EpisodeNumberInSeason);
        }
Esempio n. 6
0
        public void ExtractSeasonEpisodeFromFilenameAsEpisodeObject_ContainsCapitalSeasonEpisode_ReturnsEpObject()
        {
            TitleComparer comparer = new TitleComparer();
            string        fileName = @"Succession.S01E03.BDRip.X264-REWARD.mkv";

            int expectedSeason  = 1;
            int expectedEpisode = 3;

            Assert.Equal(expectedSeason, comparer.ExtractSeasonEpisodeFromFilenameAsEpisodeObject(fileName).SeasonNumber);
            Assert.Equal(expectedEpisode, comparer.ExtractSeasonEpisodeFromFilenameAsEpisodeObject(fileName).EpisodeNumberInSeason);
        }
Esempio n. 7
0
            public static int CompareComic(Comic x, Comic y)
            {
                var result = string.Compare(x.Author.ToLowerInvariant(), y.Author.ToLowerInvariant(), StringComparison.OrdinalIgnoreCase);

                if (result != 0)
                {
                    return(result);
                }

                return(TitleComparer.CompareComic(x, y));
            }
Esempio n. 8
0
        public void ExtractSeasonEpisodeFromFilenameAsEpisodeObject_ContainsEpisode00_ReturnsEpObject()
        {
            TitleComparer comparer = new TitleComparer();
            string        fileName = @"doctor.who.2005.s12e00.resolution.720p.webrip.hevc.x265.rmteam.mkv";

            int expectedSeason  = 12;
            int expectedEpisode = 0;

            Assert.Equal(expectedSeason, comparer.ExtractSeasonEpisodeFromFilenameAsEpisodeObject(fileName).SeasonNumber);
            Assert.Equal(expectedEpisode, comparer.ExtractSeasonEpisodeFromFilenameAsEpisodeObject(fileName).EpisodeNumberInSeason);
        }
Esempio n. 9
0
        public void ExtractSeasonEpisodeFromFilenameAsEpisodeObject_DoesNotContainSeasonEpisode_ReturnsNull()
        {
            TitleComparer comparer        = new TitleComparer();
            string        fileName        = @"the.chilling.adventures.of.sabrina.mkv";
            string        expectedMessage = $"Filename does not contain episode number in s##e## format.\r\nParameter name:{fileName}";

            // Act & Assert
            // Exception ex = Assert.Throws<ArgumentException>(() => comparer.ExtractSeasonEpisodeFromFilenameAsEpisodeObject(fileName));
            // Assert.Equal(expectedMessage.Substring(0,50), ex.Message.Substring(0,50));

            Assert.Null(comparer.ExtractSeasonEpisodeFromFilenameAsEpisodeObject(fileName));
        }
    public FranchiseEntryTitleComparer(
        CultureInfo culture,
        NullComparison nullComparison = NullComparison.NullsFirst)
        : base(nullComparison)
    {
        this.titleComparer = new TitleComparer(culture);

        this.baseComparer = ComparerBuilder.For <FranchiseEntry>()
                            .OrderBy(this.GetTitleName, this.titleComparer)
                            .ThenBy(entry => entry.GetStartYear())
                            .ThenBy(entry => entry.GetEndYear());
    }
Esempio n. 11
0
        public void FilenameContainsSeriesName_DoesNotContainSeriesName_ReturnsFalse()
        {
            TitleComparer          comparer      = new TitleComparer();
            EpisodeForComparingDto episodeObject = new EpisodeForComparingDto()
            {
                SeriesName            = "The Chilling Adventures of Sabrina",
                SeasonNumber          = 1,
                EpisodeNumberInSeason = 4,
                EpisodeTitle          = "Witch Academy"
            };
            string fileName = @"doctor.who.2005.s11e10.the.battle.of.ranskoor.av.kolos.720p.web.dl.hevc.x265.rmteam.mkv";

            Assert.False(comparer.FilenameContainsSeriesName(episodeObject, fileName));
        }
Esempio n. 12
0
        public void FilenameContainsSeriesName_ContainsSeriesName_ReturnsTrue()
        {
            TitleComparer          comparer      = new TitleComparer();
            EpisodeForComparingDto episodeObject = new EpisodeForComparingDto()
            {
                SeriesName            = "The Chilling Adventures of Sabrina",
                SeasonNumber          = 1,
                EpisodeNumberInSeason = 4,
                EpisodeTitle          = "Witch Academy"
            };
            string fileName = @"the.chilling.adventures.of.sabrina.s01e04.720p.webrip.hevc.x265.rmteam.mkv";

            Assert.True(comparer.FilenameContainsSeriesName(episodeObject, fileName));
        }
Esempio n. 13
0
        public void GetSeasonEpisodeInNumberFormat_Valid_ReturnTrue()
        {
            EpisodeForComparingDto episodeObject = new EpisodeForComparingDto()
            {
                SeriesName            = "The Orville",
                SeasonNumber          = 2,
                EpisodeNumberInSeason = 9,
                EpisodeTitle          = "Identity, Part 2"
            };
            TitleComparer comparer = new TitleComparer();
            string        expected = "2.09";

            Assert.Equal(expected, comparer.GetSeasonEpisodeInNumberFormat(episodeObject));
        }
Esempio n. 14
0
        static void Main(string[] args)
        {
            List <Book> books = Book.InitBooks();

            ShowBooks(books);

            // Sort the books by title
            // TitleComparer does a compare on BookTitle
            // We gain the compare on Book by contravariance
            // Only valid in .NET 4.0!
            TitleComparer comp = new TitleComparer();

            books.Sort(comp);
            ShowBooks(books);
        }
Esempio n. 15
0
        public void CreateEpisodeObjectFromFilename_ValidFile_CreatesObject()
        {
            TitleComparer comparer = new TitleComparer();
            string        fileName = @"the.chilling.adventures.of.sabrina.s01e07.720p.webrip.hevc.x265.rmteam.mkv";

            int    expectedSeason  = 1;
            int    expectedEpisode = 7;
            string expectedTitle   = "the chilling adventures of sabrina";

            EpisodeForComparingDto epDto = comparer.CreateEpisodeObjectFromFilename(fileName);

            Assert.Equal(expectedSeason, epDto.SeasonNumber);
            Assert.Equal(expectedEpisode, epDto.EpisodeNumberInSeason);
            Assert.Equal(expectedTitle, epDto.SeriesName);
        }
Esempio n. 16
0
        public void GetSeriesNameInLowercaseAndPeriodsWithoutStartingArticle_ReturnsTrue()
        {
            TitleComparer          comparer      = new TitleComparer();
            EpisodeForComparingDto episodeObject = new EpisodeForComparingDto()
            {
                SeriesName            = "The Chilling Adventures of Sabrina",
                SeasonNumber          = 1,
                EpisodeNumberInSeason = 4,
                EpisodeTitle          = "Witch Academy"
            };
            string expected = "chilling.adventures.of.sabrina";

            string result = comparer.GetSeriesNameInLowercaseAndPeriodsWithoutStartingArticle(episodeObject);

            Assert.Equal(expected, result);
        }
Esempio n. 17
0
        public void ContainsSeasonEpisode_DoesContain_ReturnTrue()
        {
            EpisodeForComparingDto episodeObject = new EpisodeForComparingDto()
            {
                SeriesName            = "Counterpart",
                SeasonNumber          = 2,
                EpisodeNumberInSeason = 9,
                EpisodeTitle          = "You to You"
            };
            string fileName = @"counterpart.s02e09.you.to.you.720p.webrip.hevc.x265.rmteam.mkv";
            bool   expected = true;

            TitleComparer comparer = new TitleComparer();
            bool          result   = comparer.FilenameContainsSeasonEpisode(episodeObject, fileName);

            Assert.Equal(expected, result);
        }
    public ListItemTitleComparer(
        CultureInfo culture,
        IComparer <ListItem> otherComparer,
        Func <ListItem, string> getTitle,
        Func <Franchise, string> getFranchiseTitle,
        NullComparison nullComparison = NullComparison.NullsFirst)
        : base(nullComparison)
    {
        this.getTitle          = getTitle;
        this.getFranchiseTitle = getFranchiseTitle;

        this.titleComparer         = new TitleComparer(culture);
        this.otherComparer         = otherComparer;
        this.titleAndOtherComparer = ComparerBuilder.For <ListItem>()
                                     .OrderBy(this.getTitle, this.titleComparer)
                                     .ThenBy(otherComparer);
    }
Esempio n. 19
0
        public ActionResult Index()
        {
            List <Book> books = new List <Book>(db.Books);

            string sorting = Request.Cookies["sorting"]?.Value ?? String.Empty;

            if (sorting.Equals("byName"))
            {
                TitleComparer titleComparer = new TitleComparer();
                books.Sort(titleComparer);
            }
            else if (sorting.Equals("byYear"))
            {
                YearComparer yearComparer = new YearComparer();
                books.Sort(yearComparer);
            }

            ViewBag.Books = books;

            return(View());
        }
Esempio n. 20
0
        public static MalAnime SearchListForShow(string username, string title)
        {
            // Clean out any accented characters from the show title
            var tempBytes = System.Text.Encoding.GetEncoding("ISO-8859-8").GetBytes(title);

            title = System.Text.Encoding.UTF8.GetString(tempBytes);

            var searchRequest = WebRequest.Create(string.Format(MalListUrl, username)) as HttpWebRequest;

            searchRequest.Method = "GET";

            var searchResponse = (HttpWebResponse)searchRequest.GetResponse();

            string animeList = string.Empty;

            using (var reader = new System.IO.StreamReader(searchResponse.GetResponseStream(), ASCIIEncoding.ASCII))
            {
                // this is XML
                animeList = reader.ReadToEnd();
            }

            var responseAsXml = new XmlDocument();

            responseAsXml.LoadXml(animeList);
            var responseAsJson = JsonConvert.SerializeXmlNode(responseAsXml.GetElementsByTagName("myanimelist")[0]);
            var malList        = JsonConvert.DeserializeObject <MyAnimeList>(responseAsJson);

            var currentlyWatching = from show in malList.AnimeList.AllAnime
                                    where show.MyStatus == MalStatus.Watching
                                    select show;

            MalAnime currentShow = new MalAnime();

            try
            {
                currentShow = (from show in currentlyWatching
                               where (TitleComparer.Compute(show.Title, title) < 5 || show.Title.ToLower().Contains(title.ToLower()))
                               select show).First();
            }
            catch
            {
                //Usually the title from Plex is the English title and not the default Japanese title. Check the Synonyms.

                foreach (var show in currentlyWatching)
                {
                    foreach (var altTitle in show.Synonyms.Replace("; ", ";").ToLower().Split(';'))
                    {
                        currentShow = (altTitle.Contains(title.ToLower())) ? show : null;
                        if (currentShow != null)
                        {
                            break;
                        }
                    }

                    if (currentShow != null)
                    {
                        break;
                    }
                }

                if (currentShow == null)
                {
                    // Last resort, split the show by spaces and try to find a word
                    try
                    {
                        foreach (var word in title.Split(' '))
                        {
                            var showByWord = (from show in currentlyWatching
                                              where show.Title.Contains(word)
                                              select show);

                            if (showByWord.Any())
                            {
                                currentShow = showByWord.First();
                                break;
                            }
                        }
                    }
                    catch (Exception ex)
                    {
                        Logger.CreateLogEntry(LogType.Error, ex, DateTime.Now);
                        currentShow = null;
                    }
                }
            }

            if (string.IsNullOrEmpty(currentShow.Title))
            {
                Logger.CreateLogEntry(LogType.Error, "MAL Search was not successful.", DateTime.Now);
                throw new Exception("MAL show was not found successfully.");
            }

            Logger.CreateLogEntry(LogType.Success, $"MAL API search was successful for {title}. ID: {currentShow.Id} | Total Episodes: {currentShow.Episodes}", DateTime.Now);

            return(currentShow);
        }
Esempio n. 21
0
 public bool Equals(string title)
 {
     return(TitleComparer.Equals(Title, title));
 }
Esempio n. 22
0
        public static async Task <bool> UpdateListAsync(RegisterValues values, PlexRequest plexRequest)
        {
            var entries = await GetListForUser(values.UserName);

            var title = plexRequest.Metadata.GrandparentTitle;

            AniListAnime currentShow = new AniListAnime();

            try
            {
                currentShow = entries.Entries
                              .Where(x => TitleComparer.Compute(x.MediaItem.Title.UserPreferred, title) < 5 ||
                                     x.MediaItem.Title.UserPreferred.ToLower().Contains(title.ToLower())).First();
            }
            catch
            {
                try
                {
                    currentShow = entries.Entries.Select(x => x)
                                  .OrderByDescending(x => TitleComparer.Compute(x.MediaItem.Title.UserPreferred.ToLower(), title.ToLower()))
                                  .First();
                }
                catch (Exception ex)
                {
                    Logger.CreateLogEntry(LogType.Error, ex, DateTime.Now);
                    currentShow = null;
                }
            }

            if (currentShow == null)
            {
                return(false);
            }

            var query = FormUpdateQuery(currentShow.EntryId, currentShow.MediaItem.Id, plexRequest.Metadata.Index);

            var            token   = values.AniListAccessToken;
            HttpWebRequest request = WebRequest.Create(BaseUrl + query) as HttpWebRequest;

            request.Method = "POST";
            request.Headers["Authorization"] = "Bearer " + token;

            AniListSearchResponse aniListResponse;

            try
            {
                var response = (HttpWebResponse)await request.GetResponseAsync();

                using (var reader = new StreamReader(response.GetResponseStream(), Encoding.ASCII))
                {
                    var aniListResponseString = reader.ReadToEnd();
                    aniListResponse = JsonConvert.DeserializeObject <AniListSearchResponse>(aniListResponseString);
                }
            }
            catch (Exception ex)
            {
                return(false);
            }

            return(true);
        }