subunit2sql/releasenotes/notes
mccasland, trevor (tm2086) 464a9e0adc Add attachments flag to get_test_runs_by_status
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
2018-12-26 16:15:27 -06:00
..
1.2.0-missing-notes-d0ec5023f7d9328a.yaml Add release notes for pending 1.2.0 release 2016-01-12 12:48:28 -05:00
1.3.0-missing-notes-0e12c815ad6f3232.yaml Add missing release notes before the 1.3.0 release 2016-02-17 19:17:45 -05:00
add-batch-tests-by-test_ids-api-5f2542d214f9968f.yaml Add DB API function to get multiple tests by test_id 2017-01-10 14:12:17 -05:00
add-date-sort-opt-get_test_runs_by_test_test_id-ba65e97d27fb7dd8.yaml Add option to ensure get_test_runs_by_test_id() is ordered by date 2016-08-08 12:34:50 -04:00
add-delete-by-uuid-6266652db1c8bb98.yaml Amend releasenotes for new subunit2sql functions and options 2018-04-20 20:10:45 -07:00
add-get-recent-failed-runs-by-run-meta-f36c5197f3fe869f.yaml Add api to get recent failed runs by run_metadata 2016-04-14 19:58:39 -04:00
add-get_run_count-api-43daafc592b929ef.yaml Add get_run_count DB API function 2017-01-07 13:30:19 -05:00
add-graph-time-for-test-run-time-variance-6e61e0d9b4bb0cf9.yaml Add new graph time for variance of individual tests 2017-03-08 11:33:20 -05:00
add-include-attachments-60969df79bf23b13.yaml Add attachments flag to get_test_runs_by_status 2018-12-26 16:15:27 -06:00
add-metadata-unique-constraints-dbee79c2ffedc365.yaml Add a migration for another set of index creations 2015-12-02 16:10:49 -05:00
add-missing-metadata-id-indexes-dec66ab17c5c76c9.yaml Add migration for adding missing indexes 2015-11-30 17:26:11 -05:00
add-recent-successful-runs-by-meta-560c35bcd21ac98e.yaml Add new db api method to get recent successes by metadata 2016-06-24 10:10:28 -04:00
add-run-uuid-opt-to-get_test_runs_by_status_for_run_ids-c763ca4d90f8f0ae.yaml Enable returning run id in get_test_runs_by_status_for_run_ids() 2016-05-03 21:37:36 -04:00
add-start-time-to-recent-list-commands-146b22b742c7a94a.yaml Add optional start_date parameter to get_recent*() methods 2016-05-19 11:34:15 -04:00
add_get_runs_by_ids-ffdfc2f86d60c799.yaml Add DB API function to get list of runs from ids 2016-08-09 21:12:01 -04:00
add_key_value_metadata_filter_to_get_run_times-04af21788275df24.yaml Add run_metadata filtering to get run_times function 2016-09-14 13:02:59 -04:00
add_non_subunit_name_option-9f898507bfadce16.yaml Add subunit2sql CLI option to use non_subunit_name 2017-12-26 19:29:13 +00:00
add_run_wall_time_option-299ddc24b78f9166.yaml Add subunit2sql CLI option to use run wall time 2016-09-14 11:04:11 -04:00
deprecate-str-dates-on-get_test_counts_in_date_range-b16d285cab135d52.yaml Fix date format for agg_count and get_test_counts_in_date_range() 2016-05-16 15:12:13 -04:00
dpi-cli-flag-64552fd0e10e5d91.yaml Add --dpi flag to subunit2sql-graph 2018-02-11 23:03:00 -05:00
fix-get_ids_for_all_tests-typo-and-update-the-docstring-552735ca593c4613.yaml Fix db API get_ids_for_all_tests 2016-05-19 10:34:58 +08:00
fix-get_test_metadata-to-use-test_id-48217d4c7a22b9aa.yaml Fix get_test_metadata to use test_id 2016-04-12 10:37:58 +08:00
get-vars-from-kwargs-57cb5fab5fe8f2e2.yaml Amend releasenotes for new subunit2sql functions and options 2018-04-20 20:10:45 -07:00
new_db_api_function_get_run_times_times_series-36bca8c069633859.yaml Add new DB API function to get grouped run_time time series 2016-09-14 13:03:34 -04:00
remove-test-attr-prefix-dff9d378a5e940ab.yaml Remove the test_attr_prefix before injecting 2016-08-17 16:12:52 +01:00
subunit2sql_run_at_cli_opt-ab65e3b69b29e0b0.yaml Add support to subunit2sql cli to specify a run_at time 2015-11-30 22:40:41 +00:00
uuid-to-integers-01055701452e6a62.yaml Add reno release notes to subunit2sql 2015-11-20 18:59:18 -05:00