Closed Bug 1042101 Opened 6 years ago Closed 6 years ago

[Baloo] [QA] Schema update to include Moztrap

Categories

(Community Building :: Systems and Data, task)

x86
macOS
task
Not set

Tracking

(Not tracked)

RESOLVED FIXED

People

(Reporter: pierros, Unassigned)

References

Details

(Whiteboard: [Baloo][Q3])

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

What fields should we add?
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.
Whiteboard: [Baloo]
Whiteboard: [Baloo] → [Baloo][Q3]
Status: NEW → RESOLVED
Closed: 6 years ago
Resolution: --- → FIXED
You need to log in before you can comment on or make changes to this bug.