1*b0d29bc4SBrooks Davis-- Copyright 2013 The Kyua Authors. 2*b0d29bc4SBrooks Davis-- All rights reserved. 3*b0d29bc4SBrooks Davis-- 4*b0d29bc4SBrooks Davis-- Redistribution and use in source and binary forms, with or without 5*b0d29bc4SBrooks Davis-- modification, are permitted provided that the following conditions are 6*b0d29bc4SBrooks Davis-- met: 7*b0d29bc4SBrooks Davis-- 8*b0d29bc4SBrooks Davis-- * Redistributions of source code must retain the above copyright 9*b0d29bc4SBrooks Davis-- notice, this list of conditions and the following disclaimer. 10*b0d29bc4SBrooks Davis-- * Redistributions in binary form must reproduce the above copyright 11*b0d29bc4SBrooks Davis-- notice, this list of conditions and the following disclaimer in the 12*b0d29bc4SBrooks Davis-- documentation and/or other materials provided with the distribution. 13*b0d29bc4SBrooks Davis-- * Neither the name of Google Inc. nor the names of its contributors 14*b0d29bc4SBrooks Davis-- may be used to endorse or promote products derived from this software 15*b0d29bc4SBrooks Davis-- without specific prior written permission. 16*b0d29bc4SBrooks Davis-- 17*b0d29bc4SBrooks Davis-- THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS 18*b0d29bc4SBrooks Davis-- "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT 19*b0d29bc4SBrooks Davis-- LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR 20*b0d29bc4SBrooks Davis-- A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT 21*b0d29bc4SBrooks Davis-- OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, 22*b0d29bc4SBrooks Davis-- SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT 23*b0d29bc4SBrooks Davis-- LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, 24*b0d29bc4SBrooks Davis-- DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY 25*b0d29bc4SBrooks Davis-- THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT 26*b0d29bc4SBrooks Davis-- (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE 27*b0d29bc4SBrooks Davis-- OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. 28*b0d29bc4SBrooks Davis 29*b0d29bc4SBrooks Davis-- \file store/testdata_v2.sql 30*b0d29bc4SBrooks Davis-- Populates a v2 database with some test data. 31*b0d29bc4SBrooks Davis 32*b0d29bc4SBrooks Davis 33*b0d29bc4SBrooks DavisBEGIN TRANSACTION; 34*b0d29bc4SBrooks Davis 35*b0d29bc4SBrooks Davis 36*b0d29bc4SBrooks Davis-- 37*b0d29bc4SBrooks Davis-- Action 1: Empty context and no test programs nor test cases. 38*b0d29bc4SBrooks Davis-- 39*b0d29bc4SBrooks Davis 40*b0d29bc4SBrooks Davis 41*b0d29bc4SBrooks Davis-- context_id 1 42*b0d29bc4SBrooks DavisINSERT INTO contexts (context_id, cwd) VALUES (1, '/some/root'); 43*b0d29bc4SBrooks Davis 44*b0d29bc4SBrooks Davis-- action_id 1 45*b0d29bc4SBrooks DavisINSERT INTO actions (action_id, context_id) VALUES (1, 1); 46*b0d29bc4SBrooks Davis 47*b0d29bc4SBrooks Davis 48*b0d29bc4SBrooks Davis-- 49*b0d29bc4SBrooks Davis-- Action 2: Plain test programs only. 50*b0d29bc4SBrooks Davis-- 51*b0d29bc4SBrooks Davis-- This action contains 5 test programs, each with one test case, and each 52*b0d29bc4SBrooks Davis-- reporting one of all possible result types. 53*b0d29bc4SBrooks Davis-- 54*b0d29bc4SBrooks Davis 55*b0d29bc4SBrooks Davis 56*b0d29bc4SBrooks Davis-- context_id 2 57*b0d29bc4SBrooks DavisINSERT INTO contexts (context_id, cwd) VALUES (2, '/test/suite/root'); 58*b0d29bc4SBrooks DavisINSERT INTO env_vars (context_id, var_name, var_value) 59*b0d29bc4SBrooks Davis VALUES (2, 'HOME', '/home/test'); 60*b0d29bc4SBrooks DavisINSERT INTO env_vars (context_id, var_name, var_value) 61*b0d29bc4SBrooks Davis VALUES (2, 'PATH', '/bin:/usr/bin'); 62*b0d29bc4SBrooks Davis 63*b0d29bc4SBrooks Davis-- action_id 2 64*b0d29bc4SBrooks DavisINSERT INTO actions (action_id, context_id) VALUES (2, 2); 65*b0d29bc4SBrooks Davis 66*b0d29bc4SBrooks Davis-- metadata_id 1 67*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (1, 'allowed_architectures', ''); 68*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (1, 'allowed_platforms', ''); 69*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (1, 'description', ''); 70*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (1, 'has_cleanup', 'false'); 71*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (1, 'required_configs', ''); 72*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (1, 'required_files', ''); 73*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (1, 'required_memory', '0'); 74*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (1, 'required_programs', ''); 75*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (1, 'required_user', ''); 76*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (1, 'timeout', '300'); 77*b0d29bc4SBrooks Davis 78*b0d29bc4SBrooks Davis-- test_program_id 1 79*b0d29bc4SBrooks DavisINSERT INTO test_programs (test_program_id, action_id, absolute_path, root, 80*b0d29bc4SBrooks Davis relative_path, test_suite_name, metadata_id, 81*b0d29bc4SBrooks Davis interface) 82*b0d29bc4SBrooks Davis VALUES (1, 2, '/test/suite/root/foo_test', '/test/suite/root', 83*b0d29bc4SBrooks Davis 'foo_test', 'suite-name', 1, 'plain'); 84*b0d29bc4SBrooks Davis 85*b0d29bc4SBrooks Davis-- test_case_id 1 86*b0d29bc4SBrooks DavisINSERT INTO test_cases (test_case_id, test_program_id, name, metadata_id) 87*b0d29bc4SBrooks Davis VALUES (1, 1, 'main', 1); 88*b0d29bc4SBrooks DavisINSERT INTO test_results (test_case_id, result_type, result_reason, start_time, 89*b0d29bc4SBrooks Davis end_time) 90*b0d29bc4SBrooks Davis VALUES (1, 'passed', NULL, 1357643611000000, 1357643621000500); 91*b0d29bc4SBrooks Davis 92*b0d29bc4SBrooks Davis-- metadata_id 2 93*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (2, 'allowed_architectures', ''); 94*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (2, 'allowed_platforms', ''); 95*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (2, 'description', ''); 96*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (2, 'has_cleanup', 'false'); 97*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (2, 'required_configs', ''); 98*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (2, 'required_files', ''); 99*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (2, 'required_memory', '0'); 100*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (2, 'required_programs', ''); 101*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (2, 'required_user', ''); 102*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (2, 'timeout', '10'); 103*b0d29bc4SBrooks Davis 104*b0d29bc4SBrooks Davis-- test_program_id 2 105*b0d29bc4SBrooks DavisINSERT INTO test_programs (test_program_id, action_id, absolute_path, root, 106*b0d29bc4SBrooks Davis relative_path, test_suite_name, metadata_id, 107*b0d29bc4SBrooks Davis interface) 108*b0d29bc4SBrooks Davis VALUES (2, 2, '/test/suite/root/subdir/another_test', '/test/suite/root', 109*b0d29bc4SBrooks Davis 'subdir/another_test', 'subsuite-name', 2, 'plain'); 110*b0d29bc4SBrooks Davis 111*b0d29bc4SBrooks Davis-- test_case_id 2 112*b0d29bc4SBrooks DavisINSERT INTO test_cases (test_case_id, test_program_id, name, metadata_id) 113*b0d29bc4SBrooks Davis VALUES (2, 2, 'main', 2); 114*b0d29bc4SBrooks DavisINSERT INTO test_results (test_case_id, result_type, result_reason, start_time, 115*b0d29bc4SBrooks Davis end_time) 116*b0d29bc4SBrooks Davis VALUES (2, 'failed', 'Exited with code 1', 117*b0d29bc4SBrooks Davis 1357643622001200, 1357643622900021); 118*b0d29bc4SBrooks Davis 119*b0d29bc4SBrooks Davis-- file_id 1 120*b0d29bc4SBrooks DavisINSERT INTO files (file_id, contents) VALUES (1, x'54657374207374646f7574'); 121*b0d29bc4SBrooks DavisINSERT INTO test_case_files (test_case_id, file_name, file_id) 122*b0d29bc4SBrooks Davis VALUES (2, '__STDOUT__', 1); 123*b0d29bc4SBrooks Davis 124*b0d29bc4SBrooks Davis-- file_id 2 125*b0d29bc4SBrooks DavisINSERT INTO files (file_id, contents) VALUES (2, x'5465737420737464657272'); 126*b0d29bc4SBrooks DavisINSERT INTO test_case_files (test_case_id, file_name, file_id) 127*b0d29bc4SBrooks Davis VALUES (2, '__STDERR__', 2); 128*b0d29bc4SBrooks Davis 129*b0d29bc4SBrooks Davis-- metadata_id 3 130*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (3, 'allowed_architectures', ''); 131*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (3, 'allowed_platforms', ''); 132*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (3, 'description', ''); 133*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (3, 'has_cleanup', 'false'); 134*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (3, 'required_configs', ''); 135*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (3, 'required_files', ''); 136*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (3, 'required_memory', '0'); 137*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (3, 'required_programs', ''); 138*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (3, 'required_user', ''); 139*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (3, 'timeout', '300'); 140*b0d29bc4SBrooks Davis 141*b0d29bc4SBrooks Davis-- test_program_id 3 142*b0d29bc4SBrooks DavisINSERT INTO test_programs (test_program_id, action_id, absolute_path, root, 143*b0d29bc4SBrooks Davis relative_path, test_suite_name, metadata_id, 144*b0d29bc4SBrooks Davis interface) 145*b0d29bc4SBrooks Davis VALUES (3, 2, '/test/suite/root/subdir/bar_test', '/test/suite/root', 146*b0d29bc4SBrooks Davis 'subdir/bar_test', 'subsuite-name', 3, 'plain'); 147*b0d29bc4SBrooks Davis 148*b0d29bc4SBrooks Davis-- test_case_id 3 149*b0d29bc4SBrooks DavisINSERT INTO test_cases (test_case_id, test_program_id, name, metadata_id) 150*b0d29bc4SBrooks Davis VALUES (3, 3, 'main', 3); 151*b0d29bc4SBrooks DavisINSERT INTO test_results (test_case_id, result_type, result_reason, start_time, 152*b0d29bc4SBrooks Davis end_time) 153*b0d29bc4SBrooks Davis VALUES (3, 'broken', 'Received signal 1', 154*b0d29bc4SBrooks Davis 1357643623500000, 1357643630981932); 155*b0d29bc4SBrooks Davis 156*b0d29bc4SBrooks Davis-- metadata_id 4 157*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (4, 'allowed_architectures', ''); 158*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (4, 'allowed_platforms', ''); 159*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (4, 'description', ''); 160*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (4, 'has_cleanup', 'false'); 161*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (4, 'required_configs', ''); 162*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (4, 'required_files', ''); 163*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (4, 'required_memory', '0'); 164*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (4, 'required_programs', ''); 165*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (4, 'required_user', ''); 166*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (4, 'timeout', '300'); 167*b0d29bc4SBrooks Davis 168*b0d29bc4SBrooks Davis-- test_program_id 4 169*b0d29bc4SBrooks DavisINSERT INTO test_programs (test_program_id, action_id, absolute_path, root, 170*b0d29bc4SBrooks Davis relative_path, test_suite_name, metadata_id, 171*b0d29bc4SBrooks Davis interface) 172*b0d29bc4SBrooks Davis VALUES (4, 2, '/test/suite/root/top_test', '/test/suite/root', 173*b0d29bc4SBrooks Davis 'top_test', 'suite-name', 4, 'plain'); 174*b0d29bc4SBrooks Davis 175*b0d29bc4SBrooks Davis-- test_case_id 4 176*b0d29bc4SBrooks DavisINSERT INTO test_cases (test_case_id, test_program_id, name, metadata_id) 177*b0d29bc4SBrooks Davis VALUES (4, 4, 'main', 4); 178*b0d29bc4SBrooks DavisINSERT INTO test_results (test_case_id, result_type, result_reason, start_time, 179*b0d29bc4SBrooks Davis end_time) 180*b0d29bc4SBrooks Davis VALUES (4, 'expected_failure', 'Known bug', 181*b0d29bc4SBrooks Davis 1357643631000000, 1357643631020000); 182*b0d29bc4SBrooks Davis 183*b0d29bc4SBrooks Davis-- metadata_id 5 184*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (5, 'allowed_architectures', ''); 185*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (5, 'allowed_platforms', ''); 186*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (5, 'description', ''); 187*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (5, 'has_cleanup', 'false'); 188*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (5, 'required_configs', ''); 189*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (5, 'required_files', ''); 190*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (5, 'required_memory', '0'); 191*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (5, 'required_programs', ''); 192*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (5, 'required_user', ''); 193*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (5, 'timeout', '300'); 194*b0d29bc4SBrooks Davis 195*b0d29bc4SBrooks Davis-- test_program_id 5 196*b0d29bc4SBrooks DavisINSERT INTO test_programs (test_program_id, action_id, absolute_path, root, 197*b0d29bc4SBrooks Davis relative_path, test_suite_name, metadata_id, 198*b0d29bc4SBrooks Davis interface) 199*b0d29bc4SBrooks Davis VALUES (5, 2, '/test/suite/root/last_test', '/test/suite/root', 200*b0d29bc4SBrooks Davis 'last_test', 'suite-name', 5, 'plain'); 201*b0d29bc4SBrooks Davis 202*b0d29bc4SBrooks Davis-- test_case_id 5 203*b0d29bc4SBrooks DavisINSERT INTO test_cases (test_case_id, test_program_id, name, metadata_id) 204*b0d29bc4SBrooks Davis VALUES (5, 5, 'main', 5); 205*b0d29bc4SBrooks DavisINSERT INTO test_results (test_case_id, result_type, result_reason, start_time, 206*b0d29bc4SBrooks Davis end_time) 207*b0d29bc4SBrooks Davis VALUES (5, 'skipped', 'Does not apply', 1357643632000000, 1357643638000000); 208*b0d29bc4SBrooks Davis 209*b0d29bc4SBrooks Davis 210*b0d29bc4SBrooks Davis-- 211*b0d29bc4SBrooks Davis-- Action 3: ATF test programs only. 212*b0d29bc4SBrooks Davis-- 213*b0d29bc4SBrooks Davis 214*b0d29bc4SBrooks Davis 215*b0d29bc4SBrooks Davis-- context_id 3 216*b0d29bc4SBrooks DavisINSERT INTO contexts (context_id, cwd) VALUES (3, '/usr/tests'); 217*b0d29bc4SBrooks DavisINSERT INTO env_vars (context_id, var_name, var_value) 218*b0d29bc4SBrooks Davis VALUES (3, 'PATH', '/bin:/usr/bin'); 219*b0d29bc4SBrooks Davis 220*b0d29bc4SBrooks Davis-- action_id 3 221*b0d29bc4SBrooks DavisINSERT INTO actions (action_id, context_id) VALUES (3, 3); 222*b0d29bc4SBrooks Davis 223*b0d29bc4SBrooks Davis-- metadata_id 6 224*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (6, 'allowed_architectures', ''); 225*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (6, 'allowed_platforms', ''); 226*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (6, 'description', ''); 227*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (6, 'has_cleanup', 'false'); 228*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (6, 'required_configs', ''); 229*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (6, 'required_files', ''); 230*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (6, 'required_memory', '0'); 231*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (6, 'required_programs', ''); 232*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (6, 'required_user', ''); 233*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (6, 'timeout', '300'); 234*b0d29bc4SBrooks Davis 235*b0d29bc4SBrooks Davis-- test_program_id 6 236*b0d29bc4SBrooks DavisINSERT INTO test_programs (test_program_id, action_id, absolute_path, root, 237*b0d29bc4SBrooks Davis relative_path, test_suite_name, metadata_id, 238*b0d29bc4SBrooks Davis interface) 239*b0d29bc4SBrooks Davis VALUES (6, 3, '/usr/tests/complex_test', '/usr/tests', 240*b0d29bc4SBrooks Davis 'complex_test', 'suite-name', 6, 'atf'); 241*b0d29bc4SBrooks Davis 242*b0d29bc4SBrooks Davis-- metadata_id 7 243*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (7, 'allowed_architectures', ''); 244*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (7, 'allowed_platforms', ''); 245*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (7, 'description', ''); 246*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (7, 'has_cleanup', 'false'); 247*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (7, 'required_configs', ''); 248*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (7, 'required_files', ''); 249*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (7, 'required_memory', '0'); 250*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (7, 'required_programs', ''); 251*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (7, 'required_user', ''); 252*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (7, 'timeout', '300'); 253*b0d29bc4SBrooks Davis 254*b0d29bc4SBrooks Davis-- test_case_id 6, passed, no optional metadata. 255*b0d29bc4SBrooks DavisINSERT INTO test_cases (test_case_id, test_program_id, name, metadata_id) 256*b0d29bc4SBrooks Davis VALUES (6, 6, 'this_passes', 7); 257*b0d29bc4SBrooks DavisINSERT INTO test_results (test_case_id, result_type, result_reason, start_time, 258*b0d29bc4SBrooks Davis end_time) 259*b0d29bc4SBrooks Davis VALUES (6, 'passed', NULL, 1357648712000000, 1357648718000000); 260*b0d29bc4SBrooks Davis 261*b0d29bc4SBrooks Davis-- metadata_id 8 262*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (8, 'allowed_architectures', ''); 263*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (8, 'allowed_platforms', ''); 264*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (8, 'description', 'Test description'); 265*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (8, 'has_cleanup', 'true'); 266*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (8, 'required_configs', ''); 267*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (8, 'required_files', ''); 268*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (8, 'required_memory', '128'); 269*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (8, 'required_programs', ''); 270*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (8, 'required_user', 'root'); 271*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (8, 'timeout', '300'); 272*b0d29bc4SBrooks Davis 273*b0d29bc4SBrooks Davis-- test_case_id 7, failed, optional non-multivalue metadata. 274*b0d29bc4SBrooks DavisINSERT INTO test_cases (test_case_id, test_program_id, name, metadata_id) 275*b0d29bc4SBrooks Davis VALUES (7, 6, 'this_fails', 8); 276*b0d29bc4SBrooks DavisINSERT INTO test_results (test_case_id, result_type, result_reason, start_time, 277*b0d29bc4SBrooks Davis end_time) 278*b0d29bc4SBrooks Davis VALUES (7, 'failed', 'Some reason', 1357648719000000, 1357648720897182); 279*b0d29bc4SBrooks Davis 280*b0d29bc4SBrooks Davis-- metadata_id 9 281*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (9, 'allowed_architectures', 'powerpc x86_64'); 282*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (9, 'allowed_platforms', 'amd64 macppc'); 283*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (9, 'description', 'Test explanation'); 284*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (9, 'has_cleanup', 'true'); 285*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (9, 'required_configs', 'unprivileged_user X-foo'); 286*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (9, 'required_files', '/the/data/file'); 287*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (9, 'required_memory', '512'); 288*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (9, 'required_programs', 'cp /bin/ls'); 289*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (9, 'required_user', 'unprivileged'); 290*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (9, 'timeout', '600'); 291*b0d29bc4SBrooks Davis 292*b0d29bc4SBrooks Davis-- test_case_id 8, skipped, all optional metadata. 293*b0d29bc4SBrooks DavisINSERT INTO test_cases (test_case_id, test_program_id, name, metadata_id) 294*b0d29bc4SBrooks Davis VALUES (8, 6, 'this_skips', 9); 295*b0d29bc4SBrooks DavisINSERT INTO test_results (test_case_id, result_type, result_reason, start_time, 296*b0d29bc4SBrooks Davis end_time) 297*b0d29bc4SBrooks Davis VALUES (8, 'skipped', 'Another reason', 1357648729182013, 1357648730000000); 298*b0d29bc4SBrooks Davis 299*b0d29bc4SBrooks Davis-- file_id 3 300*b0d29bc4SBrooks DavisINSERT INTO files (file_id, contents) 301*b0d29bc4SBrooks Davis VALUES (3, x'416e6f74686572207374646f7574'); 302*b0d29bc4SBrooks DavisINSERT INTO test_case_files (test_case_id, file_name, file_id) 303*b0d29bc4SBrooks Davis VALUES (8, '__STDOUT__', 3); 304*b0d29bc4SBrooks Davis 305*b0d29bc4SBrooks Davis-- metadata_id 10 306*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (10, 'allowed_architectures', ''); 307*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (10, 'allowed_platforms', ''); 308*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (10, 'description', ''); 309*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (10, 'has_cleanup', 'false'); 310*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (10, 'required_configs', ''); 311*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (10, 'required_files', ''); 312*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (10, 'required_memory', '0'); 313*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (10, 'required_programs', ''); 314*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (10, 'required_user', ''); 315*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (10, 'timeout', '300'); 316*b0d29bc4SBrooks Davis 317*b0d29bc4SBrooks Davis-- test_program_id 7 318*b0d29bc4SBrooks DavisINSERT INTO test_programs (test_program_id, action_id, absolute_path, root, 319*b0d29bc4SBrooks Davis relative_path, test_suite_name, metadata_id, 320*b0d29bc4SBrooks Davis interface) 321*b0d29bc4SBrooks Davis VALUES (7, 3, '/usr/tests/simple_test', '/usr/tests', 322*b0d29bc4SBrooks Davis 'simple_test', 'subsuite-name', 10, 'atf'); 323*b0d29bc4SBrooks Davis 324*b0d29bc4SBrooks Davis-- metadata_id 11 325*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (11, 'allowed_architectures', ''); 326*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (11, 'allowed_platforms', ''); 327*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (11, 'description', 'More text'); 328*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (11, 'has_cleanup', 'true'); 329*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (11, 'required_configs', ''); 330*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (11, 'required_files', ''); 331*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (11, 'required_memory', '128'); 332*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (11, 'required_programs', ''); 333*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (11, 'required_user', 'unprivileged'); 334*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (11, 'timeout', '300'); 335*b0d29bc4SBrooks Davis 336*b0d29bc4SBrooks Davis-- test_case_id 9 337*b0d29bc4SBrooks DavisINSERT INTO test_cases (test_case_id, test_program_id, name, metadata_id) 338*b0d29bc4SBrooks Davis VALUES (9, 7, 'main', 11); 339*b0d29bc4SBrooks DavisINSERT INTO test_results (test_case_id, result_type, result_reason, start_time, 340*b0d29bc4SBrooks Davis end_time) 341*b0d29bc4SBrooks Davis VALUES (9, 'failed', 'Exited with code 1', 342*b0d29bc4SBrooks Davis 1357648740120000, 1357648750081700); 343*b0d29bc4SBrooks Davis 344*b0d29bc4SBrooks Davis-- file_id 4 345*b0d29bc4SBrooks DavisINSERT INTO files (file_id, contents) 346*b0d29bc4SBrooks Davis VALUES (4, x'416e6f7468657220737464657272'); 347*b0d29bc4SBrooks DavisINSERT INTO test_case_files (test_case_id, file_name, file_id) 348*b0d29bc4SBrooks Davis VALUES (9, '__STDERR__', 4); 349*b0d29bc4SBrooks Davis 350*b0d29bc4SBrooks Davis 351*b0d29bc4SBrooks Davis-- 352*b0d29bc4SBrooks Davis-- Action 4: Mixture of test programs. 353*b0d29bc4SBrooks Davis-- 354*b0d29bc4SBrooks Davis 355*b0d29bc4SBrooks Davis 356*b0d29bc4SBrooks Davis-- context_id 4 357*b0d29bc4SBrooks DavisINSERT INTO contexts (context_id, cwd) VALUES (4, '/usr/tests'); 358*b0d29bc4SBrooks DavisINSERT INTO env_vars (context_id, var_name, var_value) 359*b0d29bc4SBrooks Davis VALUES (4, 'LANG', 'C'); 360*b0d29bc4SBrooks DavisINSERT INTO env_vars (context_id, var_name, var_value) 361*b0d29bc4SBrooks Davis VALUES (4, 'PATH', '/bin:/usr/bin'); 362*b0d29bc4SBrooks DavisINSERT INTO env_vars (context_id, var_name, var_value) 363*b0d29bc4SBrooks Davis VALUES (4, 'TERM', 'xterm'); 364*b0d29bc4SBrooks Davis 365*b0d29bc4SBrooks Davis-- action_id 4 366*b0d29bc4SBrooks DavisINSERT INTO actions (action_id, context_id) VALUES (4, 4); 367*b0d29bc4SBrooks Davis 368*b0d29bc4SBrooks Davis-- metadata_id 12 369*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (12, 'allowed_architectures', ''); 370*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (12, 'allowed_platforms', ''); 371*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (12, 'description', ''); 372*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (12, 'has_cleanup', 'false'); 373*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (12, 'required_configs', ''); 374*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (12, 'required_files', ''); 375*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (12, 'required_memory', '0'); 376*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (12, 'required_programs', ''); 377*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (12, 'required_user', ''); 378*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (12, 'timeout', '10'); 379*b0d29bc4SBrooks Davis 380*b0d29bc4SBrooks Davis-- test_program_id 8 381*b0d29bc4SBrooks DavisINSERT INTO test_programs (test_program_id, action_id, absolute_path, root, 382*b0d29bc4SBrooks Davis relative_path, test_suite_name, metadata_id, 383*b0d29bc4SBrooks Davis interface) 384*b0d29bc4SBrooks Davis VALUES (8, 4, '/usr/tests/subdir/another_test', '/usr/tests', 385*b0d29bc4SBrooks Davis 'subdir/another_test', 'subsuite-name', 12, 'plain'); 386*b0d29bc4SBrooks Davis 387*b0d29bc4SBrooks Davis-- test_case_id 10 388*b0d29bc4SBrooks DavisINSERT INTO test_cases (test_case_id, test_program_id, name, metadata_id) 389*b0d29bc4SBrooks Davis VALUES (10, 8, 'main', 12); 390*b0d29bc4SBrooks DavisINSERT INTO test_results (test_case_id, result_type, result_reason, start_time, 391*b0d29bc4SBrooks Davis end_time) 392*b0d29bc4SBrooks Davis VALUES (10, 'failed', 'Exit failure', 1357644395000000, 1357644396000000); 393*b0d29bc4SBrooks Davis 394*b0d29bc4SBrooks Davis-- file_id 5 395*b0d29bc4SBrooks DavisINSERT INTO files (file_id, contents) VALUES (5, x'54657374207374646f7574'); 396*b0d29bc4SBrooks DavisINSERT INTO test_case_files (test_case_id, file_name, file_id) 397*b0d29bc4SBrooks Davis VALUES (10, '__STDOUT__', 5); 398*b0d29bc4SBrooks Davis 399*b0d29bc4SBrooks Davis-- file_id 6 400*b0d29bc4SBrooks DavisINSERT INTO files (file_id, contents) VALUES (6, x'5465737420737464657272'); 401*b0d29bc4SBrooks DavisINSERT INTO test_case_files (test_case_id, file_name, file_id) 402*b0d29bc4SBrooks Davis VALUES (10, '__STDERR__', 6); 403*b0d29bc4SBrooks Davis 404*b0d29bc4SBrooks Davis-- metadata_id 13 405*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (13, 'allowed_architectures', ''); 406*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (13, 'allowed_platforms', ''); 407*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (13, 'description', ''); 408*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (13, 'has_cleanup', 'false'); 409*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (13, 'required_configs', ''); 410*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (13, 'required_files', ''); 411*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (13, 'required_memory', '0'); 412*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (13, 'required_programs', ''); 413*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (13, 'required_user', ''); 414*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (13, 'timeout', '300'); 415*b0d29bc4SBrooks Davis 416*b0d29bc4SBrooks Davis-- test_program_id 9 417*b0d29bc4SBrooks DavisINSERT INTO test_programs (test_program_id, action_id, absolute_path, root, 418*b0d29bc4SBrooks Davis relative_path, test_suite_name, metadata_id, 419*b0d29bc4SBrooks Davis interface) 420*b0d29bc4SBrooks Davis VALUES (9, 4, '/usr/tests/complex_test', '/usr/tests', 421*b0d29bc4SBrooks Davis 'complex_test', 'suite-name', 14, 'atf'); 422*b0d29bc4SBrooks Davis 423*b0d29bc4SBrooks Davis-- metadata_id 15 424*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (15, 'allowed_architectures', ''); 425*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (15, 'allowed_platforms', ''); 426*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (15, 'description', ''); 427*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (15, 'has_cleanup', 'false'); 428*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (15, 'required_configs', ''); 429*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (15, 'required_files', ''); 430*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (15, 'required_memory', '0'); 431*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (15, 'required_programs', ''); 432*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (15, 'required_user', ''); 433*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (15, 'timeout', '300'); 434*b0d29bc4SBrooks Davis 435*b0d29bc4SBrooks Davis-- test_case_id 11 436*b0d29bc4SBrooks DavisINSERT INTO test_cases (test_case_id, test_program_id, name, metadata_id) 437*b0d29bc4SBrooks Davis VALUES (11, 9, 'this_passes', 15); 438*b0d29bc4SBrooks DavisINSERT INTO test_results (test_case_id, result_type, result_reason, start_time, 439*b0d29bc4SBrooks Davis end_time) 440*b0d29bc4SBrooks Davis VALUES (11, 'passed', NULL, 1357644396500000, 1357644397000000); 441*b0d29bc4SBrooks Davis 442*b0d29bc4SBrooks Davis-- metadata_id 16 443*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (16, 'allowed_architectures', ''); 444*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (16, 'allowed_platforms', ''); 445*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (16, 'description', 'Test description'); 446*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (16, 'has_cleanup', 'false'); 447*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (16, 'required_configs', ''); 448*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (16, 'required_files', ''); 449*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (16, 'required_memory', '0'); 450*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (16, 'required_programs', ''); 451*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (16, 'required_user', 'root'); 452*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (16, 'timeout', '300'); 453*b0d29bc4SBrooks Davis 454*b0d29bc4SBrooks Davis-- test_case_id 12 455*b0d29bc4SBrooks DavisINSERT INTO test_cases (test_case_id, test_program_id, name, metadata_id) 456*b0d29bc4SBrooks Davis VALUES (12, 9, 'this_fails', 16); 457*b0d29bc4SBrooks DavisINSERT INTO test_results (test_case_id, result_type, result_reason, start_time, 458*b0d29bc4SBrooks Davis end_time) 459*b0d29bc4SBrooks Davis VALUES (12, 'failed', 'Some reason', 1357644397100000, 1357644399005000); 460*b0d29bc4SBrooks Davis 461*b0d29bc4SBrooks Davis 462*b0d29bc4SBrooks DavisCOMMIT TRANSACTION; 463