Example #1
0
def main():
    n = NewsDB()
    n.cur.execute('Select SQLITE_VERSION()')
    # data = n.cur.fetchone()
    p = Parser()
    articles = p.parseFAZ()

    liste = []

    for item in articles:
        a = (item['title'], item['link'], item['date'])
        liste.append(a)
    n.cur.executemany('INSERT INTO News (title, link, date) \
        VALUES(?,?,?)', liste)
    # being a good guy, closing the connection
    n.con.commit()
    n.closeConnection()