{"action":"created","comment":{"url":"https://api.github.com/repos/Nekorooni/Kiara/pulls/comments/237031344","pull_request_review_id":179229035,"id":237031344,"node_id":"MDI0OlB1bGxSZXF1ZXN0UmV2aWV3Q29tbWVudDIzNzAzMTM0NA==","diff_hunk":"@@ -118,6 +132,27 @@ def is_answer(c):\n         else:\n             return False\n \n+    async def free_color(self, user):\n+        owned = itertools.chain(*await self.bot.db.fetch(f'SELECT color FROM colors WHERE user_id={user.id}'))\n+        #owned = [r[0] for r in await self.bot.db.fetch(f'SELECT color FROM colors WHERE user_id={user.id}')]","path":"cogs/selfmanage.py","position":60,"original_position":60,"commit_id":"5de898db92076263c40611f5c5a57930d4277477","original_commit_id":"5de898db92076263c40611f5c5a57930d4277477","user":{"login":"Nekorooni","id":916242,"node_id":"MDQ6VXNlcjkxNjI0Mg==","avatar_url":"https://avatars2.githubusercontent.com/u/916242?v=4","gravatar_id":"","url":"https://api.github.com/users/Nekorooni","html_url":"https://github.com/Nekorooni","followers_url":"https://api.github.com/users/Nekorooni/followers","following_url":"https://api.github.com/users/Nekorooni/following{/other_user}","gists_url":"https://api.github.com/users/Nekorooni/gists{/gist_id}","starred_url":"https://api.github.com/users/Nekorooni/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Nekorooni/subscriptions","organizations_url":"https://api.github.com/users/Nekorooni/orgs","repos_url":"https://api.github.com/users/Nekorooni/repos","events_url":"https://api.github.com/users/Nekorooni/events{/privacy}","received_events_url":"https://api.github.com/users/Nekorooni/received_events","type":"User","site_admin":false},"body":"I might be wrong, but did \r\n```py\r\n[r[0] for r in await self.bot.db.fetch(f'SELECT color FROM colors WHERE user_id={user.id}')]\r\n```\r\nnot work?","created_at":"2018-11-28T10:49:20Z","updated_at":"2018-11-28T10:50:10Z","html_url":"https://github.com/Nekorooni/Kiara/pull/50#discussion_r237031344","pull_request_url":"https://api.github.com/repos/Nekorooni/Kiara/pulls/50","author_association":"OWNER","_links":{"self":{"href":"https://api.github.com/repos/Nekorooni/Kiara/pulls/comments/237031344"},"html":{"href":"https://github.com/Nekorooni/Kiara/pull/50#discussion_r237031344"},"pull_request":{"href":"https://api.github.com/repos/Nekorooni/Kiara/pulls/50"}}},"pull_request":{"url":"https://api.github.com/repos/Nekorooni/Kiara/pulls/50","id":233891539,"node_id":"MDExOlB1bGxSZXF1ZXN0MjMzODkxNTM5","html_url":"https://github.com/Nekorooni/Kiara/pull/50","diff_url":"https://github.com/Nekorooni/Kiara/pull/50.diff","patch_url":"https://github.com/Nekorooni/Kiara/pull/50.patch","issue_url":"https://api.github.com/repos/Nekorooni/Kiara/issues/50","number":50,"state":"open","locked":false,"title":"Free colour when completing introduction","user":{"login":"Kefuri","id":41115973,"node_id":"MDQ6VXNlcjQxMTE1OTcz","avatar_url":"https://avatars1.githubusercontent.com/u/41115973?v=4","gravatar_id":"","url":"https://api.github.com/users/Kefuri","html_url":"https://github.com/Kefuri","followers_url":"https://api.github.com/users/Kefuri/followers","following_url":"https://api.github.com/users/Kefuri/following{/other_user}","gists_url":"https://api.github.com/users/Kefuri/gists{/gist_id}","starred_url":"https://api.github.com/users/Kefuri/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Kefuri/subscriptions","organizations_url":"https://api.github.com/users/Kefuri/orgs","repos_url":"https://api.github.com/users/Kefuri/repos","events_url":"https://api.github.com/users/Kefuri/events{/privacy}","received_events_url":"https://api.github.com/users/Kefuri/received_events","type":"User","site_admin":false},"body":"Redis used to ensure this can only be claimed once per person//\r\nIf user attempts to claim a colour they already own they are given 30 gold instead.","created_at":"2018-11-27T12:24:16Z","updated_at":"2018-11-28T10:50:10Z","closed_at":null,"merged_at":null,"merge_commit_sha":"1e7d9a5c73117d80dc3479ba9e60c96a013ab95c","assignee":null,"assignees":[],"requested_reviewers":[],"requested_teams":[],"labels":[],"milestone":null,"commits_url":"https://api.github.com/repos/Nekorooni/Kiara/pulls/50/commits","review_comments_url":"https://api.github.com/repos/Nekorooni/Kiara/pulls/50/comments","review_comment_url":"https://api.github.com/repos/Nekorooni/Kiara/pulls/comments{/number}","comments_url":"https://api.github.com/repos/Nekorooni/Kiara/issues/50/comments","statuses_url":"https://api.github.com/repos/Nekorooni/Kiara/statuses/5de898db92076263c40611f5c5a57930d4277477","head":{"label":"Kefuri:free-colours","ref":"free-colours","sha":"5de898db92076263c40611f5c5a57930d4277477","user":{"login":"Kefuri","id":41115973,"node_id":"MDQ6VXNlcjQxMTE1OTcz","avatar_url":"https://avatars1.githubusercontent.com/u/41115973?v=4","gravatar_id":"","url":"https://api.github.com/users/Kefuri","html_url":"https://github.com/Kefuri","followers_url":"https://api.github.com/users/Kefuri/followers","following_url":"https://api.github.com/users/Kefuri/following{/other_user}","gists_url":"https://api.github.com/users/Kefuri/gists{/gist_id}","starred_url":"https://api.github.com/users/Kefuri/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Kefuri/subscriptions","organizations_url":"https://api.github.com/users/Kefuri/orgs","repos_url":"https://api.github.com/users/Kefuri/repos","events_url":"https://api.github.com/users/Kefuri/events{/privacy}","received_events_url":"https://api.github.com/users/Kefuri/received_events","type":"User","site_admin":false},"repo":{"id":156106380,"node_id":"MDEwOlJlcG9zaXRvcnkxNTYxMDYzODA=","name":"Kiara","full_name":"Kefuri/Kiara","private":false,"owner":{"login":"Kefuri","id":41115973,"node_id":"MDQ6VXNlcjQxMTE1OTcz","avatar_url":"https://avatars1.githubusercontent.com/u/41115973?v=4","gravatar_id":"","url":"https://api.github.com/users/Kefuri","html_url":"https://github.com/Kefuri","followers_url":"https://api.github.com/users/Kefuri/followers","following_url":"https://api.github.com/users/Kefuri/following{/other_user}","gists_url":"https://api.github.com/users/Kefuri/gists{/gist_id}","starred_url":"https://api.github.com/users/Kefuri/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Kefuri/subscriptions","organizations_url":"https://api.github.com/users/Kefuri/orgs","repos_url":"https://api.github.com/users/Kefuri/repos","events_url":"https://api.github.com/users/Kefuri/events{/privacy}","received_events_url":"https://api.github.com/users/Kefuri/received_events","type":"User","site_admin":false},"html_url":"https://github.com/Kefuri/Kiara","description":null,"fork":true,"url":"https://api.github.com/repos/Kefuri/Kiara","forks_url":"https://api.github.com/repos/Kefuri/Kiara/forks","keys_url":"https://api.github.com/repos/Kefuri/Kiara/keys{/key_id}","collaborators_url":"https://api.github.com/repos/Kefuri/Kiara/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/Kefuri/Kiara/teams","hooks_url":"https://api.github.com/repos/Kefuri/Kiara/hooks","issue_events_url":"https://api.github.com/repos/Kefuri/Kiara/issues/events{/number}","events_url":"https://api.github.com/repos/Kefuri/Kiara/events","assignees_url":"https://api.github.com/repos/Kefuri/Kiara/assignees{/user}","branches_url":"https://api.github.com/repos/Kefuri/Kiara/branches{/branch}","tags_url":"https://api.github.com/repos/Kefuri/Kiara/tags","blobs_url":"https://api.github.com/repos/Kefuri/Kiara/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/Kefuri/Kiara/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/Kefuri/Kiara/git/refs{/sha}","trees_url":"https://api.github.com/repos/Kefuri/Kiara/git/trees{/sha}","statuses_url":"https://api.github.com/repos/Kefuri/Kiara/statuses/{sha}","languages_url":"https://api.github.com/repos/Kefuri/Kiara/languages","stargazers_url":"https://api.github.com/repos/Kefuri/Kiara/stargazers","contributors_url":"https://api.github.com/repos/Kefuri/Kiara/contributors","subscribers_url":"https://api.github.com/repos/Kefuri/Kiara/subscribers","subscription_url":"https://api.github.com/repos/Kefuri/Kiara/subscription","commits_url":"https://api.github.com/repos/Kefuri/Kiara/commits{/sha}","git_commits_url":"https://api.github.com/repos/Kefuri/Kiara/git/commits{/sha}","comments_url":"https://api.github.com/repos/Kefuri/Kiara/comments{/number}","issue_comment_url":"https://api.github.com/repos/Kefuri/Kiara/issues/comments{/number}","contents_url":"https://api.github.com/repos/Kefuri/Kiara/contents/{+path}","compare_url":"https://api.github.com/repos/Kefuri/Kiara/compare/{base}...{head}","merges_url":"https://api.github.com/repos/Kefuri/Kiara/merges","archive_url":"https://api.github.com/repos/Kefuri/Kiara/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/Kefuri/Kiara/downloads","issues_url":"https://api.github.com/repos/Kefuri/Kiara/issues{/number}","pulls_url":"https://api.github.com/repos/Kefuri/Kiara/pulls{/number}","milestones_url":"https://api.github.com/repos/Kefuri/Kiara/milestones{/number}","notifications_url":"https://api.github.com/repos/Kefuri/Kiara/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/Kefuri/Kiara/labels{/name}","releases_url":"https://api.github.com/repos/Kefuri/Kiara/releases{/id}","deployments_url":"https://api.github.com/repos/Kefuri/Kiara/deployments","created_at":"2018-11-04T17:19:56Z","updated_at":"2018-11-26T20:24:40Z","pushed_at":"2018-11-27T00:23:43Z","git_url":"git://github.com/Kefuri/Kiara.git","ssh_url":"git@github.com:Kefuri/Kiara.git","clone_url":"https://github.com/Kefuri/Kiara.git","svn_url":"https://github.com/Kefuri/Kiara","homepage":null,"size":222,"stargazers_count":0,"watchers_count":0,"language":"Python","has_issues":false,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":0,"mirror_url":null,"archived":false,"open_issues_count":0,"license":null,"forks":0,"open_issues":0,"watchers":0,"default_branch":"master"}},"base":{"label":"Nekorooni:master","ref":"master","sha":"ec5fd4c48ccef0b36cbc123b724addc42693f9c5","user":{"login":"Nekorooni","id":916242,"node_id":"MDQ6VXNlcjkxNjI0Mg==","avatar_url":"https://avatars2.githubusercontent.com/u/916242?v=4","gravatar_id":"","url":"https://api.github.com/users/Nekorooni","html_url":"https://github.com/Nekorooni","followers_url":"https://api.github.com/users/Nekorooni/followers","following_url":"https://api.github.com/users/Nekorooni/following{/other_user}","gists_url":"https://api.github.com/users/Nekorooni/gists{/gist_id}","starred_url":"https://api.github.com/users/Nekorooni/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Nekorooni/subscriptions","organizations_url":"https://api.github.com/users/Nekorooni/orgs","repos_url":"https://api.github.com/users/Nekorooni/repos","events_url":"https://api.github.com/users/Nekorooni/events{/privacy}","received_events_url":"https://api.github.com/users/Nekorooni/received_events","type":"User","site_admin":false},"repo":{"id":106821481,"node_id":"MDEwOlJlcG9zaXRvcnkxMDY4MjE0ODE=","name":"Kiara","full_name":"Nekorooni/Kiara","private":false,"owner":{"login":"Nekorooni","id":916242,"node_id":"MDQ6VXNlcjkxNjI0Mg==","avatar_url":"https://avatars2.githubusercontent.com/u/916242?v=4","gravatar_id":"","url":"https://api.github.com/users/Nekorooni","html_url":"https://github.com/Nekorooni","followers_url":"https://api.github.com/users/Nekorooni/followers","following_url":"https://api.github.com/users/Nekorooni/following{/other_user}","gists_url":"https://api.github.com/users/Nekorooni/gists{/gist_id}","starred_url":"https://api.github.com/users/Nekorooni/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Nekorooni/subscriptions","organizations_url":"https://api.github.com/users/Nekorooni/orgs","repos_url":"https://api.github.com/users/Nekorooni/repos","events_url":"https://api.github.com/users/Nekorooni/events{/privacy}","received_events_url":"https://api.github.com/users/Nekorooni/received_events","type":"User","site_admin":false},"html_url":"https://github.com/Nekorooni/Kiara","description":null,"fork":false,"url":"https://api.github.com/repos/Nekorooni/Kiara","forks_url":"https://api.github.com/repos/Nekorooni/Kiara/forks","keys_url":"https://api.github.com/repos/Nekorooni/Kiara/keys{/key_id}","collaborators_url":"https://api.github.com/repos/Nekorooni/Kiara/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/Nekorooni/Kiara/teams","hooks_url":"https://api.github.com/repos/Nekorooni/Kiara/hooks","issue_events_url":"https://api.github.com/repos/Nekorooni/Kiara/issues/events{/number}","events_url":"https://api.github.com/repos/Nekorooni/Kiara/events","assignees_url":"https://api.github.com/repos/Nekorooni/Kiara/assignees{/user}","branches_url":"https://api.github.com/repos/Nekorooni/Kiara/branches{/branch}","tags_url":"https://api.github.com/repos/Nekorooni/Kiara/tags","blobs_url":"https://api.github.com/repos/Nekorooni/Kiara/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/Nekorooni/Kiara/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/Nekorooni/Kiara/git/refs{/sha}","trees_url":"https://api.github.com/repos/Nekorooni/Kiara/git/trees{/sha}","statuses_url":"https://api.github.com/repos/Nekorooni/Kiara/statuses/{sha}","languages_url":"https://api.github.com/repos/Nekorooni/Kiara/languages","stargazers_url":"https://api.github.com/repos/Nekorooni/Kiara/stargazers","contributors_url":"https://api.github.com/repos/Nekorooni/Kiara/contributors","subscribers_url":"https://api.github.com/repos/Nekorooni/Kiara/subscribers","subscription_url":"https://api.github.com/repos/Nekorooni/Kiara/subscription","commits_url":"https://api.github.com/repos/Nekorooni/Kiara/commits{/sha}","git_commits_url":"https://api.github.com/repos/Nekorooni/Kiara/git/commits{/sha}","comments_url":"https://api.github.com/repos/Nekorooni/Kiara/comments{/number}","issue_comment_url":"https://api.github.com/repos/Nekorooni/Kiara/issues/comments{/number}","contents_url":"https://api.github.com/repos/Nekorooni/Kiara/contents/{+path}","compare_url":"https://api.github.com/repos/Nekorooni/Kiara/compare/{base}...{head}","merges_url":"https://api.github.com/repos/Nekorooni/Kiara/merges","archive_url":"https://api.github.com/repos/Nekorooni/Kiara/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/Nekorooni/Kiara/downloads","issues_url":"https://api.github.com/repos/Nekorooni/Kiara/issues{/number}","pulls_url":"https://api.github.com/repos/Nekorooni/Kiara/pulls{/number}","milestones_url":"https://api.github.com/repos/Nekorooni/Kiara/milestones{/number}","notifications_url":"https://api.github.com/repos/Nekorooni/Kiara/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/Nekorooni/Kiara/labels{/name}","releases_url":"https://api.github.com/repos/Nekorooni/Kiara/releases{/id}","deployments_url":"https://api.github.com/repos/Nekorooni/Kiara/deployments","created_at":"2017-10-13T12:27:41Z","updated_at":"2018-11-28T10:08:22Z","pushed_at":"2018-11-28T10:08:19Z","git_url":"git://github.com/Nekorooni/Kiara.git","ssh_url":"git@github.com:Nekorooni/Kiara.git","clone_url":"https://github.com/Nekorooni/Kiara.git","svn_url":"https://github.com/Nekorooni/Kiara","homepage":null,"size":200,"stargazers_count":3,"watchers_count":3,"language":"Python","has_issues":true,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":2,"mirror_url":null,"archived":false,"open_issues_count":19,"license":null,"forks":2,"open_issues":19,"watchers":3,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/Nekorooni/Kiara/pulls/50"},"html":{"href":"https://github.com/Nekorooni/Kiara/pull/50"},"issue":{"href":"https://api.github.com/repos/Nekorooni/Kiara/issues/50"},"comments":{"href":"https://api.github.com/repos/Nekorooni/Kiara/issues/50/comments"},"review_comments":{"href":"https://api.github.com/repos/Nekorooni/Kiara/pulls/50/comments"},"review_comment":{"href":"https://api.github.com/repos/Nekorooni/Kiara/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/Nekorooni/Kiara/pulls/50/commits"},"statuses":{"href":"https://api.github.com/repos/Nekorooni/Kiara/statuses/5de898db92076263c40611f5c5a57930d4277477"}},"author_association":"CONTRIBUTOR"}}
{"actor":{"display_login":"Nekorooni"}}