Stock Analysis

#matplotlib style 
import sqlite3
import time
import datetime
import random
import matplotlib.pyplot as plt
import matplotlib.dates as mdates
from matplotlib import style
plt.style.use('fivethirtyeight')
conn=sqlite3.connect('tutorial.db')
c=conn.cursor()

def create_table():
    c.execute('CREATE TABLE IF NOT EXISTS stuffToPlot(unix REAL, datestamp TEXT, keyword TEXT, value REAL)')
def data_entry():
    c.execute('INSERT INTO stuffToPlot VALUES(145123542, "2016-01-01", "Python", 5)')
def dynamic_data_entry():
    unix=time.time();# get time stamp
    date=str(datetime.datetime.fromtimestamp(unix).strftime('%Y-%m-%d %H:%M:%S'))
    keyword='Python'
    value=random.randrange(0,10)
    c.execute("INSERT INTO stuffToPlot (unix, datestamp, keyword, value) VALUES(?,?,?,?)", (unix, date, keyword, value))
    # you can also only select only a few columns
def read_from_db():
    c.execute('SELECT * FROM stuffToPlot')
    data=c.fetchall()
    #print(data)
    for row in data:
        #print(row[0])
        print(row)
def graph_data():
    #c.execute('DELETE FROM stuffToPlot')
    c.execute('SELECT unix, value FROM stuffToPlot')
    dates=[]
    values=[]
    for row in c.fetchall():# you are only allowed to fetchall once 
        #print(row[0])
        #print(datetime.datetime.fromtimestamp(row[0]))#get date-time from unix timestamp
        dates.append(datetime.datetime.fromtimestamp(row[0]))
        values.append(row[1])
    plt.plot(dates, values, '-')
    plt.show()
def del_and_update():
    c.execute('SELECT * FROM stuffToPlot')
    [print(row)for row in c.fetchall()]
    print()
    c.execute('UPDATE stuffToPlot set value=6 WHERE value=99')
    
    c.execute('SELECT * FROM stuffToPlot')
    [print(row)for row in c.fetchall()]

#create_table()
#data_entry()
#for i in range(10):
#    dynamic_data_entry()
#    time.sleep(1)
#read_from_db()
#graph_data()
del_and_update()
conn.commit()
c.close()
conn.close()