Пример #1
0
        public HashSet <TableInfo> getTable(string db, string sqlPlace, string sqlReview, List <string> APIList)
        {
            TripDB            tripdb = new TripDB();
            SentimentAnalysis sent   = new SentimentAnalysis();

            HashSet <TableInfo> result   = new HashSet <TableInfo>();
            HashSet <Places>    placeSet = tripdb.getPlaces(db, sqlPlace);

            Parallel.ForEach(placeSet, place =>
            {
                string id = place.Id.ToString();
                HashSet <Review> reviewSet = tripdb.getReviews(db, sqlReview, place.Id);
                double note = 0;
                int counter = 0;
                foreach (Review review in reviewSet)
                {
                    if (APIList.Count > 0)
                    {
                        note += sent.getSentiment(review.Reviewstr, APIList);
                        counter++;
                    }
                    else
                    {
                        break;
                    }
                }
                double moyenne = note / counter;
                TableInfo temp = new TableInfo();
                temp.Note      = moyenne;
                temp.Latitude  = place.Latitude;
                temp.Longitude = place.Longitude;
                result.Add(temp);
            });
            return(result);
        }
Пример #2
0
        private void avgTest()
        {
            string cs      = @"server=localhost;userid=root;password=;database=traitement";
            string sqlAvg  = "SELECT AVG(note) FROM tripreviewsamst WHERE idplace =";
            int    idplace = 239469;
            TripDB trip    = new TripDB();
            double avgTest = trip.getAVG(cs, sqlAvg, idplace);

            textBlock.Text = avgTest.ToString();
        }
Пример #3
0
        public HashSet <TableInfo> getTable(string db, string sqlPlace, string sqlAvg)
        {
            TripDB tripdb = new TripDB();

            HashSet <TableInfo> result   = new HashSet <TableInfo>();
            HashSet <Places>    placeSet = tripdb.getPlaces(db, sqlPlace);

            Parallel.ForEach(placeSet, place =>
            {
                double avg     = tripdb.getAVG(db, sqlAvg, place.Id);
                TableInfo temp = new TableInfo();
                temp.Note      = avg;
                temp.Latitude  = place.Latitude;
                temp.Longitude = place.Longitude;
                result.Add(temp);
            });
            return(result);
        }