--
-- Copyright 2019 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/process_mem.sql');

SELECT RUN_METRIC('android/process_unagg_mem_view.sql',
  'table_name', 'anon_rss');

SELECT RUN_METRIC('android/process_unagg_mem_view.sql',
  'table_name', 'swap');

SELECT RUN_METRIC('android/process_unagg_mem_view.sql',
  'table_name', 'file_rss');

SELECT RUN_METRIC('android/process_unagg_mem_view.sql',
  'table_name', 'anon_and_swap');

DROP VIEW IF EXISTS process_unagg_metrics_view;
CREATE VIEW process_unagg_metrics_view AS
SELECT
  AndroidMemoryUnaggregatedMetric_ProcessValues(
    'process_name', process.name,
    'mem_values', AndroidMemoryUnaggregatedMetric_ProcessMemoryValues(
      'anon_rss', anon_rss_unagg_values.metric,
      'swap', swap_unagg_values.metric,
      'file_rss', file_rss_unagg_values.metric,
      'anon_and_swap', anon_and_swap_unagg_values.metric
    )
  ) AS metric
FROM
  process
LEFT JOIN
  anon_rss_unagg_values USING(upid)
LEFT JOIN
  swap_unagg_values USING(upid)
LEFT JOIN
  file_rss_unagg_values USING(upid)
LEFT JOIN
  anon_and_swap_unagg_values USING(upid)
WHERE
  process.name IS NOT NULL;

DROP VIEW IF EXISTS android_mem_unagg_output;
CREATE VIEW android_mem_unagg_output AS
SELECT
  AndroidMemoryUnaggregatedMetric(
    'process_values',
    (SELECT RepeatedField(metric) FROM process_unagg_metrics_view)
  );