Database Storage for Test Data and Results

Test data and results can be stored to a database when a test run completes. To enable database storage, you must add a results_database option to your config.cfg, which defines the db connection string.

example: results_database: sqlite:///results.db

Database storage requires sqlalchemy: http://www.sqlalchemy.org

Several database back-ends are available to choose from:
http://www.sqlalchemy.org/docs/dbengine.html#supported-databases'>http://www.sqlalchemy.org/docs/dbengine.html#supported-databases

Example connection strings:

SQLite is supported natively by Python, so there is no installation or configuration necessary.
The results database is created automatically on first use, no need to run your own DDL code.

Results Database Diagram

http://www.goldb.org/multi-mechanize/results_database_erd.gif'>

Sample DB Query Code

Here is some sample code for retrieving results from the database via sqlalchemy:

from sqlalchemy import create_engine

from sqlalchemy.orm import sessionmaker

from lib.resultsloader import ResultRow

from lib.resultsloader import GlobalConfig

from lib.resultsloader import UserGroupConfig

from lib.resultsloader import TimerRow



engine = create_engine('sqlite:///results.db')

session = sessionmaker(bind=engine)

current = session()



for rr in current.query(ResultRow).order_by(ResultRow.trans_count):

    print rr

    print rr.global_config

    print rr.global_config.user_group_configs

    print rr.timers