1 -- Copyright 2013 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_v1.sql
30 -- Populates a v1 database with some test data.
37 -- Action 1: Empty context and no test programs nor test cases.
42 INSERT INTO contexts (context_id, cwd) VALUES (1, '/some/root');
45 INSERT INTO actions (action_id, context_id) VALUES (1, 1);
49 -- Action 2: Plain test programs only.
51 -- This action contains 5 test programs, each with one test case, and each
52 -- reporting one of all possible result types.
57 INSERT INTO contexts (context_id, cwd) VALUES (2, '/test/suite/root');
58 INSERT INTO env_vars (context_id, var_name, var_value)
59 VALUES (2, 'HOME', '/home/test');
60 INSERT INTO env_vars (context_id, var_name, var_value)
61 VALUES (2, 'PATH', '/bin:/usr/bin');
64 INSERT INTO actions (action_id, context_id) VALUES (2, 2);
67 INSERT INTO test_programs (test_program_id, action_id, absolute_path, root,
68 relative_path, test_suite_name, interface)
69 VALUES (1, 2, '/test/suite/root/foo_test', '/test/suite/root',
70 'foo_test', 'suite-name', 'plain');
71 INSERT INTO plain_test_programs (test_program_id, timeout)
72 VALUES (1, 300000000);
75 INSERT INTO test_cases (test_case_id, test_program_id, name)
76 VALUES (1, 1, 'main');
77 INSERT INTO test_results (test_case_id, result_type, result_reason, start_time,
79 VALUES (1, 'passed', NULL, 1357643611000000, 1357643621000500);
82 INSERT INTO test_programs (test_program_id, action_id, absolute_path, root,
83 relative_path, test_suite_name, interface)
84 VALUES (2, 2, '/test/suite/root/subdir/another_test', '/test/suite/root',
85 'subdir/another_test', 'subsuite-name', 'plain');
86 INSERT INTO plain_test_programs (test_program_id, timeout)
90 INSERT INTO test_cases (test_case_id, test_program_id, name)
91 VALUES (2, 2, 'main');
92 INSERT INTO test_results (test_case_id, result_type, result_reason, start_time,
94 VALUES (2, 'failed', 'Exited with code 1',
95 1357643622001200, 1357643622900021);
98 INSERT INTO files (file_id, contents) VALUES (1, x'54657374207374646f7574');
99 INSERT INTO test_case_files (test_case_id, file_name, file_id)
100 VALUES (2, '__STDOUT__', 1);
103 INSERT INTO files (file_id, contents) VALUES (2, x'5465737420737464657272');
104 INSERT INTO test_case_files (test_case_id, file_name, file_id)
105 VALUES (2, '__STDERR__', 2);
108 INSERT INTO test_programs (test_program_id, action_id, absolute_path, root,
109 relative_path, test_suite_name, interface)
110 VALUES (3, 2, '/test/suite/root/subdir/bar_test', '/test/suite/root',
111 'subdir/bar_test', 'subsuite-name', 'plain');
112 INSERT INTO plain_test_programs (test_program_id, timeout)
113 VALUES (3, 300000000);
116 INSERT INTO test_cases (test_case_id, test_program_id, name)
117 VALUES (3, 3, 'main');
118 INSERT INTO test_results (test_case_id, result_type, result_reason, start_time,
120 VALUES (3, 'broken', 'Received signal 1',
121 1357643623500000, 1357643630981932);
124 INSERT INTO test_programs (test_program_id, action_id, absolute_path, root,
125 relative_path, test_suite_name, interface)
126 VALUES (4, 2, '/test/suite/root/top_test', '/test/suite/root',
127 'top_test', 'suite-name', 'plain');
128 INSERT INTO plain_test_programs (test_program_id, timeout)
129 VALUES (4, 300000000);
132 INSERT INTO test_cases (test_case_id, test_program_id, name)
133 VALUES (4, 4, 'main');
134 INSERT INTO test_results (test_case_id, result_type, result_reason, start_time,
136 VALUES (4, 'expected_failure', 'Known bug',
137 1357643631000000, 1357643631020000);
140 INSERT INTO test_programs (test_program_id, action_id, absolute_path, root,
141 relative_path, test_suite_name, interface)
142 VALUES (5, 2, '/test/suite/root/last_test', '/test/suite/root',
143 'last_test', 'suite-name', 'plain');
144 INSERT INTO plain_test_programs (test_program_id, timeout)
145 VALUES (5, 300000000);
148 INSERT INTO test_cases (test_case_id, test_program_id, name)
149 VALUES (5, 5, 'main');
150 INSERT INTO test_results (test_case_id, result_type, result_reason, start_time,
152 VALUES (5, 'skipped', 'Does not apply', 1357643632000000, 1357643638000000);
156 -- Action 3: ATF test programs only.
161 INSERT INTO contexts (context_id, cwd) VALUES (3, '/usr/tests');
162 INSERT INTO env_vars (context_id, var_name, var_value)
163 VALUES (3, 'PATH', '/bin:/usr/bin');
166 INSERT INTO actions (action_id, context_id) VALUES (3, 3);
169 INSERT INTO test_programs (test_program_id, action_id, absolute_path, root,
170 relative_path, test_suite_name, interface)
171 VALUES (6, 3, '/usr/tests/complex_test', '/usr/tests',
172 'complex_test', 'suite-name', 'atf');
174 -- test_case_id 6, passed, no optional metadata.
175 INSERT INTO test_cases (test_case_id, test_program_id, name)
176 VALUES (6, 6, 'this_passes');
177 INSERT INTO test_results (test_case_id, result_type, result_reason, start_time,
179 VALUES (6, 'passed', NULL, 1357648712000000, 1357648718000000);
180 INSERT INTO atf_test_cases (test_case_id, description, has_cleanup, timeout,
181 required_memory, required_user)
182 VALUES (6, NULL, 'false', 300000000, 0, NULL);
184 -- test_case_id 7, failed, optional non-multivalue metadata.
185 INSERT INTO test_cases (test_case_id, test_program_id, name)
186 VALUES (7, 6, 'this_fails');
187 INSERT INTO test_results (test_case_id, result_type, result_reason, start_time,
189 VALUES (7, 'failed', 'Some reason', 1357648719000000, 1357648720897182);
190 INSERT INTO atf_test_cases (test_case_id, description, has_cleanup, timeout,
191 required_memory, required_user)
192 VALUES (7, 'Test description', 'true', 300000000, 128, 'root');
194 -- test_case_id 8, skipped, all optional metadata.
195 INSERT INTO test_cases (test_case_id, test_program_id, name)
196 VALUES (8, 6, 'this_skips');
197 INSERT INTO test_results (test_case_id, result_type, result_reason, start_time,
199 VALUES (8, 'skipped', 'Another reason', 1357648729182013, 1357648730000000);
200 INSERT INTO atf_test_cases (test_case_id, description, has_cleanup, timeout,
201 required_memory, required_user)
202 VALUES (8, 'Test explanation', 'true', 600000000, 512, 'unprivileged');
203 INSERT INTO atf_test_cases_multivalues (test_case_id, property_name,
205 VALUES (8, 'require.arch', 'x86_64');
206 INSERT INTO atf_test_cases_multivalues (test_case_id, property_name,
208 VALUES (8, 'require.arch', 'powerpc');
209 INSERT INTO atf_test_cases_multivalues (test_case_id, property_name,
211 VALUES (8, 'require.machine', 'amd64');
212 INSERT INTO atf_test_cases_multivalues (test_case_id, property_name,
214 VALUES (8, 'require.machine', 'macppc');
215 INSERT INTO atf_test_cases_multivalues (test_case_id, property_name,
217 VALUES (8, 'require.config', 'unprivileged_user');
218 INSERT INTO atf_test_cases_multivalues (test_case_id, property_name,
220 VALUES (8, 'require.config', 'X-foo');
221 INSERT INTO atf_test_cases_multivalues (test_case_id, property_name,
223 VALUES (8, 'require.files', '/the/data/file');
224 INSERT INTO atf_test_cases_multivalues (test_case_id, property_name,
226 VALUES (8, 'require.progs', 'cp');
227 INSERT INTO atf_test_cases_multivalues (test_case_id, property_name,
229 VALUES (8, 'require.progs', '/bin/ls');
232 INSERT INTO files (file_id, contents)
233 VALUES (3, x'416e6f74686572207374646f7574');
234 INSERT INTO test_case_files (test_case_id, file_name, file_id)
235 VALUES (8, '__STDOUT__', 3);
238 INSERT INTO test_programs (test_program_id, action_id, absolute_path, root,
239 relative_path, test_suite_name, interface)
240 VALUES (7, 3, '/usr/tests/simple_test', '/usr/tests',
241 'simple_test', 'subsuite-name', 'atf');
244 INSERT INTO test_cases (test_case_id, test_program_id, name)
245 VALUES (9, 7, 'main');
246 INSERT INTO test_results (test_case_id, result_type, result_reason, start_time,
248 VALUES (9, 'failed', 'Exited with code 1',
249 1357648740120000, 1357648750081700);
250 INSERT INTO atf_test_cases (test_case_id, description, has_cleanup, timeout,
251 required_memory, required_user)
252 VALUES (9, 'More text', 'true', 300000000, 128, 'unprivileged');
255 INSERT INTO files (file_id, contents)
256 VALUES (4, x'416e6f7468657220737464657272');
257 INSERT INTO test_case_files (test_case_id, file_name, file_id)
258 VALUES (9, '__STDERR__', 4);
262 -- Action 4: Mixture of test programs.
267 INSERT INTO contexts (context_id, cwd) VALUES (4, '/usr/tests');
268 INSERT INTO env_vars (context_id, var_name, var_value)
269 VALUES (4, 'LANG', 'C');
270 INSERT INTO env_vars (context_id, var_name, var_value)
271 VALUES (4, 'PATH', '/bin:/usr/bin');
272 INSERT INTO env_vars (context_id, var_name, var_value)
273 VALUES (4, 'TERM', 'xterm');
276 INSERT INTO actions (action_id, context_id) VALUES (4, 4);
279 INSERT INTO test_programs (test_program_id, action_id, absolute_path, root,
280 relative_path, test_suite_name, interface)
281 VALUES (8, 4, '/usr/tests/subdir/another_test', '/usr/tests',
282 'subdir/another_test', 'subsuite-name', 'plain');
283 INSERT INTO plain_test_programs (test_program_id, timeout)
284 VALUES (8, 10000000);
287 INSERT INTO test_cases (test_case_id, test_program_id, name)
288 VALUES (10, 8, 'main');
289 INSERT INTO test_results (test_case_id, result_type, result_reason, start_time,
291 VALUES (10, 'failed', 'Exit failure', 1357644395000000, 1357644396000000);
294 INSERT INTO files (file_id, contents) VALUES (5, x'54657374207374646f7574');
295 INSERT INTO test_case_files (test_case_id, file_name, file_id)
296 VALUES (10, '__STDOUT__', 5);
299 INSERT INTO files (file_id, contents) VALUES (6, x'5465737420737464657272');
300 INSERT INTO test_case_files (test_case_id, file_name, file_id)
301 VALUES (10, '__STDERR__', 6);
304 INSERT INTO test_programs (test_program_id, action_id, absolute_path, root,
305 relative_path, test_suite_name, interface)
306 VALUES (9, 4, '/usr/tests/complex_test', '/usr/tests',
307 'complex_test', 'suite-name', 'atf');
310 INSERT INTO test_cases (test_case_id, test_program_id, name)
311 VALUES (11, 9, 'this_passes');
312 INSERT INTO test_results (test_case_id, result_type, result_reason, start_time,
314 VALUES (11, 'passed', NULL, 1357644396500000, 1357644397000000);
315 INSERT INTO atf_test_cases (test_case_id, description, has_cleanup, timeout,
316 required_memory, required_user)
317 VALUES (11, NULL, 'false', 300000000, 0, NULL);
320 INSERT INTO test_cases (test_case_id, test_program_id, name)
321 VALUES (12, 9, 'this_fails');
322 INSERT INTO test_results (test_case_id, result_type, result_reason, start_time,
324 VALUES (12, 'failed', 'Some reason', 1357644397100000, 1357644399005000);
325 INSERT INTO atf_test_cases (test_case_id, description, has_cleanup, timeout,
326 required_memory, required_user)
327 VALUES (12, 'Test description', 'false', 300000000, 0, 'root');