<filename>ExtractMetaDataApp/db_fxns.py
# DataBase Management
import sqlite3 
conn = sqlite3.connect('data.db')
c = conn.cursor()

# Table
def create_uploaded_filetable():
	c.execute('CREATE TABLE IF NOT EXISTS filestable(filename TEXT,filetype TEXT,filesize TEXT,uploadDate TIMESTAMP)')


# Adding Details
def add_file_details(filename,filetype,filesize,uploadDate):
	c.execute('INSERT INTO filestable(filename,filetype,filesize,uploadDate) VALUES (?,?,?,?)',(filename,filetype,filesize,uploadDate))
	conn.commit()

# View Details
def view_all_data():
	c.execute('SELECT * FROM filestable')
	data = c.fetchall()
	return data


<filename>ExtractMetaDataApp/db_fxns.py
# DataBase Management
import sqlite3 
conn = sqlite3.connect('data.db')
c = conn.cursor()

# Table
def create_uploaded_filetable():
	c.execute('CREATE TABLE IF NOT EXISTS filestable(filename TEXT,filetype TEXT,filesize TEXT,uploadDate TIMESTAMP)')


# Adding Details
def add_file_details(filename,filetype,filesize,uploadDate):
	c.execute('INSERT INTO filestable(filename,filetype,filesize,uploadDate) VALUES (?,?,?,?)',(filename,filetype,filesize,uploadDate))
	conn.commit()

# View Details
def view_all_data():
	c.execute('SELECT * FROM filestable')
	data = c.fetchall()
	return data


# DataBase Management # Table # Adding Details # View Details