public void TestUpdateWordsRelationStatus()
{
//arrange
LocalWordDB sut = new LocalWordDB();
sut.CreateDatabase();
List <DbWord> wordlist = new List <DbWord>
{
new DbWord {
Word = "test", SynsetId = "b:fzf4687", CreationDate = DateTime.Today, WordId = 1
},
new DbWord {
Word = "test2", SynsetId = "b:vdqvqdv45", CreationDate = DateTime.Today, WordId = 2
}
};
sut.TryAddWord(defaultDbWord.Word, defaultDbWord.SynsetId).Should().BeTrue();
sut.TryAddWord(defaultDbWord2.Word, defaultDbWord2.SynsetId).Should().BeTrue();
//act
sut.UpdateWordRelationStatus(wordlist, true).Should().Be(2);
//assert
sut.TryGetWords(wordlist, out IEnumerable <DbWord> outDbWords).Should().BeTrue();
outDbWords.Count().Should().Be(wordlist.Count);
outDbWords.Any(x => x.RelationsRequested == true).Should().BeTrue();
//restore
sut.DeleteDatabase();
}
public void TestSelectManyManyMoreWords(int argsize)
{
//arrange
LocalWordDB sut = new LocalWordDB();
sut.CreateDatabase();
List <DbWord> wordlist = new List <DbWord>();
for (int i = 0; i < argsize; i++)
{
wordlist.Add(new DbWord {
Word = Guid.NewGuid().ToString(), SynsetId = Guid.NewGuid().ToString(), CreationDate = DateTime.Today
});
}
wordlist.Add(defaultDbWord);
wordlist.Add(defaultDbWord2);
sut.TryAddWord(defaultDbWord.Word, defaultDbWord.SynsetId).Should().BeTrue();
sut.TryAddWord(defaultDbWord2.Word, defaultDbWord2.SynsetId).Should().BeTrue();
//act
sut.TryGetWords(wordlist, out IEnumerable <DbWord> data2).Should().BeTrue();
//assert
var wordOut = data2.ToHashSet();
wordOut.Contains(defaultDbWord).Should().BeTrue();
wordOut.Contains(defaultDbWord2).Should().BeTrue();
//restore
sut.DeleteDatabase();
}
public void TestSelectManyWords()
{
//arrange
LocalWordDB sut = new LocalWordDB();
sut.CreateDatabase();
List <DbWord> wordlist = new List <DbWord>
{
defaultDbWord,
defaultDbWord2
};
sut.TryAddWord(defaultDbWord.Word, defaultDbWord.SynsetId).Should().BeTrue();
sut.TryAddWord(defaultDbWord2.Word, defaultDbWord2.SynsetId).Should().BeTrue();
//act-assert
sut.TryGetWords(wordlist, out IEnumerable <DbWord> data2);
DbWord[] wordSelected = data2.ToArray();
for (int i = 0; i < wordlist.Count; i++)
{
wordSelected[i].Should().Be(wordlist[i]);
}
//restore
sut.DeleteDatabase();
}
public void TestUpdateManyWords()
{
//arrange
LocalWordDB sut = new LocalWordDB();
sut.CreateDatabase();
List <DbWord> wordlist = new List <DbWord>
{
defaultDbWord,
defaultDbWord2
};
sut.TryAddWord(defaultDbWord.Word, defaultDbWord.SynsetId).Should().BeTrue();
sut.TryAddWord(defaultDbWord2.Word, defaultDbWord2.SynsetId).Should().BeTrue();
var updatedSynset = "b:04704254";
List <DbWord> wordlist2 = new List <DbWord>
{
new DbWord {
Word = "test", SynsetId = updatedSynset, CreationDate = DateTime.Today
}
};
//act
sut.TryUpdateDbWords(wordlist2).Should().Be(1);
//assert
sut.TryGetWords(wordlist, out IEnumerable <DbWord> outDbWords).Should().BeTrue();
outDbWords.Count().Should().Be(wordlist.Count);
outDbWords.ToList().Where(x => x.Word == "test").First().SynsetId.Should().Be(updatedSynset);
//restore
sut.DeleteDatabase();
}
