private static void CalculateVarianceForAllMovies()
{
var conn = new VarianceConnection(VariancePath);
var calculator = new VarianceCalculator(ReviewPath);
var movieConn = new MovieDatabaseLayer(MoviePath);
var movies = movieConn.GetAllMovies().ToArray();
Console.WriteLine("Calculating {0} variances", movies.Count());
Parallel.ForEach(movies, m =>
{
var sw = new Stopwatch();
sw.Start();
var variance = calculator.VarianceForMovie(m.Id);
sw.Stop();
var calculTime = sw.ElapsedMilliseconds;
sw = new Stopwatch();
sw.Start();
conn.Save(variance);
sw.Stop();
Console.WriteLine("{0} ({1}) : {2} (calculated in {3}ms, saved in {4}ms)", m.Title, m.Id, variance.Var, calculTime, sw.ElapsedMilliseconds);
});
}
public void GetCommonMovies()
{
_reviewConnection = new ReviewDatabaseLayer <Review> (ReviewPath);
_movieConnection = new MovieDatabaseLayer(MoviePath);
while (true)
{
// var id1 = GetUser (1);
// var id2 = GetUser (2);
var id1 = 387418;
var id2 = 1008749;
// var sw = new Stopwatch ();
// sw.Start ();
//var movies = _reviewConnection.GetCommonMovies (id1, id2).ToArray ();
var movies = _reviewConnection.GetCommonMovies(id1, id2);
//sw.Stop ();
var moviesWithTitle = movies.Select(r => new { Title = _movieConnection.GetMovie(r.Item1.MovieId).Title, Id = r.Item1.MovieId });
// Console.WriteLine ("Found {0} common movies in {1}ms", movies.Count (), sw.ElapsedMilliseconds);
foreach (var movie in moviesWithTitle)
{
Console.WriteLine(" - {0} ({1})", movie.Title, movie.Id);
}
Console.ReadLine();
}
}
public MovieMeanCalculator(string reviewPath, string moviePath, string meanPath)
{
_reviewConnection = new ReviewDatabaseLayer <Review> (reviewPath);
_movieConnection = new MovieDatabaseLayer(moviePath);
_meanConnection = new MovieMeanConnection(meanPath);
}
