personally, I'd do 3 tables:
-- matrix of all the potential tests and their results
table testcondition
    id int primary key
    var_1 int
    var_2 int
    expected_result STRING

-- one record per testrun
table testrun
    id int primary key
    test_time timestamp

-- one record per test per testrun
table testresult
    id int primary key
    testrun_id int  references testrun(id)
    testcondition_id int references testcondition(id)
    test_pass boolean default NULL
    test_failed_with STRING

that would allow you to easily query tests and figure out when something 
broke or got fixed.    


-- 
SQLAlchemy - 
The Python SQL Toolkit and Object Relational Mapper

http://www.sqlalchemy.org/

To post example code, please provide an MCVE: Minimal, Complete, and Verifiable 
Example.  See  http://stackoverflow.com/help/mcve for a full description.
--- 
You received this message because you are subscribed to the Google Groups 
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at https://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.

Reply via email to