Amazing-Python-Scripts

1
import sqlite3
2
from sqlite3 import Error
3

4
# Function to connect to the SQL Database
5

6

7
def sql_connection():
8
    try:
9
        con = sqlite3.connect('./Udemy Scraper/udemyDatabase.db')
10
        return con
11
    except Error:
12
        print(Error)
13

14

15
con = sql_connection()
16

17
# Function to Fetch courses from database
18

19

20
def sql_fetch(con):
21
    cursorObj = con.cursor()
22
    try:
23
        cursorObj.execute('SELECT * FROM courses')  # SQL search query
24
    except Error:
25
        print("Database empty... Fetch courses using fetcher script")
26
        return
27

28
    rows = cursorObj.fetchall()
29

30
    # Print table header
31
    print("{:^30}".format("Title"), "{:^30}".format("Description"), "{:^20}".format("Instructor"),
32
          "{:<15}".format("Current Price"), "{:<18}".format(
33
              "Original Price"), "{:^10}".format("Rating"),
34
          "{:^10}".format("Hours"), "{:^10}".format("Lectures"))
35

36
    # Print all rows
37
    for row in rows:
38
        # Format individual data items for printing in a table like manner
39
        title = "{:<30}".format(row[0] if len(
40
            row[0]) < 30 else row[0][:26]+"...")
41
        description = "{:<30}".format(
42
            row[1] if len(row[1]) < 30 else row[1][:26]+"...")
43
        instructor = "{:<20}".format(row[2] if len(
44
            row[2]) < 30 else row[2][:16]+"...")
45
        current_price = "{:^15}".format(row[3])
46
        original_price = "{:^18}".format(row[4])
47
        rating = "{:^10}".format(row[5])
48
        hours = "{:^10}".format(row[6])
49
        lectures = "{:^10}".format(row[7])
50
        print(title, description, instructor, current_price,
51
              original_price, rating, hours, lectures)
52

53

54
sql_fetch(con)
55