{"action":"created","comment":{"url":"https://api.github.com/repos/pennlabs/pennathletics/pulls/comments/44841629","id":44841629,"diff_hunk":"@@ -0,0 +1,153 @@\n+import requests\n+from bs4 import BeautifulSoup\n+import models\n+import re\n+\n+SPORTS = {\n+    'M_Baseball' : {\n+        'SPID'  : 548,\n+        'SPSID' : 8834\n+    },\n+    'M_Basketball' : {\n+        'SPID'  : 539,\n+        'SPSID' : 8627\n+    },\n+    'M_Track_Cross' : {\n+        'SPID'  : 542,\n+        'SPSID' : 8699\n+    },\n+    'M_Fencing' : {\n+        'SPID'  : 607,\n+        'SPSID' : 10603\n+    },\n+    'M_Football' : {\n+        'SPID'  : 537,\n+        'SPSID' : 8571\n+    },\n+    'M_Sprint_Football' : {\n+        'SPID'  : 612,\n+        'SPSID' : 10618\n+    },\n+    'M_Golf' : {\n+        'SPID'  : 550,\n+        'SPSID' : 8895\n+    },\n+    'M_Lacrosse' : {\n+        'SPID'  : 544,\n+        'SPSID' : 8745\n+    },\n+    'M_Heavy_Rowing' : {\n+        'SPID'  : 610,\n+        'SPSID' : 10659\n+    },\n+    'M_Light_Rowing' : {\n+        'SPID'  : 613,\n+        'SPSID' : 10647\n+    },\n+    'M_Soccer' : {\n+        'SPID'  : 604,\n+        'SPSID' : 10672\n+    },\n+    'M_Squash' : {\n+        'SPID'  : 605,\n+        'SPSID' : 10685\n+    },\n+    'M_Swimming' : {\n+        'SPID'  : 611,\n+        'SPSID' : 10698\n+    },\n+    'M_Tennis' : {\n+        'SPID'  : 552,\n+        'SPSID' : 8927\n+    },\n+    'M_Wrestling' : {\n+        'SPID'  : 543,\n+        'SPSID' : 8720\n+    },\n+    'W_Basketball' : {\n+        'SPID'  : 540,\n+        'SPSID' : 8650\n+    },\n+    'W_Track_Cross' : {\n+        'SPID'  : 558,\n+        'SPSID' : 10758\n+    },\n+    'W_Fencing' : {\n+        'SPID'  : 608,\n+        'SPSID' : 10715\n+    },\n+    'W_Hockey' : {\n+        'SPID'  : 609,\n+        'SPSID' : 10583\n+    },\n+    'W_Golf' : {\n+        'SPID'  : 551,\n+        'SPSID' : 8903\n+    },\n+    'W_Gymnastics' : {\n+        'SPID'  : 545,\n+        'SPSID' : 8763\n+    },\n+    'W_Lacrosse' : {\n+        'SPID'  : 554,\n+        'SPSID' : 8966\n+    },\n+    'W_Rowing' : {\n+        'SPID'  : 555,\n+        'SPSID' : 8993\n+    },\n+    'W_Soccer' : {\n+        'SPID'  : 541,\n+        'SPSID' : 8673\n+    },\n+    'W_Softball' : {\n+        'SPID'  : 549,\n+        'SPSID' : 8856\n+    },\n+    'W_Squash' : {\n+        'SPID'  : 606,\n+        'SPSID' : 10741\n+    },\n+    'W_Swimming' : {\n+        'SPID'  : 546,\n+        'SPSID' : 8790\n+    },\n+    'W_Tennis' : {\n+        'SPID'  : 553,\n+        'SPSID' : 8943\n+    },\n+    'W_Volleyball' : {\n+        'SPID'  : 538,\n+        'SPSID' : 8606\n+    }\n+}\n+\n+\n+ROSTER_URL = 'http://www.pennathletics.com/SportSelect.dbml?&DB_OEM_ID=1700&SPID={}&SPSID={}&Q_SEASON={}'\n+\n+# requests.get(\"http://www.pennathletics.com/SportSelect.dbml?&DB_OEM_ID=1700&SPID=540&SPSID=8650\")\n+\n+def scrapeRoster(sport, year):","path":"pennathletics/scraper.py","position":130,"original_position":130,"commit_id":"c09556882f56f0b96e344276535d6965bb8854ca","original_commit_id":"c09556882f56f0b96e344276535d6965bb8854ca","user":{"login":"afischer","id":5422397,"avatar_url":"https://avatars.githubusercontent.com/u/5422397?v=3","gravatar_id":"","url":"https://api.github.com/users/afischer","html_url":"https://github.com/afischer","followers_url":"https://api.github.com/users/afischer/followers","following_url":"https://api.github.com/users/afischer/following{/other_user}","gists_url":"https://api.github.com/users/afischer/gists{/gist_id}","starred_url":"https://api.github.com/users/afischer/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/afischer/subscriptions","organizations_url":"https://api.github.com/users/afischer/orgs","repos_url":"https://api.github.com/users/afischer/repos","events_url":"https://api.github.com/users/afischer/events{/privacy}","received_events_url":"https://api.github.com/users/afischer/received_events","type":"User","site_admin":false},"body":"gurl.","created_at":"2015-11-13T22:25:52Z","updated_at":"2015-11-13T22:25:52Z","html_url":"https://github.com/pennlabs/pennathletics/pull/3#discussion_r44841629","pull_request_url":"https://api.github.com/repos/pennlabs/pennathletics/pulls/3","_links":{"self":{"href":"https://api.github.com/repos/pennlabs/pennathletics/pulls/comments/44841629"},"html":{"href":"https://github.com/pennlabs/pennathletics/pull/3#discussion_r44841629"},"pull_request":{"href":"https://api.github.com/repos/pennlabs/pennathletics/pulls/3"}}},"pull_request":{"url":"https://api.github.com/repos/pennlabs/pennathletics/pulls/3","id":50699230,"html_url":"https://github.com/pennlabs/pennathletics/pull/3","diff_url":"https://github.com/pennlabs/pennathletics/pull/3.diff","patch_url":"https://github.com/pennlabs/pennathletics/pull/3.patch","issue_url":"https://api.github.com/repos/pennlabs/pennathletics/issues/3","number":3,"state":"open","locked":false,"title":"API Happenings","user":{"login":"afischer","id":5422397,"avatar_url":"https://avatars.githubusercontent.com/u/5422397?v=3","gravatar_id":"","url":"https://api.github.com/users/afischer","html_url":"https://github.com/afischer","followers_url":"https://api.github.com/users/afischer/followers","following_url":"https://api.github.com/users/afischer/following{/other_user}","gists_url":"https://api.github.com/users/afischer/gists{/gist_id}","starred_url":"https://api.github.com/users/afischer/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/afischer/subscriptions","organizations_url":"https://api.github.com/users/afischer/orgs","repos_url":"https://api.github.com/users/afischer/repos","events_url":"https://api.github.com/users/afischer/events{/privacy}","received_events_url":"https://api.github.com/users/afischer/received_events","type":"User","site_admin":false},"body":"*It's the start of something new...*\r\n\r\nWeb scraping SDK for an athletics API. Implemented the \"athlete,\" @adamdom is working on games and schedules.\r\n\r\nStill todo: tests, many other things.","created_at":"2015-11-13T22:17:25Z","updated_at":"2015-11-13T22:25:52Z","closed_at":null,"merged_at":null,"merge_commit_sha":"413ed66d2166ea2f4f155cfdc039a43787faba71","assignee":null,"milestone":null,"commits_url":"https://api.github.com/repos/pennlabs/pennathletics/pulls/3/commits","review_comments_url":"https://api.github.com/repos/pennlabs/pennathletics/pulls/3/comments","review_comment_url":"https://api.github.com/repos/pennlabs/pennathletics/pulls/comments{/number}","comments_url":"https://api.github.com/repos/pennlabs/pennathletics/issues/3/comments","statuses_url":"https://api.github.com/repos/pennlabs/pennathletics/statuses/c09556882f56f0b96e344276535d6965bb8854ca","head":{"label":"pennlabs:af-api","ref":"af-api","sha":"c09556882f56f0b96e344276535d6965bb8854ca","user":{"login":"pennlabs","id":1159028,"avatar_url":"https://avatars.githubusercontent.com/u/1159028?v=3","gravatar_id":"","url":"https://api.github.com/users/pennlabs","html_url":"https://github.com/pennlabs","followers_url":"https://api.github.com/users/pennlabs/followers","following_url":"https://api.github.com/users/pennlabs/following{/other_user}","gists_url":"https://api.github.com/users/pennlabs/gists{/gist_id}","starred_url":"https://api.github.com/users/pennlabs/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pennlabs/subscriptions","organizations_url":"https://api.github.com/users/pennlabs/orgs","repos_url":"https://api.github.com/users/pennlabs/repos","events_url":"https://api.github.com/users/pennlabs/events{/privacy}","received_events_url":"https://api.github.com/users/pennlabs/received_events","type":"Organization","site_admin":false},"repo":{"id":40395499,"name":"pennathletics","full_name":"pennlabs/pennathletics","owner":{"login":"pennlabs","id":1159028,"avatar_url":"https://avatars.githubusercontent.com/u/1159028?v=3","gravatar_id":"","url":"https://api.github.com/users/pennlabs","html_url":"https://github.com/pennlabs","followers_url":"https://api.github.com/users/pennlabs/followers","following_url":"https://api.github.com/users/pennlabs/following{/other_user}","gists_url":"https://api.github.com/users/pennlabs/gists{/gist_id}","starred_url":"https://api.github.com/users/pennlabs/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pennlabs/subscriptions","organizations_url":"https://api.github.com/users/pennlabs/orgs","repos_url":"https://api.github.com/users/pennlabs/repos","events_url":"https://api.github.com/users/pennlabs/events{/privacy}","received_events_url":"https://api.github.com/users/pennlabs/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/pennlabs/pennathletics","description":"API for Penn Athletics","fork":false,"url":"https://api.github.com/repos/pennlabs/pennathletics","forks_url":"https://api.github.com/repos/pennlabs/pennathletics/forks","keys_url":"https://api.github.com/repos/pennlabs/pennathletics/keys{/key_id}","collaborators_url":"https://api.github.com/repos/pennlabs/pennathletics/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/pennlabs/pennathletics/teams","hooks_url":"https://api.github.com/repos/pennlabs/pennathletics/hooks","issue_events_url":"https://api.github.com/repos/pennlabs/pennathletics/issues/events{/number}","events_url":"https://api.github.com/repos/pennlabs/pennathletics/events","assignees_url":"https://api.github.com/repos/pennlabs/pennathletics/assignees{/user}","branches_url":"https://api.github.com/repos/pennlabs/pennathletics/branches{/branch}","tags_url":"https://api.github.com/repos/pennlabs/pennathletics/tags","blobs_url":"https://api.github.com/repos/pennlabs/pennathletics/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/pennlabs/pennathletics/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/pennlabs/pennathletics/git/refs{/sha}","trees_url":"https://api.github.com/repos/pennlabs/pennathletics/git/trees{/sha}","statuses_url":"https://api.github.com/repos/pennlabs/pennathletics/statuses/{sha}","languages_url":"https://api.github.com/repos/pennlabs/pennathletics/languages","stargazers_url":"https://api.github.com/repos/pennlabs/pennathletics/stargazers","contributors_url":"https://api.github.com/repos/pennlabs/pennathletics/contributors","subscribers_url":"https://api.github.com/repos/pennlabs/pennathletics/subscribers","subscription_url":"https://api.github.com/repos/pennlabs/pennathletics/subscription","commits_url":"https://api.github.com/repos/pennlabs/pennathletics/commits{/sha}","git_commits_url":"https://api.github.com/repos/pennlabs/pennathletics/git/commits{/sha}","comments_url":"https://api.github.com/repos/pennlabs/pennathletics/comments{/number}","issue_comment_url":"https://api.github.com/repos/pennlabs/pennathletics/issues/comments{/number}","contents_url":"https://api.github.com/repos/pennlabs/pennathletics/contents/{+path}","compare_url":"https://api.github.com/repos/pennlabs/pennathletics/compare/{base}...{head}","merges_url":"https://api.github.com/repos/pennlabs/pennathletics/merges","archive_url":"https://api.github.com/repos/pennlabs/pennathletics/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/pennlabs/pennathletics/downloads","issues_url":"https://api.github.com/repos/pennlabs/pennathletics/issues{/number}","pulls_url":"https://api.github.com/repos/pennlabs/pennathletics/pulls{/number}","milestones_url":"https://api.github.com/repos/pennlabs/pennathletics/milestones{/number}","notifications_url":"https://api.github.com/repos/pennlabs/pennathletics/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/pennlabs/pennathletics/labels{/name}","releases_url":"https://api.github.com/repos/pennlabs/pennathletics/releases{/id}","created_at":"2015-08-08T07:41:42Z","updated_at":"2015-08-08T08:08:44Z","pushed_at":"2015-11-13T22:17:26Z","git_url":"git://github.com/pennlabs/pennathletics.git","ssh_url":"git@github.com:pennlabs/pennathletics.git","clone_url":"https://github.com/pennlabs/pennathletics.git","svn_url":"https://github.com/pennlabs/pennathletics","homepage":null,"size":128,"stargazers_count":0,"watchers_count":0,"language":"Python","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":0,"mirror_url":null,"open_issues_count":2,"forks":0,"open_issues":2,"watchers":0,"default_branch":"master"}},"base":{"label":"pennlabs:master","ref":"master","sha":"606c94e5ccdd3310dbc450215a3ef140819a4623","user":{"login":"pennlabs","id":1159028,"avatar_url":"https://avatars.githubusercontent.com/u/1159028?v=3","gravatar_id":"","url":"https://api.github.com/users/pennlabs","html_url":"https://github.com/pennlabs","followers_url":"https://api.github.com/users/pennlabs/followers","following_url":"https://api.github.com/users/pennlabs/following{/other_user}","gists_url":"https://api.github.com/users/pennlabs/gists{/gist_id}","starred_url":"https://api.github.com/users/pennlabs/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pennlabs/subscriptions","organizations_url":"https://api.github.com/users/pennlabs/orgs","repos_url":"https://api.github.com/users/pennlabs/repos","events_url":"https://api.github.com/users/pennlabs/events{/privacy}","received_events_url":"https://api.github.com/users/pennlabs/received_events","type":"Organization","site_admin":false},"repo":{"id":40395499,"name":"pennathletics","full_name":"pennlabs/pennathletics","owner":{"login":"pennlabs","id":1159028,"avatar_url":"https://avatars.githubusercontent.com/u/1159028?v=3","gravatar_id":"","url":"https://api.github.com/users/pennlabs","html_url":"https://github.com/pennlabs","followers_url":"https://api.github.com/users/pennlabs/followers","following_url":"https://api.github.com/users/pennlabs/following{/other_user}","gists_url":"https://api.github.com/users/pennlabs/gists{/gist_id}","starred_url":"https://api.github.com/users/pennlabs/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pennlabs/subscriptions","organizations_url":"https://api.github.com/users/pennlabs/orgs","repos_url":"https://api.github.com/users/pennlabs/repos","events_url":"https://api.github.com/users/pennlabs/events{/privacy}","received_events_url":"https://api.github.com/users/pennlabs/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/pennlabs/pennathletics","description":"API for Penn Athletics","fork":false,"url":"https://api.github.com/repos/pennlabs/pennathletics","forks_url":"https://api.github.com/repos/pennlabs/pennathletics/forks","keys_url":"https://api.github.com/repos/pennlabs/pennathletics/keys{/key_id}","collaborators_url":"https://api.github.com/repos/pennlabs/pennathletics/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/pennlabs/pennathletics/teams","hooks_url":"https://api.github.com/repos/pennlabs/pennathletics/hooks","issue_events_url":"https://api.github.com/repos/pennlabs/pennathletics/issues/events{/number}","events_url":"https://api.github.com/repos/pennlabs/pennathletics/events","assignees_url":"https://api.github.com/repos/pennlabs/pennathletics/assignees{/user}","branches_url":"https://api.github.com/repos/pennlabs/pennathletics/branches{/branch}","tags_url":"https://api.github.com/repos/pennlabs/pennathletics/tags","blobs_url":"https://api.github.com/repos/pennlabs/pennathletics/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/pennlabs/pennathletics/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/pennlabs/pennathletics/git/refs{/sha}","trees_url":"https://api.github.com/repos/pennlabs/pennathletics/git/trees{/sha}","statuses_url":"https://api.github.com/repos/pennlabs/pennathletics/statuses/{sha}","languages_url":"https://api.github.com/repos/pennlabs/pennathletics/languages","stargazers_url":"https://api.github.com/repos/pennlabs/pennathletics/stargazers","contributors_url":"https://api.github.com/repos/pennlabs/pennathletics/contributors","subscribers_url":"https://api.github.com/repos/pennlabs/pennathletics/subscribers","subscription_url":"https://api.github.com/repos/pennlabs/pennathletics/subscription","commits_url":"https://api.github.com/repos/pennlabs/pennathletics/commits{/sha}","git_commits_url":"https://api.github.com/repos/pennlabs/pennathletics/git/commits{/sha}","comments_url":"https://api.github.com/repos/pennlabs/pennathletics/comments{/number}","issue_comment_url":"https://api.github.com/repos/pennlabs/pennathletics/issues/comments{/number}","contents_url":"https://api.github.com/repos/pennlabs/pennathletics/contents/{+path}","compare_url":"https://api.github.com/repos/pennlabs/pennathletics/compare/{base}...{head}","merges_url":"https://api.github.com/repos/pennlabs/pennathletics/merges","archive_url":"https://api.github.com/repos/pennlabs/pennathletics/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/pennlabs/pennathletics/downloads","issues_url":"https://api.github.com/repos/pennlabs/pennathletics/issues{/number}","pulls_url":"https://api.github.com/repos/pennlabs/pennathletics/pulls{/number}","milestones_url":"https://api.github.com/repos/pennlabs/pennathletics/milestones{/number}","notifications_url":"https://api.github.com/repos/pennlabs/pennathletics/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/pennlabs/pennathletics/labels{/name}","releases_url":"https://api.github.com/repos/pennlabs/pennathletics/releases{/id}","created_at":"2015-08-08T07:41:42Z","updated_at":"2015-08-08T08:08:44Z","pushed_at":"2015-11-13T22:17:26Z","git_url":"git://github.com/pennlabs/pennathletics.git","ssh_url":"git@github.com:pennlabs/pennathletics.git","clone_url":"https://github.com/pennlabs/pennathletics.git","svn_url":"https://github.com/pennlabs/pennathletics","homepage":null,"size":128,"stargazers_count":0,"watchers_count":0,"language":"Python","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":0,"mirror_url":null,"open_issues_count":2,"forks":0,"open_issues":2,"watchers":0,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/pennlabs/pennathletics/pulls/3"},"html":{"href":"https://github.com/pennlabs/pennathletics/pull/3"},"issue":{"href":"https://api.github.com/repos/pennlabs/pennathletics/issues/3"},"comments":{"href":"https://api.github.com/repos/pennlabs/pennathletics/issues/3/comments"},"review_comments":{"href":"https://api.github.com/repos/pennlabs/pennathletics/pulls/3/comments"},"review_comment":{"href":"https://api.github.com/repos/pennlabs/pennathletics/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/pennlabs/pennathletics/pulls/3/commits"},"statuses":{"href":"https://api.github.com/repos/pennlabs/pennathletics/statuses/c09556882f56f0b96e344276535d6965bb8854ca"}}}}