1#!/usr/bin/env python3 2# Copyright (C) 2024 The Android Open Source Project 3# 4# Licensed under the Apache License, Version 2.0 (the "License"); 5# you may not use this file except in compliance with the License. 6# You may obtain a copy of the License a 7# 8# http://www.apache.org/licenses/LICENSE-2.0 9# 10# Unless required by applicable law or agreed to in writing, software 11# distributed under the License is distributed on an "AS IS" BASIS, 12# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. 13# See the License for the specific language governing permissions and 14# limitations under the License. 15 16from python.generators.diff_tests.testing import DataPath 17from python.generators.diff_tests.testing import Csv 18from python.generators.diff_tests.testing import DiffTestBlueprint 19from python.generators.diff_tests.testing import TestSuite 20 21 22class GraphPartitionTests(TestSuite): 23 24 def test_tree_structural_partition(self): 25 return DiffTestBlueprint( 26 trace=DataPath('counters.json'), 27 query=""" 28 INCLUDE PERFETTO MODULE graphs.partition; 29 30 -- See the comment in the graphs.partition module for a visual 31 -- representation of this graph. 32 CREATE PERFETTO TABLE foo AS 33 WITH data(id, parent_id, group_key) AS ( 34 VALUES 35 (1, NULL, 1), 36 (2, 1, 1), 37 (3, 2, 2), 38 (4, 2, 2), 39 (5, 4, 1), 40 (6, 4, 3), 41 (7, 4, 2), 42 (8, 4, 1) 43 ) 44 SELECT * FROM data; 45 46 SELECT * 47 FROM tree_structural_partition_by_group!(foo) 48 ORDER BY id; 49 """, 50 out=Csv(""" 51 "id","parent_id","group_key" 52 1,"[NULL]",1 53 2,1,1 54 3,"[NULL]",2 55 4,"[NULL]",2 56 5,2,1 57 6,"[NULL]",3 58 7,4,2 59 8,2,1 60 """)) 61