{"action":"created","comment":{"url":"https://api.github.com/repos/poanetwork/blockscout/pulls/comments/241123222","pull_request_review_id":184316426,"id":241123222,"node_id":"MDI0OlB1bGxSZXF1ZXN0UmV2aWV3Q29tbWVudDI0MTEyMzIyMg==","diff_hunk":"@@ -251,4 +251,184 @@ defmodule Explorer.Chain.TokenTransferTest do\n       assert results == []\n     end\n   end\n+\n+  describe \"where_any_address_fields_match/3\" do\n+    test \"when to_address_hash match returns transactions hashes list\" do","path":"apps/explorer/test/explorer/chain/token_transfer_test.exs","position":6,"original_position":6,"commit_id":"4833c6c962e6a9f25b0ea7c719d15bda347653e7","original_commit_id":"f0e0fb8dc4e3380c9627ea1e0d049ddc71e4d35a","user":{"login":"feliperenan","id":27698968,"node_id":"MDQ6VXNlcjI3Njk4OTY4","avatar_url":"https://avatars2.githubusercontent.com/u/27698968?v=4","gravatar_id":"","url":"https://api.github.com/users/feliperenan","html_url":"https://github.com/feliperenan","followers_url":"https://api.github.com/users/feliperenan/followers","following_url":"https://api.github.com/users/feliperenan/following{/other_user}","gists_url":"https://api.github.com/users/feliperenan/gists{/gist_id}","starred_url":"https://api.github.com/users/feliperenan/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/feliperenan/subscriptions","organizations_url":"https://api.github.com/users/feliperenan/orgs","repos_url":"https://api.github.com/users/feliperenan/repos","events_url":"https://api.github.com/users/feliperenan/events{/privacy}","received_events_url":"https://api.github.com/users/feliperenan/received_events","type":"User","site_admin":false},"body":"Oh sorry, I didn't see that we were in the `token_tranfers` file :/.","created_at":"2018-12-12T18:02:42Z","updated_at":"2018-12-12T18:02:43Z","html_url":"https://github.com/poanetwork/blockscout/pull/1186#discussion_r241123222","pull_request_url":"https://api.github.com/repos/poanetwork/blockscout/pulls/1186","author_association":"CONTRIBUTOR","_links":{"self":{"href":"https://api.github.com/repos/poanetwork/blockscout/pulls/comments/241123222"},"html":{"href":"https://github.com/poanetwork/blockscout/pull/1186#discussion_r241123222"},"pull_request":{"href":"https://api.github.com/repos/poanetwork/blockscout/pulls/1186"}},"in_reply_to_id":241108041},"pull_request":{"url":"https://api.github.com/repos/poanetwork/blockscout/pulls/1186","id":236683137,"node_id":"MDExOlB1bGxSZXF1ZXN0MjM2NjgzMTM3","html_url":"https://github.com/poanetwork/blockscout/pull/1186","diff_url":"https://github.com/poanetwork/blockscout/pull/1186.diff","patch_url":"https://github.com/poanetwork/blockscout/pull/1186.patch","issue_url":"https://api.github.com/repos/poanetwork/blockscout/issues/1186","number":1186,"state":"open","locked":false,"title":"Fix Address Trasaction query","user":{"login":"amandasposito","id":840531,"node_id":"MDQ6VXNlcjg0MDUzMQ==","avatar_url":"https://avatars2.githubusercontent.com/u/840531?v=4","gravatar_id":"","url":"https://api.github.com/users/amandasposito","html_url":"https://github.com/amandasposito","followers_url":"https://api.github.com/users/amandasposito/followers","following_url":"https://api.github.com/users/amandasposito/following{/other_user}","gists_url":"https://api.github.com/users/amandasposito/gists{/gist_id}","starred_url":"https://api.github.com/users/amandasposito/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/amandasposito/subscriptions","organizations_url":"https://api.github.com/users/amandasposito/orgs","repos_url":"https://api.github.com/users/amandasposito/repos","events_url":"https://api.github.com/users/amandasposito/events{/privacy}","received_events_url":"https://api.github.com/users/amandasposito/received_events","type":"User","site_admin":false},"body":"Resolves #1183\r\n\r\nThe `address` `transaction` listing (with an `address`  that has 7MM `transactions`) is loading within 7s using a db similar to the ethereum mainnet.\r\n\r\n<img width=\"1439\" alt=\"screen shot 2018-12-11 at 17 27 39\" src=\"https://user-images.githubusercontent.com/840531/49824886-3e657f80-fd6a-11e8-9f21-e2f1af14e722.png\">\r\n\r\nNormal addresses continue to load quickly as well\r\n\r\n<img width=\"1439\" alt=\"screen shot 2018-12-11 at 17 28 28\" src=\"https://user-images.githubusercontent.com/840531/49824933-5d641180-fd6a-11e8-97c4-2c3553df0950.png\">\r\n\r\n\r\n## Motivation\r\n\r\nWhen a token is sent, the recipient (to) address of the token transfer is not seeing the token transfer on the transactions tab. \r\n\r\n## Changelog\r\n\r\n### Bug Fixes\r\n\r\n* The bug was that only the first transaction that had token transfers was being shown.\r\n","created_at":"2018-12-06T21:46:09Z","updated_at":"2018-12-12T18:02:43Z","closed_at":null,"merged_at":null,"merge_commit_sha":"66d5ba49254932a93e4afb6bae639f3acaeaeab1","assignee":{"login":"amandasposito","id":840531,"node_id":"MDQ6VXNlcjg0MDUzMQ==","avatar_url":"https://avatars2.githubusercontent.com/u/840531?v=4","gravatar_id":"","url":"https://api.github.com/users/amandasposito","html_url":"https://github.com/amandasposito","followers_url":"https://api.github.com/users/amandasposito/followers","following_url":"https://api.github.com/users/amandasposito/following{/other_user}","gists_url":"https://api.github.com/users/amandasposito/gists{/gist_id}","starred_url":"https://api.github.com/users/amandasposito/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/amandasposito/subscriptions","organizations_url":"https://api.github.com/users/amandasposito/orgs","repos_url":"https://api.github.com/users/amandasposito/repos","events_url":"https://api.github.com/users/amandasposito/events{/privacy}","received_events_url":"https://api.github.com/users/amandasposito/received_events","type":"User","site_admin":false},"assignees":[{"login":"amandasposito","id":840531,"node_id":"MDQ6VXNlcjg0MDUzMQ==","avatar_url":"https://avatars2.githubusercontent.com/u/840531?v=4","gravatar_id":"","url":"https://api.github.com/users/amandasposito","html_url":"https://github.com/amandasposito","followers_url":"https://api.github.com/users/amandasposito/followers","following_url":"https://api.github.com/users/amandasposito/following{/other_user}","gists_url":"https://api.github.com/users/amandasposito/gists{/gist_id}","starred_url":"https://api.github.com/users/amandasposito/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/amandasposito/subscriptions","organizations_url":"https://api.github.com/users/amandasposito/orgs","repos_url":"https://api.github.com/users/amandasposito/repos","events_url":"https://api.github.com/users/amandasposito/events{/privacy}","received_events_url":"https://api.github.com/users/amandasposito/received_events","type":"User","site_admin":false}],"requested_reviewers":[],"requested_teams":[],"labels":[{"id":803248120,"node_id":"MDU6TGFiZWw4MDMyNDgxMjA=","url":"https://api.github.com/repos/poanetwork/blockscout/labels/bug%20:bug:","name":"bug :bug:","color":"ee0701","default":false},{"id":859573185,"node_id":"MDU6TGFiZWw4NTk1NzMxODU=","url":"https://api.github.com/repos/poanetwork/blockscout/labels/in%20progress","name":"in progress","color":"ededed","default":false},{"id":995399849,"node_id":"MDU6TGFiZWw5OTUzOTk4NDk=","url":"https://api.github.com/repos/poanetwork/blockscout/labels/ready%20for%20review","name":"ready for review","color":"f274f0","default":false},{"id":1112759383,"node_id":"MDU6TGFiZWwxMTEyNzU5Mzgz","url":"https://api.github.com/repos/poanetwork/blockscout/labels/testing","name":"testing","color":"ea6054","default":false}],"milestone":null,"commits_url":"https://api.github.com/repos/poanetwork/blockscout/pulls/1186/commits","review_comments_url":"https://api.github.com/repos/poanetwork/blockscout/pulls/1186/comments","review_comment_url":"https://api.github.com/repos/poanetwork/blockscout/pulls/comments{/number}","comments_url":"https://api.github.com/repos/poanetwork/blockscout/issues/1186/comments","statuses_url":"https://api.github.com/repos/poanetwork/blockscout/statuses/4833c6c962e6a9f25b0ea7c719d15bda347653e7","head":{"label":"poanetwork:ams-fix-address-transactions-query","ref":"ams-fix-address-transactions-query","sha":"4833c6c962e6a9f25b0ea7c719d15bda347653e7","user":{"login":"poanetwork","id":28943015,"node_id":"MDEyOk9yZ2FuaXphdGlvbjI4OTQzMDE1","avatar_url":"https://avatars2.githubusercontent.com/u/28943015?v=4","gravatar_id":"","url":"https://api.github.com/users/poanetwork","html_url":"https://github.com/poanetwork","followers_url":"https://api.github.com/users/poanetwork/followers","following_url":"https://api.github.com/users/poanetwork/following{/other_user}","gists_url":"https://api.github.com/users/poanetwork/gists{/gist_id}","starred_url":"https://api.github.com/users/poanetwork/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/poanetwork/subscriptions","organizations_url":"https://api.github.com/users/poanetwork/orgs","repos_url":"https://api.github.com/users/poanetwork/repos","events_url":"https://api.github.com/users/poanetwork/events{/privacy}","received_events_url":"https://api.github.com/users/poanetwork/received_events","type":"Organization","site_admin":false},"repo":{"id":117294980,"node_id":"MDEwOlJlcG9zaXRvcnkxMTcyOTQ5ODA=","name":"blockscout","full_name":"poanetwork/blockscout","private":false,"owner":{"login":"poanetwork","id":28943015,"node_id":"MDEyOk9yZ2FuaXphdGlvbjI4OTQzMDE1","avatar_url":"https://avatars2.githubusercontent.com/u/28943015?v=4","gravatar_id":"","url":"https://api.github.com/users/poanetwork","html_url":"https://github.com/poanetwork","followers_url":"https://api.github.com/users/poanetwork/followers","following_url":"https://api.github.com/users/poanetwork/following{/other_user}","gists_url":"https://api.github.com/users/poanetwork/gists{/gist_id}","starred_url":"https://api.github.com/users/poanetwork/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/poanetwork/subscriptions","organizations_url":"https://api.github.com/users/poanetwork/orgs","repos_url":"https://api.github.com/users/poanetwork/repos","events_url":"https://api.github.com/users/poanetwork/events{/privacy}","received_events_url":"https://api.github.com/users/poanetwork/received_events","type":"Organization","site_admin":false},"html_url":"https://github.com/poanetwork/blockscout","description":"A tool for inspecting and analyzing EVM based blockchains. Blockchain explorer for Ethereum networks.","fork":false,"url":"https://api.github.com/repos/poanetwork/blockscout","forks_url":"https://api.github.com/repos/poanetwork/blockscout/forks","keys_url":"https://api.github.com/repos/poanetwork/blockscout/keys{/key_id}","collaborators_url":"https://api.github.com/repos/poanetwork/blockscout/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/poanetwork/blockscout/teams","hooks_url":"https://api.github.com/repos/poanetwork/blockscout/hooks","issue_events_url":"https://api.github.com/repos/poanetwork/blockscout/issues/events{/number}","events_url":"https://api.github.com/repos/poanetwork/blockscout/events","assignees_url":"https://api.github.com/repos/poanetwork/blockscout/assignees{/user}","branches_url":"https://api.github.com/repos/poanetwork/blockscout/branches{/branch}","tags_url":"https://api.github.com/repos/poanetwork/blockscout/tags","blobs_url":"https://api.github.com/repos/poanetwork/blockscout/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/poanetwork/blockscout/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/poanetwork/blockscout/git/refs{/sha}","trees_url":"https://api.github.com/repos/poanetwork/blockscout/git/trees{/sha}","statuses_url":"https://api.github.com/repos/poanetwork/blockscout/statuses/{sha}","languages_url":"https://api.github.com/repos/poanetwork/blockscout/languages","stargazers_url":"https://api.github.com/repos/poanetwork/blockscout/stargazers","contributors_url":"https://api.github.com/repos/poanetwork/blockscout/contributors","subscribers_url":"https://api.github.com/repos/poanetwork/blockscout/subscribers","subscription_url":"https://api.github.com/repos/poanetwork/blockscout/subscription","commits_url":"https://api.github.com/repos/poanetwork/blockscout/commits{/sha}","git_commits_url":"https://api.github.com/repos/poanetwork/blockscout/git/commits{/sha}","comments_url":"https://api.github.com/repos/poanetwork/blockscout/comments{/number}","issue_comment_url":"https://api.github.com/repos/poanetwork/blockscout/issues/comments{/number}","contents_url":"https://api.github.com/repos/poanetwork/blockscout/contents/{+path}","compare_url":"https://api.github.com/repos/poanetwork/blockscout/compare/{base}...{head}","merges_url":"https://api.github.com/repos/poanetwork/blockscout/merges","archive_url":"https://api.github.com/repos/poanetwork/blockscout/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/poanetwork/blockscout/downloads","issues_url":"https://api.github.com/repos/poanetwork/blockscout/issues{/number}","pulls_url":"https://api.github.com/repos/poanetwork/blockscout/pulls{/number}","milestones_url":"https://api.github.com/repos/poanetwork/blockscout/milestones{/number}","notifications_url":"https://api.github.com/repos/poanetwork/blockscout/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/poanetwork/blockscout/labels{/name}","releases_url":"https://api.github.com/repos/poanetwork/blockscout/releases{/id}","deployments_url":"https://api.github.com/repos/poanetwork/blockscout/deployments","created_at":"2018-01-12T22:45:24Z","updated_at":"2018-12-12T17:22:50Z","pushed_at":"2018-12-12T17:59:45Z","git_url":"git://github.com/poanetwork/blockscout.git","ssh_url":"git@github.com:poanetwork/blockscout.git","clone_url":"https://github.com/poanetwork/blockscout.git","svn_url":"https://github.com/poanetwork/blockscout","homepage":"https://blockscout.com","size":9394,"stargazers_count":350,"watchers_count":350,"language":"Elixir","has_issues":true,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":110,"mirror_url":null,"archived":false,"open_issues_count":166,"license":{"key":"gpl-3.0","name":"GNU General Public License v3.0","spdx_id":"GPL-3.0","url":"https://api.github.com/licenses/gpl-3.0","node_id":"MDc6TGljZW5zZTk="},"forks":110,"open_issues":166,"watchers":350,"default_branch":"master"}},"base":{"label":"poanetwork:master","ref":"master","sha":"decf8dafc736a4d7354068c1ee8a90ef3002c428","user":{"login":"poanetwork","id":28943015,"node_id":"MDEyOk9yZ2FuaXphdGlvbjI4OTQzMDE1","avatar_url":"https://avatars2.githubusercontent.com/u/28943015?v=4","gravatar_id":"","url":"https://api.github.com/users/poanetwork","html_url":"https://github.com/poanetwork","followers_url":"https://api.github.com/users/poanetwork/followers","following_url":"https://api.github.com/users/poanetwork/following{/other_user}","gists_url":"https://api.github.com/users/poanetwork/gists{/gist_id}","starred_url":"https://api.github.com/users/poanetwork/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/poanetwork/subscriptions","organizations_url":"https://api.github.com/users/poanetwork/orgs","repos_url":"https://api.github.com/users/poanetwork/repos","events_url":"https://api.github.com/users/poanetwork/events{/privacy}","received_events_url":"https://api.github.com/users/poanetwork/received_events","type":"Organization","site_admin":false},"repo":{"id":117294980,"node_id":"MDEwOlJlcG9zaXRvcnkxMTcyOTQ5ODA=","name":"blockscout","full_name":"poanetwork/blockscout","private":false,"owner":{"login":"poanetwork","id":28943015,"node_id":"MDEyOk9yZ2FuaXphdGlvbjI4OTQzMDE1","avatar_url":"https://avatars2.githubusercontent.com/u/28943015?v=4","gravatar_id":"","url":"https://api.github.com/users/poanetwork","html_url":"https://github.com/poanetwork","followers_url":"https://api.github.com/users/poanetwork/followers","following_url":"https://api.github.com/users/poanetwork/following{/other_user}","gists_url":"https://api.github.com/users/poanetwork/gists{/gist_id}","starred_url":"https://api.github.com/users/poanetwork/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/poanetwork/subscriptions","organizations_url":"https://api.github.com/users/poanetwork/orgs","repos_url":"https://api.github.com/users/poanetwork/repos","events_url":"https://api.github.com/users/poanetwork/events{/privacy}","received_events_url":"https://api.github.com/users/poanetwork/received_events","type":"Organization","site_admin":false},"html_url":"https://github.com/poanetwork/blockscout","description":"A tool for inspecting and analyzing EVM based blockchains. Blockchain explorer for Ethereum networks.","fork":false,"url":"https://api.github.com/repos/poanetwork/blockscout","forks_url":"https://api.github.com/repos/poanetwork/blockscout/forks","keys_url":"https://api.github.com/repos/poanetwork/blockscout/keys{/key_id}","collaborators_url":"https://api.github.com/repos/poanetwork/blockscout/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/poanetwork/blockscout/teams","hooks_url":"https://api.github.com/repos/poanetwork/blockscout/hooks","issue_events_url":"https://api.github.com/repos/poanetwork/blockscout/issues/events{/number}","events_url":"https://api.github.com/repos/poanetwork/blockscout/events","assignees_url":"https://api.github.com/repos/poanetwork/blockscout/assignees{/user}","branches_url":"https://api.github.com/repos/poanetwork/blockscout/branches{/branch}","tags_url":"https://api.github.com/repos/poanetwork/blockscout/tags","blobs_url":"https://api.github.com/repos/poanetwork/blockscout/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/poanetwork/blockscout/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/poanetwork/blockscout/git/refs{/sha}","trees_url":"https://api.github.com/repos/poanetwork/blockscout/git/trees{/sha}","statuses_url":"https://api.github.com/repos/poanetwork/blockscout/statuses/{sha}","languages_url":"https://api.github.com/repos/poanetwork/blockscout/languages","stargazers_url":"https://api.github.com/repos/poanetwork/blockscout/stargazers","contributors_url":"https://api.github.com/repos/poanetwork/blockscout/contributors","subscribers_url":"https://api.github.com/repos/poanetwork/blockscout/subscribers","subscription_url":"https://api.github.com/repos/poanetwork/blockscout/subscription","commits_url":"https://api.github.com/repos/poanetwork/blockscout/commits{/sha}","git_commits_url":"https://api.github.com/repos/poanetwork/blockscout/git/commits{/sha}","comments_url":"https://api.github.com/repos/poanetwork/blockscout/comments{/number}","issue_comment_url":"https://api.github.com/repos/poanetwork/blockscout/issues/comments{/number}","contents_url":"https://api.github.com/repos/poanetwork/blockscout/contents/{+path}","compare_url":"https://api.github.com/repos/poanetwork/blockscout/compare/{base}...{head}","merges_url":"https://api.github.com/repos/poanetwork/blockscout/merges","archive_url":"https://api.github.com/repos/poanetwork/blockscout/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/poanetwork/blockscout/downloads","issues_url":"https://api.github.com/repos/poanetwork/blockscout/issues{/number}","pulls_url":"https://api.github.com/repos/poanetwork/blockscout/pulls{/number}","milestones_url":"https://api.github.com/repos/poanetwork/blockscout/milestones{/number}","notifications_url":"https://api.github.com/repos/poanetwork/blockscout/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/poanetwork/blockscout/labels{/name}","releases_url":"https://api.github.com/repos/poanetwork/blockscout/releases{/id}","deployments_url":"https://api.github.com/repos/poanetwork/blockscout/deployments","created_at":"2018-01-12T22:45:24Z","updated_at":"2018-12-12T17:22:50Z","pushed_at":"2018-12-12T17:59:45Z","git_url":"git://github.com/poanetwork/blockscout.git","ssh_url":"git@github.com:poanetwork/blockscout.git","clone_url":"https://github.com/poanetwork/blockscout.git","svn_url":"https://github.com/poanetwork/blockscout","homepage":"https://blockscout.com","size":9394,"stargazers_count":350,"watchers_count":350,"language":"Elixir","has_issues":true,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":110,"mirror_url":null,"archived":false,"open_issues_count":166,"license":{"key":"gpl-3.0","name":"GNU General Public License v3.0","spdx_id":"GPL-3.0","url":"https://api.github.com/licenses/gpl-3.0","node_id":"MDc6TGljZW5zZTk="},"forks":110,"open_issues":166,"watchers":350,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/poanetwork/blockscout/pulls/1186"},"html":{"href":"https://github.com/poanetwork/blockscout/pull/1186"},"issue":{"href":"https://api.github.com/repos/poanetwork/blockscout/issues/1186"},"comments":{"href":"https://api.github.com/repos/poanetwork/blockscout/issues/1186/comments"},"review_comments":{"href":"https://api.github.com/repos/poanetwork/blockscout/pulls/1186/comments"},"review_comment":{"href":"https://api.github.com/repos/poanetwork/blockscout/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/poanetwork/blockscout/pulls/1186/commits"},"statuses":{"href":"https://api.github.com/repos/poanetwork/blockscout/statuses/4833c6c962e6a9f25b0ea7c719d15bda347653e7"}},"author_association":"CONTRIBUTOR"}}
{"actor":{"display_login":"feliperenan"}}