{"action":"created","comment":{"url":"https://api.github.com/repos/CodingDojoDallas/python-nov-2016/pulls/comments/87698712","pull_request_review_id":8303147,"id":87698712,"diff_hunk":"@@ -0,0 +1,38 @@\n+from flask import Flask, request, redirect, render_template, session, flash\n+from mysqlconnection import MySQLConnector\n+import re\n+app = Flask(__name__)\n+mysql = MySQLConnector(app,'email')\n+EMAIL_REGEX = re.compile(r'^[a-zA-Z0-9.+_-]+@[a-zA-Z0-9._-]+\\.[a-zA-Z]+$')\n+app.secret_key = 'KeepItSecretKeepItSafe'\n+\n+@app.route('/')\n+def index():\n+    query = \"SELECT * FROM email\"                           \n+    email = mysql.query_db(query)\n+\n+    return render_template('index.html', all_email='email')","path":"Danyal_Khan/flask_mysql_projs/emailvalidation/server.py","position":14,"original_position":14,"commit_id":"700577fa6f1db0ef43a0d4f62cff9870d3b5f603","original_commit_id":"700577fa6f1db0ef43a0d4f62cff9870d3b5f603","user":{"login":"chrisulanowicz","id":18199508,"avatar_url":"https://avatars.githubusercontent.com/u/18199508?v=3","gravatar_id":"","url":"https://api.github.com/users/chrisulanowicz","html_url":"https://github.com/chrisulanowicz","followers_url":"https://api.github.com/users/chrisulanowicz/followers","following_url":"https://api.github.com/users/chrisulanowicz/following{/other_user}","gists_url":"https://api.github.com/users/chrisulanowicz/gists{/gist_id}","starred_url":"https://api.github.com/users/chrisulanowicz/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/chrisulanowicz/subscriptions","organizations_url":"https://api.github.com/users/chrisulanowicz/orgs","repos_url":"https://api.github.com/users/chrisulanowicz/repos","events_url":"https://api.github.com/users/chrisulanowicz/events{/privacy}","received_events_url":"https://api.github.com/users/chrisulanowicz/received_events","type":"User","site_admin":false},"body":"since you don't actually display any email data on your index.html, there's no need to do a query here or pass any data to it","created_at":"2016-11-12T19:29:35Z","updated_at":"2016-11-12T19:29:35Z","html_url":"https://github.com/CodingDojoDallas/python-nov-2016/pull/27#discussion_r87698712","pull_request_url":"https://api.github.com/repos/CodingDojoDallas/python-nov-2016/pulls/27","_links":{"self":{"href":"https://api.github.com/repos/CodingDojoDallas/python-nov-2016/pulls/comments/87698712"},"html":{"href":"https://github.com/CodingDojoDallas/python-nov-2016/pull/27#discussion_r87698712"},"pull_request":{"href":"https://api.github.com/repos/CodingDojoDallas/python-nov-2016/pulls/27"}}},"pull_request":{"url":"https://api.github.com/repos/CodingDojoDallas/python-nov-2016/pulls/27","id":92352715,"html_url":"https://github.com/CodingDojoDallas/python-nov-2016/pull/27","diff_url":"https://github.com/CodingDojoDallas/python-nov-2016/pull/27.diff","patch_url":"https://github.com/CodingDojoDallas/python-nov-2016/pull/27.patch","issue_url":"https://api.github.com/repos/CodingDojoDallas/python-nov-2016/issues/27","number":27,"state":"open","locked":false,"title":"first sets of assingments","user":{"login":"lodeddie","id":23039498,"avatar_url":"https://avatars.githubusercontent.com/u/23039498?v=3","gravatar_id":"","url":"https://api.github.com/users/lodeddie","html_url":"https://github.com/lodeddie","followers_url":"https://api.github.com/users/lodeddie/followers","following_url":"https://api.github.com/users/lodeddie/following{/other_user}","gists_url":"https://api.github.com/users/lodeddie/gists{/gist_id}","starred_url":"https://api.github.com/users/lodeddie/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lodeddie/subscriptions","organizations_url":"https://api.github.com/users/lodeddie/orgs","repos_url":"https://api.github.com/users/lodeddie/repos","events_url":"https://api.github.com/users/lodeddie/events{/privacy}","received_events_url":"https://api.github.com/users/lodeddie/received_events","type":"User","site_admin":false},"body":"","created_at":"2016-11-04T14:45:24Z","updated_at":"2016-11-12T19:29:35Z","closed_at":null,"merged_at":null,"merge_commit_sha":"6c3823a7c023b7641c75f5c693a1b0e0fddb7141","assignee":null,"assignees":[],"milestone":null,"commits_url":"https://api.github.com/repos/CodingDojoDallas/python-nov-2016/pulls/27/commits","review_comments_url":"https://api.github.com/repos/CodingDojoDallas/python-nov-2016/pulls/27/comments","review_comment_url":"https://api.github.com/repos/CodingDojoDallas/python-nov-2016/pulls/comments{/number}","comments_url":"https://api.github.com/repos/CodingDojoDallas/python-nov-2016/issues/27/comments","statuses_url":"https://api.github.com/repos/CodingDojoDallas/python-nov-2016/statuses/700577fa6f1db0ef43a0d4f62cff9870d3b5f603","head":{"label":"lodeddie:danyal_9.41_nov.4.2016","ref":"danyal_9.41_nov.4.2016","sha":"700577fa6f1db0ef43a0d4f62cff9870d3b5f603","user":{"login":"lodeddie","id":23039498,"avatar_url":"https://avatars.githubusercontent.com/u/23039498?v=3","gravatar_id":"","url":"https://api.github.com/users/lodeddie","html_url":"https://github.com/lodeddie","followers_url":"https://api.github.com/users/lodeddie/followers","following_url":"https://api.github.com/users/lodeddie/following{/other_user}","gists_url":"https://api.github.com/users/lodeddie/gists{/gist_id}","starred_url":"https://api.github.com/users/lodeddie/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lodeddie/subscriptions","organizations_url":"https://api.github.com/users/lodeddie/orgs","repos_url":"https://api.github.com/users/lodeddie/repos","events_url":"https://api.github.com/users/lodeddie/events{/privacy}","received_events_url":"https://api.github.com/users/lodeddie/received_events","type":"User","site_admin":false},"repo":{"id":72467479,"name":"python-nov-2016","full_name":"lodeddie/python-nov-2016","owner":{"login":"lodeddie","id":23039498,"avatar_url":"https://avatars.githubusercontent.com/u/23039498?v=3","gravatar_id":"","url":"https://api.github.com/users/lodeddie","html_url":"https://github.com/lodeddie","followers_url":"https://api.github.com/users/lodeddie/followers","following_url":"https://api.github.com/users/lodeddie/following{/other_user}","gists_url":"https://api.github.com/users/lodeddie/gists{/gist_id}","starred_url":"https://api.github.com/users/lodeddie/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lodeddie/subscriptions","organizations_url":"https://api.github.com/users/lodeddie/orgs","repos_url":"https://api.github.com/users/lodeddie/repos","events_url":"https://api.github.com/users/lodeddie/events{/privacy}","received_events_url":"https://api.github.com/users/lodeddie/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/lodeddie/python-nov-2016","description":null,"fork":true,"url":"https://api.github.com/repos/lodeddie/python-nov-2016","forks_url":"https://api.github.com/repos/lodeddie/python-nov-2016/forks","keys_url":"https://api.github.com/repos/lodeddie/python-nov-2016/keys{/key_id}","collaborators_url":"https://api.github.com/repos/lodeddie/python-nov-2016/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/lodeddie/python-nov-2016/teams","hooks_url":"https://api.github.com/repos/lodeddie/python-nov-2016/hooks","issue_events_url":"https://api.github.com/repos/lodeddie/python-nov-2016/issues/events{/number}","events_url":"https://api.github.com/repos/lodeddie/python-nov-2016/events","assignees_url":"https://api.github.com/repos/lodeddie/python-nov-2016/assignees{/user}","branches_url":"https://api.github.com/repos/lodeddie/python-nov-2016/branches{/branch}","tags_url":"https://api.github.com/repos/lodeddie/python-nov-2016/tags","blobs_url":"https://api.github.com/repos/lodeddie/python-nov-2016/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/lodeddie/python-nov-2016/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/lodeddie/python-nov-2016/git/refs{/sha}","trees_url":"https://api.github.com/repos/lodeddie/python-nov-2016/git/trees{/sha}","statuses_url":"https://api.github.com/repos/lodeddie/python-nov-2016/statuses/{sha}","languages_url":"https://api.github.com/repos/lodeddie/python-nov-2016/languages","stargazers_url":"https://api.github.com/repos/lodeddie/python-nov-2016/stargazers","contributors_url":"https://api.github.com/repos/lodeddie/python-nov-2016/contributors","subscribers_url":"https://api.github.com/repos/lodeddie/python-nov-2016/subscribers","subscription_url":"https://api.github.com/repos/lodeddie/python-nov-2016/subscription","commits_url":"https://api.github.com/repos/lodeddie/python-nov-2016/commits{/sha}","git_commits_url":"https://api.github.com/repos/lodeddie/python-nov-2016/git/commits{/sha}","comments_url":"https://api.github.com/repos/lodeddie/python-nov-2016/comments{/number}","issue_comment_url":"https://api.github.com/repos/lodeddie/python-nov-2016/issues/comments{/number}","contents_url":"https://api.github.com/repos/lodeddie/python-nov-2016/contents/{+path}","compare_url":"https://api.github.com/repos/lodeddie/python-nov-2016/compare/{base}...{head}","merges_url":"https://api.github.com/repos/lodeddie/python-nov-2016/merges","archive_url":"https://api.github.com/repos/lodeddie/python-nov-2016/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/lodeddie/python-nov-2016/downloads","issues_url":"https://api.github.com/repos/lodeddie/python-nov-2016/issues{/number}","pulls_url":"https://api.github.com/repos/lodeddie/python-nov-2016/pulls{/number}","milestones_url":"https://api.github.com/repos/lodeddie/python-nov-2016/milestones{/number}","notifications_url":"https://api.github.com/repos/lodeddie/python-nov-2016/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/lodeddie/python-nov-2016/labels{/name}","releases_url":"https://api.github.com/repos/lodeddie/python-nov-2016/releases{/id}","deployments_url":"https://api.github.com/repos/lodeddie/python-nov-2016/deployments","created_at":"2016-10-31T18:45:34Z","updated_at":"2016-11-09T19:34:52Z","pushed_at":"2016-11-10T19:26:41Z","git_url":"git://github.com/lodeddie/python-nov-2016.git","ssh_url":"git@github.com:lodeddie/python-nov-2016.git","clone_url":"https://github.com/lodeddie/python-nov-2016.git","svn_url":"https://github.com/lodeddie/python-nov-2016","homepage":null,"size":633,"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":"master"}},"base":{"label":"CodingDojoDallas:master","ref":"master","sha":"32591c38d83dfa635b329c307067ee2e2064719f","user":{"login":"CodingDojoDallas","id":22032006,"avatar_url":"https://avatars.githubusercontent.com/u/22032006?v=3","gravatar_id":"","url":"https://api.github.com/users/CodingDojoDallas","html_url":"https://github.com/CodingDojoDallas","followers_url":"https://api.github.com/users/CodingDojoDallas/followers","following_url":"https://api.github.com/users/CodingDojoDallas/following{/other_user}","gists_url":"https://api.github.com/users/CodingDojoDallas/gists{/gist_id}","starred_url":"https://api.github.com/users/CodingDojoDallas/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/CodingDojoDallas/subscriptions","organizations_url":"https://api.github.com/users/CodingDojoDallas/orgs","repos_url":"https://api.github.com/users/CodingDojoDallas/repos","events_url":"https://api.github.com/users/CodingDojoDallas/events{/privacy}","received_events_url":"https://api.github.com/users/CodingDojoDallas/received_events","type":"Organization","site_admin":false},"repo":{"id":72453587,"name":"python-nov-2016","full_name":"CodingDojoDallas/python-nov-2016","owner":{"login":"CodingDojoDallas","id":22032006,"avatar_url":"https://avatars.githubusercontent.com/u/22032006?v=3","gravatar_id":"","url":"https://api.github.com/users/CodingDojoDallas","html_url":"https://github.com/CodingDojoDallas","followers_url":"https://api.github.com/users/CodingDojoDallas/followers","following_url":"https://api.github.com/users/CodingDojoDallas/following{/other_user}","gists_url":"https://api.github.com/users/CodingDojoDallas/gists{/gist_id}","starred_url":"https://api.github.com/users/CodingDojoDallas/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/CodingDojoDallas/subscriptions","organizations_url":"https://api.github.com/users/CodingDojoDallas/orgs","repos_url":"https://api.github.com/users/CodingDojoDallas/repos","events_url":"https://api.github.com/users/CodingDojoDallas/events{/privacy}","received_events_url":"https://api.github.com/users/CodingDojoDallas/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/CodingDojoDallas/python-nov-2016","description":null,"fork":false,"url":"https://api.github.com/repos/CodingDojoDallas/python-nov-2016","forks_url":"https://api.github.com/repos/CodingDojoDallas/python-nov-2016/forks","keys_url":"https://api.github.com/repos/CodingDojoDallas/python-nov-2016/keys{/key_id}","collaborators_url":"https://api.github.com/repos/CodingDojoDallas/python-nov-2016/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/CodingDojoDallas/python-nov-2016/teams","hooks_url":"https://api.github.com/repos/CodingDojoDallas/python-nov-2016/hooks","issue_events_url":"https://api.github.com/repos/CodingDojoDallas/python-nov-2016/issues/events{/number}","events_url":"https://api.github.com/repos/CodingDojoDallas/python-nov-2016/events","assignees_url":"https://api.github.com/repos/CodingDojoDallas/python-nov-2016/assignees{/user}","branches_url":"https://api.github.com/repos/CodingDojoDallas/python-nov-2016/branches{/branch}","tags_url":"https://api.github.com/repos/CodingDojoDallas/python-nov-2016/tags","blobs_url":"https://api.github.com/repos/CodingDojoDallas/python-nov-2016/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/CodingDojoDallas/python-nov-2016/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/CodingDojoDallas/python-nov-2016/git/refs{/sha}","trees_url":"https://api.github.com/repos/CodingDojoDallas/python-nov-2016/git/trees{/sha}","statuses_url":"https://api.github.com/repos/CodingDojoDallas/python-nov-2016/statuses/{sha}","languages_url":"https://api.github.com/repos/CodingDojoDallas/python-nov-2016/languages","stargazers_url":"https://api.github.com/repos/CodingDojoDallas/python-nov-2016/stargazers","contributors_url":"https://api.github.com/repos/CodingDojoDallas/python-nov-2016/contributors","subscribers_url":"https://api.github.com/repos/CodingDojoDallas/python-nov-2016/subscribers","subscription_url":"https://api.github.com/repos/CodingDojoDallas/python-nov-2016/subscription","commits_url":"https://api.github.com/repos/CodingDojoDallas/python-nov-2016/commits{/sha}","git_commits_url":"https://api.github.com/repos/CodingDojoDallas/python-nov-2016/git/commits{/sha}","comments_url":"https://api.github.com/repos/CodingDojoDallas/python-nov-2016/comments{/number}","issue_comment_url":"https://api.github.com/repos/CodingDojoDallas/python-nov-2016/issues/comments{/number}","contents_url":"https://api.github.com/repos/CodingDojoDallas/python-nov-2016/contents/{+path}","compare_url":"https://api.github.com/repos/CodingDojoDallas/python-nov-2016/compare/{base}...{head}","merges_url":"https://api.github.com/repos/CodingDojoDallas/python-nov-2016/merges","archive_url":"https://api.github.com/repos/CodingDojoDallas/python-nov-2016/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/CodingDojoDallas/python-nov-2016/downloads","issues_url":"https://api.github.com/repos/CodingDojoDallas/python-nov-2016/issues{/number}","pulls_url":"https://api.github.com/repos/CodingDojoDallas/python-nov-2016/pulls{/number}","milestones_url":"https://api.github.com/repos/CodingDojoDallas/python-nov-2016/milestones{/number}","notifications_url":"https://api.github.com/repos/CodingDojoDallas/python-nov-2016/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/CodingDojoDallas/python-nov-2016/labels{/name}","releases_url":"https://api.github.com/repos/CodingDojoDallas/python-nov-2016/releases{/id}","deployments_url":"https://api.github.com/repos/CodingDojoDallas/python-nov-2016/deployments","created_at":"2016-10-31T16:07:05Z","updated_at":"2016-11-03T19:08:45Z","pushed_at":"2016-11-11T22:54:30Z","git_url":"git://github.com/CodingDojoDallas/python-nov-2016.git","ssh_url":"git@github.com:CodingDojoDallas/python-nov-2016.git","clone_url":"https://github.com/CodingDojoDallas/python-nov-2016.git","svn_url":"https://github.com/CodingDojoDallas/python-nov-2016","homepage":null,"size":836,"stargazers_count":0,"watchers_count":0,"language":"Python","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":11,"mirror_url":null,"open_issues_count":5,"forks":11,"open_issues":5,"watchers":0,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/CodingDojoDallas/python-nov-2016/pulls/27"},"html":{"href":"https://github.com/CodingDojoDallas/python-nov-2016/pull/27"},"issue":{"href":"https://api.github.com/repos/CodingDojoDallas/python-nov-2016/issues/27"},"comments":{"href":"https://api.github.com/repos/CodingDojoDallas/python-nov-2016/issues/27/comments"},"review_comments":{"href":"https://api.github.com/repos/CodingDojoDallas/python-nov-2016/pulls/27/comments"},"review_comment":{"href":"https://api.github.com/repos/CodingDojoDallas/python-nov-2016/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/CodingDojoDallas/python-nov-2016/pulls/27/commits"},"statuses":{"href":"https://api.github.com/repos/CodingDojoDallas/python-nov-2016/statuses/700577fa6f1db0ef43a0d4f62cff9870d3b5f603"}}}}
{"actor":{"display_login":"chrisulanowicz"}}