{"action":"created","comment":{"url":"https://api.github.com/repos/thehyve/transmart-batch/pulls/comments/34342789","id":34342789,"diff_hunk":"@@ -0,0 +1,74 @@\n+package org.transmartproject.batch.highdim.mrna.data\n+\n+import org.junit.AfterClass\n+import org.junit.ClassRule\n+import org.junit.Test\n+import org.junit.rules.RuleChain\n+import org.junit.rules.TestRule\n+import org.junit.runner.RunWith\n+import org.springframework.context.annotation.AnnotationConfigApplicationContext\n+import org.springframework.test.context.ContextConfiguration\n+import org.springframework.test.context.junit4.SpringJUnit4ClassRunner\n+import org.transmartproject.batch.beans.GenericFunctionalTestConfiguration\n+import org.transmartproject.batch.clinical.db.objects.Tables\n+import org.transmartproject.batch.db.TableTruncator\n+import org.transmartproject.batch.junit.JobRunningTestTrait\n+import org.transmartproject.batch.junit.RunJobRule\n+import org.transmartproject.batch.support.TableLists\n+\n+import static org.hamcrest.MatcherAssert.assertThat\n+import static org.hamcrest.Matchers.*\n+\n+/**\n+ * test mRNA data import in the simplest scenario (good data not previously\n+ * loaded)\n+ */\n+@RunWith(SpringJUnit4ClassRunner)\n+@ContextConfiguration(classes = GenericFunctionalTestConfiguration)\n+class MrnaMultipleSamplesTests implements JobRunningTestTrait {\n+\n+    private final static String STUDY_ID = 'MULTSAMPL'\n+    private final static String PLATFORM_ID = 'GPL570_bogus'\n+\n+    @Test\n+    void testMultipleSamplesMeasurements() {\n+        def params = [study_id: STUDY_ID]\n+\n+        List r = jdbcTemplate.queryForList \"\"\"\n+                SELECT DISTINCT S.sample_cd\n+                FROM\n+                    ${Tables.MRNA_DATA} D\n+                    INNER JOIN ${Tables.SUBJ_SAMPLE_MAP} S ON (D.assay_id = S.assay_id)\n+                WHERE D.trial_name = :study_id\"\"\",\n+                params\n+\n+        assertThat r, containsInAnyOrder(\n+                hasEntry('sample_cd', 'S11'),\n+                hasEntry('sample_cd', 'S12'),\n+                hasEntry('sample_cd', 'S21'),\n+                hasEntry('sample_cd', 'S22'),","path":"src/test-func/groovy/org/transmartproject/batch/highdim/mrna/data/MrnaMultipleSamplesTests.groovy","position":49,"original_position":49,"commit_id":"1888b1ae1e650a02d1c8840b9ddecfecb391f3e0","original_commit_id":"1888b1ae1e650a02d1c8840b9ddecfecb391f3e0","user":{"login":"cataphract","id":496394,"avatar_url":"https://avatars.githubusercontent.com/u/496394?v=3","gravatar_id":"","url":"https://api.github.com/users/cataphract","html_url":"https://github.com/cataphract","followers_url":"https://api.github.com/users/cataphract/followers","following_url":"https://api.github.com/users/cataphract/following{/other_user}","gists_url":"https://api.github.com/users/cataphract/gists{/gist_id}","starred_url":"https://api.github.com/users/cataphract/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cataphract/subscriptions","organizations_url":"https://api.github.com/users/cataphract/orgs","repos_url":"https://api.github.com/users/cataphract/repos","events_url":"https://api.github.com/users/cataphract/events{/privacy}","received_events_url":"https://api.github.com/users/cataphract/received_events","type":"User","site_admin":false},"body":"Testing that the samples are associated with the correct patient would be interesting too.","created_at":"2015-07-10T10:16:06Z","updated_at":"2015-07-10T10:16:06Z","html_url":"https://github.com/thehyve/transmart-batch/pull/25#discussion_r34342789","pull_request_url":"https://api.github.com/repos/thehyve/transmart-batch/pulls/25","_links":{"self":{"href":"https://api.github.com/repos/thehyve/transmart-batch/pulls/comments/34342789"},"html":{"href":"https://github.com/thehyve/transmart-batch/pull/25#discussion_r34342789"},"pull_request":{"href":"https://api.github.com/repos/thehyve/transmart-batch/pulls/25"}}},"pull_request":{"url":"https://api.github.com/repos/thehyve/transmart-batch/pulls/25","id":39667551,"html_url":"https://github.com/thehyve/transmart-batch/pull/25","diff_url":"https://github.com/thehyve/transmart-batch/pull/25.diff","patch_url":"https://github.com/thehyve/transmart-batch/pull/25.patch","issue_url":"https://api.github.com/repos/thehyve/transmart-batch/issues/25","number":25,"state":"open","locked":false,"title":"A subject could have many samples","user":{"login":"forus","id":492175,"avatar_url":"https://avatars.githubusercontent.com/u/492175?v=3","gravatar_id":"","url":"https://api.github.com/users/forus","html_url":"https://github.com/forus","followers_url":"https://api.github.com/users/forus/followers","following_url":"https://api.github.com/users/forus/following{/other_user}","gists_url":"https://api.github.com/users/forus/gists{/gist_id}","starred_url":"https://api.github.com/users/forus/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/forus/subscriptions","organizations_url":"https://api.github.com/users/forus/orgs","repos_url":"https://api.github.com/users/forus/repos","events_url":"https://api.github.com/users/forus/events{/privacy}","received_events_url":"https://api.github.com/users/forus/received_events","type":"User","site_admin":false},"body":"","created_at":"2015-07-10T09:37:47Z","updated_at":"2015-07-10T10:16:06Z","closed_at":null,"merged_at":null,"merge_commit_sha":"d56437e43a71e502cad2a9f8a509141de0f916b5","assignee":null,"milestone":null,"commits_url":"https://api.github.com/repos/thehyve/transmart-batch/pulls/25/commits","review_comments_url":"https://api.github.com/repos/thehyve/transmart-batch/pulls/25/comments","review_comment_url":"https://api.github.com/repos/thehyve/transmart-batch/pulls/comments{/number}","comments_url":"https://api.github.com/repos/thehyve/transmart-batch/issues/25/comments","statuses_url":"https://api.github.com/repos/thehyve/transmart-batch/statuses/1888b1ae1e650a02d1c8840b9ddecfecb391f3e0","head":{"label":"thehyve:subj-has-multiple-samples","ref":"subj-has-multiple-samples","sha":"1888b1ae1e650a02d1c8840b9ddecfecb391f3e0","user":{"login":"thehyve","id":1502440,"avatar_url":"https://avatars.githubusercontent.com/u/1502440?v=3","gravatar_id":"","url":"https://api.github.com/users/thehyve","html_url":"https://github.com/thehyve","followers_url":"https://api.github.com/users/thehyve/followers","following_url":"https://api.github.com/users/thehyve/following{/other_user}","gists_url":"https://api.github.com/users/thehyve/gists{/gist_id}","starred_url":"https://api.github.com/users/thehyve/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/thehyve/subscriptions","organizations_url":"https://api.github.com/users/thehyve/orgs","repos_url":"https://api.github.com/users/thehyve/repos","events_url":"https://api.github.com/users/thehyve/events{/privacy}","received_events_url":"https://api.github.com/users/thehyve/received_events","type":"Organization","site_admin":false},"repo":{"id":23545751,"name":"transmart-batch","full_name":"thehyve/transmart-batch","owner":{"login":"thehyve","id":1502440,"avatar_url":"https://avatars.githubusercontent.com/u/1502440?v=3","gravatar_id":"","url":"https://api.github.com/users/thehyve","html_url":"https://github.com/thehyve","followers_url":"https://api.github.com/users/thehyve/followers","following_url":"https://api.github.com/users/thehyve/following{/other_user}","gists_url":"https://api.github.com/users/thehyve/gists{/gist_id}","starred_url":"https://api.github.com/users/thehyve/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/thehyve/subscriptions","organizations_url":"https://api.github.com/users/thehyve/orgs","repos_url":"https://api.github.com/users/thehyve/repos","events_url":"https://api.github.com/users/thehyve/events{/privacy}","received_events_url":"https://api.github.com/users/thehyve/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/thehyve/transmart-batch","description":"tranSMART pipeline alternative to ETL, using Spring Batch","fork":false,"url":"https://api.github.com/repos/thehyve/transmart-batch","forks_url":"https://api.github.com/repos/thehyve/transmart-batch/forks","keys_url":"https://api.github.com/repos/thehyve/transmart-batch/keys{/key_id}","collaborators_url":"https://api.github.com/repos/thehyve/transmart-batch/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/thehyve/transmart-batch/teams","hooks_url":"https://api.github.com/repos/thehyve/transmart-batch/hooks","issue_events_url":"https://api.github.com/repos/thehyve/transmart-batch/issues/events{/number}","events_url":"https://api.github.com/repos/thehyve/transmart-batch/events","assignees_url":"https://api.github.com/repos/thehyve/transmart-batch/assignees{/user}","branches_url":"https://api.github.com/repos/thehyve/transmart-batch/branches{/branch}","tags_url":"https://api.github.com/repos/thehyve/transmart-batch/tags","blobs_url":"https://api.github.com/repos/thehyve/transmart-batch/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/thehyve/transmart-batch/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/thehyve/transmart-batch/git/refs{/sha}","trees_url":"https://api.github.com/repos/thehyve/transmart-batch/git/trees{/sha}","statuses_url":"https://api.github.com/repos/thehyve/transmart-batch/statuses/{sha}","languages_url":"https://api.github.com/repos/thehyve/transmart-batch/languages","stargazers_url":"https://api.github.com/repos/thehyve/transmart-batch/stargazers","contributors_url":"https://api.github.com/repos/thehyve/transmart-batch/contributors","subscribers_url":"https://api.github.com/repos/thehyve/transmart-batch/subscribers","subscription_url":"https://api.github.com/repos/thehyve/transmart-batch/subscription","commits_url":"https://api.github.com/repos/thehyve/transmart-batch/commits{/sha}","git_commits_url":"https://api.github.com/repos/thehyve/transmart-batch/git/commits{/sha}","comments_url":"https://api.github.com/repos/thehyve/transmart-batch/comments{/number}","issue_comment_url":"https://api.github.com/repos/thehyve/transmart-batch/issues/comments{/number}","contents_url":"https://api.github.com/repos/thehyve/transmart-batch/contents/{+path}","compare_url":"https://api.github.com/repos/thehyve/transmart-batch/compare/{base}...{head}","merges_url":"https://api.github.com/repos/thehyve/transmart-batch/merges","archive_url":"https://api.github.com/repos/thehyve/transmart-batch/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/thehyve/transmart-batch/downloads","issues_url":"https://api.github.com/repos/thehyve/transmart-batch/issues{/number}","pulls_url":"https://api.github.com/repos/thehyve/transmart-batch/pulls{/number}","milestones_url":"https://api.github.com/repos/thehyve/transmart-batch/milestones{/number}","notifications_url":"https://api.github.com/repos/thehyve/transmart-batch/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/thehyve/transmart-batch/labels{/name}","releases_url":"https://api.github.com/repos/thehyve/transmart-batch/releases{/id}","created_at":"2014-09-01T14:46:36Z","updated_at":"2015-04-17T16:23:19Z","pushed_at":"2015-07-10T10:05:17Z","git_url":"git://github.com/thehyve/transmart-batch.git","ssh_url":"git@github.com:thehyve/transmart-batch.git","clone_url":"https://github.com/thehyve/transmart-batch.git","svn_url":"https://github.com/thehyve/transmart-batch","homepage":null,"size":1434,"stargazers_count":0,"watchers_count":0,"language":"Groovy","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":3,"mirror_url":null,"open_issues_count":3,"forks":3,"open_issues":3,"watchers":0,"default_branch":"master"}},"base":{"label":"thehyve:master","ref":"master","sha":"d89c9b2dc3ccaad85d47096dfc93f76b627416aa","user":{"login":"thehyve","id":1502440,"avatar_url":"https://avatars.githubusercontent.com/u/1502440?v=3","gravatar_id":"","url":"https://api.github.com/users/thehyve","html_url":"https://github.com/thehyve","followers_url":"https://api.github.com/users/thehyve/followers","following_url":"https://api.github.com/users/thehyve/following{/other_user}","gists_url":"https://api.github.com/users/thehyve/gists{/gist_id}","starred_url":"https://api.github.com/users/thehyve/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/thehyve/subscriptions","organizations_url":"https://api.github.com/users/thehyve/orgs","repos_url":"https://api.github.com/users/thehyve/repos","events_url":"https://api.github.com/users/thehyve/events{/privacy}","received_events_url":"https://api.github.com/users/thehyve/received_events","type":"Organization","site_admin":false},"repo":{"id":23545751,"name":"transmart-batch","full_name":"thehyve/transmart-batch","owner":{"login":"thehyve","id":1502440,"avatar_url":"https://avatars.githubusercontent.com/u/1502440?v=3","gravatar_id":"","url":"https://api.github.com/users/thehyve","html_url":"https://github.com/thehyve","followers_url":"https://api.github.com/users/thehyve/followers","following_url":"https://api.github.com/users/thehyve/following{/other_user}","gists_url":"https://api.github.com/users/thehyve/gists{/gist_id}","starred_url":"https://api.github.com/users/thehyve/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/thehyve/subscriptions","organizations_url":"https://api.github.com/users/thehyve/orgs","repos_url":"https://api.github.com/users/thehyve/repos","events_url":"https://api.github.com/users/thehyve/events{/privacy}","received_events_url":"https://api.github.com/users/thehyve/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/thehyve/transmart-batch","description":"tranSMART pipeline alternative to ETL, using Spring Batch","fork":false,"url":"https://api.github.com/repos/thehyve/transmart-batch","forks_url":"https://api.github.com/repos/thehyve/transmart-batch/forks","keys_url":"https://api.github.com/repos/thehyve/transmart-batch/keys{/key_id}","collaborators_url":"https://api.github.com/repos/thehyve/transmart-batch/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/thehyve/transmart-batch/teams","hooks_url":"https://api.github.com/repos/thehyve/transmart-batch/hooks","issue_events_url":"https://api.github.com/repos/thehyve/transmart-batch/issues/events{/number}","events_url":"https://api.github.com/repos/thehyve/transmart-batch/events","assignees_url":"https://api.github.com/repos/thehyve/transmart-batch/assignees{/user}","branches_url":"https://api.github.com/repos/thehyve/transmart-batch/branches{/branch}","tags_url":"https://api.github.com/repos/thehyve/transmart-batch/tags","blobs_url":"https://api.github.com/repos/thehyve/transmart-batch/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/thehyve/transmart-batch/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/thehyve/transmart-batch/git/refs{/sha}","trees_url":"https://api.github.com/repos/thehyve/transmart-batch/git/trees{/sha}","statuses_url":"https://api.github.com/repos/thehyve/transmart-batch/statuses/{sha}","languages_url":"https://api.github.com/repos/thehyve/transmart-batch/languages","stargazers_url":"https://api.github.com/repos/thehyve/transmart-batch/stargazers","contributors_url":"https://api.github.com/repos/thehyve/transmart-batch/contributors","subscribers_url":"https://api.github.com/repos/thehyve/transmart-batch/subscribers","subscription_url":"https://api.github.com/repos/thehyve/transmart-batch/subscription","commits_url":"https://api.github.com/repos/thehyve/transmart-batch/commits{/sha}","git_commits_url":"https://api.github.com/repos/thehyve/transmart-batch/git/commits{/sha}","comments_url":"https://api.github.com/repos/thehyve/transmart-batch/comments{/number}","issue_comment_url":"https://api.github.com/repos/thehyve/transmart-batch/issues/comments{/number}","contents_url":"https://api.github.com/repos/thehyve/transmart-batch/contents/{+path}","compare_url":"https://api.github.com/repos/thehyve/transmart-batch/compare/{base}...{head}","merges_url":"https://api.github.com/repos/thehyve/transmart-batch/merges","archive_url":"https://api.github.com/repos/thehyve/transmart-batch/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/thehyve/transmart-batch/downloads","issues_url":"https://api.github.com/repos/thehyve/transmart-batch/issues{/number}","pulls_url":"https://api.github.com/repos/thehyve/transmart-batch/pulls{/number}","milestones_url":"https://api.github.com/repos/thehyve/transmart-batch/milestones{/number}","notifications_url":"https://api.github.com/repos/thehyve/transmart-batch/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/thehyve/transmart-batch/labels{/name}","releases_url":"https://api.github.com/repos/thehyve/transmart-batch/releases{/id}","created_at":"2014-09-01T14:46:36Z","updated_at":"2015-04-17T16:23:19Z","pushed_at":"2015-07-10T10:05:17Z","git_url":"git://github.com/thehyve/transmart-batch.git","ssh_url":"git@github.com:thehyve/transmart-batch.git","clone_url":"https://github.com/thehyve/transmart-batch.git","svn_url":"https://github.com/thehyve/transmart-batch","homepage":null,"size":1434,"stargazers_count":0,"watchers_count":0,"language":"Groovy","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":3,"mirror_url":null,"open_issues_count":3,"forks":3,"open_issues":3,"watchers":0,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/thehyve/transmart-batch/pulls/25"},"html":{"href":"https://github.com/thehyve/transmart-batch/pull/25"},"issue":{"href":"https://api.github.com/repos/thehyve/transmart-batch/issues/25"},"comments":{"href":"https://api.github.com/repos/thehyve/transmart-batch/issues/25/comments"},"review_comments":{"href":"https://api.github.com/repos/thehyve/transmart-batch/pulls/25/comments"},"review_comment":{"href":"https://api.github.com/repos/thehyve/transmart-batch/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/thehyve/transmart-batch/pulls/25/commits"},"statuses":{"href":"https://api.github.com/repos/thehyve/transmart-batch/statuses/1888b1ae1e650a02d1c8840b9ddecfecb391f3e0"}}}}