{"action":"closed","issue":{"url":"https://api.github.com/repos/code-for-nashville/brigade-pulse/issues/55","labels_url":"https://api.github.com/repos/code-for-nashville/brigade-pulse/issues/55/labels{/name}","comments_url":"https://api.github.com/repos/code-for-nashville/brigade-pulse/issues/55/comments","events_url":"https://api.github.com/repos/code-for-nashville/brigade-pulse/issues/55/events","html_url":"https://github.com/code-for-nashville/brigade-pulse/issues/55","id":99836366,"number":55,"title":"Create an ORM model to represent a time series snapshot of a Repository","user":{"login":"zachmccormick","id":339105,"avatar_url":"https://avatars.githubusercontent.com/u/339105?v=3","gravatar_id":"","url":"https://api.github.com/users/zachmccormick","html_url":"https://github.com/zachmccormick","followers_url":"https://api.github.com/users/zachmccormick/followers","following_url":"https://api.github.com/users/zachmccormick/following{/other_user}","gists_url":"https://api.github.com/users/zachmccormick/gists{/gist_id}","starred_url":"https://api.github.com/users/zachmccormick/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/zachmccormick/subscriptions","organizations_url":"https://api.github.com/users/zachmccormick/orgs","repos_url":"https://api.github.com/users/zachmccormick/repos","events_url":"https://api.github.com/users/zachmccormick/events{/privacy}","received_events_url":"https://api.github.com/users/zachmccormick/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/code-for-nashville/brigade-pulse/labels/SQL/ORM","name":"SQL/ORM","color":"fad8c7"}],"state":"closed","locked":false,"assignee":null,"milestone":{"url":"https://api.github.com/repos/code-for-nashville/brigade-pulse/milestones/2","html_url":"https://github.com/code-for-nashville/brigade-pulse/milestones/Brigade%20Pulse%20v0.9","labels_url":"https://api.github.com/repos/code-for-nashville/brigade-pulse/milestones/2/labels","id":1246738,"number":2,"title":"Brigade Pulse v0.9","description":"A user can view brigades on a map and click on an icon for a particular brigade to go to a stats page for that brigade.\r\n\r\nA user can view brigades in a list, and can click on a row for a particular brigade to go to a stats page for that brigade.\r\n\r\nA user can visit the stats page for a brigade and see:\r\n- Number of meetups per day/week/month (line graph)\r\n- Size of meetup group per day/week/month (line graph)\r\n- Number of commits per day/week/month to all organization repos (line graph)\r\n- Number of issues opened per day/week/month for all organization repos (line graph)\r\n- Number of issues closed per day/week/month for all organization repos (line graph)\r\n- Current language distribution for all organization repos by bytes/LoC (bar graph)\r\n- Current LoC in HEAD of master branch by contributor for all organization repos (bar graph)\r\n- List of repos/projects for the brigade\r\n\r\nA user can can click on a repo/project for a brigade to go to a stats page for that particular project/repo.\r\n\r\nA user can visit the stats page for a project/repo and see:\r\n- Number of commits per day/week/month to the project/repo (line graph)\r\n- Number of issues opened per day/week/month for the project/repo (line graph)\r\n- Number of issues closed per day/week/month for the project/repo (line graph)\r\n- Current language distribution for the project/repo by bytes/LoC (bar graph)\r\n- Current LoC in HEAD of master branch by contributor for the project/repo (bar graph)","creator":{"login":"zachmccormick","id":339105,"avatar_url":"https://avatars.githubusercontent.com/u/339105?v=3","gravatar_id":"","url":"https://api.github.com/users/zachmccormick","html_url":"https://github.com/zachmccormick","followers_url":"https://api.github.com/users/zachmccormick/followers","following_url":"https://api.github.com/users/zachmccormick/following{/other_user}","gists_url":"https://api.github.com/users/zachmccormick/gists{/gist_id}","starred_url":"https://api.github.com/users/zachmccormick/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/zachmccormick/subscriptions","organizations_url":"https://api.github.com/users/zachmccormick/orgs","repos_url":"https://api.github.com/users/zachmccormick/repos","events_url":"https://api.github.com/users/zachmccormick/events{/privacy}","received_events_url":"https://api.github.com/users/zachmccormick/received_events","type":"User","site_admin":false},"open_issues":10,"closed_issues":5,"state":"open","created_at":"2015-08-08T21:16:50Z","updated_at":"2015-08-22T02:27:04Z","due_on":"2015-09-06T05:00:00Z","closed_at":null},"comments":0,"created_at":"2015-08-08T21:52:46Z","updated_at":"2015-08-22T02:27:04Z","closed_at":"2015-08-22T02:27:04Z","body":"In Python, we'll need an ORM model to represent a time series snapshot of a Repository. Time series snapshots are objects created/rows inserted in the database that represent the state of an object at a given time.\r\n\r\nIn this case, we want to know all quantitative metrics of a Repository, such as the total number of commits, total number of committers, total lines of code, etc.\r\n\r\nWe likely want to have a similar abstraction model as is described in the issue regarding the ORM model for Repositories.  GitHub Git Repositories have significantly more information than Git Repositories alone do, so it would be best to use inheritance and subclassing to address that concern."}}