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])
