Example #1
0
def downloadAndSaveArticles():
    #Get links
    links = Task1.getComicLinks()[0:10]

    #download site and select description in title tag
    descs = []
    for link in links:
        href = link.attr('href')
        descs.append(getAltAttrFromArticle(href))

    #Save queried data in database
    with sqlite3.connect('xkcd_db.db') as con:
        cur = con.cursor()
    cur.execute('drop table if exists xkcd')
    cur.execute('create table xkcd (url text, alt text)')
    for desc in descs:
        saveDescAndAltToDatabase(desc[1], desc[0], con, cur)