]>
iEval git - gruntmaster-data.git/blob - testdata.sql
1 CREATE OR REPLACE FUNCTION tm() RETURNS BIGINT IMMUTABLE LANGUAGE SQL AS $$
2 SELECT EXTRACT(epoch
FROM NOW())::bigint
5 TRUNCATE users
, contests
, problems
, jobs
RESTART IDENTITY CASCADE;
9 INSERT INTO users (id, admin) VALUES ('MGV', TRUE);
10 INSERT INTO users (id, admin) VALUES ('nobody', FALSE);
14 ALTER TABLE contests
ALTER owner SET DEFAULT 'MGV';
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');
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;
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);
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');
43 INSERT INTO limits (problem
, format
, timeout
) VALUES ('arc', 'C', 0.1);
44 INSERT INTO limits (problem
, format
, timeout
) VALUES ('arc', 'CPP', 0.1);
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';
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.