{"action":"created","comment":{"url":"https://api.github.com/repos/scalableminds/webknossos/pulls/comments/177990022","pull_request_review_id":107967530,"id":177990022,"diff_hunk":"@@ -189,14 +189,6 @@ object AnnotationService\n     } yield true\n   }\n \n-  def updateAnnotationBase(task: Task, newTracingRefernce: TracingReference)(implicit ctx: DBAccessContext) = {","path":"app/models/annotation/AnnotationService.scala","position":4,"original_position":4,"commit_id":"b18fca8eda7b4866b75a660a7593d77fd3d57cdd","original_commit_id":"b18fca8eda7b4866b75a660a7593d77fd3d57cdd","user":{"login":"fm3","id":1390035,"avatar_url":"https://avatars1.githubusercontent.com/u/1390035?v=4","gravatar_id":"","url":"https://api.github.com/users/fm3","html_url":"https://github.com/fm3","followers_url":"https://api.github.com/users/fm3/followers","following_url":"https://api.github.com/users/fm3/following{/other_user}","gists_url":"https://api.github.com/users/fm3/gists{/gist_id}","starred_url":"https://api.github.com/users/fm3/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/fm3/subscriptions","organizations_url":"https://api.github.com/users/fm3/orgs","repos_url":"https://api.github.com/users/fm3/repos","events_url":"https://api.github.com/users/fm3/events{/privacy}","received_events_url":"https://api.github.com/users/fm3/received_events","type":"User","site_admin":false},"body":"yes, no usages found","created_at":"2018-03-29T08:47:15Z","updated_at":"2018-03-29T08:47:15Z","html_url":"https://github.com/scalableminds/webknossos/pull/2440#discussion_r177990022","pull_request_url":"https://api.github.com/repos/scalableminds/webknossos/pulls/2440","author_association":"MEMBER","_links":{"self":{"href":"https://api.github.com/repos/scalableminds/webknossos/pulls/comments/177990022"},"html":{"href":"https://github.com/scalableminds/webknossos/pull/2440#discussion_r177990022"},"pull_request":{"href":"https://api.github.com/repos/scalableminds/webknossos/pulls/2440"}},"in_reply_to_id":177989611},"pull_request":{"url":"https://api.github.com/repos/scalableminds/webknossos/pulls/2440","id":178262135,"html_url":"https://github.com/scalableminds/webknossos/pull/2440","diff_url":"https://github.com/scalableminds/webknossos/pull/2440.diff","patch_url":"https://github.com/scalableminds/webknossos/pull/2440.patch","issue_url":"https://api.github.com/repos/scalableminds/webknossos/issues/2440","number":2440,"state":"open","locked":false,"title":"Fix some sql queries: update tracing reference and update user dataset config","user":{"login":"fm3","id":1390035,"avatar_url":"https://avatars1.githubusercontent.com/u/1390035?v=4","gravatar_id":"","url":"https://api.github.com/users/fm3","html_url":"https://github.com/fm3","followers_url":"https://api.github.com/users/fm3/followers","following_url":"https://api.github.com/users/fm3/following{/other_user}","gists_url":"https://api.github.com/users/fm3/gists{/gist_id}","starred_url":"https://api.github.com/users/fm3/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/fm3/subscriptions","organizations_url":"https://api.github.com/users/fm3/orgs","repos_url":"https://api.github.com/users/fm3/repos","events_url":"https://api.github.com/users/fm3/events{/privacy}","received_events_url":"https://api.github.com/users/fm3/received_events","type":"User","site_admin":false},"body":"* fixed updating an annotation’s tracing reference (used e.g. for revertToBase)\r\n* running the queries for changing user dataset configurations transactionally, hopefully avoiding race conditions that lead to duplicate key errors\r\n* removed an unused method\r\n\r\n### Steps to test:\r\n- change user dataset configuration (like dataset brightness), reload, should still be there\r\n- reset an annotation to its base (`/api/annotations/:typ/:id/reset`), should now work\r\n\r\n### Issues:\r\n- fixes #2417\r\n\r\n------\r\n- [x] Ready for review\r\n","created_at":"2018-03-29T08:41:01Z","updated_at":"2018-03-29T08:47:15Z","closed_at":null,"merged_at":null,"merge_commit_sha":"19ba51f311c6162a519bee4d8c523bc7fc9ace0c","assignee":{"login":"fm3","id":1390035,"avatar_url":"https://avatars1.githubusercontent.com/u/1390035?v=4","gravatar_id":"","url":"https://api.github.com/users/fm3","html_url":"https://github.com/fm3","followers_url":"https://api.github.com/users/fm3/followers","following_url":"https://api.github.com/users/fm3/following{/other_user}","gists_url":"https://api.github.com/users/fm3/gists{/gist_id}","starred_url":"https://api.github.com/users/fm3/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/fm3/subscriptions","organizations_url":"https://api.github.com/users/fm3/orgs","repos_url":"https://api.github.com/users/fm3/repos","events_url":"https://api.github.com/users/fm3/events{/privacy}","received_events_url":"https://api.github.com/users/fm3/received_events","type":"User","site_admin":false},"assignees":[{"login":"fm3","id":1390035,"avatar_url":"https://avatars1.githubusercontent.com/u/1390035?v=4","gravatar_id":"","url":"https://api.github.com/users/fm3","html_url":"https://github.com/fm3","followers_url":"https://api.github.com/users/fm3/followers","following_url":"https://api.github.com/users/fm3/following{/other_user}","gists_url":"https://api.github.com/users/fm3/gists{/gist_id}","starred_url":"https://api.github.com/users/fm3/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/fm3/subscriptions","organizations_url":"https://api.github.com/users/fm3/orgs","repos_url":"https://api.github.com/users/fm3/repos","events_url":"https://api.github.com/users/fm3/events{/privacy}","received_events_url":"https://api.github.com/users/fm3/received_events","type":"User","site_admin":false}],"requested_reviewers":[{"login":"rschwanhold","id":22892968,"avatar_url":"https://avatars3.githubusercontent.com/u/22892968?v=4","gravatar_id":"","url":"https://api.github.com/users/rschwanhold","html_url":"https://github.com/rschwanhold","followers_url":"https://api.github.com/users/rschwanhold/followers","following_url":"https://api.github.com/users/rschwanhold/following{/other_user}","gists_url":"https://api.github.com/users/rschwanhold/gists{/gist_id}","starred_url":"https://api.github.com/users/rschwanhold/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rschwanhold/subscriptions","organizations_url":"https://api.github.com/users/rschwanhold/orgs","repos_url":"https://api.github.com/users/rschwanhold/repos","events_url":"https://api.github.com/users/rschwanhold/events{/privacy}","received_events_url":"https://api.github.com/users/rschwanhold/received_events","type":"User","site_admin":false},{"login":"youri-k","id":24464600,"avatar_url":"https://avatars1.githubusercontent.com/u/24464600?v=4","gravatar_id":"","url":"https://api.github.com/users/youri-k","html_url":"https://github.com/youri-k","followers_url":"https://api.github.com/users/youri-k/followers","following_url":"https://api.github.com/users/youri-k/following{/other_user}","gists_url":"https://api.github.com/users/youri-k/gists{/gist_id}","starred_url":"https://api.github.com/users/youri-k/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/youri-k/subscriptions","organizations_url":"https://api.github.com/users/youri-k/orgs","repos_url":"https://api.github.com/users/youri-k/repos","events_url":"https://api.github.com/users/youri-k/events{/privacy}","received_events_url":"https://api.github.com/users/youri-k/received_events","type":"User","site_admin":false}],"requested_teams":[],"labels":[{"id":53909850,"url":"https://api.github.com/repos/scalableminds/webknossos/labels/backend","name":"backend","color":"092253","default":false},{"id":5005367,"url":"https://api.github.com/repos/scalableminds/webknossos/labels/bug","name":"bug","color":"f7c6c7","default":true}],"milestone":{"url":"https://api.github.com/repos/scalableminds/webknossos/milestones/35","html_url":"https://github.com/scalableminds/webknossos/milestone/35","labels_url":"https://api.github.com/repos/scalableminds/webknossos/milestones/35/labels","id":3187011,"number":35,"title":"Sprint 19","description":"","creator":{"login":"hotzenklotz","id":1105056,"avatar_url":"https://avatars2.githubusercontent.com/u/1105056?v=4","gravatar_id":"","url":"https://api.github.com/users/hotzenklotz","html_url":"https://github.com/hotzenklotz","followers_url":"https://api.github.com/users/hotzenklotz/followers","following_url":"https://api.github.com/users/hotzenklotz/following{/other_user}","gists_url":"https://api.github.com/users/hotzenklotz/gists{/gist_id}","starred_url":"https://api.github.com/users/hotzenklotz/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/hotzenklotz/subscriptions","organizations_url":"https://api.github.com/users/hotzenklotz/orgs","repos_url":"https://api.github.com/users/hotzenklotz/repos","events_url":"https://api.github.com/users/hotzenklotz/events{/privacy}","received_events_url":"https://api.github.com/users/hotzenklotz/received_events","type":"User","site_admin":false},"open_issues":5,"closed_issues":0,"state":"open","created_at":"2018-03-14T12:02:26Z","updated_at":"2018-03-29T08:41:01Z","due_on":"2018-04-06T07:00:00Z","closed_at":null},"commits_url":"https://api.github.com/repos/scalableminds/webknossos/pulls/2440/commits","review_comments_url":"https://api.github.com/repos/scalableminds/webknossos/pulls/2440/comments","review_comment_url":"https://api.github.com/repos/scalableminds/webknossos/pulls/comments{/number}","comments_url":"https://api.github.com/repos/scalableminds/webknossos/issues/2440/comments","statuses_url":"https://api.github.com/repos/scalableminds/webknossos/statuses/b18fca8eda7b4866b75a660a7593d77fd3d57cdd","head":{"label":"scalableminds:fix-some-sql-errors","ref":"fix-some-sql-errors","sha":"b18fca8eda7b4866b75a660a7593d77fd3d57cdd","user":{"login":"scalableminds","id":1648557,"avatar_url":"https://avatars1.githubusercontent.com/u/1648557?v=4","gravatar_id":"","url":"https://api.github.com/users/scalableminds","html_url":"https://github.com/scalableminds","followers_url":"https://api.github.com/users/scalableminds/followers","following_url":"https://api.github.com/users/scalableminds/following{/other_user}","gists_url":"https://api.github.com/users/scalableminds/gists{/gist_id}","starred_url":"https://api.github.com/users/scalableminds/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/scalableminds/subscriptions","organizations_url":"https://api.github.com/users/scalableminds/orgs","repos_url":"https://api.github.com/users/scalableminds/repos","events_url":"https://api.github.com/users/scalableminds/events{/privacy}","received_events_url":"https://api.github.com/users/scalableminds/received_events","type":"Organization","site_admin":false},"repo":{"id":4326197,"name":"webknossos","full_name":"scalableminds/webknossos","owner":{"login":"scalableminds","id":1648557,"avatar_url":"https://avatars1.githubusercontent.com/u/1648557?v=4","gravatar_id":"","url":"https://api.github.com/users/scalableminds","html_url":"https://github.com/scalableminds","followers_url":"https://api.github.com/users/scalableminds/followers","following_url":"https://api.github.com/users/scalableminds/following{/other_user}","gists_url":"https://api.github.com/users/scalableminds/gists{/gist_id}","starred_url":"https://api.github.com/users/scalableminds/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/scalableminds/subscriptions","organizations_url":"https://api.github.com/users/scalableminds/orgs","repos_url":"https://api.github.com/users/scalableminds/repos","events_url":"https://api.github.com/users/scalableminds/events{/privacy}","received_events_url":"https://api.github.com/users/scalableminds/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/scalableminds/webknossos","description":"A fully cloud- and browser-based 3D annotation tool for distributed large-scale data analysis in light- and electron-microscopy based Connectomics","fork":false,"url":"https://api.github.com/repos/scalableminds/webknossos","forks_url":"https://api.github.com/repos/scalableminds/webknossos/forks","keys_url":"https://api.github.com/repos/scalableminds/webknossos/keys{/key_id}","collaborators_url":"https://api.github.com/repos/scalableminds/webknossos/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/scalableminds/webknossos/teams","hooks_url":"https://api.github.com/repos/scalableminds/webknossos/hooks","issue_events_url":"https://api.github.com/repos/scalableminds/webknossos/issues/events{/number}","events_url":"https://api.github.com/repos/scalableminds/webknossos/events","assignees_url":"https://api.github.com/repos/scalableminds/webknossos/assignees{/user}","branches_url":"https://api.github.com/repos/scalableminds/webknossos/branches{/branch}","tags_url":"https://api.github.com/repos/scalableminds/webknossos/tags","blobs_url":"https://api.github.com/repos/scalableminds/webknossos/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/scalableminds/webknossos/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/scalableminds/webknossos/git/refs{/sha}","trees_url":"https://api.github.com/repos/scalableminds/webknossos/git/trees{/sha}","statuses_url":"https://api.github.com/repos/scalableminds/webknossos/statuses/{sha}","languages_url":"https://api.github.com/repos/scalableminds/webknossos/languages","stargazers_url":"https://api.github.com/repos/scalableminds/webknossos/stargazers","contributors_url":"https://api.github.com/repos/scalableminds/webknossos/contributors","subscribers_url":"https://api.github.com/repos/scalableminds/webknossos/subscribers","subscription_url":"https://api.github.com/repos/scalableminds/webknossos/subscription","commits_url":"https://api.github.com/repos/scalableminds/webknossos/commits{/sha}","git_commits_url":"https://api.github.com/repos/scalableminds/webknossos/git/commits{/sha}","comments_url":"https://api.github.com/repos/scalableminds/webknossos/comments{/number}","issue_comment_url":"https://api.github.com/repos/scalableminds/webknossos/issues/comments{/number}","contents_url":"https://api.github.com/repos/scalableminds/webknossos/contents/{+path}","compare_url":"https://api.github.com/repos/scalableminds/webknossos/compare/{base}...{head}","merges_url":"https://api.github.com/repos/scalableminds/webknossos/merges","archive_url":"https://api.github.com/repos/scalableminds/webknossos/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/scalableminds/webknossos/downloads","issues_url":"https://api.github.com/repos/scalableminds/webknossos/issues{/number}","pulls_url":"https://api.github.com/repos/scalableminds/webknossos/pulls{/number}","milestones_url":"https://api.github.com/repos/scalableminds/webknossos/milestones{/number}","notifications_url":"https://api.github.com/repos/scalableminds/webknossos/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/scalableminds/webknossos/labels{/name}","releases_url":"https://api.github.com/repos/scalableminds/webknossos/releases{/id}","deployments_url":"https://api.github.com/repos/scalableminds/webknossos/deployments","created_at":"2012-05-14T16:26:17Z","updated_at":"2018-03-28T17:00:37Z","pushed_at":"2018-03-29T08:41:02Z","git_url":"git://github.com/scalableminds/webknossos.git","ssh_url":"git@github.com:scalableminds/webknossos.git","clone_url":"https://github.com/scalableminds/webknossos.git","svn_url":"https://github.com/scalableminds/webknossos","homepage":"https://webknossos.org/","size":87747,"stargazers_count":13,"watchers_count":13,"language":"JavaScript","has_issues":true,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":1,"mirror_url":null,"archived":false,"open_issues_count":79,"license":{"key":"agpl-3.0","name":"GNU Affero General Public License v3.0","spdx_id":"AGPL-3.0","url":"https://api.github.com/licenses/agpl-3.0"},"forks":1,"open_issues":79,"watchers":13,"default_branch":"master"}},"base":{"label":"scalableminds:master","ref":"master","sha":"8eae4364195b3cb0f62c762b7ed60232acdc49e5","user":{"login":"scalableminds","id":1648557,"avatar_url":"https://avatars1.githubusercontent.com/u/1648557?v=4","gravatar_id":"","url":"https://api.github.com/users/scalableminds","html_url":"https://github.com/scalableminds","followers_url":"https://api.github.com/users/scalableminds/followers","following_url":"https://api.github.com/users/scalableminds/following{/other_user}","gists_url":"https://api.github.com/users/scalableminds/gists{/gist_id}","starred_url":"https://api.github.com/users/scalableminds/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/scalableminds/subscriptions","organizations_url":"https://api.github.com/users/scalableminds/orgs","repos_url":"https://api.github.com/users/scalableminds/repos","events_url":"https://api.github.com/users/scalableminds/events{/privacy}","received_events_url":"https://api.github.com/users/scalableminds/received_events","type":"Organization","site_admin":false},"repo":{"id":4326197,"name":"webknossos","full_name":"scalableminds/webknossos","owner":{"login":"scalableminds","id":1648557,"avatar_url":"https://avatars1.githubusercontent.com/u/1648557?v=4","gravatar_id":"","url":"https://api.github.com/users/scalableminds","html_url":"https://github.com/scalableminds","followers_url":"https://api.github.com/users/scalableminds/followers","following_url":"https://api.github.com/users/scalableminds/following{/other_user}","gists_url":"https://api.github.com/users/scalableminds/gists{/gist_id}","starred_url":"https://api.github.com/users/scalableminds/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/scalableminds/subscriptions","organizations_url":"https://api.github.com/users/scalableminds/orgs","repos_url":"https://api.github.com/users/scalableminds/repos","events_url":"https://api.github.com/users/scalableminds/events{/privacy}","received_events_url":"https://api.github.com/users/scalableminds/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/scalableminds/webknossos","description":"A fully cloud- and browser-based 3D annotation tool for distributed large-scale data analysis in light- and electron-microscopy based Connectomics","fork":false,"url":"https://api.github.com/repos/scalableminds/webknossos","forks_url":"https://api.github.com/repos/scalableminds/webknossos/forks","keys_url":"https://api.github.com/repos/scalableminds/webknossos/keys{/key_id}","collaborators_url":"https://api.github.com/repos/scalableminds/webknossos/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/scalableminds/webknossos/teams","hooks_url":"https://api.github.com/repos/scalableminds/webknossos/hooks","issue_events_url":"https://api.github.com/repos/scalableminds/webknossos/issues/events{/number}","events_url":"https://api.github.com/repos/scalableminds/webknossos/events","assignees_url":"https://api.github.com/repos/scalableminds/webknossos/assignees{/user}","branches_url":"https://api.github.com/repos/scalableminds/webknossos/branches{/branch}","tags_url":"https://api.github.com/repos/scalableminds/webknossos/tags","blobs_url":"https://api.github.com/repos/scalableminds/webknossos/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/scalableminds/webknossos/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/scalableminds/webknossos/git/refs{/sha}","trees_url":"https://api.github.com/repos/scalableminds/webknossos/git/trees{/sha}","statuses_url":"https://api.github.com/repos/scalableminds/webknossos/statuses/{sha}","languages_url":"https://api.github.com/repos/scalableminds/webknossos/languages","stargazers_url":"https://api.github.com/repos/scalableminds/webknossos/stargazers","contributors_url":"https://api.github.com/repos/scalableminds/webknossos/contributors","subscribers_url":"https://api.github.com/repos/scalableminds/webknossos/subscribers","subscription_url":"https://api.github.com/repos/scalableminds/webknossos/subscription","commits_url":"https://api.github.com/repos/scalableminds/webknossos/commits{/sha}","git_commits_url":"https://api.github.com/repos/scalableminds/webknossos/git/commits{/sha}","comments_url":"https://api.github.com/repos/scalableminds/webknossos/comments{/number}","issue_comment_url":"https://api.github.com/repos/scalableminds/webknossos/issues/comments{/number}","contents_url":"https://api.github.com/repos/scalableminds/webknossos/contents/{+path}","compare_url":"https://api.github.com/repos/scalableminds/webknossos/compare/{base}...{head}","merges_url":"https://api.github.com/repos/scalableminds/webknossos/merges","archive_url":"https://api.github.com/repos/scalableminds/webknossos/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/scalableminds/webknossos/downloads","issues_url":"https://api.github.com/repos/scalableminds/webknossos/issues{/number}","pulls_url":"https://api.github.com/repos/scalableminds/webknossos/pulls{/number}","milestones_url":"https://api.github.com/repos/scalableminds/webknossos/milestones{/number}","notifications_url":"https://api.github.com/repos/scalableminds/webknossos/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/scalableminds/webknossos/labels{/name}","releases_url":"https://api.github.com/repos/scalableminds/webknossos/releases{/id}","deployments_url":"https://api.github.com/repos/scalableminds/webknossos/deployments","created_at":"2012-05-14T16:26:17Z","updated_at":"2018-03-28T17:00:37Z","pushed_at":"2018-03-29T08:41:02Z","git_url":"git://github.com/scalableminds/webknossos.git","ssh_url":"git@github.com:scalableminds/webknossos.git","clone_url":"https://github.com/scalableminds/webknossos.git","svn_url":"https://github.com/scalableminds/webknossos","homepage":"https://webknossos.org/","size":87747,"stargazers_count":13,"watchers_count":13,"language":"JavaScript","has_issues":true,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":1,"mirror_url":null,"archived":false,"open_issues_count":79,"license":{"key":"agpl-3.0","name":"GNU Affero General Public License v3.0","spdx_id":"AGPL-3.0","url":"https://api.github.com/licenses/agpl-3.0"},"forks":1,"open_issues":79,"watchers":13,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/scalableminds/webknossos/pulls/2440"},"html":{"href":"https://github.com/scalableminds/webknossos/pull/2440"},"issue":{"href":"https://api.github.com/repos/scalableminds/webknossos/issues/2440"},"comments":{"href":"https://api.github.com/repos/scalableminds/webknossos/issues/2440/comments"},"review_comments":{"href":"https://api.github.com/repos/scalableminds/webknossos/pulls/2440/comments"},"review_comment":{"href":"https://api.github.com/repos/scalableminds/webknossos/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/scalableminds/webknossos/pulls/2440/commits"},"statuses":{"href":"https://api.github.com/repos/scalableminds/webknossos/statuses/b18fca8eda7b4866b75a660a7593d77fd3d57cdd"}},"author_association":"MEMBER"}}
{"actor":{"display_login":"fm3"}}