Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- def data_entry(data_list, data_dict):
- for dl in range(len(data_dict['data_points'])):
- c.execute("INSERT INTO all_raw_data VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, "
- "?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, "
- "?, ?, ?, ?, ?, ?)", ([data_list], [data_dict['desc'], data_dict['type'],
- data_dict['job_lot'], data_dict['jntnum'], data_dict['tally'], data_dict['depth'],
- data_dict['jnt_date'], data_dict['jnt_time'],
- float(data_dict['wnd_setting'][0]), float(data_dict['wnd_setting'][1]),
- float(data_dict['wnd_setting'][2]), float(data_dict['wnd_setting'][3]),
- float(data_dict['wnd_setting'][4]), float(data_dict['wnd_setting'][5]),
- float(data_dict['wnd_setting'][6]), float(data_dict['wnd_setting'][7]),
- float(data_dict['wnd_setting'][8]), float(data_dict['wnd_setting'][9]),
- float(data_dict['wnd_setting'][10]), float(data_dict['wnd_setting'][11]),
- float(data_dict['wnd_setting'][12]), float(data_dict['wnd_setting'][13]),
- float(data_dict['wnd_setting'][14]), float(data_dict['wnd_setting'][15]),
- float(data_dict['jnt_sum'][0]), float(data_dict['jnt_sum'][1]), float(data_dict['jnt_sum'][2]),
- float(data_dict['jnt_sum'][3]), float(data_dict['jnt_sum'][4]), float(data_dict['jnt_sum'][5]),
- float(data_dict['jnt_sum'][6]), float(data_dict['jnt_sum'][7]), data_dict['jnt_sum'][8],
- float(data_dict['data_points'][dl].strip('\n').split('\t')[0]),
- float(data_dict['data_points'][dl].strip('\n').split('\t')[1]),
- float(data_dict['data_points'][dl].strip('\n').split('\t')[2]),
- float(data_dict['data_points'][dl].strip('\n').split('\t')[3])]))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement