{"action":"closed","number":219,"pull_request":{"url":"https://api.github.com/repos/OCA/account-financial-reporting/pulls/219","id":84244111,"html_url":"https://github.com/OCA/account-financial-reporting/pull/219","diff_url":"https://github.com/OCA/account-financial-reporting/pull/219.diff","patch_url":"https://github.com/OCA/account-financial-reporting/pull/219.patch","issue_url":"https://api.github.com/repos/OCA/account-financial-reporting/issues/219","number":219,"state":"closed","locked":false,"title":"Performance improvement for OCA accounting reports","user":{"login":"jcoux","id":17567271,"avatar_url":"https://avatars.githubusercontent.com/u/17567271?v=3","gravatar_id":"","url":"https://api.github.com/users/jcoux","html_url":"https://github.com/jcoux","followers_url":"https://api.github.com/users/jcoux/followers","following_url":"https://api.github.com/users/jcoux/following{/other_user}","gists_url":"https://api.github.com/users/jcoux/gists{/gist_id}","starred_url":"https://api.github.com/users/jcoux/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jcoux/subscriptions","organizations_url":"https://api.github.com/users/jcoux/orgs","repos_url":"https://api.github.com/users/jcoux/repos","events_url":"https://api.github.com/users/jcoux/events{/privacy}","received_events_url":"https://api.github.com/users/jcoux/received_events","type":"User","site_admin":false},"body":"This PR complete the PR https://github.com/OCA/account-financial-reporting/pull/211 with a performance improvement for OCA accounting reports.\r\n\r\n* Deletion of joins between tables with \"OR\" clauses\r\n* Deletion of useless data generation of General Ledger report for Trial Balance report\r\n* Customization of xlsxwriter options to limit usage of memory for xlsx files generation","created_at":"2016-09-07T06:34:17Z","updated_at":"2016-09-09T11:55:54Z","closed_at":"2016-09-09T11:55:54Z","merged_at":"2016-09-09T11:55:54Z","merge_commit_sha":"13d43100ee38e572900b7d0d63cee28912c403e0","assignee":null,"assignees":[],"milestone":null,"commits_url":"https://api.github.com/repos/OCA/account-financial-reporting/pulls/219/commits","review_comments_url":"https://api.github.com/repos/OCA/account-financial-reporting/pulls/219/comments","review_comment_url":"https://api.github.com/repos/OCA/account-financial-reporting/pulls/comments{/number}","comments_url":"https://api.github.com/repos/OCA/account-financial-reporting/issues/219/comments","statuses_url":"https://api.github.com/repos/OCA/account-financial-reporting/statuses/9ad59f8a2b40b1ad2d9b70a05b192c260dccf80a","head":{"label":"jcoux:oca_reports_optimization","ref":"oca_reports_optimization","sha":"9ad59f8a2b40b1ad2d9b70a05b192c260dccf80a","user":{"login":"jcoux","id":17567271,"avatar_url":"https://avatars.githubusercontent.com/u/17567271?v=3","gravatar_id":"","url":"https://api.github.com/users/jcoux","html_url":"https://github.com/jcoux","followers_url":"https://api.github.com/users/jcoux/followers","following_url":"https://api.github.com/users/jcoux/following{/other_user}","gists_url":"https://api.github.com/users/jcoux/gists{/gist_id}","starred_url":"https://api.github.com/users/jcoux/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jcoux/subscriptions","organizations_url":"https://api.github.com/users/jcoux/orgs","repos_url":"https://api.github.com/users/jcoux/repos","events_url":"https://api.github.com/users/jcoux/events{/privacy}","received_events_url":"https://api.github.com/users/jcoux/received_events","type":"User","site_admin":false},"repo":{"id":61552508,"name":"account-financial-reporting","full_name":"jcoux/account-financial-reporting","owner":{"login":"jcoux","id":17567271,"avatar_url":"https://avatars.githubusercontent.com/u/17567271?v=3","gravatar_id":"","url":"https://api.github.com/users/jcoux","html_url":"https://github.com/jcoux","followers_url":"https://api.github.com/users/jcoux/followers","following_url":"https://api.github.com/users/jcoux/following{/other_user}","gists_url":"https://api.github.com/users/jcoux/gists{/gist_id}","starred_url":"https://api.github.com/users/jcoux/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jcoux/subscriptions","organizations_url":"https://api.github.com/users/jcoux/orgs","repos_url":"https://api.github.com/users/jcoux/repos","events_url":"https://api.github.com/users/jcoux/events{/privacy}","received_events_url":"https://api.github.com/users/jcoux/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/jcoux/account-financial-reporting","description":"Financial reports for Odoo","fork":true,"url":"https://api.github.com/repos/jcoux/account-financial-reporting","forks_url":"https://api.github.com/repos/jcoux/account-financial-reporting/forks","keys_url":"https://api.github.com/repos/jcoux/account-financial-reporting/keys{/key_id}","collaborators_url":"https://api.github.com/repos/jcoux/account-financial-reporting/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/jcoux/account-financial-reporting/teams","hooks_url":"https://api.github.com/repos/jcoux/account-financial-reporting/hooks","issue_events_url":"https://api.github.com/repos/jcoux/account-financial-reporting/issues/events{/number}","events_url":"https://api.github.com/repos/jcoux/account-financial-reporting/events","assignees_url":"https://api.github.com/repos/jcoux/account-financial-reporting/assignees{/user}","branches_url":"https://api.github.com/repos/jcoux/account-financial-reporting/branches{/branch}","tags_url":"https://api.github.com/repos/jcoux/account-financial-reporting/tags","blobs_url":"https://api.github.com/repos/jcoux/account-financial-reporting/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/jcoux/account-financial-reporting/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/jcoux/account-financial-reporting/git/refs{/sha}","trees_url":"https://api.github.com/repos/jcoux/account-financial-reporting/git/trees{/sha}","statuses_url":"https://api.github.com/repos/jcoux/account-financial-reporting/statuses/{sha}","languages_url":"https://api.github.com/repos/jcoux/account-financial-reporting/languages","stargazers_url":"https://api.github.com/repos/jcoux/account-financial-reporting/stargazers","contributors_url":"https://api.github.com/repos/jcoux/account-financial-reporting/contributors","subscribers_url":"https://api.github.com/repos/jcoux/account-financial-reporting/subscribers","subscription_url":"https://api.github.com/repos/jcoux/account-financial-reporting/subscription","commits_url":"https://api.github.com/repos/jcoux/account-financial-reporting/commits{/sha}","git_commits_url":"https://api.github.com/repos/jcoux/account-financial-reporting/git/commits{/sha}","comments_url":"https://api.github.com/repos/jcoux/account-financial-reporting/comments{/number}","issue_comment_url":"https://api.github.com/repos/jcoux/account-financial-reporting/issues/comments{/number}","contents_url":"https://api.github.com/repos/jcoux/account-financial-reporting/contents/{+path}","compare_url":"https://api.github.com/repos/jcoux/account-financial-reporting/compare/{base}...{head}","merges_url":"https://api.github.com/repos/jcoux/account-financial-reporting/merges","archive_url":"https://api.github.com/repos/jcoux/account-financial-reporting/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/jcoux/account-financial-reporting/downloads","issues_url":"https://api.github.com/repos/jcoux/account-financial-reporting/issues{/number}","pulls_url":"https://api.github.com/repos/jcoux/account-financial-reporting/pulls{/number}","milestones_url":"https://api.github.com/repos/jcoux/account-financial-reporting/milestones{/number}","notifications_url":"https://api.github.com/repos/jcoux/account-financial-reporting/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/jcoux/account-financial-reporting/labels{/name}","releases_url":"https://api.github.com/repos/jcoux/account-financial-reporting/releases{/id}","deployments_url":"https://api.github.com/repos/jcoux/account-financial-reporting/deployments","created_at":"2016-06-20T14:08:05Z","updated_at":"2016-06-20T14:08:07Z","pushed_at":"2016-09-07T06:20:25Z","git_url":"git://github.com/jcoux/account-financial-reporting.git","ssh_url":"git@github.com:jcoux/account-financial-reporting.git","clone_url":"https://github.com/jcoux/account-financial-reporting.git","svn_url":"https://github.com/jcoux/account-financial-reporting","homepage":"http://community.odoo.com","size":4644,"stargazers_count":0,"watchers_count":0,"language":"Python","has_issues":false,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":0,"mirror_url":null,"open_issues_count":0,"forks":0,"open_issues":0,"watchers":0,"default_branch":"9.0"}},"base":{"label":"OCA:9.0","ref":"9.0","sha":"f9d637d8bca733ec980b8aebc69ab28dc9302db8","user":{"login":"OCA","id":7600578,"avatar_url":"https://avatars.githubusercontent.com/u/7600578?v=3","gravatar_id":"","url":"https://api.github.com/users/OCA","html_url":"https://github.com/OCA","followers_url":"https://api.github.com/users/OCA/followers","following_url":"https://api.github.com/users/OCA/following{/other_user}","gists_url":"https://api.github.com/users/OCA/gists{/gist_id}","starred_url":"https://api.github.com/users/OCA/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/OCA/subscriptions","organizations_url":"https://api.github.com/users/OCA/orgs","repos_url":"https://api.github.com/users/OCA/repos","events_url":"https://api.github.com/users/OCA/events{/privacy}","received_events_url":"https://api.github.com/users/OCA/received_events","type":"Organization","site_admin":false},"repo":{"id":21203040,"name":"account-financial-reporting","full_name":"OCA/account-financial-reporting","owner":{"login":"OCA","id":7600578,"avatar_url":"https://avatars.githubusercontent.com/u/7600578?v=3","gravatar_id":"","url":"https://api.github.com/users/OCA","html_url":"https://github.com/OCA","followers_url":"https://api.github.com/users/OCA/followers","following_url":"https://api.github.com/users/OCA/following{/other_user}","gists_url":"https://api.github.com/users/OCA/gists{/gist_id}","starred_url":"https://api.github.com/users/OCA/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/OCA/subscriptions","organizations_url":"https://api.github.com/users/OCA/orgs","repos_url":"https://api.github.com/users/OCA/repos","events_url":"https://api.github.com/users/OCA/events{/privacy}","received_events_url":"https://api.github.com/users/OCA/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/OCA/account-financial-reporting","description":"Financial reports for Odoo","fork":false,"url":"https://api.github.com/repos/OCA/account-financial-reporting","forks_url":"https://api.github.com/repos/OCA/account-financial-reporting/forks","keys_url":"https://api.github.com/repos/OCA/account-financial-reporting/keys{/key_id}","collaborators_url":"https://api.github.com/repos/OCA/account-financial-reporting/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/OCA/account-financial-reporting/teams","hooks_url":"https://api.github.com/repos/OCA/account-financial-reporting/hooks","issue_events_url":"https://api.github.com/repos/OCA/account-financial-reporting/issues/events{/number}","events_url":"https://api.github.com/repos/OCA/account-financial-reporting/events","assignees_url":"https://api.github.com/repos/OCA/account-financial-reporting/assignees{/user}","branches_url":"https://api.github.com/repos/OCA/account-financial-reporting/branches{/branch}","tags_url":"https://api.github.com/repos/OCA/account-financial-reporting/tags","blobs_url":"https://api.github.com/repos/OCA/account-financial-reporting/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/OCA/account-financial-reporting/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/OCA/account-financial-reporting/git/refs{/sha}","trees_url":"https://api.github.com/repos/OCA/account-financial-reporting/git/trees{/sha}","statuses_url":"https://api.github.com/repos/OCA/account-financial-reporting/statuses/{sha}","languages_url":"https://api.github.com/repos/OCA/account-financial-reporting/languages","stargazers_url":"https://api.github.com/repos/OCA/account-financial-reporting/stargazers","contributors_url":"https://api.github.com/repos/OCA/account-financial-reporting/contributors","subscribers_url":"https://api.github.com/repos/OCA/account-financial-reporting/subscribers","subscription_url":"https://api.github.com/repos/OCA/account-financial-reporting/subscription","commits_url":"https://api.github.com/repos/OCA/account-financial-reporting/commits{/sha}","git_commits_url":"https://api.github.com/repos/OCA/account-financial-reporting/git/commits{/sha}","comments_url":"https://api.github.com/repos/OCA/account-financial-reporting/comments{/number}","issue_comment_url":"https://api.github.com/repos/OCA/account-financial-reporting/issues/comments{/number}","contents_url":"https://api.github.com/repos/OCA/account-financial-reporting/contents/{+path}","compare_url":"https://api.github.com/repos/OCA/account-financial-reporting/compare/{base}...{head}","merges_url":"https://api.github.com/repos/OCA/account-financial-reporting/merges","archive_url":"https://api.github.com/repos/OCA/account-financial-reporting/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/OCA/account-financial-reporting/downloads","issues_url":"https://api.github.com/repos/OCA/account-financial-reporting/issues{/number}","pulls_url":"https://api.github.com/repos/OCA/account-financial-reporting/pulls{/number}","milestones_url":"https://api.github.com/repos/OCA/account-financial-reporting/milestones{/number}","notifications_url":"https://api.github.com/repos/OCA/account-financial-reporting/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/OCA/account-financial-reporting/labels{/name}","releases_url":"https://api.github.com/repos/OCA/account-financial-reporting/releases{/id}","deployments_url":"https://api.github.com/repos/OCA/account-financial-reporting/deployments","created_at":"2014-06-25T12:53:30Z","updated_at":"2016-09-07T10:07:41Z","pushed_at":"2016-09-09T11:55:54Z","git_url":"git://github.com/OCA/account-financial-reporting.git","ssh_url":"git@github.com:OCA/account-financial-reporting.git","clone_url":"https://github.com/OCA/account-financial-reporting.git","svn_url":"https://github.com/OCA/account-financial-reporting","homepage":"http://community.odoo.com","size":6703,"stargazers_count":35,"watchers_count":35,"language":"Python","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":158,"mirror_url":null,"open_issues_count":66,"forks":158,"open_issues":66,"watchers":35,"default_branch":"9.0"}},"_links":{"self":{"href":"https://api.github.com/repos/OCA/account-financial-reporting/pulls/219"},"html":{"href":"https://github.com/OCA/account-financial-reporting/pull/219"},"issue":{"href":"https://api.github.com/repos/OCA/account-financial-reporting/issues/219"},"comments":{"href":"https://api.github.com/repos/OCA/account-financial-reporting/issues/219/comments"},"review_comments":{"href":"https://api.github.com/repos/OCA/account-financial-reporting/pulls/219/comments"},"review_comment":{"href":"https://api.github.com/repos/OCA/account-financial-reporting/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/OCA/account-financial-reporting/pulls/219/commits"},"statuses":{"href":"https://api.github.com/repos/OCA/account-financial-reporting/statuses/9ad59f8a2b40b1ad2d9b70a05b192c260dccf80a"}},"merged":true,"mergeable":null,"mergeable_state":"unknown","merged_by":{"login":"fclementic2c","id":5735158,"avatar_url":"https://avatars.githubusercontent.com/u/5735158?v=3","gravatar_id":"","url":"https://api.github.com/users/fclementic2c","html_url":"https://github.com/fclementic2c","followers_url":"https://api.github.com/users/fclementic2c/followers","following_url":"https://api.github.com/users/fclementic2c/following{/other_user}","gists_url":"https://api.github.com/users/fclementic2c/gists{/gist_id}","starred_url":"https://api.github.com/users/fclementic2c/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/fclementic2c/subscriptions","organizations_url":"https://api.github.com/users/fclementic2c/orgs","repos_url":"https://api.github.com/users/fclementic2c/repos","events_url":"https://api.github.com/users/fclementic2c/events{/privacy}","received_events_url":"https://api.github.com/users/fclementic2c/received_events","type":"User","site_admin":false},"comments":5,"review_comments":5,"commits":1,"additions":358,"deletions":99,"changed_files":4}}
{"actor":{"display_login":"fclementic2c"}}