def test_add_english_deutsch_translation(self):
database = MySqlDataSouce()
result = database.add_english_deutsch_translation(1, 1)
self.assertTrue(result > 0)
translations = parser.extract_translation_nouns(result)
print("Translations: " + str(translations))
for trans in translations :
englishWord = dao.find_english_word(trans["en"], NOUN)
if englishWord :
engId = englishWord[0]
else:
engId = dao.add_english_word(trans["en"], NOUN)
genderNounSplit = trans["de"].split(" ")
if len(genderNounSplit) > 2 :
print("We have a larger split: " + trans["de"])
gender = "?"
if genderNounSplit[0] == "der" :
gender = "M"
elif genderNounSplit[0] == "die" :
gender = "F"
elif genderNounSplit[0] == "das" :
gender = "N"
deutschWord = dao.find_deutsch_word(trans["de"], NOUN)
if deutschWord :
deutId = deutschWord[0]
else:
deutId = dao.add_deutsch_word(trans["de"], NOUN, gender)
dao.add_english_deutsch_translation(engId, deutId)
dao.update_search_status(id, SUCCESS)
time.sleep(THROTTLE_SECONDS)