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}
