Data Not Being Inserted Into Sqlite3 Database Using Python 2.7

Question

I'm having trouble inserting data into my table. I have a list of stocks that I pass to the function getStockData.

I use a for loop to iterate through the list and get the data for each ticker symbol. At the end I put all the information into a dictionary. My final step is to insert the data into a table. I've been unsuccessful at inserting the data in the dictionary into my table.

def getStockData(x):

   nowdate = raw_input("What Is Todays Date?: ")
   print "Todays list has %d stocks on it\n" % len(x)

   for stock in x:

        stockPrice = ystockquote.get_price(stock)

        stockPriceChange = ystockquote.get_change(stock)

        originalPrice = float(stockPrice) + (float(stockPriceChange) * -1)

        changePercentage = (float(stockPriceChange) / originalPrice) * 100

        stockDict = {'Date': nowdate, 'Ticker Symbol': stock, 'Closing Price': stockPrice, 
                 'Price Change': stockPriceChange, 'Percentage Changed': changePercentage} 

        conn = db.connect('stocks.db')
        cursor = conn.cursor()
        cursor.execute('insert into losers values (?, ?, ?, ?, ?)', (stockDict['Date'], stockDict['Ticker Symbol'], stockDict['Price Change'],
                                 stockDict['Percentage Changed'], stockDict['Closing Price']) )

        conn.close()

Ryan Kim · Accepted Answer · 2012-05-15 05:59:52Z

2

I think you forget to commit your data to your DB before close.

Try

conn.commit()

answered May 15, 2012 at 5:59

Ryan Kim

2581 silver badge6 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Data Not Being Inserted Into Sqlite3 Database Using Python 2.7

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related