public void DeleteQuestionTest_Default() { QuestionTable.SaveQuestion(defaultQuestion); int res = QuestionTable.DeleteQuestion(defaultQuestion); Assert.AreEqual(res, 1); }
public void GetQuestionIdTest_DoesNotExist() { QuestionTable.SaveQuestion(defaultQuestion); QuestionTable.DeleteQuestion(defaultQuestion); long res = QuestionTable.GetQuestionId(defaultQuestion); Assert.AreEqual(-1, res); }
public void SaveQuestionTest_FreeTextType() { Question question = new Question("Free Type", new string[] { "A;B;C;D" }); question.IsFreeText = true; int res = QuestionTable.SaveQuestion(question); QuestionTable.DeleteQuestion(question); Assert.AreEqual(res, 1); }
public void TestQuestionInsert() { QuestionAnswer qaTest = new QuestionAnswer("Praha", true); QuestionAnswer qaTest2 = new QuestionAnswer("Ostrava", false); List <QuestionAnswer> questionList = new List <QuestionAnswer>() { qaTest, qaTest2 }; Question generatedQuestion = QuestionTable.InsertQuestion(this.connection, 1, "Jaké je hlavní město ČR?", "closed", questionList); Question dbQuestion = QuestionTable.GetQuestionById(this.connection, generatedQuestion.Id); Assert.AreEqual(generatedQuestion.Id, dbQuestion.Id); Assert.AreEqual(generatedQuestion.OwnerId, dbQuestion.OwnerId); Assert.AreEqual(generatedQuestion.Text, dbQuestion.Text); Assert.AreEqual(generatedQuestion.Type, dbQuestion.Type); Assert.AreEqual(questionList.Count, dbQuestion.Answers.Count); for (int i = 0; i < dbQuestion.Answers.Count; i++) { Assert.AreEqual(dbQuestion.Id, dbQuestion.Answers[i].QuestionId); Assert.AreEqual(i, dbQuestion.Answers[i].Index); Assert.AreEqual(questionList[i].Text, dbQuestion.Answers[i].Text); Assert.AreEqual(questionList[i].Correct, dbQuestion.Answers[i].Correct); } Assert.IsTrue(QuestionTable.DeleteQuestion(this.connection, dbQuestion)); try { QuestionTable.GetQuestionById(this.connection, dbQuestion.Id); Assert.Fail("Otázka stále existuje"); } catch (DatabaseException) { } }
public void TestQuestionUpdate() { QuestionAnswer qaTest = new QuestionAnswer("Praha", true); QuestionAnswer qaTest2 = new QuestionAnswer("Ostrava", false); List <QuestionAnswer> questionList = new List <QuestionAnswer>() { qaTest, qaTest2 }; Question generatedQuestion = QuestionTable.InsertQuestion(this.connection, 1, "Jaké je hlavní město ČR?", "closed", questionList); generatedQuestion.AddAnswer(new QuestionAnswer("Brno", false)); generatedQuestion.Text = "Test"; Assert.IsTrue(QuestionTable.UpdateQuestion(this.connection, generatedQuestion)); Question updatedQuestion = QuestionTable.GetQuestionById(this.connection, generatedQuestion.Id); Assert.AreEqual("Test", updatedQuestion.Text); Assert.AreEqual(3, updatedQuestion.Answers.Count); Assert.AreEqual("Brno", updatedQuestion.Answers[2].Text); Assert.IsTrue(QuestionTable.DeleteQuestion(this.connection, generatedQuestion)); }
public void Cleanup() { QuestionTable.DeleteQuestion(defaultQuestion); }