--
-- Copyright 2021 The Android Open Source Project
--
-- 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
--
--     https://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.

SELECT RUN_METRIC(
  'android/composition_layers.sql',
  'track_name', 'HWComposer: Total Layer',
  'output', 'total_layers'
);

SELECT RUN_METRIC(
  'android/composition_layers.sql',
  'track_name', 'HWComposer: DPU Layer',
  'output', 'dpu_layers'
);

SELECT RUN_METRIC(
  'android/composition_layers.sql',
  'track_name', 'HWComposer: GPU Layer',
  'output', 'gpu_layers'
);

SELECT RUN_METRIC(
  'android/composition_layers.sql',
  'track_name', 'HWComposer: DPU Cached Layer',
  'output', 'dpu_cached_layers'
);

SELECT RUN_METRIC(
  'android/composition_layers.sql',
  'track_name', 'HWComposer: SF Cached Layer',
  'output', 'sf_cached_layers'
);

SELECT RUN_METRIC(
  'android/composer_execution.sql',
  'output', 'hwc_execution_spans'
);


SELECT RUN_METRIC('android/thread_counter_span_view.sql',
  'table_name', 'dpu_vote_clock',
  'counter_name', 'dpu_vote_clock'
);

SELECT RUN_METRIC('android/thread_counter_span_view.sql',
  'table_name', 'dpu_vote_avg_bw',
  'counter_name', 'dpu_vote_avg_bw'
);

SELECT RUN_METRIC('android/thread_counter_span_view.sql',
  'table_name', 'dpu_vote_peak_bw',
  'counter_name', 'dpu_vote_peak_bw'
);

SELECT RUN_METRIC('android/thread_counter_span_view.sql',
  'table_name', 'dpu_vote_rt_bw',
  'counter_name', 'dpu_vote_rt_bw'
);

DROP VIEW IF EXISTS dpu_vote_thread;
CREATE VIEW dpu_vote_thread AS
SELECT DISTINCT s.utid, t.tid
FROM (
  SELECT utid FROM dpu_vote_clock_span
  UNION
  SELECT utid FROM dpu_vote_avg_bw_span
  UNION
  SELECT utid FROM dpu_vote_peak_bw_span
) s JOIN thread t ON s.utid = t.utid;

DROP VIEW IF EXISTS dpu_vote_metrics;
CREATE VIEW dpu_vote_metrics AS
SELECT AndroidHwcomposerMetrics_DpuVoteMetrics(
  'tid', tid,
  'avg_dpu_vote_clock',
      (SELECT SUM(dpu_vote_clock_val * dur) / SUM(dur)
      FROM dpu_vote_clock_span s WHERE s.utid = t.utid),
  'avg_dpu_vote_avg_bw',
      (SELECT SUM(dpu_vote_avg_bw_val * dur) / SUM(dur)
      FROM dpu_vote_avg_bw_span s WHERE s.utid = t.utid),
  'avg_dpu_vote_peak_bw',
      (SELECT SUM(dpu_vote_peak_bw_val * dur) / SUM(dur)
      FROM dpu_vote_peak_bw_span s WHERE s.utid = t.utid),
  'avg_dpu_vote_rt_bw',
      (SELECT SUM(dpu_vote_rt_bw_val * dur) / SUM(dur)
      FROM dpu_vote_rt_bw_span s WHERE s.utid = t.utid)
) AS proto
FROM dpu_vote_thread t
ORDER BY tid;

DROP VIEW IF EXISTS android_hwcomposer_output;
CREATE VIEW android_hwcomposer_output AS
SELECT AndroidHwcomposerMetrics(
  'composition_total_layers', (SELECT AVG(value) FROM total_layers),
  'composition_dpu_layers', (SELECT AVG(value) FROM dpu_layers),
  'composition_gpu_layers', (SELECT AVG(value) FROM gpu_layers),
  'composition_dpu_cached_layers', (SELECT AVG(value) FROM dpu_cached_layers),
  'composition_sf_cached_layers', (SELECT AVG(value) FROM sf_cached_layers),
  'skipped_validation_count',
      (SELECT COUNT(*) FROM hwc_execution_spans
      WHERE validation_type = 'skipped_validation'),
  'unskipped_validation_count',
      (SELECT COUNT(*) FROM hwc_execution_spans
      WHERE validation_type = 'unskipped_validation'),
  'separated_validation_count',
      (SELECT COUNT(*) FROM hwc_execution_spans
      WHERE validation_type = 'separated_validation'),
  'unknown_validation_count',
      (SELECT COUNT(*) FROM hwc_execution_spans
      WHERE validation_type = 'unknown'),
  'avg_all_execution_time_ms',
      (SELECT AVG(execution_time_ns) / 1e6 FROM hwc_execution_spans
      WHERE validation_type != 'unknown'),
  'avg_skipped_execution_time_ms',
      (SELECT AVG(execution_time_ns) / 1e6 FROM hwc_execution_spans
      WHERE validation_type = 'skipped_validation'),
  'avg_unskipped_execution_time_ms',
      (SELECT AVG(execution_time_ns) / 1e6 FROM hwc_execution_spans
      WHERE validation_type = 'unskipped_validation'),
  'avg_separated_execution_time_ms',
      (SELECT AVG(execution_time_ns) / 1e6 FROM hwc_execution_spans
      WHERE validation_type = 'separated_validation'),
  'dpu_vote_metrics', (SELECT RepeatedField(proto) FROM dpu_vote_metrics)
);