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)