public void Given_A_Date_Should_Be_Return_All_Date_With_Create_At_Before_Date()
{
var date = DateTime.Now.AddDays(5);
var videoQuery = _items.AsQueryable().Where(VideoQueries.GetAllBeforeDate(date));
Assert.True(videoQuery.Count() > 0);
}
public void Given_A_Date_Should_Be_Return_No_Data()
{
var date = DateTime.Now.Subtract(TimeSpan.FromDays(5));
var videoQuery = _items.AsQueryable().Where(VideoQueries.GetAllBeforeDate(date));
Assert.True(videoQuery.Count() == 0);
}
public void Should_Be_Get_By_Server_Id_And_Return_A_Zero_Count()
{
var serverIdFake = Guid.NewGuid();
var videoQuery = _items.AsQueryable().Where(VideoQueries.GetByServerId(serverIdFake));
Assert.True(videoQuery.Count() == 0);
}
public void Should_Be_Get_By_Server_Id_And_Return_A_Data()
{
var videoExcept = _items.FirstOrDefault();
var videoQuery = _items.AsQueryable().Where(VideoQueries.GetByServerId(videoExcept.ServerId));
Assert.True(videoQuery.Count() > 0);
}
public void Should_Be_Get_By_Server_Id_And_Video_Id_And_Return_A_Data()
{
var videoExcept = _items.FirstOrDefault();
var videoQuery = _items.AsQueryable().FirstOrDefault(VideoQueries.GetByServerIdAndVideoId(videoExcept.ServerId, videoExcept.Id));
Assert.True(videoExcept.Equals(videoQuery));
}
public void Should_Be_Get_By_Server_Id_And_Video_Id_And_Return_A_Null()
{
var serverIdFake = Guid.NewGuid();
var videoIdFake = Guid.NewGuid();
var videoQuery = _items.AsQueryable().FirstOrDefault(VideoQueries.GetByServerIdAndVideoId(serverIdFake, videoIdFake));
Assert.True(videoQuery == null);
}
public void ReturnsRecentVideos()
{
var options = DbContextMock.GetOptions("ReturnsRecentVideos");
using (var actContext = new BubaTubeDbContext(options))
{
actContext.Videos.AddRange(VideoMockData.GetApprovedVideos(10));
actContext.Videos.AddRange(VideoMockData.GetDeletedVideos(10));
actContext.SaveChanges();
var videoQueries = new VideoQueries(actContext, fakeDTOMapper, fakePreviewDTOMapper);
var resentVideos = videoQueries.MostResentVideos();
Assert.Equal(10, resentVideos.Count);
}
}
public IEnumerable <Video> GetAllBeforeDate(DateTime date)
{
return(_dataContext.Videos.AsTracking().Where(VideoQueries.GetAllBeforeDate(date)).ToList());
}
public Video GetByServerIdAndVideoId(Guid serverId, Guid videoId)
{
return(_dataContext.Videos.AsTracking().FirstOrDefault(VideoQueries.GetByServerIdAndVideoId(serverId, videoId)));
}
public IEnumerable <Video> GetByServerId(Guid serverId)
{
return(_dataContext.Videos.AsTracking().Where(VideoQueries.GetByServerId(serverId)));
}
