def load_all_lines():
# 读取txt
# 返回所有曲线的数据
# 数据类型为np.array类型
all_tds = Td.all()
lines = []
for i in range(len(all_tds)):
line = []
arr_rd = []
arr_td = []
td = all_tds[i]
td = td.json()
title = td.get('td', '')
list_rD = td.get('list_rD', '')
list_TD = td.get('list_TD', '')
arr_rd = str_to_float_arr(list_rD)
arr_td = str_to_float_arr(list_TD)
# return arr_rd, arr_td
# 将曲线数据转化为np.array类型
arr_rd = np.array(arr_rd)
arr_td = np.array(arr_td)
# 将曲线 td list_rD list_TD 数据放到line中
line.append(title)
line.append(arr_rd)
line.append(arr_td)
lines.append(line)
return lines
def delete_all():
# 删除所有的td信息
# 1.返回所有的td类
# 2.根据td类的id 删除td类(id是不重复的)
tds = Td.all()
rs = []
for t in tds:
d = Td.delete(t.id)
rs.append(d)
log("删除了({})个td, 所有的td= ({})".format(len(tds), rs))
return "删除了({})个td, 所有的td= ({})".format(len(tds), rs)
pass
def write_xlsx():
# 1. 加载json文件
# 2. 将json文件写入到.xlsx中
# 创建一个新的工作表簿
all_tds = Td.all()
# log('all_td ({})'.format(all_tds))
workbook = openpyxl.Workbook()
# 获取表格的默认工作表
sheet = workbook.active
# 设置工作表的凑题
sheet.title = '三条tD曲线数据'
# 写入表头与内容
column = 'ABCDEFGHIJKLMNOPQRSTUVWXYZ'
j = 0
for i in range(len(all_tds)):
arr_rd = []
arr_td = []
td = all_tds[i]
td = td.json()
tp = column[j] + str(1)
rdp = column[j] + str(2)
tdp = column[j + 1] + str(2)
title = td.get('td', '')
title = 'td =' + title
list_rD = td.get('list_rD', '')
list_TD = td.get('list_TD', '')
arr_rd = str_to_float_arr(list_rD)
arr_td = str_to_float_arr(list_TD)
# 将数据写入sheet
write_one_td(wb=sheet, rd=arr_rd, td=arr_td, col=j + 1, titl=title)
j += 2
# log('arr_rd({}) arr_td({})'.format(arr_rd, arr_td), i)
# 保存到 .xlsx 文件中
workbook.save('({})条曲线数据 .xlsx'.format(len(all_tds)))