1042101 - [Baloo] [QA] Schema update to include Moztrap

Status: RESOLVED FIXED

(Community Building :: Systems and Data, task)

Description

[Pierros Papadeas [:pierros]]

We need to amend Baloo schema to handle Moztrap specific data
https://wiki.mozilla.org/Baloo/Schema/0.1

What fields should we add?

Comment 1

[Cameron Dawson [:camd]]

Here are the tables, fields, and related foreign key paths to get the info I think you'll need.

email:                       auth_user.email
result user:                 execution_result.created_by_id ==> auth_user
result date:                 execution_result.created_on
result to case:              execution_result.runcaseversion_id ==> execution_runcaseversion
case to run:                 execution_runcaseversion.run_id ==> execution_run
run to product version:      execution_run.productversion_id ==> core_productversion
product version to product:  core_productversion.product_id ==> core_product
        

The result has a pretty long chain.  But I think you can see how you can get information from each table in the chain.  For instance: from execution_run, you can get the name of the test run, etc.  But following it further down the foreign key chain, you can get to the core_product which would tell you if it's Firefox vs. Firefox OS, etc.

Please ping me if you need more info on this.

Comment 2

[Pierros Papadeas [:pierros]]

Schema is now updated as per comment #1
https://wiki.mozilla.org/Baloo/Schema/0.1