def get_Vokabeln():
Vokabeln = KF.Kindle_Import()
conn = sqlite3.connect(pfadDatenbank())
c = conn.cursor()
for Vokabel in Vokabeln:
c.execute("Select words from Incoming where words = :vokabel",
{"vokabel": Vokabel["word"]})
abc = c.fetchone()
if abc:
print("Wort: '{Vokab}' bereits vorhanden, Anzahl wirds geupdatet".
format(Vokab=Vokabel["word"]))
c.execute(
"UPDATE Incoming SET wordcount = wordcount + :number, timestamp = :updateat WHERE words = :vokabeln",
{
"vokabeln": Vokabel["word"],
"number": Vokabel["count"],
"updateat": Vokabel["timestamp"]
})
conn.commit()
else:
if Vokabel["lang"] == "de":
Vokabel["langto"] = None
elif Vokabel["lang"] == "en":
Vokabel["langto"] = "de"
elif Vokabel["lang"] == "fr":
Vokabel["langto"] = "de"
c.execute(
"INSERT INTO Incoming VALUES (:word, :usage, :book, :timestamp, :language, :wordcount, :languageto)",
{
"word": Vokabel["word"],
"usage": Vokabel["usage"],
"book": Vokabel["booktitle"],
"timestamp": Vokabel["timestamp"],
"language": Vokabel["lang"],
"wordcount": Vokabel["count"],
"languageto": Vokabel["lang"]
})
conn.commit()
conn.close()
return 0
def request_Linguee(query, buff=0):
baseurl = "https://www.linguee.de/deutsch-franzoesisch/search?source=auto&query="
url = baseurl + query
#print(url)
page = requests.get(url)
#print(page)
if page.status_code == 200:
#print(buff)''
src = page.content
soup = BeautifulSoup(src, "html5lib")
#print(soup)
Database = {}
Database["word"] = query
#soup1 = soup.find("div", {"class": "exact"})
#soup2 = soup.find("div", {"class": "lemma_content"})
if soup.find("div", {"class": "isMainTerm"}):
soup1 = soup.find("div", {"class": "isMainTerm"}).attrs
Database["language"] = soup1["data-source-lang"].lower()
if Database["language"] == "de":
Database["langto"] = "en"
elif Database["language"] == "en":
Database["langto"] = "de"
elif soup.find("div", {"class": "isForeignTerm"}):
soup1 = soup.find("div", {"class": "isForeignTerm"}).attrs
Database["language"] = soup1["data-source-lang"].lower()
if Database["language"] == "de":
Database["langto"] = "fr"
elif Database["language"] == "fr":
Database["langto"] = "de"
else:
Database["language"] = ""
# print(soup)
# if soup1:
# Infinitiv = soup.find_all("span", {"class": "tag_trans"})
# #print("loop1", soup1)
# elif soup2:
Infinitiv = soup.find_all("span", {"class": "tag_trans"})
#print(Infinitiv)
# print(Infinitiv)
if Infinitiv:
c = ""
for a in Infinitiv[0:5]:
c += a.text.replace(",", "") + "\n"
Database["Translation"] = c
#print(c)
else:
print("Not Found, Opening Browser")
webbrowser.open(url)
return
# timecode
ts = time.time()
Database["timestamp"] = int(str(ts)[0:10])
if buff == 1:
Datenbankpfad = pfadDatenbank() + "/Vokabldatebank.sqlite3"
conn = sqlite3.connect(Datenbankpfad)
c = conn.cursor()
c.execute(
'Select Incoming.words from Incoming where Incoming.words = "{Vokab}"'
.format(Vokab=Database["word"]))
res = c.fetchone()
if res:
c.execute(
"UPDATE Incoming SET wordcount = wordcount + :number, timestamp = :updateat WHERE words = :vokabeln",
{
"vokabeln": Database["word"],
"number": 5,
"updateat": Database["timestamp"]
})
else:
c.execute(
"INSERT INTO Incoming VALUES (:word, :usage, :book, :timestamp, :language, :wordcount, :languageto)",
{
"word": Database["word"],
"usage": "",
"book": "",
"timestamp": Database["timestamp"],
"language": Database["language"],
"wordcount": 5,
"languageto": Database["langto"]
})
c.execute(
"INSERT INTO Translation VALUES (:word, :infinitiv, :translation, :language)",
{
"word": Database["word"],
"infinitiv": "",
"translation": Database["Translation"],
"language": Database["language"]
})
conn.commit()
conn.close()
else:
print("Internetverbindung Fehlerhaft oder Wort nicht gefunden")
return
return Database
import LarousseEngl as LE import sqlite3 from Datenbankpfad import pfadDatenbank Datenbankpfad = pfadDatenbank() conn = sqlite3.connect(Datenbankpfad) c = conn.cursor()