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()