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); }