Amazing-Python-Scripts

1
import sqlite3
2
import os
3

4

5
def sql_connection():
6
    """
7
    Establishes a connection to the SQL file database
8
    :return connection object:
9
    """
10
    path = os.path.abspath('SubredditDatabase.db')
11
    con = sqlite3.connect(path)
12
    return con
13

14

15
def sql_fetcher(con):
16
    """
17
    Fetches all the tweets with the given hashtag from our database
18
    :param con:
19
    :return:
20
    """
21
    subreddit = input("\nEnter subreddit to search: r/")
22
    count = 0
23
    cur = con.cursor()
24
    cur.execute('SELECT * FROM posts')  # SQL search query
25
    rows = cur.fetchall()
26

27
    for r in rows:
28
        if subreddit in r:
29
            count += 1
30
            print(f'\nTAG: {r[1]}\nPOST TITLE: {r[2]}\nAUTHOR: {r[3]}\n'
31
                  f'TIME STAMP: {r[4]}\nUPVOTES: {r[5]}\nCOMMENTS: {r[6]}'
32
                  f'\nURL: {r[7]}\n')
33

34
    if count:
35
        print(f'{count} posts fetched from database\n')
36
    else:
37
        print('\nNo posts stored for this subreddit\n')
38

39

40
con = sql_connection()
41

42
while 1:
43
    sql_fetcher(con)
44

45
    ans = input('\nPress (y) to continue or any other key to exit: ').lower()
46
    if ans == 'y':
47
        continue
48
    else:
49
        print('\nExiting..\n')
50
        break
51