Earlier in the week, I sent out a message suggesting that we should
try to come up with a more automated way of collecting test results
from Slony-I testing.
I did a bit of rummaging around to see what the BuildFarm does; here's
a (perhaps overly flat) schema that captures all of what has come to
mind thus far.
-----------------------------------------------------------------------------
create table slony_tests (
id serial,
-- Preface with a whole bunch of versioning information
smoduleversion text NOT NULL, -- populate via @[EMAIL PROTECTED]();
sv_major integer NOT NULL, -- populate via @[EMAIL PROTECTED]();
sv_minor integer NOT NULL, -- populate via @[EMAIL PROTECTED]();
sv_patch integer NOT NULL, -- populate via @[EMAIL PROTECTED]();
pg_version text NOT NULL, -- populate via version();
uname_m text NOT NULL, -- output of `uname -m` - uname -m = ia64
uname_r text NOT NULL, -- output of `uname -r` - uname -r =
2.6.18.6
uname_s text NOT NULL, -- output of `uname -s` - uname -s = Linux
uname_v text NOT NULL, -- output of `uname -v` - uname -v = #1
SMP Fri Feb 9 20:10:44 MSK 2007
hostname text NOT NULL, -- output of `hostname -f`
username text NOT NULL, -- output of `whoami`
tester_identity text NOT NULL, -- email address of the tester, from
getenv("SLONYTESTER")
-- Now, test-specific data
testname text NOT NULL, -- which test was run?
start_time timestamptz NOT NULL,
end_time timestamptz NOT NULL,
successful boolean NOT NULL, -- was the test totally successful?
failure_desc text, -- A description of the failure noticed
primary key(id)
);
create index st_slversion on slony_tests (sv_major, sv_minor, sv_patch);
create index st_host on slony_tests(tester_identity);
create index st_start on slony_tests(start_time);
-----------------------------------------------------------------------------
--
"cbbrowne","@","ca.afilias.info"
<http://dba2.int.libertyrms.com/>
Christopher Browne
(416) 673-4124 (land)
_______________________________________________
Slony1-general mailing list
[email protected]
http://lists.slony.info/mailman/listinfo/slony1-general
