57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
|
state TEXT,
status TEXT,
count INTEGER,
last_update INTEGER DEFAULT extract(epoch from now()));
CREATE TABLE IF NOT EXISTS test_meta (
id SERIAL PRIMARY KEY,
testname TEXT DEFAULT '',
author TEXT DEFAULT '',
owner TEXT DEFAULT '',
description TEXT DEFAULT '',
reviewed TEXT,
iterated TEXT DEFAULT '',
avg_runtime REAL,
avg_disk REAL,
tags TEXT DEFAULT '',
jobgroup TEXT DEFAULT 'default',
CONSTRAINT test_meta_constraint UNIQUE (testname));
CREATE TABLE IF NOT EXISTS tasks_queue (
id SERIAL PRIMARY KEY,
action TEXT DEFAULT '',
owner TEXT,
state TEXT DEFAULT 'new',
target TEXT DEFAULT '',
|
|
|
|
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
|
state TEXT,
status TEXT,
count INTEGER,
last_update INTEGER DEFAULT extract(epoch from now()));
CREATE TABLE IF NOT EXISTS test_meta (
id SERIAL PRIMARY KEY,
test_name TEXT DEFAULT '',
author TEXT DEFAULT '',
owner TEXT DEFAULT '',
description TEXT DEFAULT '',
reviewed TEXT,
iterated TEXT DEFAULT '',
avg_runtime REAL,
avg_disk REAL,
tags TEXT DEFAULT '',
jobgroup TEXT DEFAULT 'default',
CONSTRAINT test_meta_constraint UNIQUE (test_name));
CREATE TABLE IF NOT EXISTS tasks_queue (
id SERIAL PRIMARY KEY,
action TEXT DEFAULT '',
owner TEXT,
state TEXT DEFAULT 'new',
target TEXT DEFAULT '',
|
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
|
last_du INTEGER DEFAULT -1,
last_du_time INTEGER DEFAULT extract(epoch from now()),
creation_time INTEGER DEFAULT extract(epoch from now()));
CREATE TABLE IF NOT EXISTS archive_allocations (
id SERIAL PRIMARY KEY,
archive_block_id INTEGER,
testname TEXT,
item_path TEXT,
creation_time INTEGER DEFAULT extract(epoch from now()));
CREATE TABLE IF NOT EXISTS extradat (
id SERIAL PRIMARY KEY,
run_id INTEGER,
key TEXT,
|
|
|
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
|
last_du INTEGER DEFAULT -1,
last_du_time INTEGER DEFAULT extract(epoch from now()),
creation_time INTEGER DEFAULT extract(epoch from now()));
CREATE TABLE IF NOT EXISTS archive_allocations (
id SERIAL PRIMARY KEY,
archive_block_id INTEGER,
test_name TEXT,
item_path TEXT,
creation_time INTEGER DEFAULT extract(epoch from now()));
CREATE TABLE IF NOT EXISTS extradat (
id SERIAL PRIMARY KEY,
run_id INTEGER,
key TEXT,
|
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
|
"user" TEXT,
accessed TIMESTAMP,
args TEXT);
CREATE TABLE IF NOT EXISTS tests (
id SERIAL PRIMARY KEY,
run_id INTEGER DEFAULT -1,
testname TEXT DEFAULT 'noname',
host TEXT DEFAULT 'n/a',
cpuload REAL DEFAULT -1,
diskfree INTEGER DEFAULT -1,
uname TEXT DEFAULT 'n/a',
rundir TEXT DEFAULT '/tmp/badname',
shortdir TEXT DEFAULT '/tmp/badname',
item_path TEXT DEFAULT '',
state TEXT DEFAULT 'NOT_STARTED',
status TEXT DEFAULT 'FAIL',
CONSTRAINT testsconstraint UNIQUE (run_id, testname, item_path));
CREATE TABLE IF NOT EXISTS test_steps (
id SERIAL PRIMARY KEY,
test_id INTEGER,
stepname TEXT,
state TEXT DEFAULT 'NOT_STARTED',
status TEXT DEFAULT 'n/a',
|
|
>
>
>
<
<
<
|
|
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
|
"user" TEXT,
accessed TIMESTAMP,
args TEXT);
CREATE TABLE IF NOT EXISTS tests (
id SERIAL PRIMARY KEY,
run_id INTEGER DEFAULT -1,
test_name TEXT DEFAULT 'noname',
item_path TEXT DEFAULT '',
state TEXT DEFAULT 'NOT_STARTED',
status TEXT DEFAULT 'FAIL',
host TEXT DEFAULT 'n/a',
cpuload REAL DEFAULT -1,
diskfree INTEGER DEFAULT -1,
uname TEXT DEFAULT 'n/a',
rundir TEXT DEFAULT '/tmp/badname',
shortdir TEXT DEFAULT '/tmp/badname',
attemptnum INTEGER DEFAULT 0,
final_logf TEXT DEFAULT 'logs/final.log',
logdat TEXT DEFAULT '',
run_duration INTEGER DEFAULT 0,
comment TEXT DEFAULT '',
event_time INTEGER DEFAULT extract(epoch from now()),
fail_count INTEGER DEFAULT 0,
pass_count INTEGER DEFAULT 0,
archived INTEGER DEFAULT 0, -- 0=no, > 1=archive block id where test data can be found
last_update INTEGER DEFAULT extract(epoch from now()),
CONSTRAINT testsconstraint UNIQUE (run_id, test_name, item_path));
CREATE TABLE IF NOT EXISTS test_steps (
id SERIAL PRIMARY KEY,
test_id INTEGER,
stepname TEXT,
state TEXT DEFAULT 'NOT_STARTED',
status TEXT DEFAULT 'n/a',
|