Bamboo DB relations

[Kostas Mertzianis]

Hi,

I am currently using an ODBC connection to the Bamboo database in order to create some analytics based on the data. I am running a MS SQLSERVER 2008 data platform for Bamboo and I am facing some issues when it comes to the relationship between the BUILDRESULTSUMMARY table and TEST_CASE and therefore TEST_CASE_RESULT table.
How are these two connected? Because apparently the connection between BUILDRESULTSUMMARY and TEST_CLASS_RESULT via BUILDRESULTSUMMARY_ID is invalid. I can elaborate, if needed, why I state that the aforementioned connection is invalid. It would be great if someone could shed some light on the connection between these two tables/columns.

Thanks,

Kmn

[Felipe Kraemer]

Hi,

As far as I can understand by looking at the database schema, table TEST_CLASS_RESULT is linked to table BUILDRESULTSUMMARY via column BUILDRESULTSUMMARY_ID:

SELECT * FROM test_class_result tcr, buildresultsummary brs
WHERE tcr.buildresultsummary_id = brs.buildresultsummary_id

Also, TEST_CLASS_RESULT is linked to TEST_CLASS via TEST_CLASS_ID:

SELECT * FROM test_class tc, test_class_result tcr
WHERE tc.test_class_id = tcr.test_class_id

So, joining everything in a single query:

SELECT * FROM test_class_result tcr, buildresultsummary brs, test_class tc
WHERE tcr.buildresultsummary_id = brs.buildresultsummary_id
AND tc.test_class_id = tcr.test_class_id