{"action":"created","comment":{"url":"https://api.github.com/repos/nyaruka/rapidpro/pulls/comments/212226576","pull_request_review_id":148809165,"id":212226576,"node_id":"MDI0OlB1bGxSZXF1ZXN0UmV2aWV3Q29tbWVudDIxMjIyNjU3Ng==","diff_hunk":"@@ -347,7 +347,7 @@ def test_evaluate_dynamic_groups_from_flow(self):\n                 ContactField.get_or_create(self.org, self.admin, key, value_type=Value.TYPE_NUMBER)\n                 ContactGroup.create_dynamic(self.org, self.admin, \"Group %s\" % (key), \"(%s > 10)\" % key)\n \n-        with QueryTracker(assert_query_count=110, stack_count=16, skip_unique_queries=False):\n+        with QueryTracker(assert_query_count=118, stack_count=16, skip_unique_queries=False):","path":"temba/contacts/tests.py","position":5,"original_position":5,"commit_id":"f231b9efdc884657bf3dac9ff2ce7554735f1587","original_commit_id":"f231b9efdc884657bf3dac9ff2ce7554735f1587","user":{"login":"dodobas","id":394314,"node_id":"MDQ6VXNlcjM5NDMxNA==","avatar_url":"https://avatars1.githubusercontent.com/u/394314?v=4","gravatar_id":"","url":"https://api.github.com/users/dodobas","html_url":"https://github.com/dodobas","followers_url":"https://api.github.com/users/dodobas/followers","following_url":"https://api.github.com/users/dodobas/following{/other_user}","gists_url":"https://api.github.com/users/dodobas/gists{/gist_id}","starred_url":"https://api.github.com/users/dodobas/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dodobas/subscriptions","organizations_url":"https://api.github.com/users/dodobas/orgs","repos_url":"https://api.github.com/users/dodobas/repos","events_url":"https://api.github.com/users/dodobas/events{/privacy}","received_events_url":"https://api.github.com/users/dodobas/received_events","type":"User","site_admin":false},"body":"\r\n\r\nthis is a funny one ... it's related to this change https://github.com/nyaruka/rapidpro/pull/2064/files#diff-8a47789b2c9de7beb2c22be6a4d78f2eR670 ... updated CampaignEvent query ..\r\n\r\nin the original form it was never evaluated and it did not execute a query, maybe it was cached internally, but I could not figure out where\r\n\r\nextra 8 queries are all similar to \r\n```\r\nSELECT \"campaigns_campaignevent\".\"id\", \"campaigns_campaignevent\".\"is_active\", \"campaigns_campaignevent\".\"created_by_id\", \"campaigns_campaignevent\".\"created_on\", \"campaigns_campaignevent\".\"modified_by_id\", \"campaigns_campaignevent\".\"modified_on\", \"campaigns_campaignevent\".\"uuid\", \"campaigns_campaignevent\".\"campaign_id\", \"campaigns_campaignevent\".\"offset\", \"campaigns_campaignevent\".\"unit\", \"campaigns_campaignevent\".\"relative_to_id\", \"campaigns_campaignevent\".\"flow_id\", \"campaigns_campaignevent\".\"event_type\", \"campaigns_campaignevent\".\"message\", \"campaigns_campaignevent\".\"delivery_hour\" FROM \"campaigns_campaignevent\" INNER JOIN \"campaigns_campaign\" ON (\"campaigns_campaignevent\".\"campaign_id\" = \"campaigns_campaign\".\"id\") INNER JOIN \"contacts_contactfield\" ON (\"campaigns_campaignevent\".\"relative_to_id\" = \"contacts_contactfield\".\"id\") WHERE (\"campaigns_campaign\".\"group_id\" IN (SELECT U0.\"id\" FROM \"contacts_contactgroup\" U0 INNER JOIN \"contacts_contactgroup_contacts\" U1 ON (U0.\"id\" = U1.\"contactgroup_id\") WHERE (U1.\"contact_id\" = 36 AND U0.\"group_type\" = 'U')) AND \"campaigns_campaign\".\"is_archived\" = false AND \"campaigns_campaignevent\".\"is_active\" = true AND \"contacts_contactfield\".\"key\" IN ('total_calls_made'))\r\n```","created_at":"2018-08-23T08:40:00Z","updated_at":"2018-08-23T08:40:56Z","html_url":"https://github.com/nyaruka/rapidpro/pull/2064#discussion_r212226576","pull_request_url":"https://api.github.com/repos/nyaruka/rapidpro/pulls/2064","author_association":"NONE","_links":{"self":{"href":"https://api.github.com/repos/nyaruka/rapidpro/pulls/comments/212226576"},"html":{"href":"https://github.com/nyaruka/rapidpro/pull/2064#discussion_r212226576"},"pull_request":{"href":"https://api.github.com/repos/nyaruka/rapidpro/pulls/2064"}}},"pull_request":{"url":"https://api.github.com/repos/nyaruka/rapidpro/pulls/2064","id":210370860,"node_id":"MDExOlB1bGxSZXF1ZXN0MjEwMzcwODYw","html_url":"https://github.com/nyaruka/rapidpro/pull/2064","diff_url":"https://github.com/nyaruka/rapidpro/pull/2064.diff","patch_url":"https://github.com/nyaruka/rapidpro/pull/2064.patch","issue_url":"https://api.github.com/repos/nyaruka/rapidpro/issues/2064","number":2064,"state":"open","locked":false,"title":"WIP","user":{"login":"dodobas","id":394314,"node_id":"MDQ6VXNlcjM5NDMxNA==","avatar_url":"https://avatars1.githubusercontent.com/u/394314?v=4","gravatar_id":"","url":"https://api.github.com/users/dodobas","html_url":"https://github.com/dodobas","followers_url":"https://api.github.com/users/dodobas/followers","following_url":"https://api.github.com/users/dodobas/following{/other_user}","gists_url":"https://api.github.com/users/dodobas/gists{/gist_id}","starred_url":"https://api.github.com/users/dodobas/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dodobas/subscriptions","organizations_url":"https://api.github.com/users/dodobas/orgs","repos_url":"https://api.github.com/users/dodobas/repos","events_url":"https://api.github.com/users/dodobas/events{/privacy}","received_events_url":"https://api.github.com/users/dodobas/received_events","type":"User","site_admin":false},"body":"","created_at":"2018-08-23T08:36:42Z","updated_at":"2018-08-23T08:40:56Z","closed_at":null,"merged_at":null,"merge_commit_sha":"a56bdab25877d9f3b44670039fbe6d4aa0ae9e9c","assignee":null,"assignees":[],"requested_reviewers":[],"requested_teams":[],"labels":[],"milestone":null,"commits_url":"https://api.github.com/repos/nyaruka/rapidpro/pulls/2064/commits","review_comments_url":"https://api.github.com/repos/nyaruka/rapidpro/pulls/2064/comments","review_comment_url":"https://api.github.com/repos/nyaruka/rapidpro/pulls/comments{/number}","comments_url":"https://api.github.com/repos/nyaruka/rapidpro/issues/2064/comments","statuses_url":"https://api.github.com/repos/nyaruka/rapidpro/statuses/f231b9efdc884657bf3dac9ff2ce7554735f1587","head":{"label":"nyaruka:add_Contact_set_fields","ref":"add_Contact_set_fields","sha":"f231b9efdc884657bf3dac9ff2ce7554735f1587","user":{"login":"nyaruka","id":299256,"node_id":"MDEyOk9yZ2FuaXphdGlvbjI5OTI1Ng==","avatar_url":"https://avatars0.githubusercontent.com/u/299256?v=4","gravatar_id":"","url":"https://api.github.com/users/nyaruka","html_url":"https://github.com/nyaruka","followers_url":"https://api.github.com/users/nyaruka/followers","following_url":"https://api.github.com/users/nyaruka/following{/other_user}","gists_url":"https://api.github.com/users/nyaruka/gists{/gist_id}","starred_url":"https://api.github.com/users/nyaruka/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nyaruka/subscriptions","organizations_url":"https://api.github.com/users/nyaruka/orgs","repos_url":"https://api.github.com/users/nyaruka/repos","events_url":"https://api.github.com/users/nyaruka/events{/privacy}","received_events_url":"https://api.github.com/users/nyaruka/received_events","type":"Organization","site_admin":false},"repo":{"id":27415685,"node_id":"MDEwOlJlcG9zaXRvcnkyNzQxNTY4NQ==","name":"rapidpro","full_name":"nyaruka/rapidpro","owner":{"login":"nyaruka","id":299256,"node_id":"MDEyOk9yZ2FuaXphdGlvbjI5OTI1Ng==","avatar_url":"https://avatars0.githubusercontent.com/u/299256?v=4","gravatar_id":"","url":"https://api.github.com/users/nyaruka","html_url":"https://github.com/nyaruka","followers_url":"https://api.github.com/users/nyaruka/followers","following_url":"https://api.github.com/users/nyaruka/following{/other_user}","gists_url":"https://api.github.com/users/nyaruka/gists{/gist_id}","starred_url":"https://api.github.com/users/nyaruka/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nyaruka/subscriptions","organizations_url":"https://api.github.com/users/nyaruka/orgs","repos_url":"https://api.github.com/users/nyaruka/repos","events_url":"https://api.github.com/users/nyaruka/events{/privacy}","received_events_url":"https://api.github.com/users/nyaruka/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/nyaruka/rapidpro","description":"RapidPro is a hosted service allowing organizations to visually build scalable interactive messaging applications.","fork":true,"url":"https://api.github.com/repos/nyaruka/rapidpro","forks_url":"https://api.github.com/repos/nyaruka/rapidpro/forks","keys_url":"https://api.github.com/repos/nyaruka/rapidpro/keys{/key_id}","collaborators_url":"https://api.github.com/repos/nyaruka/rapidpro/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/nyaruka/rapidpro/teams","hooks_url":"https://api.github.com/repos/nyaruka/rapidpro/hooks","issue_events_url":"https://api.github.com/repos/nyaruka/rapidpro/issues/events{/number}","events_url":"https://api.github.com/repos/nyaruka/rapidpro/events","assignees_url":"https://api.github.com/repos/nyaruka/rapidpro/assignees{/user}","branches_url":"https://api.github.com/repos/nyaruka/rapidpro/branches{/branch}","tags_url":"https://api.github.com/repos/nyaruka/rapidpro/tags","blobs_url":"https://api.github.com/repos/nyaruka/rapidpro/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/nyaruka/rapidpro/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/nyaruka/rapidpro/git/refs{/sha}","trees_url":"https://api.github.com/repos/nyaruka/rapidpro/git/trees{/sha}","statuses_url":"https://api.github.com/repos/nyaruka/rapidpro/statuses/{sha}","languages_url":"https://api.github.com/repos/nyaruka/rapidpro/languages","stargazers_url":"https://api.github.com/repos/nyaruka/rapidpro/stargazers","contributors_url":"https://api.github.com/repos/nyaruka/rapidpro/contributors","subscribers_url":"https://api.github.com/repos/nyaruka/rapidpro/subscribers","subscription_url":"https://api.github.com/repos/nyaruka/rapidpro/subscription","commits_url":"https://api.github.com/repos/nyaruka/rapidpro/commits{/sha}","git_commits_url":"https://api.github.com/repos/nyaruka/rapidpro/git/commits{/sha}","comments_url":"https://api.github.com/repos/nyaruka/rapidpro/comments{/number}","issue_comment_url":"https://api.github.com/repos/nyaruka/rapidpro/issues/comments{/number}","contents_url":"https://api.github.com/repos/nyaruka/rapidpro/contents/{+path}","compare_url":"https://api.github.com/repos/nyaruka/rapidpro/compare/{base}...{head}","merges_url":"https://api.github.com/repos/nyaruka/rapidpro/merges","archive_url":"https://api.github.com/repos/nyaruka/rapidpro/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/nyaruka/rapidpro/downloads","issues_url":"https://api.github.com/repos/nyaruka/rapidpro/issues{/number}","pulls_url":"https://api.github.com/repos/nyaruka/rapidpro/pulls{/number}","milestones_url":"https://api.github.com/repos/nyaruka/rapidpro/milestones{/number}","notifications_url":"https://api.github.com/repos/nyaruka/rapidpro/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/nyaruka/rapidpro/labels{/name}","releases_url":"https://api.github.com/repos/nyaruka/rapidpro/releases{/id}","deployments_url":"https://api.github.com/repos/nyaruka/rapidpro/deployments","created_at":"2014-12-02T04:53:16Z","updated_at":"2018-08-21T14:02:35Z","pushed_at":"2018-08-23T08:36:42Z","git_url":"git://github.com/nyaruka/rapidpro.git","ssh_url":"git@github.com:nyaruka/rapidpro.git","clone_url":"https://github.com/nyaruka/rapidpro.git","svn_url":"https://github.com/nyaruka/rapidpro","homepage":null,"size":117251,"stargazers_count":13,"watchers_count":13,"language":"JavaScript","has_issues":false,"has_projects":false,"has_downloads":true,"has_wiki":false,"has_pages":false,"forks_count":7,"mirror_url":null,"archived":false,"open_issues_count":9,"license":{"key":"other","name":"Other","spdx_id":null,"url":null,"node_id":"MDc6TGljZW5zZTA="},"forks":7,"open_issues":9,"watchers":13,"default_branch":"master"}},"base":{"label":"nyaruka:master","ref":"master","sha":"aac584bcb8159566407b23054c14b4276063657a","user":{"login":"nyaruka","id":299256,"node_id":"MDEyOk9yZ2FuaXphdGlvbjI5OTI1Ng==","avatar_url":"https://avatars0.githubusercontent.com/u/299256?v=4","gravatar_id":"","url":"https://api.github.com/users/nyaruka","html_url":"https://github.com/nyaruka","followers_url":"https://api.github.com/users/nyaruka/followers","following_url":"https://api.github.com/users/nyaruka/following{/other_user}","gists_url":"https://api.github.com/users/nyaruka/gists{/gist_id}","starred_url":"https://api.github.com/users/nyaruka/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nyaruka/subscriptions","organizations_url":"https://api.github.com/users/nyaruka/orgs","repos_url":"https://api.github.com/users/nyaruka/repos","events_url":"https://api.github.com/users/nyaruka/events{/privacy}","received_events_url":"https://api.github.com/users/nyaruka/received_events","type":"Organization","site_admin":false},"repo":{"id":27415685,"node_id":"MDEwOlJlcG9zaXRvcnkyNzQxNTY4NQ==","name":"rapidpro","full_name":"nyaruka/rapidpro","owner":{"login":"nyaruka","id":299256,"node_id":"MDEyOk9yZ2FuaXphdGlvbjI5OTI1Ng==","avatar_url":"https://avatars0.githubusercontent.com/u/299256?v=4","gravatar_id":"","url":"https://api.github.com/users/nyaruka","html_url":"https://github.com/nyaruka","followers_url":"https://api.github.com/users/nyaruka/followers","following_url":"https://api.github.com/users/nyaruka/following{/other_user}","gists_url":"https://api.github.com/users/nyaruka/gists{/gist_id}","starred_url":"https://api.github.com/users/nyaruka/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nyaruka/subscriptions","organizations_url":"https://api.github.com/users/nyaruka/orgs","repos_url":"https://api.github.com/users/nyaruka/repos","events_url":"https://api.github.com/users/nyaruka/events{/privacy}","received_events_url":"https://api.github.com/users/nyaruka/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/nyaruka/rapidpro","description":"RapidPro is a hosted service allowing organizations to visually build scalable interactive messaging applications.","fork":true,"url":"https://api.github.com/repos/nyaruka/rapidpro","forks_url":"https://api.github.com/repos/nyaruka/rapidpro/forks","keys_url":"https://api.github.com/repos/nyaruka/rapidpro/keys{/key_id}","collaborators_url":"https://api.github.com/repos/nyaruka/rapidpro/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/nyaruka/rapidpro/teams","hooks_url":"https://api.github.com/repos/nyaruka/rapidpro/hooks","issue_events_url":"https://api.github.com/repos/nyaruka/rapidpro/issues/events{/number}","events_url":"https://api.github.com/repos/nyaruka/rapidpro/events","assignees_url":"https://api.github.com/repos/nyaruka/rapidpro/assignees{/user}","branches_url":"https://api.github.com/repos/nyaruka/rapidpro/branches{/branch}","tags_url":"https://api.github.com/repos/nyaruka/rapidpro/tags","blobs_url":"https://api.github.com/repos/nyaruka/rapidpro/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/nyaruka/rapidpro/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/nyaruka/rapidpro/git/refs{/sha}","trees_url":"https://api.github.com/repos/nyaruka/rapidpro/git/trees{/sha}","statuses_url":"https://api.github.com/repos/nyaruka/rapidpro/statuses/{sha}","languages_url":"https://api.github.com/repos/nyaruka/rapidpro/languages","stargazers_url":"https://api.github.com/repos/nyaruka/rapidpro/stargazers","contributors_url":"https://api.github.com/repos/nyaruka/rapidpro/contributors","subscribers_url":"https://api.github.com/repos/nyaruka/rapidpro/subscribers","subscription_url":"https://api.github.com/repos/nyaruka/rapidpro/subscription","commits_url":"https://api.github.com/repos/nyaruka/rapidpro/commits{/sha}","git_commits_url":"https://api.github.com/repos/nyaruka/rapidpro/git/commits{/sha}","comments_url":"https://api.github.com/repos/nyaruka/rapidpro/comments{/number}","issue_comment_url":"https://api.github.com/repos/nyaruka/rapidpro/issues/comments{/number}","contents_url":"https://api.github.com/repos/nyaruka/rapidpro/contents/{+path}","compare_url":"https://api.github.com/repos/nyaruka/rapidpro/compare/{base}...{head}","merges_url":"https://api.github.com/repos/nyaruka/rapidpro/merges","archive_url":"https://api.github.com/repos/nyaruka/rapidpro/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/nyaruka/rapidpro/downloads","issues_url":"https://api.github.com/repos/nyaruka/rapidpro/issues{/number}","pulls_url":"https://api.github.com/repos/nyaruka/rapidpro/pulls{/number}","milestones_url":"https://api.github.com/repos/nyaruka/rapidpro/milestones{/number}","notifications_url":"https://api.github.com/repos/nyaruka/rapidpro/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/nyaruka/rapidpro/labels{/name}","releases_url":"https://api.github.com/repos/nyaruka/rapidpro/releases{/id}","deployments_url":"https://api.github.com/repos/nyaruka/rapidpro/deployments","created_at":"2014-12-02T04:53:16Z","updated_at":"2018-08-21T14:02:35Z","pushed_at":"2018-08-23T08:36:42Z","git_url":"git://github.com/nyaruka/rapidpro.git","ssh_url":"git@github.com:nyaruka/rapidpro.git","clone_url":"https://github.com/nyaruka/rapidpro.git","svn_url":"https://github.com/nyaruka/rapidpro","homepage":null,"size":117251,"stargazers_count":13,"watchers_count":13,"language":"JavaScript","has_issues":false,"has_projects":false,"has_downloads":true,"has_wiki":false,"has_pages":false,"forks_count":7,"mirror_url":null,"archived":false,"open_issues_count":9,"license":{"key":"other","name":"Other","spdx_id":null,"url":null,"node_id":"MDc6TGljZW5zZTA="},"forks":7,"open_issues":9,"watchers":13,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/nyaruka/rapidpro/pulls/2064"},"html":{"href":"https://github.com/nyaruka/rapidpro/pull/2064"},"issue":{"href":"https://api.github.com/repos/nyaruka/rapidpro/issues/2064"},"comments":{"href":"https://api.github.com/repos/nyaruka/rapidpro/issues/2064/comments"},"review_comments":{"href":"https://api.github.com/repos/nyaruka/rapidpro/pulls/2064/comments"},"review_comment":{"href":"https://api.github.com/repos/nyaruka/rapidpro/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/nyaruka/rapidpro/pulls/2064/commits"},"statuses":{"href":"https://api.github.com/repos/nyaruka/rapidpro/statuses/f231b9efdc884657bf3dac9ff2ce7554735f1587"}},"author_association":"NONE"}}
{"actor":{"display_login":"dodobas"}}