)]}'
{"/COMMIT_MSG":[{"author":{"_account_id":11564,"name":"Chris Dent","email":"cdent@anticdent.org","username":"chdent"},"change_message_id":"460735f42c3f339b6bd391e46e3626d1efb9a839","unresolved":false,"context_lines":[{"line_number":11,"context_line":""},{"line_number":12,"context_line":"Change-Id: I47b758b949b7fbed70906e9a95cbe7bb99da13c2"},{"line_number":13,"context_line":"Closes-Bug: 1662012"},{"line_number":14,"context_line":"Related-Bug: 1662012"}],"source_content_type":"text/x-gerrit-commit-message","patch_set":1,"id":"1a430d35_93abc074","line":14,"updated":"2017-02-07 19:20:11.000000000","message":"Only need closes","commit_id":"fc290c4bd4a91fd34afe70e7c66f0879ee907cd6"},{"author":{"_account_id":11564,"name":"Chris Dent","email":"cdent@anticdent.org","username":"chdent"},"change_message_id":"edb027c3dab60ae7a8f95c315d6c40b36598f7f4","unresolved":false,"context_lines":[{"line_number":7,"context_line":"allocations.consumer_id is not used in query."},{"line_number":8,"context_line":""},{"line_number":9,"context_line":"PostGreSQL required consumer_id in group by clause, but"},{"line_number":10,"context_line":"consumer_id is not being used in the query and is superfluous."},{"line_number":11,"context_line":""},{"line_number":12,"context_line":"Change-Id: I47b758b949b7fbed70906e9a95cbe7bb99da13c2"},{"line_number":13,"context_line":"Closes-Bug: 1662012"}],"source_content_type":"text/x-gerrit-commit-message","patch_set":2,"id":"1a430d35_ffd575e4","line":10,"updated":"2017-02-08 17:36:57.000000000","message":"You could state which method the query is in, just because that will make the commit message more useful when compared with the similar fix that happened earlier.","commit_id":"85c76a7f0827ff8f278d071a0b3f721847079711"}],"nova/objects/resource_provider.py":[{"author":{"_account_id":6873,"name":"Matt Riedemann","email":"mriedem.os@gmail.com","username":"mriedem"},"change_message_id":"772fa621d2da7f13a1fbb2da0f03fdb3e987e660","unresolved":false,"context_lines":[{"line_number":958,"context_line":"    # JOIN inventories AS i1"},{"line_number":959,"context_line":"    # ON rp.id \u003d i1.resource_provider_id"},{"line_number":960,"context_line":"    # LEFT JOIN ("},{"line_number":961,"context_line":"    #    SELECT resource_provider_id, resource_class_id, SUM(used) AS used"},{"line_number":962,"context_line":"    #    FROM allocations"},{"line_number":963,"context_line":"    #    WHERE resource_class_id IN ($RESOURCE_CLASSES)"},{"line_number":964,"context_line":"    #    GROUP BY resource_provider_id, resource_class_id"}],"source_content_type":"text/x-python","patch_set":2,"id":"fa31d9ce_eedec20f","line":961,"range":{"start_line":961,"start_character":9,"end_line":961,"end_character":55},"updated":"2017-02-14 21:22:33.000000000","message":"Yeah I guess that was pointed out here.","commit_id":"85c76a7f0827ff8f278d071a0b3f721847079711"}]}