/// <summary>
/// Retrieves a vod from the database based on the game and search terms provided. This will be the
/// "default" method to avoid leaning on the YouTube API quota too hard.
/// </summary>
/// <param name="gameName">The name of the desired game</param>
/// <param name="searchTerms">A POCO that will hold either a character name, player name, or both</param>
/// <returns>A singular <see cref="YouTubeVideo"/> randomly chosen from the search results</returns>
private async Task <YouTubeVideo> GetVodFromDatabase(FightingGameName gameName, VodSearchTerms searchTerms)
{
Expression <Func <FightingGameVod, bool> > filterAsFunc = (vod) => false;
filterAsFunc = GenerateFilterExpression(searchTerms, filterAsFunc);
var databaseResults = await _fightingGameVodRepository.FindAsync(filterAsFunc) as List <FightingGameVod>;
var randomSelectedVod = databaseResults[_rnd.Next(databaseResults.Count)];
return(new YouTubeVideo {
Title = randomSelectedVod.OriginalTitle, Id = randomSelectedVod.VideoId
});
// Builds the LINQ expression used to comb the database for the desired vod
Expression <Func <FightingGameVod, bool> > GenerateFilterExpression(VodSearchTerms searchTerms, Expression <Func <FightingGameVod, bool> > filterAsFunc)
{
if (SearchTermsJustHasCharacter(searchTerms))
{
filterAsFunc = vod => (vod.CharacterP1.ToLower() == searchTerms.Character.ToLower() || vod.CharacterP2.ToLower() == searchTerms.Character.ToLower()) && (vod.GameName == gameName);
}
else if (SearchTermsJustHasPlayer(searchTerms))
{
filterAsFunc = vod => (vod.Player1.ToLower() == searchTerms.Player.ToLower() || vod.Player2.ToLower() == searchTerms.Player.ToLower()) && (vod.GameName == gameName);
}
else
{
filterAsFunc = vod => ((vod.CharacterP1.ToLower() == searchTerms.Character.ToLower() || vod.CharacterP2.ToLower() == searchTerms.Character.ToLower()) && (vod.Player1.ToLower() == searchTerms.Player.ToLower() || vod.Player2.ToLower() == searchTerms.Player.ToLower())) && (vod.GameName == gameName);
}
return(filterAsFunc);
}
}
/// <summary>
/// Retrieve a vod based on the provided game and search terms.
/// </summary>
/// <param name="game">The enum parsed and sent from the command module</param>
/// <param name="searchTerms">Either the character, the player, or both terms to filter on</param>
/// <param name="getNewClips">If true, will pull videos from the YouTube API and populate the database</param>
/// <returns>A random vod from the filtered results</returns>
public async Task <YouTubeVideo> GetVodFor(FightingGameName game, VodSearchTerms searchTerms, bool getNewClips = false)
{
if (getNewClips)
{
return(await GetVodFromYouTubeApi(game, searchTerms));
}
else
{
return(await GetVodFromDatabase(game, searchTerms));
}
}
/// <summary>
/// If requested by the user, will hit the YouTube API to search for a vod and return it to the end user.
/// This method will incur a performance hit as not only will it hit the API, but it will upload the results
/// to the vod database.
/// </summary>
/// <param name="gameName">The name of the desired game</param>
/// <param name="searchTerms">A POCO that will hold either a character name, player name, or both</param>
/// <returns>A singular <see cref="YouTubeVideo"/> randomly chosen from the search results</returns>
private async Task <YouTubeVideo> GetVodFromYouTubeApi(FightingGameName gameName, VodSearchTerms searchTerms)
{
var vods = await GetSpecifiedVodsAsync(gameName, searchTerms);
List <FightingGameVod> vodsToStoreInDatabase = new();
foreach (var vod in vods)
{
var fgVod = CreateFightingGameVodObj(vod);
vodsToStoreInDatabase.Add(fgVod);
}
await _fightingGameVodRepository.AddRangeAsync(vodsToStoreInDatabase);
await _fightingGameVodRepository.SaveChangesAsync();
return(vods[_rnd.Next(vods.Count)]);
}
/// <summary>
/// Gets a vod for a specific game, and if provided, a filter for getting either
/// vods for a certain player, character, or both
/// </summary>
/// <param name="game">The game to look up</param>
/// <param name="filter">An object containing named parameters for the command</param>
//[Command("vod")]
public async Task GetVod(string game, VodFilter filter)
{
var searchTerms = new VodSearchTerms {
Character = filter.Character, Player = filter.Player
};
YouTubeVideo vod = null;
try
{
FightingGameName gameName = GetFullGameName(game);
vod = await vodSearchEngine.GetVodFor(gameName, searchTerms, filter.GetNewClips);
}
catch (InvalidOperationException invalidOpEx)
{
await ReplyAsync(invalidOpEx.Message);
}
await ReplyAsync((vod != null)?vod.GetVideoUrl() : CouldNotFindVod);
}
/// <summary>
/// Retrieves a list of vods from a randomly chosen vod channel based on the provided game and
/// search terms
/// </summary>
/// <param name="gameName">An enum representing the desired game</param>
/// <param name="searchTerms">A POCO that will hold either a character name, player name, or both</param>
/// <returns>A list of <see cref="YouTubeVideo"/> objects representing vods, filtered by the <see cref="VodSearchTerms"/> object</returns>
private async Task <List <YouTubeVideo> > GetSpecifiedVodsAsync(FightingGameName fgName, VodSearchTerms searchTerms)
{
List <YouTubeVideo> vods;
var vodChannelsForSpecifiedGame = _ushioConstants.VodChannels.Where(ch => Enum.Parse <FightingGameName>(ch.GetEnumFromGame()) == fgName).ToList();
var channel = vodChannelsForSpecifiedGame[_rnd.Next(vodChannelsForSpecifiedGame.Count)];
Regex vodRegex = GenerateSearchRegexForChannel(channel.Name, searchTerms);
var channelItems = await _youTubeApiService.GetVideosFromPlaylistAsync(vodRegex, channel.Id);
vods = channelItems.Select(y => new YouTubeVideo
{
Title = y.Snippet.Title,
Id = y.Snippet.ResourceId.VideoId,
SourceChannel = channel.Name,
GameName = fgName,
DateUploaded = new DateTimeOffset(y.ContentDetails.VideoPublishedAt.Value)
}).ToList();
return(vods);
}
