Compressor/backend/console.sql

select device_part, device_point, measurement_type,point_name,min(sample_time) minTime,max(sample_time) maxTime, count(*)
from wave_file
where rpm>0
group by device_part, device_point,measurement_type,point_name


select point_name, measurement_type, min(sample_time) minTime,max(sample_time) maxTime, count(*)
from wave_file
where point_name like '8号机%'
group by measurement_type,point_name

select point_name, measurement_type,count(*)
from wave_file
where   rpm>0
group by measurement_type,point_name


select sample_time
from  wave_file
where point_name='7号机组一缸压力盖侧' and measurement_type='压力'
order by sample_time desc

select sample_index,signal_value,second_value
from wave_sample_one where wave_file_id=1572
order by sample_index asc

# 查找第一个有压力数据的文件
select *
from  wave_file
where point_name='7号机组一缸压力盖侧' and measurement_type='压力'
and rpm>0
order by sample_time asc
limit 2

# 7号机组一缸压力盖侧 压力 数据
select * from wave_sample_one where wave_file_id=288146 order by wave_file_id,sample_index

# 8号机组一缸压力盖侧 压力 数据
select * from wave_sample_one where wave_file_id in(360903, 360904) order by wave_file_id,sample_index

# 9号机组一缸压力盖侧 压力 数据
select * from wave_sample_one where wave_file_id in(434810, 434968) order by wave_file_id,sample_index


select min(tspluse_status),max(tspluse_status)
from wave_file
where rpm>0 and measurement_type='压力'



SELECT t.*
FROM pks_long_sample t
INNER JOIN compressor_data_import i on i.id = t.import_batch_id
WHERE i.directory_path='8#' and sample_time>'2026-07-21 16:14:00'
LIMIT 501


select count(*)
from wave_file
where rpm>0 and measurement_type='压力' and tspluse_status=0
order by sample_time asc

# 增加标注故障预测字段，标注之前的小模型通用简单自动标注
alter table wave_file add tspluse_status tinyint null default 0;
alter table wave_file
    modify tspluse_status tinyint default 0 null comment '标注之前的小模型通用简单自动标注，0 没有异常，大于0有异常';

select * from machine_run_status order by import_batch_id,status_start