{"action":"created","comment":{"url":"https://api.github.com/repos/advancedtelematic/rvi_sota_server/pulls/comments/42006467","id":42006467,"diff_hunk":"@@ -87,6 +90,19 @@ object UpdateSpecs {\n       .update( newStatus )\n   }\n \n+  def getPackagesQueuedForVin(vin: Vehicle.IdentificationNumber)\n+                             (implicit ec: ExecutionContext) : DBIO[Iterable[Id]] = {\n+    val specs = updateSpecs.filter(r => r.vin === vin && (r.status === UpdateStatus.InFlight ||\n+      r.status === UpdateStatus.Pending))\n+    val q = for {\n+      s <- specs\n+      u <- updateRequests if s.requestId === u.id\n+    } yield (u.packageName, u.packageVersion)\n+    val res : DBIO[Iterable[(Package.Name, Package.Version)]] = q.result","path":"core/src/main/scala/org/genivi/sota/core/db/UpdateSpecs.scala","position":29,"original_position":29,"commit_id":"a54c37fa0aeec4633b980a00808e965dd51d5c8c","original_commit_id":"a54c37fa0aeec4633b980a00808e965dd51d5c8c","user":{"login":"jerrytrieu","id":7487227,"avatar_url":"https://avatars.githubusercontent.com/u/7487227?v=3","gravatar_id":"","url":"https://api.github.com/users/jerrytrieu","html_url":"https://github.com/jerrytrieu","followers_url":"https://api.github.com/users/jerrytrieu/followers","following_url":"https://api.github.com/users/jerrytrieu/following{/other_user}","gists_url":"https://api.github.com/users/jerrytrieu/gists{/gist_id}","starred_url":"https://api.github.com/users/jerrytrieu/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jerrytrieu/subscriptions","organizations_url":"https://api.github.com/users/jerrytrieu/orgs","repos_url":"https://api.github.com/users/jerrytrieu/repos","events_url":"https://api.github.com/users/jerrytrieu/events{/privacy}","received_events_url":"https://api.github.com/users/jerrytrieu/received_events","type":"User","site_admin":false},"body":"Probably don't need these temp vars?","created_at":"2015-10-14T15:11:31Z","updated_at":"2015-10-14T15:11:31Z","html_url":"https://github.com/advancedtelematic/rvi_sota_server/pull/179#discussion_r42006467","pull_request_url":"https://api.github.com/repos/advancedtelematic/rvi_sota_server/pulls/179","_links":{"self":{"href":"https://api.github.com/repos/advancedtelematic/rvi_sota_server/pulls/comments/42006467"},"html":{"href":"https://github.com/advancedtelematic/rvi_sota_server/pull/179#discussion_r42006467"},"pull_request":{"href":"https://api.github.com/repos/advancedtelematic/rvi_sota_server/pulls/179"}}},"pull_request":{"url":"https://api.github.com/repos/advancedtelematic/rvi_sota_server/pulls/179","id":47666958,"html_url":"https://github.com/advancedtelematic/rvi_sota_server/pull/179","diff_url":"https://github.com/advancedtelematic/rvi_sota_server/pull/179.diff","patch_url":"https://github.com/advancedtelematic/rvi_sota_server/pull/179.patch","issue_url":"https://api.github.com/repos/advancedtelematic/rvi_sota_server/issues/179","number":179,"state":"open","locked":false,"title":"Add list of queued packages to VIN page","user":{"login":"calumats","id":12608649,"avatar_url":"https://avatars.githubusercontent.com/u/12608649?v=3","gravatar_id":"","url":"https://api.github.com/users/calumats","html_url":"https://github.com/calumats","followers_url":"https://api.github.com/users/calumats/followers","following_url":"https://api.github.com/users/calumats/following{/other_user}","gists_url":"https://api.github.com/users/calumats/gists{/gist_id}","starred_url":"https://api.github.com/users/calumats/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/calumats/subscriptions","organizations_url":"https://api.github.com/users/calumats/orgs","repos_url":"https://api.github.com/users/calumats/repos","events_url":"https://api.github.com/users/calumats/events{/privacy}","received_events_url":"https://api.github.com/users/calumats/received_events","type":"User","site_admin":false},"body":"SOTA-137","created_at":"2015-10-14T14:32:50Z","updated_at":"2015-10-14T15:11:31Z","closed_at":null,"merged_at":null,"merge_commit_sha":"e370f3dfbc909e9c5e3cf9c7d859b907db6d1518","assignee":{"login":"jerrytrieu","id":7487227,"avatar_url":"https://avatars.githubusercontent.com/u/7487227?v=3","gravatar_id":"","url":"https://api.github.com/users/jerrytrieu","html_url":"https://github.com/jerrytrieu","followers_url":"https://api.github.com/users/jerrytrieu/followers","following_url":"https://api.github.com/users/jerrytrieu/following{/other_user}","gists_url":"https://api.github.com/users/jerrytrieu/gists{/gist_id}","starred_url":"https://api.github.com/users/jerrytrieu/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jerrytrieu/subscriptions","organizations_url":"https://api.github.com/users/jerrytrieu/orgs","repos_url":"https://api.github.com/users/jerrytrieu/repos","events_url":"https://api.github.com/users/jerrytrieu/events{/privacy}","received_events_url":"https://api.github.com/users/jerrytrieu/received_events","type":"User","site_admin":false},"milestone":null,"commits_url":"https://api.github.com/repos/advancedtelematic/rvi_sota_server/pulls/179/commits","review_comments_url":"https://api.github.com/repos/advancedtelematic/rvi_sota_server/pulls/179/comments","review_comment_url":"https://api.github.com/repos/advancedtelematic/rvi_sota_server/pulls/comments{/number}","comments_url":"https://api.github.com/repos/advancedtelematic/rvi_sota_server/issues/179/comments","statuses_url":"https://api.github.com/repos/advancedtelematic/rvi_sota_server/statuses/a54c37fa0aeec4633b980a00808e965dd51d5c8c","head":{"label":"advancedtelematic:feat/add-package-queue-for-vin","ref":"feat/add-package-queue-for-vin","sha":"a54c37fa0aeec4633b980a00808e965dd51d5c8c","user":{"login":"advancedtelematic","id":7944633,"avatar_url":"https://avatars.githubusercontent.com/u/7944633?v=3","gravatar_id":"","url":"https://api.github.com/users/advancedtelematic","html_url":"https://github.com/advancedtelematic","followers_url":"https://api.github.com/users/advancedtelematic/followers","following_url":"https://api.github.com/users/advancedtelematic/following{/other_user}","gists_url":"https://api.github.com/users/advancedtelematic/gists{/gist_id}","starred_url":"https://api.github.com/users/advancedtelematic/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/advancedtelematic/subscriptions","organizations_url":"https://api.github.com/users/advancedtelematic/orgs","repos_url":"https://api.github.com/users/advancedtelematic/repos","events_url":"https://api.github.com/users/advancedtelematic/events{/privacy}","received_events_url":"https://api.github.com/users/advancedtelematic/received_events","type":"Organization","site_admin":false},"repo":{"id":41109281,"name":"rvi_sota_server","full_name":"advancedtelematic/rvi_sota_server","owner":{"login":"advancedtelematic","id":7944633,"avatar_url":"https://avatars.githubusercontent.com/u/7944633?v=3","gravatar_id":"","url":"https://api.github.com/users/advancedtelematic","html_url":"https://github.com/advancedtelematic","followers_url":"https://api.github.com/users/advancedtelematic/followers","following_url":"https://api.github.com/users/advancedtelematic/following{/other_user}","gists_url":"https://api.github.com/users/advancedtelematic/gists{/gist_id}","starred_url":"https://api.github.com/users/advancedtelematic/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/advancedtelematic/subscriptions","organizations_url":"https://api.github.com/users/advancedtelematic/orgs","repos_url":"https://api.github.com/users/advancedtelematic/repos","events_url":"https://api.github.com/users/advancedtelematic/events{/privacy}","received_events_url":"https://api.github.com/users/advancedtelematic/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/advancedtelematic/rvi_sota_server","description":"SOTA Reference Implementation project - Server","fork":true,"url":"https://api.github.com/repos/advancedtelematic/rvi_sota_server","forks_url":"https://api.github.com/repos/advancedtelematic/rvi_sota_server/forks","keys_url":"https://api.github.com/repos/advancedtelematic/rvi_sota_server/keys{/key_id}","collaborators_url":"https://api.github.com/repos/advancedtelematic/rvi_sota_server/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/advancedtelematic/rvi_sota_server/teams","hooks_url":"https://api.github.com/repos/advancedtelematic/rvi_sota_server/hooks","issue_events_url":"https://api.github.com/repos/advancedtelematic/rvi_sota_server/issues/events{/number}","events_url":"https://api.github.com/repos/advancedtelematic/rvi_sota_server/events","assignees_url":"https://api.github.com/repos/advancedtelematic/rvi_sota_server/assignees{/user}","branches_url":"https://api.github.com/repos/advancedtelematic/rvi_sota_server/branches{/branch}","tags_url":"https://api.github.com/repos/advancedtelematic/rvi_sota_server/tags","blobs_url":"https://api.github.com/repos/advancedtelematic/rvi_sota_server/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/advancedtelematic/rvi_sota_server/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/advancedtelematic/rvi_sota_server/git/refs{/sha}","trees_url":"https://api.github.com/repos/advancedtelematic/rvi_sota_server/git/trees{/sha}","statuses_url":"https://api.github.com/repos/advancedtelematic/rvi_sota_server/statuses/{sha}","languages_url":"https://api.github.com/repos/advancedtelematic/rvi_sota_server/languages","stargazers_url":"https://api.github.com/repos/advancedtelematic/rvi_sota_server/stargazers","contributors_url":"https://api.github.com/repos/advancedtelematic/rvi_sota_server/contributors","subscribers_url":"https://api.github.com/repos/advancedtelematic/rvi_sota_server/subscribers","subscription_url":"https://api.github.com/repos/advancedtelematic/rvi_sota_server/subscription","commits_url":"https://api.github.com/repos/advancedtelematic/rvi_sota_server/commits{/sha}","git_commits_url":"https://api.github.com/repos/advancedtelematic/rvi_sota_server/git/commits{/sha}","comments_url":"https://api.github.com/repos/advancedtelematic/rvi_sota_server/comments{/number}","issue_comment_url":"https://api.github.com/repos/advancedtelematic/rvi_sota_server/issues/comments{/number}","contents_url":"https://api.github.com/repos/advancedtelematic/rvi_sota_server/contents/{+path}","compare_url":"https://api.github.com/repos/advancedtelematic/rvi_sota_server/compare/{base}...{head}","merges_url":"https://api.github.com/repos/advancedtelematic/rvi_sota_server/merges","archive_url":"https://api.github.com/repos/advancedtelematic/rvi_sota_server/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/advancedtelematic/rvi_sota_server/downloads","issues_url":"https://api.github.com/repos/advancedtelematic/rvi_sota_server/issues{/number}","pulls_url":"https://api.github.com/repos/advancedtelematic/rvi_sota_server/pulls{/number}","milestones_url":"https://api.github.com/repos/advancedtelematic/rvi_sota_server/milestones{/number}","notifications_url":"https://api.github.com/repos/advancedtelematic/rvi_sota_server/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/advancedtelematic/rvi_sota_server/labels{/name}","releases_url":"https://api.github.com/repos/advancedtelematic/rvi_sota_server/releases{/id}","created_at":"2015-08-20T17:22:41Z","updated_at":"2015-09-17T07:24:32Z","pushed_at":"2015-10-14T14:32:51Z","git_url":"git://github.com/advancedtelematic/rvi_sota_server.git","ssh_url":"git@github.com:advancedtelematic/rvi_sota_server.git","clone_url":"https://github.com/advancedtelematic/rvi_sota_server.git","svn_url":"https://github.com/advancedtelematic/rvi_sota_server","homepage":null,"size":14055,"stargazers_count":2,"watchers_count":2,"language":"Scala","has_issues":false,"has_downloads":true,"has_wiki":true,"has_pages":true,"forks_count":0,"mirror_url":null,"open_issues_count":1,"forks":0,"open_issues":1,"watchers":2,"default_branch":"master"}},"base":{"label":"advancedtelematic:master","ref":"master","sha":"95292d543a38de60e3efbffdbda55c1076302c5d","user":{"login":"advancedtelematic","id":7944633,"avatar_url":"https://avatars.githubusercontent.com/u/7944633?v=3","gravatar_id":"","url":"https://api.github.com/users/advancedtelematic","html_url":"https://github.com/advancedtelematic","followers_url":"https://api.github.com/users/advancedtelematic/followers","following_url":"https://api.github.com/users/advancedtelematic/following{/other_user}","gists_url":"https://api.github.com/users/advancedtelematic/gists{/gist_id}","starred_url":"https://api.github.com/users/advancedtelematic/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/advancedtelematic/subscriptions","organizations_url":"https://api.github.com/users/advancedtelematic/orgs","repos_url":"https://api.github.com/users/advancedtelematic/repos","events_url":"https://api.github.com/users/advancedtelematic/events{/privacy}","received_events_url":"https://api.github.com/users/advancedtelematic/received_events","type":"Organization","site_admin":false},"repo":{"id":41109281,"name":"rvi_sota_server","full_name":"advancedtelematic/rvi_sota_server","owner":{"login":"advancedtelematic","id":7944633,"avatar_url":"https://avatars.githubusercontent.com/u/7944633?v=3","gravatar_id":"","url":"https://api.github.com/users/advancedtelematic","html_url":"https://github.com/advancedtelematic","followers_url":"https://api.github.com/users/advancedtelematic/followers","following_url":"https://api.github.com/users/advancedtelematic/following{/other_user}","gists_url":"https://api.github.com/users/advancedtelematic/gists{/gist_id}","starred_url":"https://api.github.com/users/advancedtelematic/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/advancedtelematic/subscriptions","organizations_url":"https://api.github.com/users/advancedtelematic/orgs","repos_url":"https://api.github.com/users/advancedtelematic/repos","events_url":"https://api.github.com/users/advancedtelematic/events{/privacy}","received_events_url":"https://api.github.com/users/advancedtelematic/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/advancedtelematic/rvi_sota_server","description":"SOTA Reference Implementation project - Server","fork":true,"url":"https://api.github.com/repos/advancedtelematic/rvi_sota_server","forks_url":"https://api.github.com/repos/advancedtelematic/rvi_sota_server/forks","keys_url":"https://api.github.com/repos/advancedtelematic/rvi_sota_server/keys{/key_id}","collaborators_url":"https://api.github.com/repos/advancedtelematic/rvi_sota_server/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/advancedtelematic/rvi_sota_server/teams","hooks_url":"https://api.github.com/repos/advancedtelematic/rvi_sota_server/hooks","issue_events_url":"https://api.github.com/repos/advancedtelematic/rvi_sota_server/issues/events{/number}","events_url":"https://api.github.com/repos/advancedtelematic/rvi_sota_server/events","assignees_url":"https://api.github.com/repos/advancedtelematic/rvi_sota_server/assignees{/user}","branches_url":"https://api.github.com/repos/advancedtelematic/rvi_sota_server/branches{/branch}","tags_url":"https://api.github.com/repos/advancedtelematic/rvi_sota_server/tags","blobs_url":"https://api.github.com/repos/advancedtelematic/rvi_sota_server/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/advancedtelematic/rvi_sota_server/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/advancedtelematic/rvi_sota_server/git/refs{/sha}","trees_url":"https://api.github.com/repos/advancedtelematic/rvi_sota_server/git/trees{/sha}","statuses_url":"https://api.github.com/repos/advancedtelematic/rvi_sota_server/statuses/{sha}","languages_url":"https://api.github.com/repos/advancedtelematic/rvi_sota_server/languages","stargazers_url":"https://api.github.com/repos/advancedtelematic/rvi_sota_server/stargazers","contributors_url":"https://api.github.com/repos/advancedtelematic/rvi_sota_server/contributors","subscribers_url":"https://api.github.com/repos/advancedtelematic/rvi_sota_server/subscribers","subscription_url":"https://api.github.com/repos/advancedtelematic/rvi_sota_server/subscription","commits_url":"https://api.github.com/repos/advancedtelematic/rvi_sota_server/commits{/sha}","git_commits_url":"https://api.github.com/repos/advancedtelematic/rvi_sota_server/git/commits{/sha}","comments_url":"https://api.github.com/repos/advancedtelematic/rvi_sota_server/comments{/number}","issue_comment_url":"https://api.github.com/repos/advancedtelematic/rvi_sota_server/issues/comments{/number}","contents_url":"https://api.github.com/repos/advancedtelematic/rvi_sota_server/contents/{+path}","compare_url":"https://api.github.com/repos/advancedtelematic/rvi_sota_server/compare/{base}...{head}","merges_url":"https://api.github.com/repos/advancedtelematic/rvi_sota_server/merges","archive_url":"https://api.github.com/repos/advancedtelematic/rvi_sota_server/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/advancedtelematic/rvi_sota_server/downloads","issues_url":"https://api.github.com/repos/advancedtelematic/rvi_sota_server/issues{/number}","pulls_url":"https://api.github.com/repos/advancedtelematic/rvi_sota_server/pulls{/number}","milestones_url":"https://api.github.com/repos/advancedtelematic/rvi_sota_server/milestones{/number}","notifications_url":"https://api.github.com/repos/advancedtelematic/rvi_sota_server/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/advancedtelematic/rvi_sota_server/labels{/name}","releases_url":"https://api.github.com/repos/advancedtelematic/rvi_sota_server/releases{/id}","created_at":"2015-08-20T17:22:41Z","updated_at":"2015-09-17T07:24:32Z","pushed_at":"2015-10-14T14:32:51Z","git_url":"git://github.com/advancedtelematic/rvi_sota_server.git","ssh_url":"git@github.com:advancedtelematic/rvi_sota_server.git","clone_url":"https://github.com/advancedtelematic/rvi_sota_server.git","svn_url":"https://github.com/advancedtelematic/rvi_sota_server","homepage":null,"size":14055,"stargazers_count":2,"watchers_count":2,"language":"Scala","has_issues":false,"has_downloads":true,"has_wiki":true,"has_pages":true,"forks_count":0,"mirror_url":null,"open_issues_count":1,"forks":0,"open_issues":1,"watchers":2,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/advancedtelematic/rvi_sota_server/pulls/179"},"html":{"href":"https://github.com/advancedtelematic/rvi_sota_server/pull/179"},"issue":{"href":"https://api.github.com/repos/advancedtelematic/rvi_sota_server/issues/179"},"comments":{"href":"https://api.github.com/repos/advancedtelematic/rvi_sota_server/issues/179/comments"},"review_comments":{"href":"https://api.github.com/repos/advancedtelematic/rvi_sota_server/pulls/179/comments"},"review_comment":{"href":"https://api.github.com/repos/advancedtelematic/rvi_sota_server/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/advancedtelematic/rvi_sota_server/pulls/179/commits"},"statuses":{"href":"https://api.github.com/repos/advancedtelematic/rvi_sota_server/statuses/a54c37fa0aeec4633b980a00808e965dd51d5c8c"}}}}