Book a Demo!
CoCalc Logo Icon
StoreFeaturesDocsShareSupportNewsAboutPoliciesSign UpSign In
freebsd
GitHub Repository: freebsd/freebsd-src
 Path: blob/main/contrib/kyua/store/testdata_v2.sql
39478 views
1
-- Copyright 2013 The Kyua Authors.

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


464