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