/// <summary> /// Gets a page of videos for a search query. /// </summary> public override async Task <SearchVideosResponse> SearchVideos(SearchVideosRequest request, ServerCallContext context) { // 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\\\"}" + request.Query + "\" }"; PreparedStatement prepared = await _statementCache.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) .SetConsistencyLevel(ConsistencyLevel.LocalOne) // Search queries only support One / LocalOne .SetAutoPage(false) .SetPageSize(request.PageSize); // The initial query won't have a paging state, but subsequent calls should if there are more pages if (string.IsNullOrEmpty(request.PagingState) == false) { bound.SetPagingState(Convert.FromBase64String(request.PagingState)); } RowSet rows = await _session.ExecuteAsync(bound).ConfigureAwait(false); var response = new SearchVideosResponse { Query = request.Query, PagingState = rows.PagingState != null && rows.PagingState.Length > 0 ? Convert.ToBase64String(rows.PagingState) : "" }; response.Videos.Add(rows.Select(MapRowToVideoPreview)); return(response); }
/// <summary> /// Gets a page of videos for a search query (looks for videos with that tag). /// </summary> public override async Task <SearchVideosResponse> SearchVideos(SearchVideosRequest request, ServerCallContext context) { // Use the driver's built-in paging feature to get only a page of rows PreparedStatement preparedStatement = await _statementCache.GetOrAddAsync("SELECT * FROM videos_by_tag WHERE tag = ?"); IStatement boundStatement = preparedStatement.Bind(request.Query) .SetAutoPage(false) .SetPageSize(request.PageSize); // The initial query won't have a paging state, but subsequent calls should if there are more pages if (string.IsNullOrEmpty(request.PagingState) == false) { boundStatement.SetPagingState(Convert.FromBase64String(request.PagingState)); } RowSet rows = await _session.ExecuteAsync(boundStatement).ConfigureAwait(false); var response = new SearchVideosResponse { Query = request.Query, PagingState = rows.PagingState != null && rows.PagingState.Length > 0 ? Convert.ToBase64String(rows.PagingState) : "" }; response.Videos.Add(rows.Select(MapRowToVideoPreview)); return(response); }