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_v2.sql
30 -- Populates a v2 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 metadatas VALUES (1, 'allowed_architectures', '');
68 INSERT INTO metadatas VALUES (1, 'allowed_platforms', '');
69 INSERT INTO metadatas VALUES (1, 'description', '');
70 INSERT INTO metadatas VALUES (1, 'has_cleanup', 'false');
71 INSERT INTO metadatas VALUES (1, 'required_configs', '');
72 INSERT INTO metadatas VALUES (1, 'required_files', '');
73 INSERT INTO metadatas VALUES (1, 'required_memory', '0');
74 INSERT INTO metadatas VALUES (1, 'required_programs', '');
75 INSERT INTO metadatas VALUES (1, 'required_user', '');
76 INSERT INTO metadatas VALUES (1, 'timeout', '300');
79 INSERT INTO test_programs (test_program_id, action_id, absolute_path, root,
80 relative_path, test_suite_name, metadata_id,
82 VALUES (1, 2, '/test/suite/root/foo_test', '/test/suite/root',
83 'foo_test', 'suite-name', 1, 'plain');
86 INSERT INTO test_cases (test_case_id, test_program_id, name, metadata_id)
87 VALUES (1, 1, 'main', 1);
88 INSERT INTO test_results (test_case_id, result_type, result_reason, start_time,
90 VALUES (1, 'passed', NULL, 1357643611000000, 1357643621000500);
93 INSERT INTO metadatas VALUES (2, 'allowed_architectures', '');
94 INSERT INTO metadatas VALUES (2, 'allowed_platforms', '');
95 INSERT INTO metadatas VALUES (2, 'description', '');
96 INSERT INTO metadatas VALUES (2, 'has_cleanup', 'false');
97 INSERT INTO metadatas VALUES (2, 'required_configs', '');
98 INSERT INTO metadatas VALUES (2, 'required_files', '');
99 INSERT INTO metadatas VALUES (2, 'required_memory', '0');
100 INSERT INTO metadatas VALUES (2, 'required_programs', '');
101 INSERT INTO metadatas VALUES (2, 'required_user', '');
102 INSERT INTO metadatas VALUES (2, 'timeout', '10');
105 INSERT INTO test_programs (test_program_id, action_id, absolute_path, root,
106 relative_path, test_suite_name, metadata_id,
108 VALUES (2, 2, '/test/suite/root/subdir/another_test', '/test/suite/root',
109 'subdir/another_test', 'subsuite-name', 2, 'plain');
112 INSERT INTO test_cases (test_case_id, test_program_id, name, metadata_id)
113 VALUES (2, 2, 'main', 2);
114 INSERT INTO test_results (test_case_id, result_type, result_reason, start_time,
116 VALUES (2, 'failed', 'Exited with code 1',
117 1357643622001200, 1357643622900021);
120 INSERT INTO files (file_id, contents) VALUES (1, x'54657374207374646f7574');
121 INSERT INTO test_case_files (test_case_id, file_name, file_id)
122 VALUES (2, '__STDOUT__', 1);
125 INSERT INTO files (file_id, contents) VALUES (2, x'5465737420737464657272');
126 INSERT INTO test_case_files (test_case_id, file_name, file_id)
127 VALUES (2, '__STDERR__', 2);
130 INSERT INTO metadatas VALUES (3, 'allowed_architectures', '');
131 INSERT INTO metadatas VALUES (3, 'allowed_platforms', '');
132 INSERT INTO metadatas VALUES (3, 'description', '');
133 INSERT INTO metadatas VALUES (3, 'has_cleanup', 'false');
134 INSERT INTO metadatas VALUES (3, 'required_configs', '');
135 INSERT INTO metadatas VALUES (3, 'required_files', '');
136 INSERT INTO metadatas VALUES (3, 'required_memory', '0');
137 INSERT INTO metadatas VALUES (3, 'required_programs', '');
138 INSERT INTO metadatas VALUES (3, 'required_user', '');
139 INSERT INTO metadatas VALUES (3, 'timeout', '300');
142 INSERT INTO test_programs (test_program_id, action_id, absolute_path, root,
143 relative_path, test_suite_name, metadata_id,
145 VALUES (3, 2, '/test/suite/root/subdir/bar_test', '/test/suite/root',
146 'subdir/bar_test', 'subsuite-name', 3, 'plain');
149 INSERT INTO test_cases (test_case_id, test_program_id, name, metadata_id)
150 VALUES (3, 3, 'main', 3);
151 INSERT INTO test_results (test_case_id, result_type, result_reason, start_time,
153 VALUES (3, 'broken', 'Received signal 1',
154 1357643623500000, 1357643630981932);
157 INSERT INTO metadatas VALUES (4, 'allowed_architectures', '');
158 INSERT INTO metadatas VALUES (4, 'allowed_platforms', '');
159 INSERT INTO metadatas VALUES (4, 'description', '');
160 INSERT INTO metadatas VALUES (4, 'has_cleanup', 'false');
161 INSERT INTO metadatas VALUES (4, 'required_configs', '');
162 INSERT INTO metadatas VALUES (4, 'required_files', '');
163 INSERT INTO metadatas VALUES (4, 'required_memory', '0');
164 INSERT INTO metadatas VALUES (4, 'required_programs', '');
165 INSERT INTO metadatas VALUES (4, 'required_user', '');
166 INSERT INTO metadatas VALUES (4, 'timeout', '300');
169 INSERT INTO test_programs (test_program_id, action_id, absolute_path, root,
170 relative_path, test_suite_name, metadata_id,
172 VALUES (4, 2, '/test/suite/root/top_test', '/test/suite/root',
173 'top_test', 'suite-name', 4, 'plain');
176 INSERT INTO test_cases (test_case_id, test_program_id, name, metadata_id)
177 VALUES (4, 4, 'main', 4);
178 INSERT INTO test_results (test_case_id, result_type, result_reason, start_time,
180 VALUES (4, 'expected_failure', 'Known bug',
181 1357643631000000, 1357643631020000);
184 INSERT INTO metadatas VALUES (5, 'allowed_architectures', '');
185 INSERT INTO metadatas VALUES (5, 'allowed_platforms', '');
186 INSERT INTO metadatas VALUES (5, 'description', '');
187 INSERT INTO metadatas VALUES (5, 'has_cleanup', 'false');
188 INSERT INTO metadatas VALUES (5, 'required_configs', '');
189 INSERT INTO metadatas VALUES (5, 'required_files', '');
190 INSERT INTO metadatas VALUES (5, 'required_memory', '0');
191 INSERT INTO metadatas VALUES (5, 'required_programs', '');
192 INSERT INTO metadatas VALUES (5, 'required_user', '');
193 INSERT INTO metadatas VALUES (5, 'timeout', '300');
196 INSERT INTO test_programs (test_program_id, action_id, absolute_path, root,
197 relative_path, test_suite_name, metadata_id,
199 VALUES (5, 2, '/test/suite/root/last_test', '/test/suite/root',
200 'last_test', 'suite-name', 5, 'plain');
203 INSERT INTO test_cases (test_case_id, test_program_id, name, metadata_id)
204 VALUES (5, 5, 'main', 5);
205 INSERT INTO test_results (test_case_id, result_type, result_reason, start_time,
207 VALUES (5, 'skipped', 'Does not apply', 1357643632000000, 1357643638000000);
211 -- Action 3: ATF test programs only.
216 INSERT INTO contexts (context_id, cwd) VALUES (3, '/usr/tests');
217 INSERT INTO env_vars (context_id, var_name, var_value)
218 VALUES (3, 'PATH', '/bin:/usr/bin');
221 INSERT INTO actions (action_id, context_id) VALUES (3, 3);
224 INSERT INTO metadatas VALUES (6, 'allowed_architectures', '');
225 INSERT INTO metadatas VALUES (6, 'allowed_platforms', '');
226 INSERT INTO metadatas VALUES (6, 'description', '');
227 INSERT INTO metadatas VALUES (6, 'has_cleanup', 'false');
228 INSERT INTO metadatas VALUES (6, 'required_configs', '');
229 INSERT INTO metadatas VALUES (6, 'required_files', '');
230 INSERT INTO metadatas VALUES (6, 'required_memory', '0');
231 INSERT INTO metadatas VALUES (6, 'required_programs', '');
232 INSERT INTO metadatas VALUES (6, 'required_user', '');
233 INSERT INTO metadatas VALUES (6, 'timeout', '300');
236 INSERT INTO test_programs (test_program_id, action_id, absolute_path, root,
237 relative_path, test_suite_name, metadata_id,
239 VALUES (6, 3, '/usr/tests/complex_test', '/usr/tests',
240 'complex_test', 'suite-name', 6, 'atf');
243 INSERT INTO metadatas VALUES (7, 'allowed_architectures', '');
244 INSERT INTO metadatas VALUES (7, 'allowed_platforms', '');
245 INSERT INTO metadatas VALUES (7, 'description', '');
246 INSERT INTO metadatas VALUES (7, 'has_cleanup', 'false');
247 INSERT INTO metadatas VALUES (7, 'required_configs', '');
248 INSERT INTO metadatas VALUES (7, 'required_files', '');
249 INSERT INTO metadatas VALUES (7, 'required_memory', '0');
250 INSERT INTO metadatas VALUES (7, 'required_programs', '');
251 INSERT INTO metadatas VALUES (7, 'required_user', '');
252 INSERT INTO metadatas VALUES (7, 'timeout', '300');
254 -- test_case_id 6, passed, no optional metadata.
255 INSERT INTO test_cases (test_case_id, test_program_id, name, metadata_id)
256 VALUES (6, 6, 'this_passes', 7);
257 INSERT INTO test_results (test_case_id, result_type, result_reason, start_time,
259 VALUES (6, 'passed', NULL, 1357648712000000, 1357648718000000);
262 INSERT INTO metadatas VALUES (8, 'allowed_architectures', '');
263 INSERT INTO metadatas VALUES (8, 'allowed_platforms', '');
264 INSERT INTO metadatas VALUES (8, 'description', 'Test description');
265 INSERT INTO metadatas VALUES (8, 'has_cleanup', 'true');
266 INSERT INTO metadatas VALUES (8, 'required_configs', '');
267 INSERT INTO metadatas VALUES (8, 'required_files', '');
268 INSERT INTO metadatas VALUES (8, 'required_memory', '128');
269 INSERT INTO metadatas VALUES (8, 'required_programs', '');
270 INSERT INTO metadatas VALUES (8, 'required_user', 'root');
271 INSERT INTO metadatas VALUES (8, 'timeout', '300');
273 -- test_case_id 7, failed, optional non-multivalue metadata.
274 INSERT INTO test_cases (test_case_id, test_program_id, name, metadata_id)
275 VALUES (7, 6, 'this_fails', 8);
276 INSERT INTO test_results (test_case_id, result_type, result_reason, start_time,
278 VALUES (7, 'failed', 'Some reason', 1357648719000000, 1357648720897182);
281 INSERT INTO metadatas VALUES (9, 'allowed_architectures', 'powerpc x86_64');
282 INSERT INTO metadatas VALUES (9, 'allowed_platforms', 'amd64 macppc');
283 INSERT INTO metadatas VALUES (9, 'description', 'Test explanation');
284 INSERT INTO metadatas VALUES (9, 'has_cleanup', 'true');
285 INSERT INTO metadatas VALUES (9, 'required_configs', 'unprivileged_user X-foo');
286 INSERT INTO metadatas VALUES (9, 'required_files', '/the/data/file');
287 INSERT INTO metadatas VALUES (9, 'required_memory', '512');
288 INSERT INTO metadatas VALUES (9, 'required_programs', 'cp /bin/ls');
289 INSERT INTO metadatas VALUES (9, 'required_user', 'unprivileged');
290 INSERT INTO metadatas VALUES (9, 'timeout', '600');
292 -- test_case_id 8, skipped, all optional metadata.
293 INSERT INTO test_cases (test_case_id, test_program_id, name, metadata_id)
294 VALUES (8, 6, 'this_skips', 9);
295 INSERT INTO test_results (test_case_id, result_type, result_reason, start_time,
297 VALUES (8, 'skipped', 'Another reason', 1357648729182013, 1357648730000000);
300 INSERT INTO files (file_id, contents)
301 VALUES (3, x'416e6f74686572207374646f7574');
302 INSERT INTO test_case_files (test_case_id, file_name, file_id)
303 VALUES (8, '__STDOUT__', 3);
306 INSERT INTO metadatas VALUES (10, 'allowed_architectures', '');
307 INSERT INTO metadatas VALUES (10, 'allowed_platforms', '');
308 INSERT INTO metadatas VALUES (10, 'description', '');
309 INSERT INTO metadatas VALUES (10, 'has_cleanup', 'false');
310 INSERT INTO metadatas VALUES (10, 'required_configs', '');
311 INSERT INTO metadatas VALUES (10, 'required_files', '');
312 INSERT INTO metadatas VALUES (10, 'required_memory', '0');
313 INSERT INTO metadatas VALUES (10, 'required_programs', '');
314 INSERT INTO metadatas VALUES (10, 'required_user', '');
315 INSERT INTO metadatas VALUES (10, 'timeout', '300');
318 INSERT INTO test_programs (test_program_id, action_id, absolute_path, root,
319 relative_path, test_suite_name, metadata_id,
321 VALUES (7, 3, '/usr/tests/simple_test', '/usr/tests',
322 'simple_test', 'subsuite-name', 10, 'atf');
325 INSERT INTO metadatas VALUES (11, 'allowed_architectures', '');
326 INSERT INTO metadatas VALUES (11, 'allowed_platforms', '');
327 INSERT INTO metadatas VALUES (11, 'description', 'More text');
328 INSERT INTO metadatas VALUES (11, 'has_cleanup', 'true');
329 INSERT INTO metadatas VALUES (11, 'required_configs', '');
330 INSERT INTO metadatas VALUES (11, 'required_files', '');
331 INSERT INTO metadatas VALUES (11, 'required_memory', '128');
332 INSERT INTO metadatas VALUES (11, 'required_programs', '');
333 INSERT INTO metadatas VALUES (11, 'required_user', 'unprivileged');
334 INSERT INTO metadatas VALUES (11, 'timeout', '300');
337 INSERT INTO test_cases (test_case_id, test_program_id, name, metadata_id)
338 VALUES (9, 7, 'main', 11);
339 INSERT INTO test_results (test_case_id, result_type, result_reason, start_time,
341 VALUES (9, 'failed', 'Exited with code 1',
342 1357648740120000, 1357648750081700);
345 INSERT INTO files (file_id, contents)
346 VALUES (4, x'416e6f7468657220737464657272');
347 INSERT INTO test_case_files (test_case_id, file_name, file_id)
348 VALUES (9, '__STDERR__', 4);
352 -- Action 4: Mixture of test programs.
357 INSERT INTO contexts (context_id, cwd) VALUES (4, '/usr/tests');
358 INSERT INTO env_vars (context_id, var_name, var_value)
359 VALUES (4, 'LANG', 'C');
360 INSERT INTO env_vars (context_id, var_name, var_value)
361 VALUES (4, 'PATH', '/bin:/usr/bin');
362 INSERT INTO env_vars (context_id, var_name, var_value)
363 VALUES (4, 'TERM', 'xterm');
366 INSERT INTO actions (action_id, context_id) VALUES (4, 4);
369 INSERT INTO metadatas VALUES (12, 'allowed_architectures', '');
370 INSERT INTO metadatas VALUES (12, 'allowed_platforms', '');
371 INSERT INTO metadatas VALUES (12, 'description', '');
372 INSERT INTO metadatas VALUES (12, 'has_cleanup', 'false');
373 INSERT INTO metadatas VALUES (12, 'required_configs', '');
374 INSERT INTO metadatas VALUES (12, 'required_files', '');
375 INSERT INTO metadatas VALUES (12, 'required_memory', '0');
376 INSERT INTO metadatas VALUES (12, 'required_programs', '');
377 INSERT INTO metadatas VALUES (12, 'required_user', '');
378 INSERT INTO metadatas VALUES (12, 'timeout', '10');
381 INSERT INTO test_programs (test_program_id, action_id, absolute_path, root,
382 relative_path, test_suite_name, metadata_id,
384 VALUES (8, 4, '/usr/tests/subdir/another_test', '/usr/tests',
385 'subdir/another_test', 'subsuite-name', 12, 'plain');
388 INSERT INTO test_cases (test_case_id, test_program_id, name, metadata_id)
389 VALUES (10, 8, 'main', 12);
390 INSERT INTO test_results (test_case_id, result_type, result_reason, start_time,
392 VALUES (10, 'failed', 'Exit failure', 1357644395000000, 1357644396000000);
395 INSERT INTO files (file_id, contents) VALUES (5, x'54657374207374646f7574');
396 INSERT INTO test_case_files (test_case_id, file_name, file_id)
397 VALUES (10, '__STDOUT__', 5);
400 INSERT INTO files (file_id, contents) VALUES (6, x'5465737420737464657272');
401 INSERT INTO test_case_files (test_case_id, file_name, file_id)
402 VALUES (10, '__STDERR__', 6);
405 INSERT INTO metadatas VALUES (13, 'allowed_architectures', '');
406 INSERT INTO metadatas VALUES (13, 'allowed_platforms', '');
407 INSERT INTO metadatas VALUES (13, 'description', '');
408 INSERT INTO metadatas VALUES (13, 'has_cleanup', 'false');
409 INSERT INTO metadatas VALUES (13, 'required_configs', '');
410 INSERT INTO metadatas VALUES (13, 'required_files', '');
411 INSERT INTO metadatas VALUES (13, 'required_memory', '0');
412 INSERT INTO metadatas VALUES (13, 'required_programs', '');
413 INSERT INTO metadatas VALUES (13, 'required_user', '');
414 INSERT INTO metadatas VALUES (13, 'timeout', '300');
417 INSERT INTO test_programs (test_program_id, action_id, absolute_path, root,
418 relative_path, test_suite_name, metadata_id,
420 VALUES (9, 4, '/usr/tests/complex_test', '/usr/tests',
421 'complex_test', 'suite-name', 14, 'atf');
424 INSERT INTO metadatas VALUES (15, 'allowed_architectures', '');
425 INSERT INTO metadatas VALUES (15, 'allowed_platforms', '');
426 INSERT INTO metadatas VALUES (15, 'description', '');
427 INSERT INTO metadatas VALUES (15, 'has_cleanup', 'false');
428 INSERT INTO metadatas VALUES (15, 'required_configs', '');
429 INSERT INTO metadatas VALUES (15, 'required_files', '');
430 INSERT INTO metadatas VALUES (15, 'required_memory', '0');
431 INSERT INTO metadatas VALUES (15, 'required_programs', '');
432 INSERT INTO metadatas VALUES (15, 'required_user', '');
433 INSERT INTO metadatas VALUES (15, 'timeout', '300');
436 INSERT INTO test_cases (test_case_id, test_program_id, name, metadata_id)
437 VALUES (11, 9, 'this_passes', 15);
438 INSERT INTO test_results (test_case_id, result_type, result_reason, start_time,
440 VALUES (11, 'passed', NULL, 1357644396500000, 1357644397000000);
443 INSERT INTO metadatas VALUES (16, 'allowed_architectures', '');
444 INSERT INTO metadatas VALUES (16, 'allowed_platforms', '');
445 INSERT INTO metadatas VALUES (16, 'description', 'Test description');
446 INSERT INTO metadatas VALUES (16, 'has_cleanup', 'false');
447 INSERT INTO metadatas VALUES (16, 'required_configs', '');
448 INSERT INTO metadatas VALUES (16, 'required_files', '');
449 INSERT INTO metadatas VALUES (16, 'required_memory', '0');
450 INSERT INTO metadatas VALUES (16, 'required_programs', '');
451 INSERT INTO metadatas VALUES (16, 'required_user', 'root');
452 INSERT INTO metadatas VALUES (16, 'timeout', '300');
455 INSERT INTO test_cases (test_case_id, test_program_id, name, metadata_id)
456 VALUES (12, 9, 'this_fails', 16);
457 INSERT INTO test_results (test_case_id, result_type, result_reason, start_time,
459 VALUES (12, 'failed', 'Some reason', 1357644397100000, 1357644399005000);