p3 = money_info[3]
p4 = money_info[4]
p5 = money_info[5]
p6 = money_info[6]
p7 = money_info[7]
p8 = money_info[8]
params = {
"name": name,
"sid": sid,
"price": price,
"time_point": time_point,
"date": today,
"zdf": zdf,
"pre": pre,
"volume": volume,
"p1": p1,
"p2": p2,
"p3": p3,
"p4": p4,
"p5": p5,
"p6": p6,
"p7": p7,
"p8": p8
}
sql = 'insert into tan_stock_record values(null,%(name)s,%(sid)s,%(price)s,%(time_point)s,%(date)s,%(zdf)s,%(pre)s,%(volume)s,' \
'%(p1)s,%(p2)s,%(p3)s,%(p4)s,%(p5)s,%(p6)s,%(p7)s,%(p8)s)'
helper.insert(sql, params)
k += 1
time.sleep(60)
if (is_float(item['yy_hb'])):
pass
else:
item['yy_hb'] = 0
if (is_float(item['lr_tb'])):
pass
else:
item['lr_tb'] = 0
if (is_float(item['lr_hb'])):
pass
else:
item['lr_hb'] = 0
sql = 'insert into tan_report values(null,%(sid)s,%(sname)s,%(time_date)s,%(yy_tb)s,%(yy_hb)s,%(lr_tb)s,%(lr_hb)s)'
helper.insert(sql,item)
time.sleep(65)
# for one_point in data_arr:
# info = one_point.split(',')
# time_point = int(info[0])
# price = float(info[1])
# zdf = round((price-pre)/pre*100,2)
# volume = int(info[4])
# params = {"name": name, "sid": sid, "price": price,"time_point":time_point, "date": today,"zdf":zdf,"pre":pre,"volume":volume}
# sql = 'insert into tan_plate_record values(null,%(name)s,%(sid)s,%(price)s,%(time_point)s,%(date)s,%(zdf)s,%(pre)s,%(volume)s)'
# print(params)
# helper.insert(sql,params)
#print(helper)