464a9e0adc
By adding an 'include_attachments' flag to the get_test_runs_by_status method we can join the Attachments table with the same structure as the RunMetadata table allowing us to optionally include attachments or metadata with test_runs filtered by a given status. Notes on testing: * As far as I could tell, logstash.o.o doesn't store attachments[1] so to test this patch you will have to setup/use another subunit2sql db with attachments stored in it * you can find the openstack-health patch to render the attachments in the Needed-By change of the footer of this commit message. Notes on performance: * on average loading attachments is about 13% slower when calling this api with python[2]. The query times in the paste were produced by calling the api method get_test_runs_by_status_for_run_ids 100x in a for loop with 49 test_runs being returned from the call, which is the number of failures in the last 10 runs. [1] http://paste.openstack.org/show/719192/ [2] http://paste.openstack.org/show/738662/ Needed-By: I3ce2fc50ada9462de3df29b5a8b76b12a548fd12 Change-Id: I31468c825cf259b8df62134e578f31d96af6ac75 |
||
---|---|---|
.. | ||
1.2.0-missing-notes-d0ec5023f7d9328a.yaml | ||
1.3.0-missing-notes-0e12c815ad6f3232.yaml | ||
add_get_runs_by_ids-ffdfc2f86d60c799.yaml | ||
add_key_value_metadata_filter_to_get_run_times-04af21788275df24.yaml | ||
add_non_subunit_name_option-9f898507bfadce16.yaml | ||
add_run_wall_time_option-299ddc24b78f9166.yaml | ||
add-batch-tests-by-test_ids-api-5f2542d214f9968f.yaml | ||
add-date-sort-opt-get_test_runs_by_test_test_id-ba65e97d27fb7dd8.yaml | ||
add-delete-by-uuid-6266652db1c8bb98.yaml | ||
add-get_run_count-api-43daafc592b929ef.yaml | ||
add-get-recent-failed-runs-by-run-meta-f36c5197f3fe869f.yaml | ||
add-graph-time-for-test-run-time-variance-6e61e0d9b4bb0cf9.yaml | ||
add-include-attachments-60969df79bf23b13.yaml | ||
add-metadata-unique-constraints-dbee79c2ffedc365.yaml | ||
add-missing-metadata-id-indexes-dec66ab17c5c76c9.yaml | ||
add-recent-successful-runs-by-meta-560c35bcd21ac98e.yaml | ||
add-run-uuid-opt-to-get_test_runs_by_status_for_run_ids-c763ca4d90f8f0ae.yaml | ||
add-start-time-to-recent-list-commands-146b22b742c7a94a.yaml | ||
deprecate-str-dates-on-get_test_counts_in_date_range-b16d285cab135d52.yaml | ||
dpi-cli-flag-64552fd0e10e5d91.yaml | ||
fix-get_ids_for_all_tests-typo-and-update-the-docstring-552735ca593c4613.yaml | ||
fix-get_test_metadata-to-use-test_id-48217d4c7a22b9aa.yaml | ||
get-vars-from-kwargs-57cb5fab5fe8f2e2.yaml | ||
new_db_api_function_get_run_times_times_series-36bca8c069633859.yaml | ||
remove-test-attr-prefix-dff9d378a5e940ab.yaml | ||
subunit2sql_run_at_cli_opt-ab65e3b69b29e0b0.yaml | ||
uuid-to-integers-01055701452e6a62.yaml |