def update_stock_info(self,ticker):
"""
updates stock information in database for argument ticker
"""
want = ['low', 'high', 'open', 'close', 'latestPrice', 'latestVolume']
sys.stdout = open(os.devnull, 'w')
updatedInfo = Stock(ticker).quote()
sys.stdout = sys.__stdout__
thevalues = {key:value for key, value in updatedInfo.items() if key in want}
detime = time.strftime("%H:%M")
conn = sqlite3.connect(self.db)
c = conn.cursor()
print("Opened database successfully")
print(f"the values to insert...\n{thevalues}")
print(type(thevalues['latestVolume']))
c.execute("INSERT INTO STOCKDATA VALUES (?, ?, ?, ?, ?, ?, ?, ?)", (detime, ticker, thevalues['low'], thevalues['high'], thevalues['open'], thevalues['close'], thevalues['latestPrice'], thevalues['latestVolume']))
conn.commit()
conn.close()
def update_stock_info(self,ticker):
"""
updates stock information in database for argument ticker
:type ticker : string
:param ticker : ticker name
"""
want = ['low', 'high', 'open', 'close', 'latestPrice', 'latestVolume']
sys.stdout = open(os.devnull, 'w')
updatedInfo = Stock(ticker).quote()
sys.stdout = sys.__stdout__
thevalues = {key:value for key, value in updatedInfo.items() if key in want}
detime = time.strftime("%H:%M")
conn = sqlite3.connect(self.db)
c = conn.cursor()
c.execute("INSERT INTO StockData VALUES (?, ?, ?, ?, ?, ?, ?, ?)", (detime, ticker, thevalues['low'], thevalues['high'], thevalues['open'], thevalues['close'], thevalues['latestPrice'], thevalues['latestVolume']))
conn.commit()
conn.close()