]> iEval git - gruntmaster-data.git/blob - testdata.sql
Purge problem/contest list after adding problem/contest
[gruntmaster-data.git] / testdata.sql
1 CREATE OR REPLACE FUNCTION tm() RETURNS BIGINT IMMUTABLE LANGUAGE SQL AS $$
2 SELECT EXTRACT(epoch FROM NOW())::bigint
3 $$;
4
5 TRUNCATE users, contests, problems, jobs RESTART IDENTITY CASCADE;
6
7 -- USERS
8
9 INSERT INTO users (id, admin) VALUES ('MGV', TRUE);
10 INSERT INTO users (id, admin) VALUES ('nobody', FALSE);
11
12 -- CONTESTS
13
14 ALTER TABLE contests ALTER owner SET DEFAULT 'MGV';
15
16 INSERT INTO contests (id, start, stop, name) VALUES ('fc', tm() - 2000, tm() - 1000, 'Finished contest');
17 INSERT INTO contests (id, start, stop, name) VALUES ('rc', tm() - 1000, tm() + 1000, 'Running contest');
18 INSERT INTO contests (id, start, stop, name) VALUES ('pc', tm() + 1000, tm() + 2000, 'Pending contest');
19
20 -- PROBLEMS
21
22 ALTER TABLE problems ALTER generator SET DEFAULT 'Undef',
23 ALTER runner SET DEFAULT 'File',
24 ALTER judge SET DEFAULT 'Absolute',
25 ALTER level SET DEFAULT 'beginner',
26 ALTER value SET DEFAULT 100,
27 ALTER owner SET DEFAULT 'MGV',
28 ALTER statement SET DEFAULT 'Sample Text',
29 ALTER solution SET DEFAULT 'Sample Text',
30 ALTER testcnt SET DEFAULT 1,
31 ALTER timeout SET DEFAULT 1;
32
33 INSERT INTO problems (id, name, private) VALUES ('fca', 'FC problem A', FALSE);
34 INSERT INTO problems (id, name, private) VALUES ('rca', 'RC problem A', TRUE);
35 INSERT INTO problems (id, name, private) VALUES ('pca', 'PC problem A', TRUE);
36 INSERT INTO problems (id, name, private) VALUES ('arc', 'Problem in archive', FALSE);
37 INSERT INTO problems (id, name, private) VALUES ('prv', 'Private problem', TRUE);
38
39 INSERT INTO contest_problems (contest, problem) VALUES ('fc', 'fca');
40 INSERT INTO contest_problems (contest, problem) VALUES ('rc', 'rca');
41 INSERT INTO contest_problems (contest, problem) VALUES ('pc', 'pca');
42
43 INSERT INTO limits (problem, format, timeout) VALUES ('arc', 'C', 0.1);
44 INSERT INTO limits (problem, format, timeout) VALUES ('arc', 'CPP', 0.1);
45
46 -- JOBS
47
48 ALTER TABLE jobs ALTER date SET DEFAULT tm() - 1500,
49 ALTER errors SET DEFAULT 'Errors here',
50 ALTER extension SET DEFAULT 'pl',
51 ALTER format SET DEFAULT 'PERL',
52 ALTER result SET DEFAULT 0,
53 ALTER result_text SET DEFAULT 'Accepted',
54 ALTER results SET DEFAULT '[]',
55 ALTER source SET DEFAULT 'print "Hello, world!"',
56 ALTER owner SET DEFAULT 'nobody';
57
58 INSERT INTO jobs (contest, problem, owner) VALUES ('fc', 'fca', 'MGV');
59 INSERT INTO jobs (contest, problem, result, result_text, date) VALUES ('fc', 'fca', 1, 'Wrong Answer', tm() - 1600);
60 INSERT INTO jobs (contest, problem) VALUES ('fc', 'fca');
61 INSERT INTO jobs (problem, date) VALUES ('fca', tm() - 500);
62 INSERT INTO jobs (problem, date) VALUES ('arc', tm() - 100);
63 INSERT INTO jobs (problem, private, owner) VALUES ('pca', TRUE, 'MGV');
64 INSERT INTO jobs (problem, private, owner, result, result_text, results) VALUES ('prv', TRUE, 'MGV', NULL, NULL, NULL);
This page took 0.047286 seconds and 4 git commands to generate.