+ c.execute("""INSERT INTO phrases
+ (id, latin, english, notes, length)
+ VALUES(?, ?, ?, ?, ?)""",
+ (i, latin, english, notes, len(latin)))
+ conn.commit()
+ i = i + 1
+
+
+def get_tables():
+ url = ("""https://en.wikipedia.org/w/index.php?title=List_of_Latin_phrases_(
+ full)&oldid=986793908""")
+ return get_html(url).find_all("table", attrs={"class": "wikitable"})
+
+
+def main():
+ prep_database()
+ fill_database(get_tables())