def insertStock(stock):
conn = db.createConnection(database)
count = db.assertStockEntry(conn, stock[0], stock[1])
if (len(count) == 0):
stocks = db.createStock(conn, stock)
conn.commit()
conn.close()
def insertETF(etf):
conn = db.createConnection(database)
count = db.assertETFEntry(conn, etf[0], etf[1])
if (len(count) == 0):
stocks = db.createETF(conn, etf)
conn.commit()
conn.close()
def getStockByTicker(stock):
conn = db.createConnection(database)
stocks = db.selectStockByTicker(conn, stock)
conn.commit()
conn.close()
for item in stocks:
list = [isNumber(i) for i in item]
print(list)
def getAllStocks():
conn = db.createConnection(database)
stocks = db.selectAllStocks(conn)
conn.commit()
conn.close()
for item in stocks:
list = [isNumber(i) for i in item]
print(list)
def createETFsTable():
sqlCreateETFsTable = """ CREATE TABLE IF NOT EXISTS etfs (
id integer PRIMARY KEY,
name text NOT NULL,
date text NOT NULL,
open real,
high real,
low real,
close real,
volume real
); """
conn = db.createConnection(database)
db.createTable(conn, sqlCreateETFsTable)
conn.commit()
conn.close()