/// <summary>
/// Gets a page of videos for a search query.
/// </summary>
public async Task <VideosForSearchQuery> SearchVideos(SearchVideosQuery searchVideosQuery)
{
// Do a Solr query against DSE search to find videos using Solr's ExtendedDisMax query parser. Query the
// name, tags, and description fields in the videos table giving a boost to matches in the name and tags
// fields as opposed to the description field
// More info on ExtendedDisMax: http://wiki.apache.org/solr/ExtendedDisMax
string solrQuery = "{ \"q\": \"{!edismax qf=\\\"name^2 tags^1 description\\\"}" + searchVideosQuery.Query + "\" }";
PreparedStatement prepared = await _statementCache.NoContext.GetOrAddAsync(
"SELECT videoid, userid, name, preview_image_location, added_date FROM videos WHERE solr_query=?");
// The driver's built-in paging feature just works with DSE Search Solr paging which is pretty cool
IStatement bound = prepared.Bind(solrQuery)
.SetAutoPage(false)
.SetPageSize(searchVideosQuery.PageSize);
// The initial query won't have a paging state, but subsequent calls should if there are more pages
if (string.IsNullOrEmpty(searchVideosQuery.PagingState) == false)
{
bound.SetPagingState(Convert.FromBase64String(searchVideosQuery.PagingState));
}
RowSet rows = await _session.ExecuteAsync(bound).ConfigureAwait(false);
return(new VideosForSearchQuery
{
Query = searchVideosQuery.Query,
Videos = rows.Select(MapRowToVideoPreview).ToList(),
PagingState = rows.PagingState != null && rows.PagingState.Length > 0 ? Convert.ToBase64String(rows.PagingState) : null
});
}
public async Task SearchVideos_FromCacheEqualsTrue_DataFromApplicationDatabase()
{
// Arrange
string searchTerm = "oscar 2021";
var query = new SearchVideosQuery(searchTerm, true);
// Act
await fixture.Instance.Send(query);
// Assert
fixture.VideoRepositoryMock.Verify(m => m.SearchAsync(It.IsAny <string>()), Times.Once());
fixture.YoutubeApiClientMock.Verify(m => m.GetVideosAsync(searchTerm), Times.Never());
}
public async Task SearchVideos_FromCacheEqualsFalse_DataFromGoogleApi()
{
// Arrange
string searchTerm = "oscar 2020";
var query = new SearchVideosQuery(searchTerm, false);
// Act
await fixture.Instance.Send(query);
// Assert
fixture.VideoRepositoryMock.Verify(m => m.SearchAsync(It.IsAny <string>()), Times.Never());
fixture.YoutubeApiClientMock.Verify(m => m.GetVideosAsync(searchTerm), Times.Once());
fixture.VideoRepositoryMock.Verify(m => m.AddRangeAsync(It.IsAny <IEnumerable <Domain.Video> >()), Times.Once());
}
/// <summary>
/// Gets a page of videos for a search query (looks for videos with that tag).
/// </summary>
public async Task <VideosForSearchQuery> SearchVideos(SearchVideosQuery searchVideosQuery)
{
// Use the driver's built-in paging feature to get only a page of rows
PreparedStatement preparedStatement = await _statementCache.NoContext.GetOrAddAsync("SELECT * FROM videos_by_tag WHERE tag = ?");
IStatement boundStatement = preparedStatement.Bind(searchVideosQuery.Query)
.SetAutoPage(false)
.SetPageSize(searchVideosQuery.PageSize);
// The initial query won't have a paging state, but subsequent calls should if there are more pages
if (string.IsNullOrEmpty(searchVideosQuery.PagingState) == false)
{
boundStatement.SetPagingState(Convert.FromBase64String(searchVideosQuery.PagingState));
}
RowSet rows = await _session.ExecuteAsync(boundStatement).ConfigureAwait(false);
return(new VideosForSearchQuery
{
Query = searchVideosQuery.Query,
Videos = rows.Select(MapRowToVideoPreview).ToList(),
PagingState = rows.PagingState != null && rows.PagingState.Length > 0 ? Convert.ToBase64String(rows.PagingState) : null
});
}
