public void Initialize()
{
Database.SetInitializer(new DropCreateDatabaseAlways <ChineseTrainerContext>());
var objectUnderTest = new ChineseTrainerContext(TestDatabaseName);
Guard <Dictionary>(objectUnderTest);
Guard <DictionaryEntry>(objectUnderTest);
Guard <Translation>(objectUnderTest);
Guard <Highscore>(objectUnderTest);
Guard <User>(objectUnderTest);
var dictionary1 = CreateDictionary("1");
objectUnderTest.Add(typeof(Dictionary), dictionary1);
var dictionary2 = CreateDictionary("2");
objectUnderTest.Add(typeof(Dictionary), dictionary2);
var highscore = CreateHighscore(dictionary1);
objectUnderTest.Add(typeof(Highscore), highscore);
objectUnderTest.SaveChanges();
}
public void ShouldGetTranslationsFromDatabase()
{
var objectUnderTest = new ChineseTrainerContext(TestDatabaseName);
var translations = objectUnderTest.GetAll <Translation>().ToList();
Assert.AreEqual(4, translations.Count);
}
public void ShouldGetDictionariesFromDatabase()
{
var objectUnderTest = new ChineseTrainerContext(TestDatabaseName);
var dictionaries = objectUnderTest.GetAll(typeof(Dictionary));
Assert.AreEqual(2, dictionaries.Count);
}
public void Initialize()
{
Database.SetInitializer(new DropCreateDatabaseAlways <ChineseTrainerContext>());
var testSetupContext = new ChineseTrainerContext(TestDatabaseName);
Guard <Dictionary>(testSetupContext);
Guard <DictionaryEntry>(testSetupContext);
Guard <Translation>(testSetupContext);
Guard <Highscore>(testSetupContext);
Guard <Answer>(testSetupContext);
var dictionary1 = CreateDictionary("1");
testSetupContext.Add(dictionary1);
var dictionary2 = CreateDictionary("2");
testSetupContext.Add(dictionary2);
var highscore = CreateHighscore(dictionary1);
testSetupContext.Add(highscore);
_questionResultId = highscore.QuestionResult.Id;
foreach (var answer in highscore.QuestionResult.Answers)
{
testSetupContext.Add(answer);
}
testSetupContext.SaveChanges();
}
public void ShouldGetEntriesFromDatabase()
{
var objectUnderTest = new ChineseTrainerContext(TestDatabaseName);
var entries = objectUnderTest.GetAll <DictionaryEntry>().ToList();
Assert.AreEqual(4, entries.Count);
}
public void ShouldGetQuestionResultById()
{
var objectUnderTest = new ChineseTrainerContext(TestDatabaseName);
var questionResult = objectUnderTest.GetById <QuestionResult>(_questionResultId);
Assert.IsNotNull(questionResult);
}
public void ShouldGetHighscoreFromDatabase()
{
var objectUnderTest = new ChineseTrainerContext(TestDatabaseName);
var highscores = objectUnderTest.GetAll <Highscore>().ToList();
Assert.AreEqual(1, highscores.Count);
}
public void ShouldGetUserFromDatabase()
{
var objectUnderTest = new ChineseTrainerContext(TestDatabaseName);
var users = objectUnderTest.GetAll(typeof(User));
Assert.AreEqual(1, users.Count);
}
public void ShouldGetQuestionResultsFromDatabase()
{
var objectUnderTest = new ChineseTrainerContext(TestDatabaseName);
var questionResults = objectUnderTest.GetAll <QuestionResult>().ToList();
Assert.AreEqual(1, questionResults.Count);
Assert.AreEqual(1, questionResults[0].Answers.Count);
}
public void AddQuestionResult(QuestionResult questionResult)
{
ChineseTrainerContext.Add(questionResult);
ChineseTrainerContext.SaveChanges();
}
public void AddHighscore(Highscore highscore)
{
ChineseTrainerContext.Add(highscore);
ChineseTrainerContext.SaveChanges();
}
public void AddDictionaryEntry(DictionaryEntry dictionaryEntry)
{
ChineseTrainerContext.Add(dictionaryEntry);
ChineseTrainerContext.SaveChanges();
}
public QuestionResult GetQuestionResultById(Guid questionResultId)
{
var questionResult = ChineseTrainerContext.GetById <QuestionResult>(questionResultId);
return(questionResult);
}
public List <Highscore> GetHighscoresForDictionary(Guid dictionaryId)
{
var result = ChineseTrainerContext.GetAll <Highscore>().Where(p => p.DictionaryId == dictionaryId).ToList();
return(result);
}
public List <DictionaryEntry> GetDictionaryEntriesForDictionary(Guid dictionaryId)
{
var result = ChineseTrainerContext.GetAll <DictionaryEntry>().Where(p => p.DictionaryId == dictionaryId);
return(result.ToList());
}
public List <Dictionary> GetDictionaries()
{
var result = ChineseTrainerContext.GetAll <Dictionary>();
return(result.ToList());
}
public void AddAnswer(Answer answer)
{
ChineseTrainerContext.Add(answer);
ChineseTrainerContext.SaveChanges();
}
private static void Guard <T>(ChineseTrainerContext objectUnderTest) where T : Entity
{
Assert.AreEqual(0, objectUnderTest.GetAll <T>().Count(),
string.Format("Guard: Table for type {0} should be empty.", typeof(T)));
}
