Python scrapeの例

コード例 #1

ファイル: videos.py プロジェクト: prakash09/CourseEra-Lectures-Downloader

import sqlite3 as lite
import os
import sys
from module1 import download, scrape
'''
Handling Database 
'''

con = None

if not (os.path.exists('database.db')):
    con = lite.connect('database.db')
    urls = scrape('https://class.coursera.org/compilers-003/lecture')

    with con:
        cur = con.cursor()
        cur.execute("CREATE TABLE links(url TEXT)")

        for link in urls:
            cur.execute("INSERT INTO links VALUES(?)", (link, ))

else:
    con = lite.connect('database.db')

    with con:
        cur = con.cursor()
        cur.execute("SELECT * FROM links")

        rows = cur.fetchall()

        for row in rows:

コード例 #2

ファイル: videos.py プロジェクト: Diwahars/CourseEra-Lectures-Downloader

import sqlite3 as lite
import os
import sys
from module1 import download, scrape

'''
Handling Database 
'''

con = None

if not(os.path.exists('database.db')):
	con = lite.connect('database.db')	
	urls = scrape('https://class.coursera.org/compilers-003/lecture')

	with con:
		cur = con.cursor()
		cur.execute("CREATE TABLE links(url TEXT)")

		for link in urls:
			cur.execute("INSERT INTO links VALUES(?)", (link,))			

else:
	con = lite.connect('database.db')

	with con:
		cur = con.cursor()
		cur.execute("SELECT * FROM links")

		rows = cur.fetchall()

コード例 #3

ファイル: videos.py プロジェクト: Elavarasanlee/CourseEra-Lectures-Downloader

import sqlite3 as lite
import os
import sys
from module1 import download, scrape

'''
Handling Database 
'''

con = None

if not(os.path.exists('database.db')):
	con = lite.connect('database.db')	
	urls = scrape('https://class.coursera.org/crypto-007/lecture')
	
	with con:
		cur = con.cursor()
		cur.execute("CREATE TABLE links(url TEXT)")

		for link in urls:
			cur.execute("INSERT INTO links VALUES(?)", (link,))			

else:
	con = lite.connect('database.db')

	with con:
		cur = con.cursor()
		cur.execute("SELECT * FROM links")

		rows = cur.fetchall()