def save_simple_data(project_id, data): try: table_name = "sample_table" db = DBConn() db.delete(table_name, {'project_id': project_id}) for row in data: row['project_id'] = project_id db.insert(table_name, row) ret = {'data': '', 'errcode': 0, 'msg': ''} except Exception, e: import traceback traceback.print_exc() ret = {'data': '', 'errcode': 1, 'msg': '%s DB issue!' % e}
def save_compare_input(all_info, username, project_id, action='new'): current_time = datetime.datetime.now() save_compare_text(project_id, all_info, str(current_time)) db_instance = DBConn() project_log = get_project_log_by_num(db_instance, project_id) all_info['project_id'] = project_id cmd = "select id from analysis_master where created_by='%s' and project_id=%s" % (username, project_id) result = db_instance.execute(cmd, get_all=False) if result: action = 'update' master_id = result[0] db_instance.delete('sample_packet_information', {'master_id': master_id}) db_instance.delete('compare_table', {'master_id': master_id}) sample_packet_information = all_info['sample_packet_information'] compare_table = all_info['compare_table'] del all_info['sample_packet_information'] del all_info['compare_table'] all_info['updated_by'] = username all_info['update_time'] = current_time if action == 'new': all_info['create_time'] = current_time all_info['created_by'] = username master_id = db_instance.insert('analysis_master', all_info) project_log += '\n%s: %s created compare method.\n' % (current_time, username) db_instance.update('sample_project_master', {'id': project_id}, {'project_log': project_log}) else: project_log += '\n%s: %s update compare method.\n' % (current_time, username) db_instance.update('sample_project_master', {'id': project_id}, {'project_log': project_log}) db_instance.update('analysis_master', {'id': master_id}, all_info) for row in sample_packet_information: del row['id'] row['master_id'] = master_id db_instance.insert('sample_packet_information', row) for row in compare_table: del row['id'] row['master_id'] = master_id db_instance.insert('compare_table', row) msg = '更新成功!' if action == 'update' else '保存成功!' return {'data': '', 'errcode': 0, 'msg': msg}
def save_compare_input(all_info, username, selected_project, action='new'): time = datetime.datetime.now() db_instance = DBConn() project_number = selected_project.split('-')[-1] project_id = get_project_id_by_num(db_instance, project_number) all_info['project_id'] = project_id cmd = "select id from analysis_master where created_by='%s' and project_id=%s" % (username, project_id) result = db_instance.execute(cmd, get_all=False) if result: action = 'update' master_id = result[0] db_instance.delete('sample_packet_information', {'master_id': master_id}) db_instance.delete('compare_table', {'master_id': master_id}) sample_packet_information = all_info['sample_packet_information'] compare_table = all_info['compare_table'] del all_info['sample_packet_information'] del all_info['compare_table'] all_info['updated_by'] = username all_info['update_time'] = time if action == 'new': all_info['create_time'] = time all_info['created_by'] = username master_id = db_instance.insert('analysis_master', all_info) else: db_instance.update('analysis_master', {'id': master_id}, all_info) for row in sample_packet_information: del row['id'] row['master_id'] = master_id db_instance.insert('sample_packet_information', row) for row in compare_table: del row['id'] row['master_id'] = master_id db_instance.insert('compare_table', row) save_compare_text(selected_project, compare_table) msg = '更新成功!' if action == 'update' else '保存成功!' return {'data': '', 'errcode': 0, 'msg': msg}