def writeFinance(): global listCompanies threading.Timer(float(720.0*len(listCompanies)), writeFinance).start() conn = MySQLdb.connect(host= "localhost", user="******", passwd="iamroot", db="statschart") x = conn.cursor() for i in listCompanies.keys(): tradePrice = financeDb(listCompanies[i][2]) insertsql = "INSERT INTO financedata(company,stockdata) VALUES ('" +str(listCompanies[i][0])+"',"+ str(tradePrice)+");" try: x.execute(insertsql) conn.commit() except: conn.rollback() conn.close()
def writeCCext(): global listCompanies threading.Timer(float((720.0)*len(listCompanies)), writeCCext).start() for i in listCompanies.keys(): ccextractorDatabase(listCompanies[i])
def writeCCext(): global listCompanies threading.Timer(float((720.0) * len(listCompanies)), writeCCext).start() for i in listCompanies.keys(): ccextractorDatabase(listCompanies[i])