def test_add_translations(self):
c = Cards.LanguageBVocab(text="Morgen")
tr1 = Cards.LanguageAVocab(text="Morning")
tr2 = Cards.LanguageAVocab(text="tomorrow")
tr3 = Cards.LanguageAExample(text="not supposed to be here")
self.sess.add_all([c, tr1, tr2, tr3])
self.sess.commit()
cds.add_translation(c, tr1)
probe = cds.get_translations(c)
ans = [tr1]
self.assertEqual(probe, ans)
cds.add_translation(c, tr2)
probe = cds.get_translations(c)
ans = [tr1, tr2]
self.assertEqual(probe, ans)
try:
cds.add_translation(c, tr3)
self.assertTrue(False)
except AssertionError:
print("caught assertion error")
def test_add_all_cards(self):
d = decks.Deck(name="Testdeck")
cb = Cards.LanguageBVocab(text="worte1")
cb2 = Cards.LanguageBVocab(text="worte2")
ca1 = Cards.LanguageAVocab(text="word1")
cea1 = Cards.LanguageAExample(text="example1")
ceb1 = Cards.LanguageBExample(text="Beispiel1")
u = Cards.User(name="jack")
self.sess.add_all([d, cb, cb2, ca1, cea1, ceb1, u])
self.sess.commit()
dks.add_all_cards(d, [cb, cb2, ca1, cea1, ceb1])
self.sess.commit()
probe = dks.get_examples_a(d)
ans = [cea1]
self.assertEqual(probe, ans)
probe = dks.get_examples_b(d)
ans = [ceb1]
self.assertEqual(probe, ans)
probe = dks.get_vocab_a(d)
ans = [ca1]
self.assertEqual(probe, ans)
probe = dks.get_vocab_b(d)
ans = [cb, cb2]
self.assertEqual(probe, ans)
def test_get_translations(self):
c = Cards.LanguageAVocab(text="hello")
v1 = Cards.LanguageBVocab(text="hallo")
v2 = Cards.LanguageBVocab(text="gutentag")
self.sess.add(c)
self.sess.add(v1)
self.sess.add(v2)
self.sess.commit()
c.translations.append(v1)
c.translations.append(v2)
self.sess.commit()
ans = cds.get_translations(c)
self.assertEqual(ans, [v1, v2])
e = Cards.LanguageAExample(text="this is an example")
t1 = Cards.LanguageBExample(text="Diese ist ein Beispiel")
self.sess.add(e)
self.sess.add(t1)
e.translations.append(t1)
self.sess.commit()
ans = cds.get_translations(e)
self.assertEqual(ans, [t1])
def test_sql_ids(self):
worda = Cards.LanguageAVocab(text="word1")
self.sess.add(worda)
print("id is: {ids}".format(ids=worda.id))
self.sess.flush()
print("id is: {ids}".format(ids=worda.id))
self.sess.commit()
print("id is: {ids}".format(ids=worda.id))
def test_translations(self):
worda = Cards.LanguageAVocab(text="word1",
date_created=datetime.date.today())
self.sess.add(worda)
wordb = Cards.LanguageAVocab()
wordb.text = "word2"
wordb.date_created = datetime.date.today()
self.sess.add(wordb)
fwordc = Cards.LanguageBVocab()
fwordc.text = "translation11"
fwordc.date_created = datetime.date.today()
fwordc.translations.append(worda)
self.sess.add(fwordc)
fwordd = Cards.LanguageBVocab()
fwordd.text = "translation12"
fwordd.date_created = datetime.date.today()
fwordd.translations.append(worda)
fwordd.translations.append(wordb)
self.sess.add(fwordd)
self.sess.commit()
self.assertEqual(worda.text, "word1")
translations = [
a.text for a in self.sess.query(Cards.LanguageAVocab).filter_by(
id=worda.id).all()[0].translations
]
self.assertTrue("translation11" in translations)
self.assertTrue("translation12" in translations)
translations = [
a.text for a in self.sess.query(Cards.LanguageAVocab).filter_by(
id=wordb.id).all()[0].translations
]
self.assertTrue("translation11" not in translations)
self.assertTrue("translation12" in translations)
def test_remove_translation(self):
c = Cards.LanguageBVocab(text="machen")
tr1 = Cards.LanguageAVocab(text="this is a translation")
tr2 = Cards.LanguageAVocab(text="this is not a translation")
self.sess.add_all([c, tr1, tr2])
c.translations.append(tr1)
self.sess.commit()
self.assertEqual(cds.get_translations(c), [tr1])
cds.remove_translation(c, tr1)
probe = cds.get_translations(c)
ans = []
self.assertEqual(probe, ans)
try:
cds.remove_translation(c, tr2)
self.fail()
except AssertionError:
print("Caught assertion error")
def test_remove_cards(self):
d = decks.Deck(name="Testdeck")
cb = Cards.LanguageBVocab(text="worte1")
cb2 = Cards.LanguageBVocab(text="worte2")
ca1 = Cards.LanguageAVocab(text="word1")
cea1 = Cards.LanguageAExample(text="example1")
ceb1 = Cards.LanguageBExample(text="Beispiel1")
u = Cards.User(name="jack")
self.sess.add_all([d, cb, cb2, ca1, cea1, u])
self.sess.commit()
dks.add_all_cards(d, [cb, cb2, ca1, cea1])
self.sess.commit()
dks.remove_card(d, cb)
self.sess.commit()
probe = dks.get_vocab_b(d)
ans = [cb2]
self.assertEqual(probe, ans)
dks.remove_card(d, ca1)
self.sess.commit()
self.assertEqual(dks.get_vocab_a(d), [])
dks.remove_card(d, cea1)
self.sess.commit()
self.assertEqual(dks.get_examples_a(d), [])
try:
dks.remove_card(d, ceb1)
self.sess.commit()
self.fail()
except ValueError:
print("value error caught")
def test_decks(self):
user = Cards.User(name="Samuel")
decka = decks.Deck(name="decka")
vocabaa = Cards.LanguageAVocab(text="howdy")
vocabba = Cards.LanguageBVocab(text="gutentag")
vocabbb = Cards.LanguageBVocab(text="wie geht's")
exampleaa = Cards.LanguageAExample(text="dude, I'm an example")
exampleba = Cards.LanguageBExample(text="Je, Ich bin ein Beispiel")
self.sess.add(user)
self.sess.add(decka)
self.sess.add(vocabaa)
self.sess.add(vocabba)
self.sess.add(vocabbb)
self.sess.add(exampleaa)
self.sess.add(exampleba)
decka.user_id = user.id
decka.vocab_a.append(vocabaa)
decka.vocab_b.append(vocabba)
decka.vocab_b.append(vocabbb)
decka.examples_a.append(exampleaa)
decka.examples_b.append(exampleba)
self.sess.commit()
d = self.sess.query(type(decka)).filter_by(id=1).one()
self.assertEqual(len(d.vocab_a), 1)
self.assertEqual(len(d.vocab_b), 2)
self.assertEqual(len(d.examples_a), 1)
self.assertEqual(len(d.examples_b), 1)
self.sess.delete(vocabbb)
self.sess.commit()
self.assertEqual(len(d.vocab_b), 1)
self.sess.delete(decka)
self.sess.commit()
self.assertEqual(vocabaa.text, "howdy")
def test_add_card(self):
d = decks.Deck(name="Testdeck")
cb = Cards.LanguageBVocab(text="worte1")
cb2 = Cards.LanguageBVocab(text="worte2")
ca1 = Cards.LanguageAVocab(text="word1")
cea1 = Cards.LanguageAExample(text="example1")
ceb1 = Cards.LanguageBExample(text="Beispiel1")
self.sess.add_all([d, cb, cb2, ca1, cea1, ceb1])
self.sess.commit()
self.assertEqual(d.examples_a, [])
self.assertEqual(d.examples_b, [])
self.assertEqual(d.vocab_a, [])
self.assertEqual(d.vocab_b, [])
dks.add_card(d, cb)
self.sess.commit()
self.assertEqual(d.examples_a, [])
self.assertEqual(d.examples_b, [])
self.assertEqual(d.vocab_a, [])
self.assertEqual(d.vocab_b, [cb])
dks.add_card(d, cb2)
dks.add_card(d, ca1)
dks.add_card(d, cea1)
dks.add_card(d, ceb1)
self.sess.commit()
self.assertEqual(d.examples_a, [cea1])
self.assertEqual(d.examples_b, [ceb1])
self.assertEqual(d.vocab_a, [ca1])
self.assertEqual(d.vocab_b, [cb, cb2])
try:
dks.add_card(d, 4)
self.fail("assertion error was not caught")
except AssertionError:
print("assertion error caught")
def test_edit_paradigm(self):
import LanguageDeck.session_tools.session_scope as scp
with scp.session_scope(self.session) as sess:
c1 = Cards.LanguageAVocab(text="error")
c2 = Cards.Grammar(paradigm="old paradigm")
sess.add_all([c1, c2])
sess.commit()
try:
cds.edit_g_paradigm(c1, "new paradigm")
except AssertionError:
print("caught assertion error")
cds.edit_g_paradigm(c2, "new paradigm")
sess.commit()
probe = cds.get_paradigm_content(c2)
ans = "new paradigm"
self.assertEqual(probe, ans)
def test_get_low_scores(self):
d = decks.Deck(name="Testdeck")
cb = Cards.LanguageBVocab(text="worte1")
cb2 = Cards.LanguageBVocab(text="worte2")
ca1 = Cards.LanguageAVocab(text="word1")
cea1 = Cards.LanguageAExample(text="example1")
ceb1 = Cards.LanguageBExample(text="Beispiel1")
u = Cards.User(name="jack")
self.sess.add_all([d, cb, cb2, ca1, cea1, ceb1, u])
self.sess.commit()
dks.add_card(d, cb)
dks.add_card(d, cb2)
dks.add_card(d, ca1)
dks.add_card(d, cea1)
dks.add_card(d, ceb1)
cds.edit_score(self.sess, cb, u, 5)
cds.edit_score(self.sess, cb2, u, 10)
cds.edit_score(self.sess, ceb1, u, 8)
u.decks.append(d)
self.sess.commit()
probe = dks.get_low_scores(self.sess, d, 3)
ans = []
self.assertEqual(probe, ans)
probe = dks.get_low_scores(self.sess, d, 7)
ans = [cb]
self.assertEqual(probe, ans)
probe = dks.get_low_scores(self.sess, d, 9)
ans = [cb, ceb1]
self.assertEqual(probe, ans)
def test_delete_deck(self):
d = decks.Deck(name="Testdeck")
self.sess.add(d)
self.sess.commit()
alldecks = self.sess.query(decks.Deck).all()
self.assertEqual(alldecks, [d])
dks.delete_deck(self.sess, d)
self.sess.commit()
alldecks = self.sess.query(decks.Deck).all()
self.assertEqual(alldecks, [])
# Deletion of decks should not delete cards
cb = Cards.LanguageBVocab(text="worte1")
cb2 = Cards.LanguageBVocab(text="worte2")
ca1 = Cards.LanguageAVocab(text="word1")
cea1 = Cards.LanguageAExample(text="example1")
ceb1 = Cards.LanguageBExample(text="Beispiel1")
self.sess.add_all([cb, cb2, ca1, cea1, ceb1])
self.sess.commit()
d = decks.Deck(name="Testdeck")
self.sess.add(d)
self.sess.commit()
dks.add_all_cards(d, [cb, cb2, ca1, cea1, ceb1])
self.sess.commit()
dks.delete_deck(self.sess, d)
self.sess.commit()
bvocab = self.sess.query(Cards.LanguageBVocab).all()
self.assertTrue(cb in bvocab)
self.assertTrue(cb2 in bvocab)
self.assertEqual(len(bvocab), 2)
def test_new_deck(self):
cb = Cards.LanguageBVocab(text="worte1")
cb2 = Cards.LanguageBVocab(text="worte2")
ca1 = Cards.LanguageAVocab(text="word1")
cea1 = Cards.LanguageAExample(text="example1")
ceb1 = Cards.LanguageBExample(text="Beispiel1")
u = Cards.User(name="jack")
self.sess.add_all([cb, cb2, ca1, cea1, ceb1, u])
self.sess.commit()
d = dks.new_deck(self.sess, [cb, cb2, ca1, cea1, ceb1], u, "test_deck")
self.sess.commit()
probe = dks.get_examples_a(d)
ans = [cea1]
self.assertEqual(probe, ans)
probe = dks.get_examples_b(d)
ans = [ceb1]
self.assertEqual(probe, ans)
probe = dks.get_vocab_a(d)
ans = [ca1]
self.assertEqual(probe, ans)
probe = dks.get_vocab_b(d)
ans = [cb, cb2]
self.assertEqual(probe, ans)
probe = d.user_id
ans = u.id
self.assertEqual(probe, ans)
def test_add_examples(self):
import LanguageDeck.session_tools.session_scope as scp
with scp.session_scope(self.session) as sess:
cvb = Cards.LanguageBVocab(text="lbv")
cvb2 = Cards.LanguageBVocab(text="lbv2")
cva = Cards.LanguageAVocab(text="lav")
ceb = Cards.LanguageBExample(text="example lbv")
cea = Cards.LanguageAExample(text="example lav")
sess.add_all([cvb, cvb2, cva, ceb, cea])
sess.commit()
cds.add_example(cvb, ceb)
sess.commit()
probe = cds.get_examples(cvb)
ans = [ceb]
self.assertEqual(probe, ans)
cds.add_example(cvb2, ceb)
sess.commit()
probe = cds.get_examples(cvb2)
ans = [ceb]
self.assertEqual(probe, ans)
cds.add_example(cva, cea)
sess.commit()
probe = cds.get_examples(cva)
ans = [cea]
self.assertEqual(probe, ans)
cds.add_example(cvb, ceb)
cds.add_example(cvb, ceb)
sess.commit()
probe = cds.get_examples(cvb)
ans = [ceb]
self.assertEqual(probe, ans)
def test_deletions(self):
worda = Cards.LanguageAVocab(text="word1",
date_created=datetime.date.today())
self.sess.add(worda)
wordb = Cards.LanguageAVocab()
wordb.text = "word2"
wordb.date_created = datetime.date.today()
self.sess.add(wordb)
fwordc = Cards.LanguageBVocab()
fwordc.text = "translation11"
fwordc.date_created = datetime.date.today()
fwordc.translations.append(worda)
self.sess.add(fwordc)
fwordd = Cards.LanguageBVocab()
fwordd.text = "translation12"
fwordd.date_created = datetime.date.today()
fwordd.translations.append(worda)
fwordd.translations.append(wordb)
self.sess.add(fwordd)
self.sess.commit()
self.sess.delete(fwordc)
self.sess.commit()
self.assertTrue(
len(
self.sess.query(Cards.LanguageAVocab).filter_by(
id=worda.id).one().translations) == 1)
self.assertEqual(
self.sess.query(Cards.LanguageAVocab).filter_by(
id=worda.id).one().translations[0], fwordd)
self.sess.delete(worda)
self.sess.commit()
self.assertTrue(
len(
self.sess.query(Cards.LanguageAVocab).filter_by(
id=wordb.id).one().translations) == 1)
user = Cards.User(name="bob")
user2 = Cards.User(name="sally")
self.sess.add(user)
self.sess.add(user2)
self.sess.commit()
las = associations.LanguageAVocabScore(user_id=1, card_id=2, score=3)
las2 = associations.LanguageAVocabScore(user_id=2, card_id=2, score=5)
wordb.scores.append(las)
wordb.scores.append(las2)
self.sess.commit()
self.assertEqual(
self.sess.query(associations.LanguageAVocabScore).filter_by(
card_id=2, user_id=1).one().score, 3)
self.sess.delete(user2)
self.sess.commit()
self.assertEqual(
len(self.sess.query(associations.LanguageAVocabScore).all()), 1)
self.sess.delete(wordb)
self.sess.commit()
self.assertEqual(
len(self.sess.query(associations.LanguageAVocabScore).all()), 0)
def test_get_text(self):
c = Cards.LanguageAVocab(text="heythere!")
ans = cds.get_text(c)
self.assertEqual(ans, "heythere!")
