)]}'
{"subunit2sql/db/models.py":[{"author":{"_account_id":6488,"name":"Clint Byrum","email":"clint@fewbar.com","username":"clint-fewbar"},"change_message_id":"a4561a39efa7f32c4288054e246095812705889a","unresolved":false,"context_lines":[{"line_number":82,"context_line":"    __table_args__ \u003d (sa.Index(\u0027ix_test_id_status\u0027, \u0027test_id\u0027, \u0027status\u0027),"},{"line_number":83,"context_line":"                      sa.Index(\u0027ix_test_id_start_time\u0027, \u0027test_id\u0027,"},{"line_number":84,"context_line":"                               \u0027start_time\u0027),"},{"line_number":85,"context_line":"                      sa.Index(\u0027ix_run_id_start_time\u0027, \u0027run_id\u0027, \u0027start_time\u0027),"},{"line_number":86,"context_line":"                      sa.Index(\u0027ix_test_runs_test_id\u0027, \u0027test_id\u0027),"},{"line_number":87,"context_line":"                      sa.Index(\u0027ix_test_runs_run_id\u0027, \u0027run_id\u0027),"},{"line_number":88,"context_line":"                      sa.Index(\u0027ix_test_runs_start_time\u0027, \u0027start_time\u0027),"}],"source_content_type":"text/x-python","patch_set":2,"id":"9a8ffd7b_2ea8b076","line":85,"updated":"2015-12-02 18:16:10.000000000","message":"This one isn\u0027t actually all that useful, because run_id wants to be a \u0027ref\u0027, and start_time wants to be a \u0027range\u0027.","commit_id":"a44d481786f50ca716b9c5c0a424b44ee9348814"},{"author":{"_account_id":6488,"name":"Clint Byrum","email":"clint@fewbar.com","username":"clint-fewbar"},"change_message_id":"a4561a39efa7f32c4288054e246095812705889a","unresolved":false,"context_lines":[{"line_number":113,"context_line":"    __table_args__ \u003d (sa.Index(\u0027ix_run_key_value\u0027, \u0027key\u0027, \u0027value\u0027),"},{"line_number":114,"context_line":"                      sa.Index(\u0027ix_run_id\u0027, \u0027run_id\u0027),"},{"line_number":115,"context_line":"                      sa.UniqueConstraint(\u0027run_id\u0027, \u0027key\u0027, \u0027value\u0027,"},{"line_number":116,"context_line":"                                          name\u003d\u0027uq_run_metadata\u0027))"},{"line_number":117,"context_line":""},{"line_number":118,"context_line":"    id \u003d sa.Column(sa.BigInteger, primary_key\u003dTrue)"},{"line_number":119,"context_line":"    key \u003d sa.Column(sa.String(255))"}],"source_content_type":"text/x-python","patch_set":2,"id":"9a8ffd7b_aee900b9","line":116,"updated":"2015-12-02 18:16:10.000000000","message":"However, this one is extremely useful in my testing... it should make queries that join test_runs and run_metadata scale at O(N) ... so for 1 day ranges, that makes the query about 400x faster (7 minutes down to 1 second).","commit_id":"a44d481786f50ca716b9c5c0a424b44ee9348814"},{"author":{"_account_id":6488,"name":"Clint Byrum","email":"clint@fewbar.com","username":"clint-fewbar"},"change_message_id":"a4561a39efa7f32c4288054e246095812705889a","unresolved":false,"context_lines":[{"line_number":145,"context_line":"    __table_args__ \u003d (sa.Index(\u0027ix_test_key_value\u0027, \u0027key\u0027, \u0027value\u0027),"},{"line_number":146,"context_line":"                      sa.Index(\u0027ix_test_id\u0027, \u0027test_id\u0027),"},{"line_number":147,"context_line":"                      sa.UniqueConstraint(\u0027test_id\u0027, \u0027key\u0027, \u0027value\u0027,"},{"line_number":148,"context_line":"                                          name\u003d\u0027uq_test_metadata\u0027))"},{"line_number":149,"context_line":""},{"line_number":150,"context_line":"    id \u003d sa.Column(sa.BigInteger, primary_key\u003dTrue)"},{"line_number":151,"context_line":"    key \u003d sa.Column(sa.String(255))"}],"source_content_type":"text/x-python","patch_set":2,"id":"9a8ffd7b_0ef04c90","line":148,"updated":"2015-12-02 18:16:10.000000000","message":"Ditto here.","commit_id":"a44d481786f50ca716b9c5c0a424b44ee9348814"}]}