1 -- Copyright 2014 The Kyua Authors.
2 -- All rights reserved.
4 -- Redistribution and use in source and binary forms, with or without
5 -- modification, are permitted provided that the following conditions are
8 -- * Redistributions of source code must retain the above copyright
9 -- notice, this list of conditions and the following disclaimer.
10 -- * Redistributions in binary form must reproduce the above copyright
11 -- notice, this list of conditions and the following disclaimer in the
12 -- documentation and/or other materials provided with the distribution.
13 -- * Neither the name of Google Inc. nor the names of its contributors
14 -- may be used to endorse or promote products derived from this software
15 -- without specific prior written permission.
17 -- THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS
18 -- "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT
19 -- LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR
20 -- A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT
21 -- OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
22 -- SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT
23 -- LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE,
24 -- DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY
25 -- THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
26 -- (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE
27 -- OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
29 -- \file store/testdata_v3.sql
30 -- Populates a v3 database with some test data.
32 -- ATF test programs only.
39 INSERT INTO contexts (cwd) VALUES ('/usr/tests');
40 INSERT INTO env_vars (var_name, var_value)
41 VALUES ('PATH', '/bin:/usr/bin');
44 INSERT INTO metadatas VALUES (6, 'allowed_architectures', '');
45 INSERT INTO metadatas VALUES (6, 'allowed_platforms', '');
46 INSERT INTO metadatas VALUES (6, 'description', '');
47 INSERT INTO metadatas VALUES (6, 'has_cleanup', 'false');
48 INSERT INTO metadatas VALUES (6, 'required_configs', '');
49 INSERT INTO metadatas VALUES (6, 'required_files', '');
50 INSERT INTO metadatas VALUES (6, 'required_memory', '0');
51 INSERT INTO metadatas VALUES (6, 'required_programs', '');
52 INSERT INTO metadatas VALUES (6, 'required_user', '');
53 INSERT INTO metadatas VALUES (6, 'timeout', '300');
56 INSERT INTO test_programs (test_program_id, absolute_path, root,
57 relative_path, test_suite_name, metadata_id,
59 VALUES (6, '/usr/tests/complex_test', '/usr/tests',
60 'complex_test', 'suite-name', 6, 'atf');
63 INSERT INTO metadatas VALUES (7, 'allowed_architectures', '');
64 INSERT INTO metadatas VALUES (7, 'allowed_platforms', '');
65 INSERT INTO metadatas VALUES (7, 'description', '');
66 INSERT INTO metadatas VALUES (7, 'has_cleanup', 'false');
67 INSERT INTO metadatas VALUES (7, 'required_configs', '');
68 INSERT INTO metadatas VALUES (7, 'required_files', '');
69 INSERT INTO metadatas VALUES (7, 'required_memory', '0');
70 INSERT INTO metadatas VALUES (7, 'required_programs', '');
71 INSERT INTO metadatas VALUES (7, 'required_user', '');
72 INSERT INTO metadatas VALUES (7, 'timeout', '300');
74 -- test_case_id 6, passed, no optional metadata.
75 INSERT INTO test_cases (test_case_id, test_program_id, name, metadata_id)
76 VALUES (6, 6, 'this_passes', 7);
77 INSERT INTO test_results (test_case_id, result_type, result_reason, start_time,
79 VALUES (6, 'passed', NULL, 1357648712000000, 1357648718000000);
82 INSERT INTO metadatas VALUES (8, 'allowed_architectures', '');
83 INSERT INTO metadatas VALUES (8, 'allowed_platforms', '');
84 INSERT INTO metadatas VALUES (8, 'description', 'Test description');
85 INSERT INTO metadatas VALUES (8, 'has_cleanup', 'true');
86 INSERT INTO metadatas VALUES (8, 'required_configs', '');
87 INSERT INTO metadatas VALUES (8, 'required_files', '');
88 INSERT INTO metadatas VALUES (8, 'required_memory', '128');
89 INSERT INTO metadatas VALUES (8, 'required_programs', '');
90 INSERT INTO metadatas VALUES (8, 'required_user', 'root');
91 INSERT INTO metadatas VALUES (8, 'timeout', '300');
93 -- test_case_id 7, failed, optional non-multivalue metadata.
94 INSERT INTO test_cases (test_case_id, test_program_id, name, metadata_id)
95 VALUES (7, 6, 'this_fails', 8);
96 INSERT INTO test_results (test_case_id, result_type, result_reason, start_time,
98 VALUES (7, 'failed', 'Some reason', 1357648719000000, 1357648720897182);
101 INSERT INTO metadatas VALUES (9, 'allowed_architectures', 'powerpc x86_64');
102 INSERT INTO metadatas VALUES (9, 'allowed_platforms', 'amd64 macppc');
103 INSERT INTO metadatas VALUES (9, 'description', 'Test explanation');
104 INSERT INTO metadatas VALUES (9, 'has_cleanup', 'true');
105 INSERT INTO metadatas VALUES (9, 'required_configs', 'unprivileged_user X-foo');
106 INSERT INTO metadatas VALUES (9, 'required_files', '/the/data/file');
107 INSERT INTO metadatas VALUES (9, 'required_memory', '512');
108 INSERT INTO metadatas VALUES (9, 'required_programs', 'cp /bin/ls');
109 INSERT INTO metadatas VALUES (9, 'required_user', 'unprivileged');
110 INSERT INTO metadatas VALUES (9, 'timeout', '600');
112 -- test_case_id 8, skipped, all optional metadata.
113 INSERT INTO test_cases (test_case_id, test_program_id, name, metadata_id)
114 VALUES (8, 6, 'this_skips', 9);
115 INSERT INTO test_results (test_case_id, result_type, result_reason, start_time,
117 VALUES (8, 'skipped', 'Another reason', 1357648729182013, 1357648730000000);
120 INSERT INTO files (file_id, contents)
121 VALUES (3, x'416e6f74686572207374646f7574');
122 INSERT INTO test_case_files (test_case_id, file_name, file_id)
123 VALUES (8, '__STDOUT__', 3);
126 INSERT INTO metadatas VALUES (10, 'allowed_architectures', '');
127 INSERT INTO metadatas VALUES (10, 'allowed_platforms', '');
128 INSERT INTO metadatas VALUES (10, 'description', '');
129 INSERT INTO metadatas VALUES (10, 'has_cleanup', 'false');
130 INSERT INTO metadatas VALUES (10, 'required_configs', '');
131 INSERT INTO metadatas VALUES (10, 'required_files', '');
132 INSERT INTO metadatas VALUES (10, 'required_memory', '0');
133 INSERT INTO metadatas VALUES (10, 'required_programs', '');
134 INSERT INTO metadatas VALUES (10, 'required_user', '');
135 INSERT INTO metadatas VALUES (10, 'timeout', '300');
138 INSERT INTO test_programs (test_program_id, absolute_path, root,
139 relative_path, test_suite_name, metadata_id,
141 VALUES (7, '/usr/tests/simple_test', '/usr/tests',
142 'simple_test', 'subsuite-name', 10, 'atf');
145 INSERT INTO metadatas VALUES (11, 'allowed_architectures', '');
146 INSERT INTO metadatas VALUES (11, 'allowed_platforms', '');
147 INSERT INTO metadatas VALUES (11, 'description', 'More text');
148 INSERT INTO metadatas VALUES (11, 'has_cleanup', 'true');
149 INSERT INTO metadatas VALUES (11, 'required_configs', '');
150 INSERT INTO metadatas VALUES (11, 'required_files', '');
151 INSERT INTO metadatas VALUES (11, 'required_memory', '128');
152 INSERT INTO metadatas VALUES (11, 'required_programs', '');
153 INSERT INTO metadatas VALUES (11, 'required_user', 'unprivileged');
154 INSERT INTO metadatas VALUES (11, 'timeout', '300');
157 INSERT INTO test_cases (test_case_id, test_program_id, name, metadata_id)
158 VALUES (9, 7, 'main', 11);
159 INSERT INTO test_results (test_case_id, result_type, result_reason, start_time,
161 VALUES (9, 'failed', 'Exited with code 1',
162 1357648740120000, 1357648750081700);
165 INSERT INTO files (file_id, contents)
166 VALUES (4, x'416e6f7468657220737464657272');
167 INSERT INTO test_case_files (test_case_id, file_name, file_id)
168 VALUES (9, '__STDERR__', 4);