Exemple #1
0
        protected SqliteCommand GetUpdateSeriesSequenceCommand(SqliteConnection db, SeriesSequence sequence, string idColumn, object idValue)
        {
            var command = new SqliteCommand($"UPDATE series_sequence SET is_season = {sequence.IsSeason}, season_number = {sequence.SeasonNumber} WHERE {idColumn} = @UniqueId", db);

            command.Parameters.AddWithValue("@UniqueId", idValue);
            return(command);
        }
        public void UpsertSeriesSequences_ShouldInsertNewItems()
        {
            var sequences = new List <ExportedSeriesSequenceSimpleDto>();

            for (int i = 0; i < 3; ++i)
            {
                var s = new SeriesSequence(-1, "t" + i, "", -1, false, false, 0, testSeries.SeriesId, UniqueIdUtil.GenerateUniqueId());
                sequences.Add(new ExportedSeriesSequenceSimpleDto(s, null, testSeries.UniqueId));
            }

            var ids = new Dictionary <string, long>();

            repository.UpsertSeriesSequences(sequences, ids);

            var retSequences = repository.GetVideoSequencesInSeries(testSeries.SeriesId, GetFirstPage()).Result.Results;
            var expectedIds  = new Dictionary <string, long>();

            foreach (var s in retSequences)
            {
                expectedIds[s.UniqueId] = s.SequenceId;
            }

            var expectedSequences = sequences.Select(p => p.Details).ToList();

            CollectionAssert.AreEquivalent(expectedSequences, retSequences);
            CollectionAssert.AreEquivalent(expectedIds, ids);
        }
        public async Task <PaginationResult <Video> > GetVideosNotInSeriesSequence(SeriesSequence sequence, long seriesId, string titleFilter, Pagination pagination)
        {
            var videosToExcludeQuery = sequence.IsSeason ?
                                       ($"SELECT vs.video_id FROM video_in_sequence vs, series_sequence ss WHERE vs.sequence_id = ss.sequence_id AND ss.series_id = {seriesId} AND ss.is_season = true AND ss.deleted = false") :
                                       ($"SELECT vs.video_id FROM video_in_sequence vs WHERE vs.sequence_id = {sequence.SequenceId}");
            var query = $"{SELECT_BASE} WHERE v.deleted = false AND v.title LIKE @TitleFilter AND v.series_id = {seriesId} AND v.video_id NOT IN ({videosToExcludeQuery})";
            Action <SqliteCommand> parameterize = (SqliteCommand command) => {
                command.Parameters.AddWithValue("@TitleFilter", "%" + titleFilter + "%");
            };

            return(await DataAccessUtil.GetPaginatedResult(pagination, query, parameterize, ParseVideo));
        }
Exemple #4
0
 public ExportedSeriesSequenceSimpleDto(SeriesSequence details, string fileId, string seriesId)
 {
     Details  = details;
     FileId   = fileId;
     SeriesId = seriesId;
 }