{"action":"created","comment":{"url":"https://api.github.com/repos/EdinburghGenomics/Reporting-App/pulls/comments/279385432","pull_request_review_id":231666572,"id":279385432,"node_id":"MDI0OlB1bGxSZXF1ZXN0UmV2aWV3Q29tbWVudDI3OTM4NTQzMg==","diff_hunk":"@@ -2,15 +2,17 @@\n from egcg_core.clarity import sanitize_user_id\n from flask import request\n from config import project_status as status_cfg\n-from datetime import datetime, timedelta\n from rest_api.common import retrieve_args\n from rest_api.limsdb import queries\n-from rest_api.limsdb.queries.data_models import ProjectInfo, SampleInfo, Container, Run, Sample, Project\n+from rest_api.limsdb.queries import data_models\n+from string import ascii_uppercase\n+\n+y_coords = ascii_uppercase[:8]","path":"rest_api/limsdb/queries/factories.py","position":11,"original_position":11,"commit_id":"fe78b82f2b608d5c2370f31ef2b6dbe3089cf9ac","original_commit_id":"fe78b82f2b608d5c2370f31ef2b6dbe3089cf9ac","user":{"login":"lukbut","id":26323272,"node_id":"MDQ6VXNlcjI2MzIzMjcy","avatar_url":"https://avatars3.githubusercontent.com/u/26323272?v=4","gravatar_id":"","url":"https://api.github.com/users/lukbut","html_url":"https://github.com/lukbut","followers_url":"https://api.github.com/users/lukbut/followers","following_url":"https://api.github.com/users/lukbut/following{/other_user}","gists_url":"https://api.github.com/users/lukbut/gists{/gist_id}","starred_url":"https://api.github.com/users/lukbut/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lukbut/subscriptions","organizations_url":"https://api.github.com/users/lukbut/orgs","repos_url":"https://api.github.com/users/lukbut/repos","events_url":"https://api.github.com/users/lukbut/events{/privacy}","received_events_url":"https://api.github.com/users/lukbut/received_events","type":"User","site_admin":false},"body":"Out of curiosity, why is this clipped to 8 characters?","created_at":"2019-04-29T14:23:07Z","updated_at":"2019-04-29T14:50:53Z","html_url":"https://github.com/EdinburghGenomics/Reporting-App/pull/231#discussion_r279385432","pull_request_url":"https://api.github.com/repos/EdinburghGenomics/Reporting-App/pulls/231","author_association":"MEMBER","_links":{"self":{"href":"https://api.github.com/repos/EdinburghGenomics/Reporting-App/pulls/comments/279385432"},"html":{"href":"https://github.com/EdinburghGenomics/Reporting-App/pull/231#discussion_r279385432"},"pull_request":{"href":"https://api.github.com/repos/EdinburghGenomics/Reporting-App/pulls/231"}}},"pull_request":{"url":"https://api.github.com/repos/EdinburghGenomics/Reporting-App/pulls/231","id":273170536,"node_id":"MDExOlB1bGxSZXF1ZXN0MjczMTcwNTM2","html_url":"https://github.com/EdinburghGenomics/Reporting-App/pull/231","diff_url":"https://github.com/EdinburghGenomics/Reporting-App/pull/231.diff","patch_url":"https://github.com/EdinburghGenomics/Reporting-App/pull/231.patch","issue_url":"https://api.github.com/repos/EdinburghGenomics/Reporting-App/issues/231","number":231,"state":"open","locked":false,"title":"Library prep graphing","user":{"login":"mwhamgenomics","id":12951686,"node_id":"MDQ6VXNlcjEyOTUxNjg2","avatar_url":"https://avatars2.githubusercontent.com/u/12951686?v=4","gravatar_id":"","url":"https://api.github.com/users/mwhamgenomics","html_url":"https://github.com/mwhamgenomics","followers_url":"https://api.github.com/users/mwhamgenomics/followers","following_url":"https://api.github.com/users/mwhamgenomics/following{/other_user}","gists_url":"https://api.github.com/users/mwhamgenomics/gists{/gist_id}","starred_url":"https://api.github.com/users/mwhamgenomics/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mwhamgenomics/subscriptions","organizations_url":"https://api.github.com/users/mwhamgenomics/orgs","repos_url":"https://api.github.com/users/mwhamgenomics/repos","events_url":"https://api.github.com/users/mwhamgenomics/events{/privacy}","received_events_url":"https://api.github.com/users/mwhamgenomics/received_events","type":"User","site_admin":false},"body":"Adds library views - closes #222.\r\n\r\n- `/libraries`\r\n    - datatable of all libraries prepared\r\n    - library name (links to libraries/<library_name>)\r\n    - number of times prepared - at the moment, we can only view the most recent one\r\n    - date last prepared\r\n- `/libraries/<library>`\r\n    - heatmap of all samples in the library plate, plotted with [Highcharts](https://www.highcharts.com/demo/heatmap)\r\n    - x/y axes reflect the sample's position in the plate\r\n    - colour axis is chosen from a dropdown of reporting app QC and UDFs\r\n- API endpoint `lims/library_info`\r\n    - queries Lims database and extracts artifact UDFs for each library's recent prep\r\n        - extracting only numerical UDFs for now\r\n    - can filter by library ID or date range","created_at":"2019-04-24T14:56:34Z","updated_at":"2019-04-29T14:50:52Z","closed_at":null,"merged_at":null,"merge_commit_sha":"146d266ca16c90e10b13ea4c2d2a2ce1460e682d","assignee":null,"assignees":[],"requested_reviewers":[{"login":"tcezard","id":650891,"node_id":"MDQ6VXNlcjY1MDg5MQ==","avatar_url":"https://avatars0.githubusercontent.com/u/650891?v=4","gravatar_id":"","url":"https://api.github.com/users/tcezard","html_url":"https://github.com/tcezard","followers_url":"https://api.github.com/users/tcezard/followers","following_url":"https://api.github.com/users/tcezard/following{/other_user}","gists_url":"https://api.github.com/users/tcezard/gists{/gist_id}","starred_url":"https://api.github.com/users/tcezard/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tcezard/subscriptions","organizations_url":"https://api.github.com/users/tcezard/orgs","repos_url":"https://api.github.com/users/tcezard/repos","events_url":"https://api.github.com/users/tcezard/events{/privacy}","received_events_url":"https://api.github.com/users/tcezard/received_events","type":"User","site_admin":false}],"requested_teams":[],"labels":[{"id":291146037,"node_id":"MDU6TGFiZWwyOTExNDYwMzc=","url":"https://api.github.com/repos/EdinburghGenomics/Reporting-App/labels/new%20feature","name":"new feature","color":"bfdadc","default":false}],"milestone":null,"commits_url":"https://api.github.com/repos/EdinburghGenomics/Reporting-App/pulls/231/commits","review_comments_url":"https://api.github.com/repos/EdinburghGenomics/Reporting-App/pulls/231/comments","review_comment_url":"https://api.github.com/repos/EdinburghGenomics/Reporting-App/pulls/comments{/number}","comments_url":"https://api.github.com/repos/EdinburghGenomics/Reporting-App/issues/231/comments","statuses_url":"https://api.github.com/repos/EdinburghGenomics/Reporting-App/statuses/fe78b82f2b608d5c2370f31ef2b6dbe3089cf9ac","head":{"label":"EdinburghGenomics:library_prep_graphing","ref":"library_prep_graphing","sha":"fe78b82f2b608d5c2370f31ef2b6dbe3089cf9ac","user":{"login":"EdinburghGenomics","id":12951724,"node_id":"MDEyOk9yZ2FuaXphdGlvbjEyOTUxNzI0","avatar_url":"https://avatars0.githubusercontent.com/u/12951724?v=4","gravatar_id":"","url":"https://api.github.com/users/EdinburghGenomics","html_url":"https://github.com/EdinburghGenomics","followers_url":"https://api.github.com/users/EdinburghGenomics/followers","following_url":"https://api.github.com/users/EdinburghGenomics/following{/other_user}","gists_url":"https://api.github.com/users/EdinburghGenomics/gists{/gist_id}","starred_url":"https://api.github.com/users/EdinburghGenomics/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/EdinburghGenomics/subscriptions","organizations_url":"https://api.github.com/users/EdinburghGenomics/orgs","repos_url":"https://api.github.com/users/EdinburghGenomics/repos","events_url":"https://api.github.com/users/EdinburghGenomics/events{/privacy}","received_events_url":"https://api.github.com/users/EdinburghGenomics/received_events","type":"Organization","site_admin":false},"repo":{"id":45608433,"node_id":"MDEwOlJlcG9zaXRvcnk0NTYwODQzMw==","name":"Reporting-App","full_name":"EdinburghGenomics/Reporting-App","private":false,"owner":{"login":"EdinburghGenomics","id":12951724,"node_id":"MDEyOk9yZ2FuaXphdGlvbjEyOTUxNzI0","avatar_url":"https://avatars0.githubusercontent.com/u/12951724?v=4","gravatar_id":"","url":"https://api.github.com/users/EdinburghGenomics","html_url":"https://github.com/EdinburghGenomics","followers_url":"https://api.github.com/users/EdinburghGenomics/followers","following_url":"https://api.github.com/users/EdinburghGenomics/following{/other_user}","gists_url":"https://api.github.com/users/EdinburghGenomics/gists{/gist_id}","starred_url":"https://api.github.com/users/EdinburghGenomics/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/EdinburghGenomics/subscriptions","organizations_url":"https://api.github.com/users/EdinburghGenomics/orgs","repos_url":"https://api.github.com/users/EdinburghGenomics/repos","events_url":"https://api.github.com/users/EdinburghGenomics/events{/privacy}","received_events_url":"https://api.github.com/users/EdinburghGenomics/received_events","type":"Organization","site_admin":false},"html_url":"https://github.com/EdinburghGenomics/Reporting-App","description":"A Flask web app for presenting bcl2fastq and variant calling performance reports from Analysis-Driver","fork":false,"url":"https://api.github.com/repos/EdinburghGenomics/Reporting-App","forks_url":"https://api.github.com/repos/EdinburghGenomics/Reporting-App/forks","keys_url":"https://api.github.com/repos/EdinburghGenomics/Reporting-App/keys{/key_id}","collaborators_url":"https://api.github.com/repos/EdinburghGenomics/Reporting-App/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/EdinburghGenomics/Reporting-App/teams","hooks_url":"https://api.github.com/repos/EdinburghGenomics/Reporting-App/hooks","issue_events_url":"https://api.github.com/repos/EdinburghGenomics/Reporting-App/issues/events{/number}","events_url":"https://api.github.com/repos/EdinburghGenomics/Reporting-App/events","assignees_url":"https://api.github.com/repos/EdinburghGenomics/Reporting-App/assignees{/user}","branches_url":"https://api.github.com/repos/EdinburghGenomics/Reporting-App/branches{/branch}","tags_url":"https://api.github.com/repos/EdinburghGenomics/Reporting-App/tags","blobs_url":"https://api.github.com/repos/EdinburghGenomics/Reporting-App/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/EdinburghGenomics/Reporting-App/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/EdinburghGenomics/Reporting-App/git/refs{/sha}","trees_url":"https://api.github.com/repos/EdinburghGenomics/Reporting-App/git/trees{/sha}","statuses_url":"https://api.github.com/repos/EdinburghGenomics/Reporting-App/statuses/{sha}","languages_url":"https://api.github.com/repos/EdinburghGenomics/Reporting-App/languages","stargazers_url":"https://api.github.com/repos/EdinburghGenomics/Reporting-App/stargazers","contributors_url":"https://api.github.com/repos/EdinburghGenomics/Reporting-App/contributors","subscribers_url":"https://api.github.com/repos/EdinburghGenomics/Reporting-App/subscribers","subscription_url":"https://api.github.com/repos/EdinburghGenomics/Reporting-App/subscription","commits_url":"https://api.github.com/repos/EdinburghGenomics/Reporting-App/commits{/sha}","git_commits_url":"https://api.github.com/repos/EdinburghGenomics/Reporting-App/git/commits{/sha}","comments_url":"https://api.github.com/repos/EdinburghGenomics/Reporting-App/comments{/number}","issue_comment_url":"https://api.github.com/repos/EdinburghGenomics/Reporting-App/issues/comments{/number}","contents_url":"https://api.github.com/repos/EdinburghGenomics/Reporting-App/contents/{+path}","compare_url":"https://api.github.com/repos/EdinburghGenomics/Reporting-App/compare/{base}...{head}","merges_url":"https://api.github.com/repos/EdinburghGenomics/Reporting-App/merges","archive_url":"https://api.github.com/repos/EdinburghGenomics/Reporting-App/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/EdinburghGenomics/Reporting-App/downloads","issues_url":"https://api.github.com/repos/EdinburghGenomics/Reporting-App/issues{/number}","pulls_url":"https://api.github.com/repos/EdinburghGenomics/Reporting-App/pulls{/number}","milestones_url":"https://api.github.com/repos/EdinburghGenomics/Reporting-App/milestones{/number}","notifications_url":"https://api.github.com/repos/EdinburghGenomics/Reporting-App/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/EdinburghGenomics/Reporting-App/labels{/name}","releases_url":"https://api.github.com/repos/EdinburghGenomics/Reporting-App/releases{/id}","deployments_url":"https://api.github.com/repos/EdinburghGenomics/Reporting-App/deployments","created_at":"2015-11-05T11:58:25Z","updated_at":"2019-04-29T08:39:14Z","pushed_at":"2019-04-29T08:39:15Z","git_url":"git://github.com/EdinburghGenomics/Reporting-App.git","ssh_url":"git@github.com:EdinburghGenomics/Reporting-App.git","clone_url":"https://github.com/EdinburghGenomics/Reporting-App.git","svn_url":"https://github.com/EdinburghGenomics/Reporting-App","homepage":null,"size":4634,"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":0,"mirror_url":null,"archived":false,"disabled":false,"open_issues_count":18,"license":{"key":"other","name":"Other","spdx_id":"NOASSERTION","url":null,"node_id":"MDc6TGljZW5zZTA="},"forks":0,"open_issues":18,"watchers":3,"default_branch":"master"}},"base":{"label":"EdinburghGenomics:master","ref":"master","sha":"1378ca1e3609f04211fe6440ab94d96af8335099","user":{"login":"EdinburghGenomics","id":12951724,"node_id":"MDEyOk9yZ2FuaXphdGlvbjEyOTUxNzI0","avatar_url":"https://avatars0.githubusercontent.com/u/12951724?v=4","gravatar_id":"","url":"https://api.github.com/users/EdinburghGenomics","html_url":"https://github.com/EdinburghGenomics","followers_url":"https://api.github.com/users/EdinburghGenomics/followers","following_url":"https://api.github.com/users/EdinburghGenomics/following{/other_user}","gists_url":"https://api.github.com/users/EdinburghGenomics/gists{/gist_id}","starred_url":"https://api.github.com/users/EdinburghGenomics/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/EdinburghGenomics/subscriptions","organizations_url":"https://api.github.com/users/EdinburghGenomics/orgs","repos_url":"https://api.github.com/users/EdinburghGenomics/repos","events_url":"https://api.github.com/users/EdinburghGenomics/events{/privacy}","received_events_url":"https://api.github.com/users/EdinburghGenomics/received_events","type":"Organization","site_admin":false},"repo":{"id":45608433,"node_id":"MDEwOlJlcG9zaXRvcnk0NTYwODQzMw==","name":"Reporting-App","full_name":"EdinburghGenomics/Reporting-App","private":false,"owner":{"login":"EdinburghGenomics","id":12951724,"node_id":"MDEyOk9yZ2FuaXphdGlvbjEyOTUxNzI0","avatar_url":"https://avatars0.githubusercontent.com/u/12951724?v=4","gravatar_id":"","url":"https://api.github.com/users/EdinburghGenomics","html_url":"https://github.com/EdinburghGenomics","followers_url":"https://api.github.com/users/EdinburghGenomics/followers","following_url":"https://api.github.com/users/EdinburghGenomics/following{/other_user}","gists_url":"https://api.github.com/users/EdinburghGenomics/gists{/gist_id}","starred_url":"https://api.github.com/users/EdinburghGenomics/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/EdinburghGenomics/subscriptions","organizations_url":"https://api.github.com/users/EdinburghGenomics/orgs","repos_url":"https://api.github.com/users/EdinburghGenomics/repos","events_url":"https://api.github.com/users/EdinburghGenomics/events{/privacy}","received_events_url":"https://api.github.com/users/EdinburghGenomics/received_events","type":"Organization","site_admin":false},"html_url":"https://github.com/EdinburghGenomics/Reporting-App","description":"A Flask web app for presenting bcl2fastq and variant calling performance reports from Analysis-Driver","fork":false,"url":"https://api.github.com/repos/EdinburghGenomics/Reporting-App","forks_url":"https://api.github.com/repos/EdinburghGenomics/Reporting-App/forks","keys_url":"https://api.github.com/repos/EdinburghGenomics/Reporting-App/keys{/key_id}","collaborators_url":"https://api.github.com/repos/EdinburghGenomics/Reporting-App/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/EdinburghGenomics/Reporting-App/teams","hooks_url":"https://api.github.com/repos/EdinburghGenomics/Reporting-App/hooks","issue_events_url":"https://api.github.com/repos/EdinburghGenomics/Reporting-App/issues/events{/number}","events_url":"https://api.github.com/repos/EdinburghGenomics/Reporting-App/events","assignees_url":"https://api.github.com/repos/EdinburghGenomics/Reporting-App/assignees{/user}","branches_url":"https://api.github.com/repos/EdinburghGenomics/Reporting-App/branches{/branch}","tags_url":"https://api.github.com/repos/EdinburghGenomics/Reporting-App/tags","blobs_url":"https://api.github.com/repos/EdinburghGenomics/Reporting-App/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/EdinburghGenomics/Reporting-App/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/EdinburghGenomics/Reporting-App/git/refs{/sha}","trees_url":"https://api.github.com/repos/EdinburghGenomics/Reporting-App/git/trees{/sha}","statuses_url":"https://api.github.com/repos/EdinburghGenomics/Reporting-App/statuses/{sha}","languages_url":"https://api.github.com/repos/EdinburghGenomics/Reporting-App/languages","stargazers_url":"https://api.github.com/repos/EdinburghGenomics/Reporting-App/stargazers","contributors_url":"https://api.github.com/repos/EdinburghGenomics/Reporting-App/contributors","subscribers_url":"https://api.github.com/repos/EdinburghGenomics/Reporting-App/subscribers","subscription_url":"https://api.github.com/repos/EdinburghGenomics/Reporting-App/subscription","commits_url":"https://api.github.com/repos/EdinburghGenomics/Reporting-App/commits{/sha}","git_commits_url":"https://api.github.com/repos/EdinburghGenomics/Reporting-App/git/commits{/sha}","comments_url":"https://api.github.com/repos/EdinburghGenomics/Reporting-App/comments{/number}","issue_comment_url":"https://api.github.com/repos/EdinburghGenomics/Reporting-App/issues/comments{/number}","contents_url":"https://api.github.com/repos/EdinburghGenomics/Reporting-App/contents/{+path}","compare_url":"https://api.github.com/repos/EdinburghGenomics/Reporting-App/compare/{base}...{head}","merges_url":"https://api.github.com/repos/EdinburghGenomics/Reporting-App/merges","archive_url":"https://api.github.com/repos/EdinburghGenomics/Reporting-App/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/EdinburghGenomics/Reporting-App/downloads","issues_url":"https://api.github.com/repos/EdinburghGenomics/Reporting-App/issues{/number}","pulls_url":"https://api.github.com/repos/EdinburghGenomics/Reporting-App/pulls{/number}","milestones_url":"https://api.github.com/repos/EdinburghGenomics/Reporting-App/milestones{/number}","notifications_url":"https://api.github.com/repos/EdinburghGenomics/Reporting-App/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/EdinburghGenomics/Reporting-App/labels{/name}","releases_url":"https://api.github.com/repos/EdinburghGenomics/Reporting-App/releases{/id}","deployments_url":"https://api.github.com/repos/EdinburghGenomics/Reporting-App/deployments","created_at":"2015-11-05T11:58:25Z","updated_at":"2019-04-29T08:39:14Z","pushed_at":"2019-04-29T08:39:15Z","git_url":"git://github.com/EdinburghGenomics/Reporting-App.git","ssh_url":"git@github.com:EdinburghGenomics/Reporting-App.git","clone_url":"https://github.com/EdinburghGenomics/Reporting-App.git","svn_url":"https://github.com/EdinburghGenomics/Reporting-App","homepage":null,"size":4634,"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":0,"mirror_url":null,"archived":false,"disabled":false,"open_issues_count":18,"license":{"key":"other","name":"Other","spdx_id":"NOASSERTION","url":null,"node_id":"MDc6TGljZW5zZTA="},"forks":0,"open_issues":18,"watchers":3,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/EdinburghGenomics/Reporting-App/pulls/231"},"html":{"href":"https://github.com/EdinburghGenomics/Reporting-App/pull/231"},"issue":{"href":"https://api.github.com/repos/EdinburghGenomics/Reporting-App/issues/231"},"comments":{"href":"https://api.github.com/repos/EdinburghGenomics/Reporting-App/issues/231/comments"},"review_comments":{"href":"https://api.github.com/repos/EdinburghGenomics/Reporting-App/pulls/231/comments"},"review_comment":{"href":"https://api.github.com/repos/EdinburghGenomics/Reporting-App/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/EdinburghGenomics/Reporting-App/pulls/231/commits"},"statuses":{"href":"https://api.github.com/repos/EdinburghGenomics/Reporting-App/statuses/fe78b82f2b608d5c2370f31ef2b6dbe3089cf9ac"}},"author_association":"MEMBER"}}
{"actor":{"display_login":"lukbut"}}