spacepaste

  1.  
  2. column_str = "ticker, instrument, name, sector, currency, created_date, last_updated_date"
  3. insert_str = ("%s, " * 7)[:-2]
  4. final_str = "INSERT INTO SYMBOL (%s) VALUES (%s);" % (column_str, insert_str)
  5. try:
  6. con = connectToDatabase()
  7. logging.info(str(now) + " Connected!")
  8. except:
  9. logging.exception(str(now) + " Unable to connect to Database. Exiting.")
  10. exit()
  11. cursor = con.cursor();
  12. for i in range(0, int(ceil(len(symbols) / 100.0))):
  13. cursor.executemany(final_str, symbols[i*100:(i+1)*100-1])
  14.