track_utils.py

import sqlite3
conn = sqlite3.connect('data.db',check_same_thread=False)
c = conn.cursor()


# Fxn
def create_page_visited_table():
    c.execute('CREATE TABLE IF NOT EXISTS pageTrackTable(pagename TEXT,timeOfvisit TIMESTAMP)')

def add_page_visited_details(pagename,timeOfvisit):
    c.execute('INSERT INTO pageTrackTable(pagename,timeOfvisit) VALUES(?,?)',(pagename,timeOfvisit))
    conn.commit()

def view_all_page_visited_details():
    c.execute('SELECT * FROM pageTrackTable')
    data = c.fetchall()
    return data


# Fxn To Track Input & Prediction
def create_fakenewsdetclf_table():
    c.execute('CREATE TABLE IF NOT EXISTS fakenewsdetclfTable(rawtext TEXT,prediction TEXT,probability NUMBER,timeOfvisit TIMESTAMP)')

def add_prediction_details(rawtext,prediction,probability,timeOfvisit):
    c.execute('INSERT INTO fakenewsdetclfTable(rawtext,prediction,probability,timeOfvisit) VALUES(?,?,?,?)',(rawtext,prediction,probability,timeOfvisit))
    conn.commit()

def view_all_prediction_details():
    c.execute('SELECT * FROM fakenewsdetclfTable')
    data = c.fetchall()
    return data