1*b0d29bc4SBrooks Davis-- Copyright 2014 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_v3.sql 30*b0d29bc4SBrooks Davis-- Populates a v3 database with some test data. 31*b0d29bc4SBrooks Davis-- 32*b0d29bc4SBrooks Davis-- Mixture of test programs. 33*b0d29bc4SBrooks Davis 34*b0d29bc4SBrooks Davis 35*b0d29bc4SBrooks DavisBEGIN TRANSACTION; 36*b0d29bc4SBrooks Davis 37*b0d29bc4SBrooks Davis 38*b0d29bc4SBrooks Davis-- context 39*b0d29bc4SBrooks DavisINSERT INTO contexts (cwd) VALUES ('/usr/tests'); 40*b0d29bc4SBrooks DavisINSERT INTO env_vars (var_name, var_value) 41*b0d29bc4SBrooks Davis VALUES ('LANG', 'C'); 42*b0d29bc4SBrooks DavisINSERT INTO env_vars (var_name, var_value) 43*b0d29bc4SBrooks Davis VALUES ('PATH', '/bin:/usr/bin'); 44*b0d29bc4SBrooks DavisINSERT INTO env_vars (var_name, var_value) 45*b0d29bc4SBrooks Davis VALUES ('TERM', 'xterm'); 46*b0d29bc4SBrooks Davis 47*b0d29bc4SBrooks Davis-- metadata_id 12 48*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (12, 'allowed_architectures', ''); 49*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (12, 'allowed_platforms', ''); 50*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (12, 'description', ''); 51*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (12, 'has_cleanup', 'false'); 52*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (12, 'required_configs', ''); 53*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (12, 'required_files', ''); 54*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (12, 'required_memory', '0'); 55*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (12, 'required_programs', ''); 56*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (12, 'required_user', ''); 57*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (12, 'timeout', '10'); 58*b0d29bc4SBrooks Davis 59*b0d29bc4SBrooks Davis-- test_program_id 8 60*b0d29bc4SBrooks DavisINSERT INTO test_programs (test_program_id, absolute_path, root, 61*b0d29bc4SBrooks Davis relative_path, test_suite_name, metadata_id, 62*b0d29bc4SBrooks Davis interface) 63*b0d29bc4SBrooks Davis VALUES (8, '/usr/tests/subdir/another_test', '/usr/tests', 64*b0d29bc4SBrooks Davis 'subdir/another_test', 'subsuite-name', 12, 'plain'); 65*b0d29bc4SBrooks Davis 66*b0d29bc4SBrooks Davis-- test_case_id 10 67*b0d29bc4SBrooks DavisINSERT INTO test_cases (test_case_id, test_program_id, name, metadata_id) 68*b0d29bc4SBrooks Davis VALUES (10, 8, 'main', 12); 69*b0d29bc4SBrooks DavisINSERT INTO test_results (test_case_id, result_type, result_reason, start_time, 70*b0d29bc4SBrooks Davis end_time) 71*b0d29bc4SBrooks Davis VALUES (10, 'failed', 'Exit failure', 1357644395000000, 1357644396000000); 72*b0d29bc4SBrooks Davis 73*b0d29bc4SBrooks Davis-- file_id 5 74*b0d29bc4SBrooks DavisINSERT INTO files (file_id, contents) VALUES (5, x'54657374207374646f7574'); 75*b0d29bc4SBrooks DavisINSERT INTO test_case_files (test_case_id, file_name, file_id) 76*b0d29bc4SBrooks Davis VALUES (10, '__STDOUT__', 5); 77*b0d29bc4SBrooks Davis 78*b0d29bc4SBrooks Davis-- file_id 6 79*b0d29bc4SBrooks DavisINSERT INTO files (file_id, contents) VALUES (6, x'5465737420737464657272'); 80*b0d29bc4SBrooks DavisINSERT INTO test_case_files (test_case_id, file_name, file_id) 81*b0d29bc4SBrooks Davis VALUES (10, '__STDERR__', 6); 82*b0d29bc4SBrooks Davis 83*b0d29bc4SBrooks Davis-- metadata_id 13 84*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (13, 'allowed_architectures', ''); 85*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (13, 'allowed_platforms', ''); 86*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (13, 'description', ''); 87*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (13, 'has_cleanup', 'false'); 88*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (13, 'required_configs', ''); 89*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (13, 'required_files', ''); 90*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (13, 'required_memory', '0'); 91*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (13, 'required_programs', ''); 92*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (13, 'required_user', ''); 93*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (13, 'timeout', '300'); 94*b0d29bc4SBrooks Davis 95*b0d29bc4SBrooks Davis-- test_program_id 9 96*b0d29bc4SBrooks DavisINSERT INTO test_programs (test_program_id, absolute_path, root, 97*b0d29bc4SBrooks Davis relative_path, test_suite_name, metadata_id, 98*b0d29bc4SBrooks Davis interface) 99*b0d29bc4SBrooks Davis VALUES (9, '/usr/tests/complex_test', '/usr/tests', 100*b0d29bc4SBrooks Davis 'complex_test', 'suite-name', 14, 'atf'); 101*b0d29bc4SBrooks Davis 102*b0d29bc4SBrooks Davis-- metadata_id 15 103*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (15, 'allowed_architectures', ''); 104*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (15, 'allowed_platforms', ''); 105*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (15, 'description', ''); 106*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (15, 'has_cleanup', 'false'); 107*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (15, 'required_configs', ''); 108*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (15, 'required_files', ''); 109*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (15, 'required_memory', '0'); 110*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (15, 'required_programs', ''); 111*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (15, 'required_user', ''); 112*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (15, 'timeout', '300'); 113*b0d29bc4SBrooks Davis 114*b0d29bc4SBrooks Davis-- test_case_id 11 115*b0d29bc4SBrooks DavisINSERT INTO test_cases (test_case_id, test_program_id, name, metadata_id) 116*b0d29bc4SBrooks Davis VALUES (11, 9, 'this_passes', 15); 117*b0d29bc4SBrooks DavisINSERT INTO test_results (test_case_id, result_type, result_reason, start_time, 118*b0d29bc4SBrooks Davis end_time) 119*b0d29bc4SBrooks Davis VALUES (11, 'passed', NULL, 1357644396500000, 1357644397000000); 120*b0d29bc4SBrooks Davis 121*b0d29bc4SBrooks Davis-- metadata_id 16 122*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (16, 'allowed_architectures', ''); 123*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (16, 'allowed_platforms', ''); 124*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (16, 'description', 'Test description'); 125*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (16, 'has_cleanup', 'false'); 126*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (16, 'required_configs', ''); 127*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (16, 'required_files', ''); 128*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (16, 'required_memory', '0'); 129*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (16, 'required_programs', ''); 130*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (16, 'required_user', 'root'); 131*b0d29bc4SBrooks DavisINSERT INTO metadatas VALUES (16, 'timeout', '300'); 132*b0d29bc4SBrooks Davis 133*b0d29bc4SBrooks Davis-- test_case_id 12 134*b0d29bc4SBrooks DavisINSERT INTO test_cases (test_case_id, test_program_id, name, metadata_id) 135*b0d29bc4SBrooks Davis VALUES (12, 9, 'this_fails', 16); 136*b0d29bc4SBrooks DavisINSERT INTO test_results (test_case_id, result_type, result_reason, start_time, 137*b0d29bc4SBrooks Davis end_time) 138*b0d29bc4SBrooks Davis VALUES (12, 'failed', 'Some reason', 1357644397100000, 1357644399005000); 139*b0d29bc4SBrooks Davis 140*b0d29bc4SBrooks Davis 141*b0d29bc4SBrooks DavisCOMMIT TRANSACTION; 142