コード例 #1
0
ファイル: DataTest.cs プロジェクト: auxua/Qurvey
        public void TestResultComputation()
        {
            Assert.IsNull(GetTestSurveyFromDb());

            Survey s = CreateTestSurvey();
            Survey s2 = CreateTestSurvey();
            s2.Question += "2";
            using (var db = new TestSurveyContext())
            {
                db.Surveys.Add(s);
                db.Surveys.Add(s2);
                db.SaveChanges();
                Vote v1 = new Vote(new User() { Code = "User1", Created = DateTime.Now }, s, s.Answers.ElementAt(0));
                db.Votes.Add(v1);
                Vote v2 = new Vote(new User() { Code = "User2", Created = DateTime.Now }, s, s.Answers.ElementAt(2));
                db.Votes.Add(v2);
                Vote v3 = new Vote(new User() { Code = "User3", Created = DateTime.Now }, s, s.Answers.ElementAt(0));
                db.Votes.Add(v3);
                Vote v4 = new Vote(new User() { Code = "User3", Created = DateTime.Now }, s2, s2.Answers.ElementAt(0));
                db.Votes.Add(v4);
                db.SaveChanges();
            }

            using (var db = new TestSurveyContext())
            {
                Result[] res = db.getResultsFor(s);
                Assert.IsNotNull(res);
                Assert.IsTrue(res.Length == 2);
                Assert.IsTrue(res[0].Answer.AnswerText == "Answer 1");
                Assert.IsTrue(res[0].Count == 2);
                Assert.IsTrue(res[1].Answer.AnswerText == "Answer 3");
                Assert.IsTrue(res[1].Count == 1);

                Vote[] votes = db.Votes.Where(v => v.Survey.Id == s.Id || v.Survey.Id == s2.Id).ToArray<Vote>();
                foreach (Vote v in votes)
                {
                    db.Votes.Remove(v);
                }
                db.SaveChanges();
            }

            using (var db = new TestSurveyContext())
            {
                db.Surveys.Attach(s);
                db.Surveys.Remove(s);
                db.Surveys.Attach(s2);
                db.Surveys.Remove(s2);
                db.SaveChanges();
            }
        }
コード例 #2
0
        public void TestSurveyData()
        {
            Assert.IsNull(GetTestSurveyFromDb());

            Survey survey = CreateTestSurvey();

            using (var db = new TestSurveyContext())
            {
                db.SaveSurvey(survey);
                db.SaveChanges();
            }

            using (var db = new TestSurveyContext())
            {
                Survey[] res = db.getSurveysFor("TEST");
                Assert.IsTrue(res.Length == 1);
            }

            Survey fromDb;

            using (var db = new TestSurveyContext())
            {
                fromDb = db.Surveys.Where(s => s.Question == Title).FirstOrDefault <Survey>();
                Assert.IsNotNull(fromDb);
                Assert.IsTrue(fromDb.Question == Title);
                Assert.IsTrue(fromDb.Answers.Count == 3);
                Assert.IsTrue(fromDb.Answers.Where <Answer>(a => a.AnswerText == "Answer 2").Count() == 1);

                db.DeleteSurvey(fromDb);
                db.SaveChanges();
            }

            Assert.IsNull(GetTestSurveyFromDb());
        }
コード例 #3
0
        public void TestUserGenSave()
        {
            User u = User.GenerateNewUser();

            using (var db = new TestSurveyContext())
            {
                db.SaveUser(u);
                db.SaveChanges();
            }
        }
コード例 #4
0
ファイル: DataTest.cs プロジェクト: auxua/Qurvey
 public void TestSavePanic()
 {
     User u = User.GenerateNewUser();
     Panic p = new Panic("testCourse", u);
     Panic p2 = new Panic("testCourse", u);
     using (var db = new TestSurveyContext())
     {
         db.SaveUser(u);
         db.SavePanic(p);
         db.SavePanic(p2);
         db.SaveChanges();
     }
 }
コード例 #5
0
        public void TestSavePanic()
        {
            User  u  = User.GenerateNewUser();
            Panic p  = new Panic("testCourse", u);
            Panic p2 = new Panic("testCourse", u);

            using (var db = new TestSurveyContext())
            {
                db.SaveUser(u);
                db.SavePanic(p);
                db.SavePanic(p2);
                db.SaveChanges();
            }
        }
コード例 #6
0
        public void TestVoteData()
        {
            Assert.IsNull(GetTestSurveyFromDb());
            Survey survey = CreateTestSurvey();

            using (var db = new TestSurveyContext())
            {
                db.SaveSurvey(survey);
                Vote v1 = new Vote(new User()
                {
                    Code = "User1", Created = DateTime.Now
                }, survey, survey.Answers.ElementAt(0));
                db.SaveVote(v1);
                Vote v2 = new Vote(new User()
                {
                    Code = "User2", Created = DateTime.Now
                }, survey, survey.Answers.ElementAt(2));
                db.SaveVote(v2);
                Vote v3 = new Vote(new User()
                {
                    Code = "User3", Created = DateTime.Now
                }, survey, survey.Answers.ElementAt(0));
                db.SaveVote(v3);
                db.SaveChanges();
            }

            using (var db = new TestSurveyContext())
            {
                db.Surveys.Attach(survey);
                var query = db.Votes.Where(v => v.Survey.Id == survey.Id);
                Assert.IsNotNull(query);
                Assert.IsTrue(query.Count() == 3);
                Assert.IsTrue(query.Where(v => v.User.Code == "User3").Count() == 1);

                foreach (Vote v in query)
                {
                    db.Votes.Remove(v);
                }
                db.Surveys.Remove(survey);
                db.SaveChanges();
            }

            Assert.IsNull(GetTestSurveyFromDb());
        }
コード例 #7
0
        public void TestResultComputation()
        {
            Assert.IsNull(GetTestSurveyFromDb());

            Survey s  = CreateTestSurvey();
            Survey s2 = CreateTestSurvey();

            s2.Question += "2";
            using (var db = new TestSurveyContext())
            {
                db.Surveys.Add(s);
                db.Surveys.Add(s2);
                db.SaveChanges();
                Vote v1 = new Vote(new User()
                {
                    Code = "User1", Created = DateTime.Now
                }, s, s.Answers.ElementAt(0));
                db.Votes.Add(v1);
                Vote v2 = new Vote(new User()
                {
                    Code = "User2", Created = DateTime.Now
                }, s, s.Answers.ElementAt(2));
                db.Votes.Add(v2);
                Vote v3 = new Vote(new User()
                {
                    Code = "User3", Created = DateTime.Now
                }, s, s.Answers.ElementAt(0));
                db.Votes.Add(v3);
                Vote v4 = new Vote(new User()
                {
                    Code = "User3", Created = DateTime.Now
                }, s2, s2.Answers.ElementAt(0));
                db.Votes.Add(v4);
                db.SaveChanges();
            }

            using (var db = new TestSurveyContext())
            {
                Result[] res = db.getResultsFor(s);
                Assert.IsNotNull(res);
                Assert.IsTrue(res.Length == 2);
                Assert.IsTrue(res[0].Answer.AnswerText == "Answer 1");
                Assert.IsTrue(res[0].Count == 2);
                Assert.IsTrue(res[1].Answer.AnswerText == "Answer 3");
                Assert.IsTrue(res[1].Count == 1);

                Vote[] votes = db.Votes.Where(v => v.Survey.Id == s.Id || v.Survey.Id == s2.Id).ToArray <Vote>();
                foreach (Vote v in votes)
                {
                    db.Votes.Remove(v);
                }
                db.SaveChanges();
            }

            using (var db = new TestSurveyContext())
            {
                db.Surveys.Attach(s);
                db.Surveys.Remove(s);
                db.Surveys.Attach(s2);
                db.Surveys.Remove(s2);
                db.SaveChanges();
            }
        }
コード例 #8
0
ファイル: DataTest.cs プロジェクト: auxua/Qurvey
        public void TestSurveyData()
        {
            Assert.IsNull(GetTestSurveyFromDb());

            Survey survey = CreateTestSurvey();
            using (var db = new TestSurveyContext())
            {
                db.SaveSurvey(survey);
                db.SaveChanges();
            }

            using (var db = new TestSurveyContext())
            {
                Survey[] res = db.getSurveysFor("TEST");
                Assert.IsTrue(res.Length == 1);
            }

            Survey fromDb;
            using (var db = new TestSurveyContext())
            {
                fromDb = db.Surveys.Where(s => s.Question == Title).FirstOrDefault<Survey>();
                Assert.IsNotNull(fromDb);
                Assert.IsTrue(fromDb.Question == Title);
                Assert.IsTrue(fromDb.Answers.Count == 3);
                Assert.IsTrue(fromDb.Answers.Where<Answer>(a => a.AnswerText == "Answer 2").Count() == 1);

                db.DeleteSurvey(fromDb);
                db.SaveChanges();
            }

            Assert.IsNull(GetTestSurveyFromDb());
        }
コード例 #9
0
ファイル: DataTest.cs プロジェクト: auxua/Qurvey
        public void TestVoteData()
        {
            Assert.IsNull(GetTestSurveyFromDb());
            Survey survey = CreateTestSurvey();
            using (var db = new TestSurveyContext())
            {
                db.SaveSurvey(survey);
                Vote v1 = new Vote(new User() { Code = "User1", Created = DateTime.Now }, survey, survey.Answers.ElementAt(0));
                db.SaveVote(v1);
                Vote v2 = new Vote(new User() { Code = "User2", Created = DateTime.Now }, survey, survey.Answers.ElementAt(2));
                db.SaveVote(v2);
                Vote v3 = new Vote(new User() { Code = "User3", Created = DateTime.Now }, survey, survey.Answers.ElementAt(0));
                db.SaveVote(v3);
                db.SaveChanges();
            }

            using (var db = new TestSurveyContext())
            {
                db.Surveys.Attach(survey);
                var query = db.Votes.Where(v => v.Survey.Id == survey.Id);
                Assert.IsNotNull(query);
                Assert.IsTrue(query.Count() == 3);
                Assert.IsTrue(query.Where(v => v.User.Code == "User3").Count() == 1);

                foreach(Vote v in query) {
                    db.Votes.Remove(v);
                }
                db.Surveys.Remove(survey);
                db.SaveChanges();
            }

            Assert.IsNull(GetTestSurveyFromDb());
        }
コード例 #10
0
ファイル: DataTest.cs プロジェクト: auxua/Qurvey
 public void TestUserGenSave()
 {
     User u = User.GenerateNewUser();
     using (var db = new TestSurveyContext())
     {
         db.SaveUser(u);
         db.SaveChanges();
     }
 }