public void Add_question_to_database()
{
var options = new DbContextOptionsBuilder <QuizDbContext>()
.UseInMemoryDatabase(databaseName: "Add_question_to_database")
.Options;
using (var context = new QuizDbContext(options))
{
var service = new QuestionService(context);
Question q1 = new Question {
Content = "AAA", QuizID = 12, Id = 1
};
Question q2 = new Question {
Content = "BBB", QuizID = 13, Id = 2
};
service.CreateQuestion(q1);
service.CreateQuestion(q2);
}
using (var context = new QuizDbContext(options))
{
var numberOfQuestionsInDb = context.Question.Count();
numberOfQuestionsInDb.Should().Be(2);
}
}
public void Add_quiz_to_database()
{
var options = new DbContextOptionsBuilder <QuizDbContext>()
.UseInMemoryDatabase(databaseName: "Add_quiz_to_database")
.Options;
using (var context = new QuizDbContext(options))
{
var service = new QuizService(context);
Quiz q1 = new Quiz {
Name = "AAA", Id = 1
};
Quiz q2 = new Quiz {
Name = "BBB", Id = 2
};
service.CreateQuiz(q1);
service.CreateQuiz(q2);
}
using (var context = new QuizDbContext(options))
{
var numberOfQuizesInDb = context.Quiz.Count();
numberOfQuizesInDb.Should().Be(2);
}
}
public QuizUserControllerBase(
QuizDbContext <IdType, FormType, QuestionType, RecordType, WritedType> dbContext,
IAuthorizationProvider authProvider
) : base(dbContext)
{
this.AuthorizationProvider = authProvider;
}
public EmployeeRepository(QuizDbContext dbContext, UserManager <EmployeeAuthentication> userManager, SignInManager <EmployeeAuthentication> signInManager, IConfiguration configuration)
{
_dbContext = dbContext;
_userManager = userManager;
_signInManager = signInManager;
_configuration = configuration;
}
public void Add_answer_to_database()
{
var options = new DbContextOptionsBuilder <QuizDbContext>()
.UseInMemoryDatabase(databaseName: "Add_answer_to_database")
.Options;
using (var context = new QuizDbContext(options))
{
var service = new AnswerService(context);
Answer a1 = new Answer {
Content = "AAA", Id = 1, QuestionID = 12
};
Answer a2 = new Answer {
Content = "BBB", Id = 2, QuestionID = 13
};
service.CreateAnswer(a1);
service.CreateAnswer(a2);
}
using (var context = new QuizDbContext(options))
{
var numberOfAnserwsInDb = context.Answer.Count();
numberOfAnserwsInDb.Should().Be(2);
}
}
public async void DbTest()
{
using (var db = new QuizDbContext(_testFixture.DbOptions))
{
var count = db.Quizzes.Count();
Assert.Equal(16, count);
var firstQuiz = await db.Quizzes
.Include(q => q.Questions)
.ThenInclude(q => q.Answers)
.ThenInclude(a => a.AnswerOutcomes)
.FirstAsync();
Assert.NotNull(firstQuiz);
Assert.Equal("Quiz Number 0", firstQuiz.Title);
var firstQuestion = firstQuiz.Questions.First();
Assert.Equal("What is question number 0?", firstQuestion.Text);
var firstAnswer = firstQuestion.Answers.First();
Assert.Equal("Answer number 0", firstAnswer.Text);
var answerOutcome = firstAnswer.AnswerOutcomes.First();
Assert.NotNull(answerOutcome);
}
}
public ManageQuizController(
QuizDbContext context,
IMapper mapper)
{
_context = context;
_mapper = mapper;
}
public QuestionService()
{
var options = new DbContextOptionsBuilder <QuizDbContext>()
.UseInMemoryDatabase("Quiz")
.Options;
_context = new QuizDbContext(options);
}
public AnswerController(QuizDbContext db, IAnswerService answerService, IStorageService storageService,
IPhotoService photoService, IMapper mapper)
{
_db = db;
_answerService = answerService;
_storageService = storageService;
_photoService = photoService;
_mapper = mapper;
}
public AdminController(
UserManager <IdentityUser> userManager,
IdentityDbContext identityContext,
QuizDbContext context)
{
this.userManager = userManager;
this.identityContext = identityContext;
this.context = context;
}
public QuizController(
QuizDbContext context,
IMapper mapper,
IQuizChecker quizChecker)
{
_context = context;
_mapper = mapper;
_quizChecker = quizChecker;
}
public void SetUp()
{
_validator = new Mock <AbstractValidator <AnswerDto> >();
_validator.Setup(validator => validator.ValidateAsync(It.IsAny <ValidationContext <AnswerDto> >(), It.IsAny <CancellationToken>()))
.ReturnsAsync(new ValidationResult());
_context = new QuizDbContext(UnitTestsHelper.GetUnitTestDbOptions());
_helper = new Mock <IServiceHelper <Answer> >();
_service = new AnswerService(_context, _helper.Object, _validator.Object);
}
public OutcomeController(QuizDbContext db, IOutcomeService outcomeService,
IStorageService storageService, IPhotoService photoService, IMapper mapper)
{
_db = db;
_outcomeService = outcomeService;
_storageService = storageService;
_photoService = photoService;
_mapper = mapper;
}
public async Task TestMethod_UsingSqliteInMemoryProvider_Fail()
{
var options = new DbContextOptionsBuilder <QuizDbContext>()
.UseSqlite("DataSource=:memory:")
.Options;
await using (var context = new QuizDbContext(options)) { Assert.True(await context.Database.EnsureCreatedAsync()); }
await using (var context = new QuizDbContext(options)) { Assert.Throws <Microsoft.Data.Sqlite.SqliteException>(() => context.Quiz.Count()); }
}
public UserService(QuizDbContext dbContext, SignInManager <User> signInManager, UserManager <User> userManager, IOptions <JwtSettings> jwtSettings,
AbstractValidator <UserDto> validator, RoleManager <IdentityRole> roleManager)
{
_quizDbContext = dbContext;
_signInManager = signInManager;
_userManager = userManager;
_roleManager = roleManager;
_jwtSettings = jwtSettings.Value;
_validator = validator;
}
public static DbContextOptions <QuizDbContext> GetUnitTestDbOptions()
{
var options = new DbContextOptionsBuilder <QuizDbContext>()
.UseInMemoryDatabase(Guid.NewGuid().ToString())
.Options;
using var context = new QuizDbContext(options);
FillWithData(context);
return(options);
}
public MembersController(
UserManager <IdentityUser> userManager,
SignInManager <IdentityUser> signInManager,
IdentityDbContext identityContext,
QuizDbContext context)
{
this.userManager = userManager;
this.signInManager = signInManager;
this.identityContext = identityContext;
this.context = context;
}
private static void Add_example_records(DbContextOptions <QuizDbContext> options)
{
using (var context = new QuizDbContext(options))
{
context.Answer.Add(new Answer {
Content = "AAA", Id = 1, QuestionID = 12
});
context.Answer.Add(new Answer {
Content = "BBB", Id = 2, QuestionID = 13
});
context.SaveChanges();
}
}
private static void Add_example_recorods(DbContextOptions <QuizDbContext> options)
{
using (var context = new QuizDbContext(options))
{
context.Quiz.Add(new Quiz {
Name = "AAA", Id = 1
});
context.Quiz.Add(new Quiz {
Name = "BBB", Id = 2
});
context.SaveChanges();
}
}
private static void Add_example_records(DbContextOptions <QuizDbContext> options)
{
using (var context = new QuizDbContext(options))
{
context.Question.Add(new Question {
Content = "AAA", QuizID = 12, Id = 1
});
context.Question.Add(new Question {
Content = "BBB", QuizID = 13, Id = 2
});
context.SaveChanges();
}
}
public TestFixture()
{
var dbOptionsBuilder = new DbContextOptionsBuilder <QuizDbContext>();
dbOptionsBuilder.UseInMemoryDatabase();
this.DbOptions = dbOptionsBuilder.Options;
using (var db = new QuizDbContext(DbOptions))
{
var seeder = new DefaultSeeder(db);
seeder.Seed();
}
MapperConfig = new ConfigureMapper().Config;
}
public void Get_quiz_by_id_from_database()
{
var options = new DbContextOptionsBuilder <QuizDbContext>()
.UseInMemoryDatabase(databaseName: "Get_quiz_id_from_database")
.Options;
Add_example_recorods(options);
using (var context = new QuizDbContext(options))
{
var service = new QuizService(context);
var nameOfQuizWithIdEquals1 = service.GetQuizByID(1).Name;
nameOfQuizWithIdEquals1.Should().Be("AAA");
}
}
public void Get_answer_by_id_from_database()
{
var options = new DbContextOptionsBuilder <QuizDbContext>()
.UseInMemoryDatabase(databaseName: "Get_answer_by_id_from_database")
.Options;
Add_example_records(options);
using (var context = new QuizDbContext(options))
{
var service = new AnswerService(context);
var questionIdOfChosenAnswer = service.GetAnswerByID(2).QuestionID;
questionIdOfChosenAnswer.Should().Be(13);
}
}
private void SeedData(QuizDbContext context)
{
context.Subjects.Add(new Subject {
Id = "subject1", Name = "Subject1", LecturerId = "1"
});
context.Subjects.Add(new Subject {
Id = "subject2", Name = "Subject2", LecturerId = "2"
});
context.Topics.Add(new Topic {
Id = "topic1", Name = "Topic1", MaxAttemptCount = 3, QuestionsPerAttempt = 1, TimeToPass = 5, TopicNumber = 1, SubjectId = "subject1"
});
context.Topics.Add(new Topic {
Id = "topic2", Name = "Topic2", MaxAttemptCount = 2, QuestionsPerAttempt = 2, TimeToPass = 3, TopicNumber = 2, SubjectId = "subject2"
});
context.Questions.Add(new Question {
Id = "question1", QuestionNumber = 1, TopicId = "topic1", QuestionText = "Where?"
});
context.Questions.Add(new Question {
Id = "question2", QuestionNumber = 3, TopicId = "topic2", QuestionText = "Why?"
});
context.Answers.Add(new Answer {
Id = "answer1", AnswerText = "Here", IsCorrect = true, QuestionId = "question1"
});
context.Answers.Add(new Answer {
Id = "answer2", AnswerText = "There", IsCorrect = false, QuestionId = "question1"
});
context.Answers.Add(new Answer {
Id = "answer3", AnswerText = "Because", IsCorrect = true, QuestionId = "question2"
});
context.Answers.Add(new Answer {
Id = "answer4", AnswerText = "London is the capital of Great Britain", IsCorrect = false, QuestionId = "question2"
});
context.Attempts.Add(new Attempt {
Id = "attempt1", DateTime = DateTime.Now, Score = 100, StudentId = "1", TopicId = "topic2"
});
context.Attempts.Add(new Attempt {
Id = "attempt3", DateTime = DateTime.Now, Score = 75, StudentId = "1", TopicId = "topic2"
});
context.QuestionResults.Add(new QuestionResult {
Id = "questionResult1", AttemptId = "attempt1", QuestionId = "question2", Result = true
});
context.QuestionResults.Add(new QuestionResult {
Id = "questionResult3", AttemptId = "attempt3", QuestionId = "question2", Result = false
});
context.SaveChanges();
}
public void Get_all_quizes_from_database()
{
var options = new DbContextOptionsBuilder <QuizDbContext>()
.UseInMemoryDatabase(databaseName: "Get_all_quizes_from_database")
.Options;
Add_example_recorods(options);
using (var context = new QuizDbContext(options))
{
var service = new QuizService(context);
var actual = service.GetAll();
var numberOfQuizes = actual.Count();
numberOfQuizes.Should().Be(2);
}
}
public void Get_answers_by_questionID_from_database()
{
var options = new DbContextOptionsBuilder <QuizDbContext>()
.UseInMemoryDatabase(databaseName: "Get_answers_by_questionID_from_database")
.Options;
Add_example_records(options);
using (var context = new QuizDbContext(options))
{
var service = new AnswerService(context);
var actual = service.GetAnswersByQuestionID(12);
var numberOfAnswersToSelectedQuestion = actual.Count();
numberOfAnswersToSelectedQuestion.Should().Be(1);
}
}
public void Delete_quiz_from_database()
{
var options = new DbContextOptionsBuilder <QuizDbContext>()
.UseInMemoryDatabase(databaseName: "Delete_quiz_from_database")
.Options;
Add_example_recorods(options);
using (var context = new QuizDbContext(options))
{
var service = new QuizService(context);
service.DeleteQuizByID(1);
var numberOfQuizesInDb = context.Quiz.Count();
var idOfLastedQuiz = context.Quiz.Single().Id;
numberOfQuizesInDb.Should().Be(1);
idOfLastedQuiz.Should().Be(2);
}
}
public void Delete_answer_from_database()
{
var options = new DbContextOptionsBuilder <QuizDbContext>()
.UseInMemoryDatabase(databaseName: "Delete_answer_from_database")
.Options;
Add_example_records(options);
using (var context = new QuizDbContext(options))
{
var service = new AnswerService(context);
service.DeleteAnswerByID(1);
var numberOfAnserwsInDb = context.Answer.Count();
var idOfLastedAnswer = context.Answer.Single().Id;
numberOfAnserwsInDb.Should().Be(1);
idOfLastedAnswer.Should().Be(2);
}
}
public void ShouldGetQuizzesTest()
{
const int numberOfQuizzes = 3;
var skipInterval = numberOfQuizzes;
using (var db = new QuizDbContext(_testFixture.DbOptions))
{
var quizService = new QuizService(db);
var quizzes1 = quizService.GetQuizzes(numberOfQuizzes).ToList();
Assert.Equal("Quiz Number 0", quizzes1[0].Title);
Assert.Equal("Quiz Number 1", quizzes1[1].Title);
Assert.Equal("Quiz Number 10", quizzes1[2].Title);
Assert.Equal(numberOfQuizzes, quizzes1.Count);
var quizzes2 = quizService.GetQuizzes(numberOfQuizzes, skipInterval).ToList();
Assert.Equal("Quiz Number 11", quizzes2[0].Title);
Assert.Equal("Quiz Number 12", quizzes2[1].Title);
Assert.Equal("Quiz Number 13", quizzes2[2].Title);
Assert.Equal(numberOfQuizzes, quizzes2.Count);
}
}
public void QuizDBContext_Constructor_Success()
{
//Arrange
var settings = new ConnectionStrings()
{
Mongo = "mongodb://localhost:27017/Quiz"
};
var mongodbUrl = new MongoUrl(settings.Mongo);
_mockOptions.Setup(s => s.Value).Returns(settings);
_mockClient.Setup(c => c
.GetDatabase(mongodbUrl.DatabaseName, null))
.Returns(_mockDB.Object);
//Act
var context = new QuizDbContext(_mockOptions.Object);
//Assert
Assert.NotNull(context);
}
