)]}'
{"/COMMIT_MSG":[{"author":{"_account_id":5948,"name":"Oleg Bondarev","email":"obondarev@mirantis.com","username":"obondarev"},"change_message_id":"ebe7463bc858dada484d90c400e389cb8994c7db","unresolved":true,"context_lines":[{"line_number":13,"context_line":"L3HARouterAgentPortBinding.agent relationships to be \"joined\". That"},{"line_number":14,"context_line":"will retrieve the port object in the main query and the returned"},{"line_number":15,"context_line":"object won\u0027t need to make a second DB call. The SQL query looks"},{"line_number":16,"context_line":"like http://paste.openstack.org/show/806275/."},{"line_number":17,"context_line":""},{"line_number":18,"context_line":"Change-Id: I7870b869a755054ef1989f86ebdd3470ec5cf435"},{"line_number":19,"context_line":"Closes-Bug: #1930397"}],"source_content_type":"text/x-gerrit-commit-message","patch_set":2,"id":"7d2caf3c_563a0dfa","line":16,"range":{"start_line":16,"start_character":5,"end_line":16,"end_character":44},"updated":"2021-06-04 07:02:17.000000000","message":"query now has agent joined, right?","commit_id":"76a4b28e3fca525ab58e774f2b9620843b459e23"},{"author":{"_account_id":16688,"name":"Rodolfo Alonso","email":"ralonsoh@redhat.com","username":"rodolfo-alonso-hernandez"},"change_message_id":"70aacda075af7d93c5b15149ed3ed682404bc7be","unresolved":true,"context_lines":[{"line_number":13,"context_line":"L3HARouterAgentPortBinding.agent relationships to be \"joined\". That"},{"line_number":14,"context_line":"will retrieve the port object in the main query and the returned"},{"line_number":15,"context_line":"object won\u0027t need to make a second DB call. The SQL query looks"},{"line_number":16,"context_line":"like http://paste.openstack.org/show/806275/."},{"line_number":17,"context_line":""},{"line_number":18,"context_line":"Change-Id: I7870b869a755054ef1989f86ebdd3470ec5cf435"},{"line_number":19,"context_line":"Closes-Bug: #1930397"}],"source_content_type":"text/x-gerrit-commit-message","patch_set":2,"id":"9f43efa4_b86ca86e","line":16,"range":{"start_line":16,"start_character":5,"end_line":16,"end_character":44},"in_reply_to":"7d2caf3c_563a0dfa","updated":"2021-06-08 15:28:07.000000000","message":"Right, now ha_router_agent_port_bindings retrieves \"port\" and \"agent\" in the same query, solving this lazy loading issue.","commit_id":"76a4b28e3fca525ab58e774f2b9620843b459e23"},{"author":{"_account_id":16688,"name":"Rodolfo Alonso","email":"ralonsoh@redhat.com","username":"rodolfo-alonso-hernandez"},"change_message_id":"a70919bc38a040460a3c5d4cf668824d6aae48cd","unresolved":false,"context_lines":[{"line_number":13,"context_line":"L3HARouterAgentPortBinding.agent relationships to be \"joined\". That"},{"line_number":14,"context_line":"will retrieve the port object in the main query and the returned"},{"line_number":15,"context_line":"object won\u0027t need to make a second DB call. The SQL query looks"},{"line_number":16,"context_line":"like http://paste.openstack.org/show/806275/."},{"line_number":17,"context_line":""},{"line_number":18,"context_line":"Change-Id: I7870b869a755054ef1989f86ebdd3470ec5cf435"},{"line_number":19,"context_line":"Closes-Bug: #1930397"}],"source_content_type":"text/x-gerrit-commit-message","patch_set":2,"id":"63bb9acf_3801ff18","line":16,"range":{"start_line":16,"start_character":5,"end_line":16,"end_character":44},"in_reply_to":"9a5df1b0_c1c4cecf","updated":"2021-06-08 15:49:12.000000000","message":"Done","commit_id":"76a4b28e3fca525ab58e774f2b9620843b459e23"},{"author":{"_account_id":5948,"name":"Oleg Bondarev","email":"obondarev@mirantis.com","username":"obondarev"},"change_message_id":"8435681e8d62a61b6ec83dc7543f67fc23ca11ee","unresolved":true,"context_lines":[{"line_number":13,"context_line":"L3HARouterAgentPortBinding.agent relationships to be \"joined\". That"},{"line_number":14,"context_line":"will retrieve the port object in the main query and the returned"},{"line_number":15,"context_line":"object won\u0027t need to make a second DB call. The SQL query looks"},{"line_number":16,"context_line":"like http://paste.openstack.org/show/806275/."},{"line_number":17,"context_line":""},{"line_number":18,"context_line":"Change-Id: I7870b869a755054ef1989f86ebdd3470ec5cf435"},{"line_number":19,"context_line":"Closes-Bug: #1930397"}],"source_content_type":"text/x-gerrit-commit-message","patch_set":2,"id":"9a5df1b0_c1c4cecf","line":16,"range":{"start_line":16,"start_character":5,"end_line":16,"end_character":44},"in_reply_to":"9f43efa4_b86ca86e","updated":"2021-06-08 15:34:16.000000000","message":"Yeah, I meant probably update this in commit message to make it consistent","commit_id":"76a4b28e3fca525ab58e774f2b9620843b459e23"},{"author":{"_account_id":5948,"name":"Oleg Bondarev","email":"obondarev@mirantis.com","username":"obondarev"},"change_message_id":"ccef6e7bd86596ba0ba64d10993b48f08b819a43","unresolved":true,"context_lines":[{"line_number":14,"context_line":"will retrieve the port and the agent DB registers in the main query"},{"line_number":15,"context_line":"and the returned object won\u0027t need to make subqueries to retrieve"},{"line_number":16,"context_line":"them. The SQL query looks like"},{"line_number":17,"context_line":"http://paste.openstack.org/show/806275/."},{"line_number":18,"context_line":""},{"line_number":19,"context_line":"Change-Id: I7870b869a755054ef1989f86ebdd3470ec5cf435"},{"line_number":20,"context_line":"Closes-Bug: #1930397"}],"source_content_type":"text/x-gerrit-commit-message","patch_set":3,"id":"bc460992_95143454","line":17,"range":{"start_line":17,"start_character":0,"end_line":17,"end_character":39},"updated":"2021-06-08 15:58:51.000000000","message":"query seems doesn\u0027t have agent..","commit_id":"ff2eb955c51c5350df51dbe2ec956c5a49ae1bff"},{"author":{"_account_id":9531,"name":"liuyulong","display_name":"LIU Yulong","email":"i@liuyulong.me","username":"LIU-Yulong"},"change_message_id":"c59111cdc31659ec4f15b60ebb71b7f7306fb0f7","unresolved":true,"context_lines":[{"line_number":14,"context_line":"will retrieve the port and the agent DB registers in the main query"},{"line_number":15,"context_line":"and the returned object won\u0027t need to make subqueries to retrieve"},{"line_number":16,"context_line":"them. The SQL query looks like"},{"line_number":17,"context_line":"http://paste.openstack.org/show/806275/."},{"line_number":18,"context_line":""},{"line_number":19,"context_line":"Change-Id: I7870b869a755054ef1989f86ebdd3470ec5cf435"},{"line_number":20,"context_line":"Closes-Bug: #1930397"}],"source_content_type":"text/x-gerrit-commit-message","patch_set":5,"id":"24479d1b_848ddfa0","line":17,"range":{"start_line":17,"start_character":0,"end_line":17,"end_character":40},"updated":"2021-06-15 14:54:49.000000000","message":"Sql \"desc\" shows not too many rows get involved in this query.","commit_id":"cc3dc7c8508a142b614ee9cfe3f4a6766f62d8b8"}]}