xref: /developtools/smartperf_host/ide/src/trace/database/sql/Xpower.sql.ts

/*
 * Copyright (C) 2022 Huawei Device Co., Ltd.
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *     http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */

import { query } from '../SqlLite';
// import { XpowerStruct } from '../ui-worker/ProcedureWorkerXpower';
export const queryXpowerMeasureData = (traceId?: string): Promise<
  Array<{
    filter_id: number;
  }>
> =>
  query(
    'queryXpowerMeasureData',
    `
    select 
        name 
    from     
        measure_filter mf
    where
        mf.type = 'xpower_filter'
;
`, {}, {traceId: traceId}
  );
export const queryXpowerData = (traceId?: string): Promise<
  Array<{
    name: string;
    num: number;
    maxValue?: number;
  }>
> =>
  query(
    'queryXpowerData',
    `
    select 
        name,
        COUNT(*) num 
    from     
        measure_filter mf
    left join
        xpower_measure xm
    on
        mf.id = xm.filter_id
    where 
        mf.type = 'xpower_filter'
    group by name
;
`, {}, {traceId: traceId}
  );