Advertisement
Guest User

Untitled

a guest
Jun 21st, 2018
71
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 2.20 KB | None | 0 0
  1. def data_entry(data_list, data_dict):
  2.  
  3.     for dl in range(len(data_dict['data_points'])):
  4.  
  5.         c.execute("INSERT INTO all_raw_data VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, "
  6.                   "?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, "
  7.                   "?, ?, ?, ?, ?, ?)", ([data_list], [data_dict['desc'], data_dict['type'],
  8.                                 data_dict['job_lot'], data_dict['jntnum'], data_dict['tally'], data_dict['depth'],
  9.                                 data_dict['jnt_date'], data_dict['jnt_time'],
  10.                                 float(data_dict['wnd_setting'][0]), float(data_dict['wnd_setting'][1]),
  11.                                 float(data_dict['wnd_setting'][2]), float(data_dict['wnd_setting'][3]),
  12.                                 float(data_dict['wnd_setting'][4]), float(data_dict['wnd_setting'][5]),
  13.                                 float(data_dict['wnd_setting'][6]), float(data_dict['wnd_setting'][7]),
  14.                                 float(data_dict['wnd_setting'][8]), float(data_dict['wnd_setting'][9]),
  15.                                 float(data_dict['wnd_setting'][10]), float(data_dict['wnd_setting'][11]),
  16.                                 float(data_dict['wnd_setting'][12]), float(data_dict['wnd_setting'][13]),
  17.                                 float(data_dict['wnd_setting'][14]), float(data_dict['wnd_setting'][15]),
  18.                                 float(data_dict['jnt_sum'][0]), float(data_dict['jnt_sum'][1]), float(data_dict['jnt_sum'][2]),
  19.                                 float(data_dict['jnt_sum'][3]), float(data_dict['jnt_sum'][4]), float(data_dict['jnt_sum'][5]),
  20.                                 float(data_dict['jnt_sum'][6]), float(data_dict['jnt_sum'][7]), data_dict['jnt_sum'][8],
  21.                                 float(data_dict['data_points'][dl].strip('\n').split('\t')[0]),
  22.                                 float(data_dict['data_points'][dl].strip('\n').split('\t')[1]),
  23.                                 float(data_dict['data_points'][dl].strip('\n').split('\t')[2]),
  24.                                 float(data_dict['data_points'][dl].strip('\n').split('\t')[3])]))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement