1 -- Copyright 2013 Google Inc. 2 -- All rights reserved. 3 -- 4 -- Redistribution and use in source and binary forms, with or without 5 -- modification, are permitted provided that the following conditions are 6 -- met: 7 -- 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. 16 -- 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. 28 29 -- \file store/testdata_v2.sql 30 -- Populates a v2 database with some test data. 31 32 33 BEGIN TRANSACTION; 34 35 36 -- 37 -- Action 1: Empty context and no test programs nor test cases. 38 -- 39 40 41 -- context_id 1 42 INSERT INTO contexts (context_id, cwd) VALUES (1, '/some/root'); 43 44 -- action_id 1 45 INSERT INTO actions (action_id, context_id) VALUES (1, 1); 46 47 48 -- 49 -- Action 2: Plain test programs only. 50 -- 51 -- This action contains 5 test programs, each with one test case, and each 52 -- reporting one of all possible result types. 53 -- 54 55 56 -- context_id 2 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'); 62 63 -- action_id 2 64 INSERT INTO actions (action_id, context_id) VALUES (2, 2); 65 66 -- metadata_id 1 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'); 77 78 -- test_program_id 1 79 INSERT INTO test_programs (test_program_id, action_id, absolute_path, root, 80 relative_path, test_suite_name, metadata_id, 81 interface) 82 VALUES (1, 2, '/test/suite/root/foo_test', '/test/suite/root', 83 'foo_test', 'suite-name', 1, 'plain'); 84 85 -- test_case_id 1 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, 89 end_time) 90 VALUES (1, 'passed', NULL, 1357643611000000, 1357643621000500); 91 92 -- metadata_id 2 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'); 103 104 -- test_program_id 2 105 INSERT INTO test_programs (test_program_id, action_id, absolute_path, root, 106 relative_path, test_suite_name, metadata_id, 107 interface) 108 VALUES (2, 2, '/test/suite/root/subdir/another_test', '/test/suite/root', 109 'subdir/another_test', 'subsuite-name', 2, 'plain'); 110 111 -- test_case_id 2 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, 115 end_time) 116 VALUES (2, 'failed', 'Exited with code 1', 117 1357643622001200, 1357643622900021); 118 119 -- file_id 1 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); 123 124 -- file_id 2 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); 128 129 -- metadata_id 3 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'); 140 141 -- test_program_id 3 142 INSERT INTO test_programs (test_program_id, action_id, absolute_path, root, 143 relative_path, test_suite_name, metadata_id, 144 interface) 145 VALUES (3, 2, '/test/suite/root/subdir/bar_test', '/test/suite/root', 146 'subdir/bar_test', 'subsuite-name', 3, 'plain'); 147 148 -- test_case_id 3 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, 152 end_time) 153 VALUES (3, 'broken', 'Received signal 1', 154 1357643623500000, 1357643630981932); 155 156 -- metadata_id 4 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'); 167 168 -- test_program_id 4 169 INSERT INTO test_programs (test_program_id, action_id, absolute_path, root, 170 relative_path, test_suite_name, metadata_id, 171 interface) 172 VALUES (4, 2, '/test/suite/root/top_test', '/test/suite/root', 173 'top_test', 'suite-name', 4, 'plain'); 174 175 -- test_case_id 4 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, 179 end_time) 180 VALUES (4, 'expected_failure', 'Known bug', 181 1357643631000000, 1357643631020000); 182 183 -- metadata_id 5 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'); 194 195 -- test_program_id 5 196 INSERT INTO test_programs (test_program_id, action_id, absolute_path, root, 197 relative_path, test_suite_name, metadata_id, 198 interface) 199 VALUES (5, 2, '/test/suite/root/last_test', '/test/suite/root', 200 'last_test', 'suite-name', 5, 'plain'); 201 202 -- test_case_id 5 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, 206 end_time) 207 VALUES (5, 'skipped', 'Does not apply', 1357643632000000, 1357643638000000); 208 209 210 -- 211 -- Action 3: ATF test programs only. 212 -- 213 214 215 -- context_id 3 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'); 219 220 -- action_id 3 221 INSERT INTO actions (action_id, context_id) VALUES (3, 3); 222 223 -- metadata_id 6 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'); 234 235 -- test_program_id 6 236 INSERT INTO test_programs (test_program_id, action_id, absolute_path, root, 237 relative_path, test_suite_name, metadata_id, 238 interface) 239 VALUES (6, 3, '/usr/tests/complex_test', '/usr/tests', 240 'complex_test', 'suite-name', 6, 'atf'); 241 242 -- metadata_id 7 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'); 253 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, 258 end_time) 259 VALUES (6, 'passed', NULL, 1357648712000000, 1357648718000000); 260 261 -- metadata_id 8 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'); 272 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, 277 end_time) 278 VALUES (7, 'failed', 'Some reason', 1357648719000000, 1357648720897182); 279 280 -- metadata_id 9 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'); 291 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, 296 end_time) 297 VALUES (8, 'skipped', 'Another reason', 1357648729182013, 1357648730000000); 298 299 -- file_id 3 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); 304 305 -- metadata_id 10 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'); 316 317 -- test_program_id 7 318 INSERT INTO test_programs (test_program_id, action_id, absolute_path, root, 319 relative_path, test_suite_name, metadata_id, 320 interface) 321 VALUES (7, 3, '/usr/tests/simple_test', '/usr/tests', 322 'simple_test', 'subsuite-name', 10, 'atf'); 323 324 -- metadata_id 11 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'); 335 336 -- test_case_id 9 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, 340 end_time) 341 VALUES (9, 'failed', 'Exited with code 1', 342 1357648740120000, 1357648750081700); 343 344 -- file_id 4 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); 349 350 351 -- 352 -- Action 4: Mixture of test programs. 353 -- 354 355 356 -- context_id 4 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'); 364 365 -- action_id 4 366 INSERT INTO actions (action_id, context_id) VALUES (4, 4); 367 368 -- metadata_id 12 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'); 379 380 -- test_program_id 8 381 INSERT INTO test_programs (test_program_id, action_id, absolute_path, root, 382 relative_path, test_suite_name, metadata_id, 383 interface) 384 VALUES (8, 4, '/usr/tests/subdir/another_test', '/usr/tests', 385 'subdir/another_test', 'subsuite-name', 12, 'plain'); 386 387 -- test_case_id 10 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, 391 end_time) 392 VALUES (10, 'failed', 'Exit failure', 1357644395000000, 1357644396000000); 393 394 -- file_id 5 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); 398 399 -- file_id 6 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); 403 404 -- metadata_id 13 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'); 415 416 -- test_program_id 9 417 INSERT INTO test_programs (test_program_id, action_id, absolute_path, root, 418 relative_path, test_suite_name, metadata_id, 419 interface) 420 VALUES (9, 4, '/usr/tests/complex_test', '/usr/tests', 421 'complex_test', 'suite-name', 14, 'atf'); 422 423 -- metadata_id 15 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'); 434 435 -- test_case_id 11 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, 439 end_time) 440 VALUES (11, 'passed', NULL, 1357644396500000, 1357644397000000); 441 442 -- metadata_id 16 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'); 453 454 -- test_case_id 12 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, 458 end_time) 459 VALUES (12, 'failed', 'Some reason', 1357644397100000, 1357644399005000); 460 461 462 COMMIT TRANSACTION; 463
Indexes created Tue Feb 24 01:34:59 UTC 2026