xref: /freebsd-src/contrib/kyua/store/testdata_v1.sql (revision b0d29bc47dba79f6f38e67eabadfb4b32ffd9390)
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_v1.sql
30*b0d29bc4SBrooks Davis-- Populates a v1 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-- test_program_id 1
67*b0d29bc4SBrooks DavisINSERT INTO test_programs (test_program_id, action_id, absolute_path, root,
68*b0d29bc4SBrooks Davis                           relative_path, test_suite_name, interface)
69*b0d29bc4SBrooks Davis    VALUES (1, 2, '/test/suite/root/foo_test', '/test/suite/root',
70*b0d29bc4SBrooks Davis            'foo_test', 'suite-name', 'plain');
71*b0d29bc4SBrooks DavisINSERT INTO plain_test_programs (test_program_id, timeout)
72*b0d29bc4SBrooks Davis    VALUES (1, 300000000);
73*b0d29bc4SBrooks Davis
74*b0d29bc4SBrooks Davis-- test_case_id 1
75*b0d29bc4SBrooks DavisINSERT INTO test_cases (test_case_id, test_program_id, name)
76*b0d29bc4SBrooks Davis    VALUES (1, 1, 'main');
77*b0d29bc4SBrooks DavisINSERT INTO test_results (test_case_id, result_type, result_reason, start_time,
78*b0d29bc4SBrooks Davis                          end_time)
79*b0d29bc4SBrooks Davis    VALUES (1, 'passed', NULL, 1357643611000000, 1357643621000500);
80*b0d29bc4SBrooks Davis
81*b0d29bc4SBrooks Davis-- test_program_id 2
82*b0d29bc4SBrooks DavisINSERT INTO test_programs (test_program_id, action_id, absolute_path, root,
83*b0d29bc4SBrooks Davis                           relative_path, test_suite_name, interface)
84*b0d29bc4SBrooks Davis    VALUES (2, 2, '/test/suite/root/subdir/another_test', '/test/suite/root',
85*b0d29bc4SBrooks Davis            'subdir/another_test', 'subsuite-name', 'plain');
86*b0d29bc4SBrooks DavisINSERT INTO plain_test_programs (test_program_id, timeout)
87*b0d29bc4SBrooks Davis    VALUES (2, 10000000);
88*b0d29bc4SBrooks Davis
89*b0d29bc4SBrooks Davis-- test_case_id 2
90*b0d29bc4SBrooks DavisINSERT INTO test_cases (test_case_id, test_program_id, name)
91*b0d29bc4SBrooks Davis    VALUES (2, 2, 'main');
92*b0d29bc4SBrooks DavisINSERT INTO test_results (test_case_id, result_type, result_reason, start_time,
93*b0d29bc4SBrooks Davis                          end_time)
94*b0d29bc4SBrooks Davis    VALUES (2, 'failed', 'Exited with code 1',
95*b0d29bc4SBrooks Davis            1357643622001200, 1357643622900021);
96*b0d29bc4SBrooks Davis
97*b0d29bc4SBrooks Davis-- file_id 1
98*b0d29bc4SBrooks DavisINSERT INTO files (file_id, contents) VALUES (1, x'54657374207374646f7574');
99*b0d29bc4SBrooks DavisINSERT INTO test_case_files (test_case_id, file_name, file_id)
100*b0d29bc4SBrooks Davis    VALUES (2, '__STDOUT__', 1);
101*b0d29bc4SBrooks Davis
102*b0d29bc4SBrooks Davis-- file_id 2
103*b0d29bc4SBrooks DavisINSERT INTO files (file_id, contents) VALUES (2, x'5465737420737464657272');
104*b0d29bc4SBrooks DavisINSERT INTO test_case_files (test_case_id, file_name, file_id)
105*b0d29bc4SBrooks Davis    VALUES (2, '__STDERR__', 2);
106*b0d29bc4SBrooks Davis
107*b0d29bc4SBrooks Davis-- test_program_id 3
108*b0d29bc4SBrooks DavisINSERT INTO test_programs (test_program_id, action_id, absolute_path, root,
109*b0d29bc4SBrooks Davis                           relative_path, test_suite_name, interface)
110*b0d29bc4SBrooks Davis    VALUES (3, 2, '/test/suite/root/subdir/bar_test', '/test/suite/root',
111*b0d29bc4SBrooks Davis            'subdir/bar_test', 'subsuite-name', 'plain');
112*b0d29bc4SBrooks DavisINSERT INTO plain_test_programs (test_program_id, timeout)
113*b0d29bc4SBrooks Davis    VALUES (3, 300000000);
114*b0d29bc4SBrooks Davis
115*b0d29bc4SBrooks Davis-- test_case_id 3
116*b0d29bc4SBrooks DavisINSERT INTO test_cases (test_case_id, test_program_id, name)
117*b0d29bc4SBrooks Davis    VALUES (3, 3, 'main');
118*b0d29bc4SBrooks DavisINSERT INTO test_results (test_case_id, result_type, result_reason, start_time,
119*b0d29bc4SBrooks Davis                          end_time)
120*b0d29bc4SBrooks Davis    VALUES (3, 'broken', 'Received signal 1',
121*b0d29bc4SBrooks Davis            1357643623500000, 1357643630981932);
122*b0d29bc4SBrooks Davis
123*b0d29bc4SBrooks Davis-- test_program_id 4
124*b0d29bc4SBrooks DavisINSERT INTO test_programs (test_program_id, action_id, absolute_path, root,
125*b0d29bc4SBrooks Davis                           relative_path, test_suite_name, interface)
126*b0d29bc4SBrooks Davis    VALUES (4, 2, '/test/suite/root/top_test', '/test/suite/root',
127*b0d29bc4SBrooks Davis            'top_test', 'suite-name', 'plain');
128*b0d29bc4SBrooks DavisINSERT INTO plain_test_programs (test_program_id, timeout)
129*b0d29bc4SBrooks Davis    VALUES (4, 300000000);
130*b0d29bc4SBrooks Davis
131*b0d29bc4SBrooks Davis-- test_case_id 4
132*b0d29bc4SBrooks DavisINSERT INTO test_cases (test_case_id, test_program_id, name)
133*b0d29bc4SBrooks Davis    VALUES (4, 4, 'main');
134*b0d29bc4SBrooks DavisINSERT INTO test_results (test_case_id, result_type, result_reason, start_time,
135*b0d29bc4SBrooks Davis                          end_time)
136*b0d29bc4SBrooks Davis    VALUES (4, 'expected_failure', 'Known bug',
137*b0d29bc4SBrooks Davis            1357643631000000, 1357643631020000);
138*b0d29bc4SBrooks Davis
139*b0d29bc4SBrooks Davis-- test_program_id 5
140*b0d29bc4SBrooks DavisINSERT INTO test_programs (test_program_id, action_id, absolute_path, root,
141*b0d29bc4SBrooks Davis                           relative_path, test_suite_name, interface)
142*b0d29bc4SBrooks Davis    VALUES (5, 2, '/test/suite/root/last_test', '/test/suite/root',
143*b0d29bc4SBrooks Davis            'last_test', 'suite-name', 'plain');
144*b0d29bc4SBrooks DavisINSERT INTO plain_test_programs (test_program_id, timeout)
145*b0d29bc4SBrooks Davis    VALUES (5, 300000000);
146*b0d29bc4SBrooks Davis
147*b0d29bc4SBrooks Davis-- test_case_id 5
148*b0d29bc4SBrooks DavisINSERT INTO test_cases (test_case_id, test_program_id, name)
149*b0d29bc4SBrooks Davis    VALUES (5, 5, 'main');
150*b0d29bc4SBrooks DavisINSERT INTO test_results (test_case_id, result_type, result_reason, start_time,
151*b0d29bc4SBrooks Davis                          end_time)
152*b0d29bc4SBrooks Davis    VALUES (5, 'skipped', 'Does not apply', 1357643632000000, 1357643638000000);
153*b0d29bc4SBrooks Davis
154*b0d29bc4SBrooks Davis
155*b0d29bc4SBrooks Davis--
156*b0d29bc4SBrooks Davis-- Action 3: ATF test programs only.
157*b0d29bc4SBrooks Davis--
158*b0d29bc4SBrooks Davis
159*b0d29bc4SBrooks Davis
160*b0d29bc4SBrooks Davis-- context_id 3
161*b0d29bc4SBrooks DavisINSERT INTO contexts (context_id, cwd) VALUES (3, '/usr/tests');
162*b0d29bc4SBrooks DavisINSERT INTO env_vars (context_id, var_name, var_value)
163*b0d29bc4SBrooks Davis    VALUES (3, 'PATH', '/bin:/usr/bin');
164*b0d29bc4SBrooks Davis
165*b0d29bc4SBrooks Davis-- action_id 3
166*b0d29bc4SBrooks DavisINSERT INTO actions (action_id, context_id) VALUES (3, 3);
167*b0d29bc4SBrooks Davis
168*b0d29bc4SBrooks Davis-- test_program_id 6
169*b0d29bc4SBrooks DavisINSERT INTO test_programs (test_program_id, action_id, absolute_path, root,
170*b0d29bc4SBrooks Davis                           relative_path, test_suite_name, interface)
171*b0d29bc4SBrooks Davis    VALUES (6, 3, '/usr/tests/complex_test', '/usr/tests',
172*b0d29bc4SBrooks Davis            'complex_test', 'suite-name', 'atf');
173*b0d29bc4SBrooks Davis
174*b0d29bc4SBrooks Davis-- test_case_id 6, passed, no optional metadata.
175*b0d29bc4SBrooks DavisINSERT INTO test_cases (test_case_id, test_program_id, name)
176*b0d29bc4SBrooks Davis    VALUES (6, 6, 'this_passes');
177*b0d29bc4SBrooks DavisINSERT INTO test_results (test_case_id, result_type, result_reason, start_time,
178*b0d29bc4SBrooks Davis                          end_time)
179*b0d29bc4SBrooks Davis    VALUES (6, 'passed', NULL, 1357648712000000, 1357648718000000);
180*b0d29bc4SBrooks DavisINSERT INTO atf_test_cases (test_case_id, description, has_cleanup, timeout,
181*b0d29bc4SBrooks Davis                            required_memory, required_user)
182*b0d29bc4SBrooks Davis    VALUES (6, NULL, 'false', 300000000, 0, NULL);
183*b0d29bc4SBrooks Davis
184*b0d29bc4SBrooks Davis-- test_case_id 7, failed, optional non-multivalue metadata.
185*b0d29bc4SBrooks DavisINSERT INTO test_cases (test_case_id, test_program_id, name)
186*b0d29bc4SBrooks Davis    VALUES (7, 6, 'this_fails');
187*b0d29bc4SBrooks DavisINSERT INTO test_results (test_case_id, result_type, result_reason, start_time,
188*b0d29bc4SBrooks Davis                          end_time)
189*b0d29bc4SBrooks Davis    VALUES (7, 'failed', 'Some reason', 1357648719000000, 1357648720897182);
190*b0d29bc4SBrooks DavisINSERT INTO atf_test_cases (test_case_id, description, has_cleanup, timeout,
191*b0d29bc4SBrooks Davis                            required_memory, required_user)
192*b0d29bc4SBrooks Davis    VALUES (7, 'Test description', 'true', 300000000, 128, 'root');
193*b0d29bc4SBrooks Davis
194*b0d29bc4SBrooks Davis-- test_case_id 8, skipped, all optional metadata.
195*b0d29bc4SBrooks DavisINSERT INTO test_cases (test_case_id, test_program_id, name)
196*b0d29bc4SBrooks Davis    VALUES (8, 6, 'this_skips');
197*b0d29bc4SBrooks DavisINSERT INTO test_results (test_case_id, result_type, result_reason, start_time,
198*b0d29bc4SBrooks Davis                          end_time)
199*b0d29bc4SBrooks Davis    VALUES (8, 'skipped', 'Another reason', 1357648729182013, 1357648730000000);
200*b0d29bc4SBrooks DavisINSERT INTO atf_test_cases (test_case_id, description, has_cleanup, timeout,
201*b0d29bc4SBrooks Davis                            required_memory, required_user)
202*b0d29bc4SBrooks Davis    VALUES (8, 'Test explanation', 'true', 600000000, 512, 'unprivileged');
203*b0d29bc4SBrooks DavisINSERT INTO atf_test_cases_multivalues (test_case_id, property_name,
204*b0d29bc4SBrooks Davis                                        property_value)
205*b0d29bc4SBrooks Davis    VALUES (8, 'require.arch', 'x86_64');
206*b0d29bc4SBrooks DavisINSERT INTO atf_test_cases_multivalues (test_case_id, property_name,
207*b0d29bc4SBrooks Davis                                        property_value)
208*b0d29bc4SBrooks Davis    VALUES (8, 'require.arch', 'powerpc');
209*b0d29bc4SBrooks DavisINSERT INTO atf_test_cases_multivalues (test_case_id, property_name,
210*b0d29bc4SBrooks Davis                                        property_value)
211*b0d29bc4SBrooks Davis    VALUES (8, 'require.machine', 'amd64');
212*b0d29bc4SBrooks DavisINSERT INTO atf_test_cases_multivalues (test_case_id, property_name,
213*b0d29bc4SBrooks Davis                                        property_value)
214*b0d29bc4SBrooks Davis    VALUES (8, 'require.machine', 'macppc');
215*b0d29bc4SBrooks DavisINSERT INTO atf_test_cases_multivalues (test_case_id, property_name,
216*b0d29bc4SBrooks Davis                                        property_value)
217*b0d29bc4SBrooks Davis    VALUES (8, 'require.config', 'unprivileged_user');
218*b0d29bc4SBrooks DavisINSERT INTO atf_test_cases_multivalues (test_case_id, property_name,
219*b0d29bc4SBrooks Davis                                        property_value)
220*b0d29bc4SBrooks Davis    VALUES (8, 'require.config', 'X-foo');
221*b0d29bc4SBrooks DavisINSERT INTO atf_test_cases_multivalues (test_case_id, property_name,
222*b0d29bc4SBrooks Davis                                        property_value)
223*b0d29bc4SBrooks Davis    VALUES (8, 'require.files', '/the/data/file');
224*b0d29bc4SBrooks DavisINSERT INTO atf_test_cases_multivalues (test_case_id, property_name,
225*b0d29bc4SBrooks Davis                                        property_value)
226*b0d29bc4SBrooks Davis    VALUES (8, 'require.progs', 'cp');
227*b0d29bc4SBrooks DavisINSERT INTO atf_test_cases_multivalues (test_case_id, property_name,
228*b0d29bc4SBrooks Davis                                        property_value)
229*b0d29bc4SBrooks Davis    VALUES (8, 'require.progs', '/bin/ls');
230*b0d29bc4SBrooks Davis
231*b0d29bc4SBrooks Davis-- file_id 3
232*b0d29bc4SBrooks DavisINSERT INTO files (file_id, contents)
233*b0d29bc4SBrooks Davis    VALUES (3, x'416e6f74686572207374646f7574');
234*b0d29bc4SBrooks DavisINSERT INTO test_case_files (test_case_id, file_name, file_id)
235*b0d29bc4SBrooks Davis    VALUES (8, '__STDOUT__', 3);
236*b0d29bc4SBrooks Davis
237*b0d29bc4SBrooks Davis-- test_program_id 7
238*b0d29bc4SBrooks DavisINSERT INTO test_programs (test_program_id, action_id, absolute_path, root,
239*b0d29bc4SBrooks Davis                           relative_path, test_suite_name, interface)
240*b0d29bc4SBrooks Davis    VALUES (7, 3, '/usr/tests/simple_test', '/usr/tests',
241*b0d29bc4SBrooks Davis            'simple_test', 'subsuite-name', 'atf');
242*b0d29bc4SBrooks Davis
243*b0d29bc4SBrooks Davis-- test_case_id 9
244*b0d29bc4SBrooks DavisINSERT INTO test_cases (test_case_id, test_program_id, name)
245*b0d29bc4SBrooks Davis    VALUES (9, 7, 'main');
246*b0d29bc4SBrooks DavisINSERT INTO test_results (test_case_id, result_type, result_reason, start_time,
247*b0d29bc4SBrooks Davis                          end_time)
248*b0d29bc4SBrooks Davis    VALUES (9, 'failed', 'Exited with code 1',
249*b0d29bc4SBrooks Davis            1357648740120000, 1357648750081700);
250*b0d29bc4SBrooks DavisINSERT INTO atf_test_cases (test_case_id, description, has_cleanup, timeout,
251*b0d29bc4SBrooks Davis                            required_memory, required_user)
252*b0d29bc4SBrooks Davis    VALUES (9, 'More text', 'true', 300000000, 128, 'unprivileged');
253*b0d29bc4SBrooks Davis
254*b0d29bc4SBrooks Davis-- file_id 4
255*b0d29bc4SBrooks DavisINSERT INTO files (file_id, contents)
256*b0d29bc4SBrooks Davis    VALUES (4, x'416e6f7468657220737464657272');
257*b0d29bc4SBrooks DavisINSERT INTO test_case_files (test_case_id, file_name, file_id)
258*b0d29bc4SBrooks Davis    VALUES (9, '__STDERR__', 4);
259*b0d29bc4SBrooks Davis
260*b0d29bc4SBrooks Davis
261*b0d29bc4SBrooks Davis--
262*b0d29bc4SBrooks Davis-- Action 4: Mixture of test programs.
263*b0d29bc4SBrooks Davis--
264*b0d29bc4SBrooks Davis
265*b0d29bc4SBrooks Davis
266*b0d29bc4SBrooks Davis-- context_id 4
267*b0d29bc4SBrooks DavisINSERT INTO contexts (context_id, cwd) VALUES (4, '/usr/tests');
268*b0d29bc4SBrooks DavisINSERT INTO env_vars (context_id, var_name, var_value)
269*b0d29bc4SBrooks Davis    VALUES (4, 'LANG', 'C');
270*b0d29bc4SBrooks DavisINSERT INTO env_vars (context_id, var_name, var_value)
271*b0d29bc4SBrooks Davis    VALUES (4, 'PATH', '/bin:/usr/bin');
272*b0d29bc4SBrooks DavisINSERT INTO env_vars (context_id, var_name, var_value)
273*b0d29bc4SBrooks Davis    VALUES (4, 'TERM', 'xterm');
274*b0d29bc4SBrooks Davis
275*b0d29bc4SBrooks Davis-- action_id 4
276*b0d29bc4SBrooks DavisINSERT INTO actions (action_id, context_id) VALUES (4, 4);
277*b0d29bc4SBrooks Davis
278*b0d29bc4SBrooks Davis-- test_program_id 8
279*b0d29bc4SBrooks DavisINSERT INTO test_programs (test_program_id, action_id, absolute_path, root,
280*b0d29bc4SBrooks Davis                           relative_path, test_suite_name, interface)
281*b0d29bc4SBrooks Davis    VALUES (8, 4, '/usr/tests/subdir/another_test', '/usr/tests',
282*b0d29bc4SBrooks Davis            'subdir/another_test', 'subsuite-name', 'plain');
283*b0d29bc4SBrooks DavisINSERT INTO plain_test_programs (test_program_id, timeout)
284*b0d29bc4SBrooks Davis    VALUES (8, 10000000);
285*b0d29bc4SBrooks Davis
286*b0d29bc4SBrooks Davis-- test_case_id 10
287*b0d29bc4SBrooks DavisINSERT INTO test_cases (test_case_id, test_program_id, name)
288*b0d29bc4SBrooks Davis    VALUES (10, 8, 'main');
289*b0d29bc4SBrooks DavisINSERT INTO test_results (test_case_id, result_type, result_reason, start_time,
290*b0d29bc4SBrooks Davis                          end_time)
291*b0d29bc4SBrooks Davis    VALUES (10, 'failed', 'Exit failure', 1357644395000000, 1357644396000000);
292*b0d29bc4SBrooks Davis
293*b0d29bc4SBrooks Davis-- file_id 5
294*b0d29bc4SBrooks DavisINSERT INTO files (file_id, contents) VALUES (5, x'54657374207374646f7574');
295*b0d29bc4SBrooks DavisINSERT INTO test_case_files (test_case_id, file_name, file_id)
296*b0d29bc4SBrooks Davis    VALUES (10, '__STDOUT__', 5);
297*b0d29bc4SBrooks Davis
298*b0d29bc4SBrooks Davis-- file_id 6
299*b0d29bc4SBrooks DavisINSERT INTO files (file_id, contents) VALUES (6, x'5465737420737464657272');
300*b0d29bc4SBrooks DavisINSERT INTO test_case_files (test_case_id, file_name, file_id)
301*b0d29bc4SBrooks Davis    VALUES (10, '__STDERR__', 6);
302*b0d29bc4SBrooks Davis
303*b0d29bc4SBrooks Davis-- test_program_id 9
304*b0d29bc4SBrooks DavisINSERT INTO test_programs (test_program_id, action_id, absolute_path, root,
305*b0d29bc4SBrooks Davis                           relative_path, test_suite_name, interface)
306*b0d29bc4SBrooks Davis    VALUES (9, 4, '/usr/tests/complex_test', '/usr/tests',
307*b0d29bc4SBrooks Davis            'complex_test', 'suite-name', 'atf');
308*b0d29bc4SBrooks Davis
309*b0d29bc4SBrooks Davis-- test_case_id 11
310*b0d29bc4SBrooks DavisINSERT INTO test_cases (test_case_id, test_program_id, name)
311*b0d29bc4SBrooks Davis    VALUES (11, 9, 'this_passes');
312*b0d29bc4SBrooks DavisINSERT INTO test_results (test_case_id, result_type, result_reason, start_time,
313*b0d29bc4SBrooks Davis                          end_time)
314*b0d29bc4SBrooks Davis    VALUES (11, 'passed', NULL, 1357644396500000, 1357644397000000);
315*b0d29bc4SBrooks DavisINSERT INTO atf_test_cases (test_case_id, description, has_cleanup, timeout,
316*b0d29bc4SBrooks Davis                            required_memory, required_user)
317*b0d29bc4SBrooks Davis    VALUES (11, NULL, 'false', 300000000, 0, NULL);
318*b0d29bc4SBrooks Davis
319*b0d29bc4SBrooks Davis-- test_case_id 12
320*b0d29bc4SBrooks DavisINSERT INTO test_cases (test_case_id, test_program_id, name)
321*b0d29bc4SBrooks Davis    VALUES (12, 9, 'this_fails');
322*b0d29bc4SBrooks DavisINSERT INTO test_results (test_case_id, result_type, result_reason, start_time,
323*b0d29bc4SBrooks Davis                          end_time)
324*b0d29bc4SBrooks Davis    VALUES (12, 'failed', 'Some reason', 1357644397100000, 1357644399005000);
325*b0d29bc4SBrooks DavisINSERT INTO atf_test_cases (test_case_id, description, has_cleanup, timeout,
326*b0d29bc4SBrooks Davis                            required_memory, required_user)
327*b0d29bc4SBrooks Davis    VALUES (12, 'Test description', 'false', 300000000, 0, 'root');
328*b0d29bc4SBrooks Davis
329*b0d29bc4SBrooks Davis
330*b0d29bc4SBrooks DavisCOMMIT TRANSACTION;
331