using System.Text.Json;
using System.Text.Json.Serialization;
using tasks.Databases;
namespace tasks;
///
/// Here you should implement various database query methods for the IMovieDatabase interface.
///
public static class DatabaseQueries
{
public static void RunQueries(this IMovieDatabase movieDatabase)
{
movieDatabase.ActorsFromFantasyMovies();
movieDatabase.LongestMovieByGenre();
movieDatabase.HighRatedMoviesWithCast();
movieDatabase.DistinctRolesCountPerActor();
movieDatabase.RecentMoviesWithAverageRating();
movieDatabase.AverageRatingByGenre();
movieDatabase.ActorsWhoNeverPlayedInThriller();
movieDatabase.Top3MoviesByRatingCount();
movieDatabase.MoviesWithoutRatings();
movieDatabase.MostVersatileActors();
}
public static void ActorsFromFantasyMovies(this IMovieDatabase movieDatabase)
{
var movies = movieDatabase.Movies;
var actors = movieDatabase.Actors;
var ratings = movieDatabase.Ratings;
var casts = movieDatabase.Casts;
var queryResult = new object();
Console.WriteLine("Actors From Fantasy Movies");
DisplayQueryResults(queryResult);
Console.WriteLine();
}
public static void LongestMovieByGenre(this IMovieDatabase movieDatabase)
{
var movies = movieDatabase.Movies;
var actors = movieDatabase.Actors;
var ratings = movieDatabase.Ratings;
var casts = movieDatabase.Casts;
var queryResult = new object();
Console.WriteLine("Longest Movie By Genre");
DisplayQueryResults(queryResult);
Console.WriteLine();
}
public static void HighRatedMoviesWithCast(this IMovieDatabase movieDatabase)
{
var movies = movieDatabase.Movies;
var actors = movieDatabase.Actors;
var ratings = movieDatabase.Ratings;
var casts = movieDatabase.Casts;
var queryResult = new object();
Console.WriteLine("High Rated Movies With Cast");
DisplayQueryResults(queryResult);
Console.WriteLine();
}
public static void DistinctRolesCountPerActor(this IMovieDatabase movieDatabase)
{
var movies = movieDatabase.Movies;
var actors = movieDatabase.Actors;
var ratings = movieDatabase.Ratings;
var casts = movieDatabase.Casts;
var queryResult = new object();
Console.WriteLine("Distinct Roles Count Per Actor");
DisplayQueryResults(queryResult);
Console.WriteLine();
}
public static void RecentMoviesWithAverageRating(this IMovieDatabase movieDatabase)
{
var movies = movieDatabase.Movies;
var actors = movieDatabase.Actors;
var ratings = movieDatabase.Ratings;
var casts = movieDatabase.Casts;
var queryResult = new object();
Console.WriteLine("Recent Movies With Average Rating");
DisplayQueryResults(queryResult);
Console.WriteLine();
}
public static void AverageRatingByGenre(this IMovieDatabase movieDatabase)
{
var movies = movieDatabase.Movies;
var actors = movieDatabase.Actors;
var ratings = movieDatabase.Ratings;
var casts = movieDatabase.Casts;
var queryResult = new object();
Console.WriteLine("Average Rating By Genre");
DisplayQueryResults(queryResult);
Console.WriteLine();
}
public static void ActorsWhoNeverPlayedInThriller(this IMovieDatabase movieDatabase)
{
var movies = movieDatabase.Movies;
var actors = movieDatabase.Actors;
var ratings = movieDatabase.Ratings;
var casts = movieDatabase.Casts;
var queryResult = new object();
Console.WriteLine("Actors Who Never Played In Thriller");
DisplayQueryResults(queryResult);
Console.WriteLine();
}
public static void Top3MoviesByRatingCount(this IMovieDatabase movieDatabase)
{
var movies = movieDatabase.Movies;
var actors = movieDatabase.Actors;
var ratings = movieDatabase.Ratings;
var casts = movieDatabase.Casts;
var queryResult = new object();
Console.WriteLine("Top 3 Movies By Rating Count");
DisplayQueryResults(queryResult);
Console.WriteLine();
}
public static void MoviesWithoutRatings(this IMovieDatabase movieDatabase)
{
var movies = movieDatabase.Movies;
var actors = movieDatabase.Actors;
var ratings = movieDatabase.Ratings;
var casts = movieDatabase.Casts;
var queryResult = new object();
Console.WriteLine("Movies Without Ratings");
DisplayQueryResults(queryResult);
Console.WriteLine();
}
public static void MostVersatileActors(this IMovieDatabase movieDatabase)
{
var movies = movieDatabase.Movies;
var actors = movieDatabase.Actors;
var ratings = movieDatabase.Ratings;
var casts = movieDatabase.Casts;
var queryResult = new object();
Console.WriteLine("Most Versatile Actors");
DisplayQueryResults(queryResult);
Console.WriteLine();
}
public static void DisplayQueryResults(T query)
{
var options = new JsonSerializerOptions
{
WriteIndented = true
};
options.Converters.Add(new JsonStringEnumConverter());
var json = JsonSerializer.Serialize(query, options);
Console.WriteLine(json);
}
}